Prev: Design with no experience
Next: Table design help!
From: MTSmith on 12 Nov 2009 21:48
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

From: MTSmith on 12 Nov 2009 21:58
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
>
From: Barry A&P on 13 Nov 2009 19:49
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
> >
From: MTSmith on 13 Nov 2009 23:29
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
> > >
From: MTSmith on 15 Nov 2009 23:31
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
> > >
 | 
Pages: 1
Prev: Design with no experience
Next: Table design help!