A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

setvalue macro



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2009, 03:48 AM posted to microsoft.public.access.tablesdbdesign
MTSmith
external usenet poster
 
Posts: 11
Default 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  
Old November 13th, 2009, 03:58 AM posted to microsoft.public.access.tablesdbdesign
MTSmith
external usenet poster
 
Posts: 11
Default 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  
Old November 14th, 2009, 01:49 AM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default 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  
Old November 14th, 2009, 05:29 AM posted to microsoft.public.access.tablesdbdesign
MTSmith
external usenet poster
 
Posts: 11
Default 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  
Old November 16th, 2009, 05:31 AM posted to microsoft.public.access.tablesdbdesign
MTSmith
external usenet poster
 
Posts: 11
Default 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  
Old January 9th, 2010, 04:19 AM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.