Recent content by devolved_one

Is it possible to run a Delete Query from VBA with out it prompting the user to delete the data in the table you are deleting from!? Thanks.

How do you "SAVE AS" a table using VBA code?? and can you secify the table name using Variables instead of being prompted?

How do you preform a save as on a form using VBA code, or maybe a macro (whichever is easiest)??? Thanks

How do you execute a query using VBA Code? (check previous posting to see whats already been posted)

hmm.. I dunno.. there most be something else missing.. with that last post if I copy and paste I get "Compile Error: User-defined type not defined" on the Dim dbClient as DataBase and I'm assuming I'll get it on the Dim qdf as QueryDef too.. (seeing as I have before) any other ideas...

ok.. I was looking through the ms help on it and basically copied and pasted the code in an example and modified to work with my stuff. I created a delete action query.. here's the names of my database (my naming conventions are shit! I'm lazy! ) database - db1 table - table1 query - query1...

hmm.. ok. I'm not familiar with Queries at all. Do I just through that statement into my code or do I create a query and if I create a query how do I do it?

Is it possible to delete all records in a database from code inside a form?? If so whats the code to do it?? Everytime I go into the Form I want it to clean out the database it is linked with. Also what is the command to close a form. Thanks.