|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
July 21st, 2005, 12:31 PM
|
|||
|
|||
Queries...
Well, I want a combobox to display the information contained in a table generated by a query. The thing is that when I load the form, I want the query to run so that the ComboBox can be updated but since the query is a Make-Table Query everytime I open it, it asks for permission to delete the old table and generate a new one.
Can someone please help me to know how to avoid this message and just make it so that it doesn't need to click OK, everytime I run the Query?  I'd really appreciate it. PECH
|
|
#2
July 21st, 2005, 12:49 PM
|
|||
|
|||
|
In your code just before you run the query turn the system warnings off and then turn the warnings back on after the query runs.
DoCmd.SetWarnings False 'Run the Query DoCmd.SetWarnings True
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Queries... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
