3 questions

G

golan

hello, i have 3 questions:
1. how i switch the database to application .
2. i have some forms and i want one of then to run when the application is
load.
3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.
thanks
 
T

Tom Wickerath

Hi Golan,
1. how i switch the database to application.
Click to expand...

Not really sure what you mean, although providing a "switchboard-like" form
that opens at startup might be a good first step, along with hiding the
database window (or Navigation Pane in A2007).
2. i have some forms and i want one of then to run when the application is
load.
Click to expand...

Use a macro named AutoExec that includes an action to open your form, or
specify your form under Tools | Startup (Access 2003 and lower--you'll need
to look up the equivalent if you are using A2007).
3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.
Click to expand...

You can set warnings off in code, or use the .execute method of DoCmd
object. See examples # 3-5 in this Word document:

http://www.accessmvp.com/TWickerath/downloads/ActionQueryExamplesWithSetWarnings.doc


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
P

pietlinden

hello, i have 3 questions:
1. how i switch the database to application .
2. i have some forms and i want one of then to run when the application is
load.
3.i have add query and delete query and i dont want the msg box " u want to
add/delete....." to open.
thanks
Click to expand...

1. not possible.
2. set the startup form in Tools/Startup/Display form ... dropdown
3.
DoCmd.SetWarnings False
DoCmd.OpenQuery "qappendRecords"
DoCmd.OpenQuery "qdeleteRecords"
Docmd.SetWarnings True
 
G

golan

thanks, but in thanks mistake some menu are gone how i get it back.
when i rum the program i dont tools and more
golani
 
J

John W. Vinson

thanks, but in thanks mistake some menu are gone how i get it back.
when i rum the program i dont tools and more
golani
Click to expand...

Hold down the SHIFT key while opening the database to bypass the Startup
processing. Correct the errors, restore the menus, and close and reopen the
database.
 
Top