setvalue macro

[MTSmith]

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

 

[Barry A&P]

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

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?

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

 

[MTSmith]

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

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

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?

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

 

[MTSmith]

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.

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

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?

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

 

[Barry A&P]

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

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.

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

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?

:

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