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
|
|||
|
|||
setvalue macro
I have a client record that when I push the events button I want a Events
Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
#2
|
|||
|
|||
setvalue macro
I also forgot to add that I had put in a couple of events directly into the
events table with the ClientID# just to see if I could get the events form to open up according to the Client record I had on screen. On the Events button on the client record I used the macro Open Form where [ClientID]=Forms![main client record]!FAMID . It didn't open the events form showing the records I had put in manually for that client. Is there something wrong on my syntax? "MTSmith" wrote: I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
#3
|
|||
|
|||
setvalue macro
Terry
Maybe you should use a bound subform "Events" on your main "clients form" and link child and master on ClientID and dont deal with all that macro stuff.. Just my two cents. Barry "MTSmith" wrote: I also forgot to add that I had put in a couple of events directly into the events table with the ClientID# just to see if I could get the events form to open up according to the Client record I had on screen. On the Events button on the client record I used the macro Open Form where [ClientID]=Forms![main client record]!FAMID . It didn't open the events form showing the records I had put in manually for that client. Is there something wrong on my syntax? "MTSmith" wrote: I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
#4
|
|||
|
|||
setvalue macro
I already have one subform on the main form for listing family member
details. I also want to do one for Contributions. Would adding too many subforms slow down the performance of the database? That would be 3 subforms. It would solve the problem of setting the correct ClientID though. Terry "Barry A&P" wrote: Terry Maybe you should use a bound subform "Events" on your main "clients form" and link child and master on ClientID and dont deal with all that macro stuff.. Just my two cents. Barry "MTSmith" wrote: I also forgot to add that I had put in a couple of events directly into the events table with the ClientID# just to see if I could get the events form to open up according to the Client record I had on screen. On the Events button on the client record I used the macro Open Form where [ClientID]=Forms![main client record]!FAMID . It didn't open the events form showing the records I had put in manually for that client. Is there something wrong on my syntax? "MTSmith" wrote: I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
#5
|
|||
|
|||
setvalue macro
Barry,
You were right. I finally realized that I should just make a second main form and put the 2nd subform on the bottom of it, and not put 2 subforms on the same main form. It works beautifully and I've finally finished making the database using that system. Thanks for the hint. "Barry A&P" wrote: Terry Maybe you should use a bound subform "Events" on your main "clients form" and link child and master on ClientID and dont deal with all that macro stuff.. Just my two cents. Barry "MTSmith" wrote: I also forgot to add that I had put in a couple of events directly into the events table with the ClientID# just to see if I could get the events form to open up according to the Client record I had on screen. On the Events button on the client record I used the macro Open Form where [ClientID]=Forms![main client record]!FAMID . It didn't open the events form showing the records I had put in manually for that client. Is there something wrong on my syntax? "MTSmith" wrote: I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
#6
|
|||
|
|||
setvalue macro
Terry
this post is on my unanswered list, so i figured i would check on it.. Tou mentioned a concern about speed with a bunch of subforms.. Check out the TAB control and put each subject or subform on a different tab that way access doesnt even open the sub unless you click the tab. so you can have 15 tabs and subforms while only using as much processor as required to display the active tab.. Barry "MTSmith" wrote: Barry, You were right. I finally realized that I should just make a second main form and put the 2nd subform on the bottom of it, and not put 2 subforms on the same main form. It works beautifully and I've finally finished making the database using that system. Thanks for the hint. "Barry A&P" wrote: Terry Maybe you should use a bound subform "Events" on your main "clients form" and link child and master on ClientID and dont deal with all that macro stuff.. Just my two cents. Barry "MTSmith" wrote: I also forgot to add that I had put in a couple of events directly into the events table with the ClientID# just to see if I could get the events form to open up according to the Client record I had on screen. On the Events button on the client record I used the macro Open Form where [ClientID]=Forms![main client record]!FAMID . It didn't open the events form showing the records I had put in manually for that client. Is there something wrong on my syntax? "MTSmith" wrote: I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering data. I read about the setvalue you can use in a macro, but I cannot find the setvalue operation in the macro builder. The ex: is in the help like this: Echo Echo On: No Stop screen updating while the macro is running. Close Object Type: Form Object Name: Product List Save: No Close the Product List form. OpenForm Form Name: Products View: Form Data Mode: Add Window Mode: Normal Open the Products form. SetValue Item: [Forms]![Products]![SupplierID] Expression: SupplierID Set the SupplierID control to the current supplier on the Suppliers form. GoToControl Control Name: CategoryID Go to the CategoryID control. in the macro builder I choose Action of Open Form and I choose the Events form. On the next line I open the box, but setvalue is not a choice. Am I doing this wrong? Any help? Thanks in advance. Terry Smith |
Thread Tools | |
Display Modes | |
|
|