Hi all,

I just started using VB to create macros and am running into a problem. I
have a database query that is pulling data from a mysql db and presenting it
to a template. I want to be able to open a form when the user opens the
template and ask the for the month and year to run the query. I am trying to
use a UserForm in the VB Editor, but I keep getting the following error:

System Error &80070057 (-2147024809) The parameter is incorrect.

I am running Excel 2002 and vb 6.0. anyone have any ideas? I checked the
update page and I am up to date.

thanks in advance.

drew

Hi
I am having the same error. I did have forms working but all of a sudden
they stopped. have you found a solution? I notice no one has responded to you
in this group.

Gene

"drewnkc" wrote:

Hi all,

I just started using VB to create macros and am running into a problem. I
have a database query that is pulling data from a mysql db and presenting it
to a template. I want to be able to open a form when the user opens the
template and ask the for the month and year to run the query. I am trying to
use a UserForm in the VB Editor, but I keep getting the following error:

System Error &80070057 (-2147024809) The parameter is incorrect.

I am running Excel 2002 and vb 6.0. anyone have any ideas? I checked the
update page and I am up to date.

thanks in advance.

drew