Any Microsoft Access guru's out here....
| Posted By | Message |
|---|---|
|
Any Microsoft Access guru's out here.... I'm trying to do something with a macro, and I need help. |
|
Posted 7/19/07 11:18 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|




