If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Command Button
Hi, I am just starting out using Access, my question is, i am creating a
quotation system for my manager. What i am trying to do with the command button, is to use a macro to open the next form, which works well, i have one from called gas cylinder installation, which then opens another form Contractors, then Consumables etc. My problem is when i start the process again to link the Contractors form to another form it already has the original macro attached and goes back to the original form? How do i make it go to various forms? If you could help that would be great. Thanks Sarah |
#2
|
|||
|
|||
Command Button
The OpenForm macro action has an argument for the Form Name. That is where
you would put the name of the form that you want to open. If you want to have a different form from another form, you will need to have separate macros, one for each form to be opened, and use the appropriate macro that you need. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message ... Hi, I am just starting out using Access, my question is, i am creating a quotation system for my manager. What i am trying to do with the command button, is to use a macro to open the next form, which works well, i have one from called gas cylinder installation, which then opens another form Contractors, then Consumables etc. My problem is when i start the process again to link the Contractors form to another form it already has the original macro attached and goes back to the original form? How do i make it go to various forms? If you could help that would be great. Thanks Sarah |
#3
|
|||
|
|||
Command Button
Hi Ken,
Thanks for that, but if i am using the same form for various reason, and i have already attached a macro if i change that to work for another form how will it work for the old form? Sorry not really good on all this stuff..... Should i be writing VBA code for the form to go to another form? Thanks "Ken Snell" wrote: The OpenForm macro action has an argument for the Form Name. That is where you would put the name of the form that you want to open. If you want to have a different form from another form, you will need to have separate macros, one for each form to be opened, and use the appropriate macro that you need. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message ... Hi, I am just starting out using Access, my question is, i am creating a quotation system for my manager. What i am trying to do with the command button, is to use a macro to open the next form, which works well, i have one from called gas cylinder installation, which then opens another form Contractors, then Consumables etc. My problem is when i start the process again to link the Contractors form to another form it already has the original macro attached and goes back to the original form? How do i make it go to various forms? If you could help that would be great. Thanks Sarah |
#4
|
|||
|
|||
Command Button
You can have different macros on the same form; just use different command
buttons to run each separate macro. Or, perhaps I'm not understanding what you want to do? Are you wanting to use one command button only, and to have that button cause different forms to be opened? If yes, how will the button know which form is to be opened? -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message news Hi Ken, Thanks for that, but if i am using the same form for various reason, and i have already attached a macro if i change that to work for another form how will it work for the old form? Sorry not really good on all this stuff..... Should i be writing VBA code for the form to go to another form? Thanks "Ken Snell" wrote: The OpenForm macro action has an argument for the Form Name. That is where you would put the name of the form that you want to open. If you want to have a different form from another form, you will need to have separate macros, one for each form to be opened, and use the appropriate macro that you need. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message ... Hi, I am just starting out using Access, my question is, i am creating a quotation system for my manager. What i am trying to do with the command button, is to use a macro to open the next form, which works well, i have one from called gas cylinder installation, which then opens another form Contractors, then Consumables etc. My problem is when i start the process again to link the Contractors form to another form it already has the original macro attached and goes back to the original form? How do i make it go to various forms? If you could help that would be great. Thanks Sarah |
#5
|
|||
|
|||
Command Button
Oh now that makes sense... sorry have been having a "dumb" moment for awhile
now, i didnt even think of adding another button.... that works really well.... one of the people here tryed to help me, told me to do a whole new form for everytime i want to use it for a different form...... That is great really appreciate your help, Have a great weekend Thanks sarah from Australia "Ken Snell" wrote: You can have different macros on the same form; just use different command buttons to run each separate macro. Or, perhaps I'm not understanding what you want to do? Are you wanting to use one command button only, and to have that button cause different forms to be opened? If yes, how will the button know which form is to be opened? -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message news Hi Ken, Thanks for that, but if i am using the same form for various reason, and i have already attached a macro if i change that to work for another form how will it work for the old form? Sorry not really good on all this stuff..... Should i be writing VBA code for the form to go to another form? Thanks "Ken Snell" wrote: The OpenForm macro action has an argument for the Form Name. That is where you would put the name of the form that you want to open. If you want to have a different form from another form, you will need to have separate macros, one for each form to be opened, and use the appropriate macro that you need. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Sarah" wrote in message ... Hi, I am just starting out using Access, my question is, i am creating a quotation system for my manager. What i am trying to do with the command button, is to use a macro to open the next form, which works well, i have one from called gas cylinder installation, which then opens another form Contractors, then Consumables etc. My problem is when i start the process again to link the Contractors form to another form it already has the original macro attached and goes back to the original form? How do i make it go to various forms? If you could help that would be great. Thanks Sarah |
Thread Tools | |
Display Modes | |
|
|