| Posted By |
Message |
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Any Microsoft Access guru's out here....
I'm trying to do something with a macro, and I need help.
I have a macro, and I want the user to fill out a form. I need the macro to stop...wait for the user to fill out the form and then continue running the macro. thanks.
|
Posted 7/19/07 11:18 AM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
LSP2005
Bunny kisses are so cute!
Member since 5/05 19461 total posts
Name:
L
|
Re: Any Microsoft Access guru's out here....
According to my DH macros can ask for input but unfortunately he thinks you need to design it a different way. Either have the person fill out the form first or have the macro end, the person fills out form and a new macro begins when the form is completed. If necessary, have the first macro pass arguments with hidden fields on the form to the new macro.
|
| Posted 7/19/07 11:29 AM |
| |
|
seank80
Don't Taze My Dog Bro!!
Member since 5/07 2240 total posts
Name:
Sean
|
Re: Any Microsoft Access guru's out here....
It has been a few years since I actively used Macros in Access but I agree with LSP. You are going to have to use a form for them to fill out then a macro possibly. Sorry I can't give more insight. If you need SQL or Crystal Reports help then I could def be more of a help.
|
| Posted 7/19/07 11:57 AM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: Any Microsoft Access guru's out here....
Posted by LSP2005
According to my DH macros can ask for input but unfortunately he thinks you need to design it a different way. Either have the person fill out the form first or have the macro end, the person fills out form and a new macro begins when the form is completed. If necessary, have the first macro pass arguments with hidden fields on the form to the new macro.
Hmm...that's what I was afraid of. I have a query that creates a table, and I want to update this new table with the user input. I really can't have the user do the imput first, because the table doesn't exist. Grrrr....
|
| Posted 7/19/07 1:01 PM |
| |
|
LSP2005
Bunny kisses are so cute!
Member since 5/05 19461 total posts
Name:
L
|
Re: Any Microsoft Access guru's out here....
Posted by luvsun27
Posted by LSP2005
According to my DH macros can ask for input but unfortunately he thinks you need to design it a different way. Either have the person fill out the form first or have the macro end, the person fills out form and a new macro begins when the form is completed. If necessary, have the first macro pass arguments with hidden fields on the form to the new macro.
Hmm...that's what I was afraid of. I have a query that creates a table, and I want to update this new table with the user input. I really can't have the user do the imput first, because the table doesn't exist. Grrrr....
No problem, DH sticks by his first response, put the second half the instructions you need in your second macro that is triggered by the close event of the form.
Example:
Macro A
Creates Table
Opens form
Macro B
Starts when form is closed
...
...
|
| Posted 7/19/07 2:14 PM |
| |
|
luvsun27
Check out my cool glasses
Member since 5/05 8135 total posts
Name:
Kim
|
Re: Any Microsoft Access guru's out here....
Posted by LSP2005
No problem, DH sticks by his first response, put the second half the instructions you need in your second macro that is triggered by the close event of the form.
Example:
Macro A
Creates Table
Opens form
Macro B
Starts when form is closed
...
...
Yep....I did this, and it worked. Yeah me 
thanks 
|
| Posted 7/19/07 3:57 PM |
| |
|
