append query

[vrmomo]

I created this pretty neat form that does some calculations....
I also created a very simple append query for it, but I have no idea on how to creat a button on the form to run the append query.

please help

thanks

 

[ansentry]

Put this code behind the OnClick event of your command button; If you want to see the warnings (for a test run) put ' in front of the 2 lines that relate to SetWarnings.

DoCmd.SetWarnings False ' This will turn off Access warnings
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True ' This will turn them back on.

P.S. Just a question, Are you storing the result of your calculations in a table?

 

[vrmomo]

Yes, I want to store certain results (not all) of my calculations

thanks

John

 

[ansentry]

You should not store calculations in a table, however it is your database and your can do what you wish.

P.S. Did this work:

DoCmd.SetWarnings False ' This will turn off Access warnings
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True ' This will turn them back on.

 

[vrmomo]

Yeah, it worked perfectly, thanks.

can you explain why its not a good idea to store calculations in a table??? Sorry if this is a noob question, but me not know too much about access

 

[ansentry]

Yeah, it worked perfectly, thanks.

can you explain why its not a good idea to store calculations in a table??? Sorry if this is a noob question, but me not know too much about access

Do a search here on "store calculations in a table" and you find plenty of explanationsfrom the Access Gurus as to why you should not do it.

Click the link below and then go the the last post by Pat Hartman (she is a Guru+) and read what she says.

Click Here