Recent content by knelson

I'm not sure if I understand what you want exactly, but I think you could do something like the following. It will do your first select statement and pull out the SQL strings from your table then insert it into a temporary table. It then puts assigns the first value in the temp table as the...

1. No the code is not in a startup form, I don't have a startup form defined (yet) 2. Mostly event code: button clicks, check boxes, combo boxes, etc. On one of the forms I was tweaking a couple buttons, one button which creates a query based on which check boxes are selected and a few other...

If you want to take a SQL statement and actually run it then use the DoCmd.RunSQL method and pass your SQL string as an argument.

Greetings, I have a database I have been developing for some time that I can no longer access. I am running windows XP and Access 2003, I am the only user and it is stored on my local system. I was tweaking some VBA code in a few of the forms and closed the file which triggered the auto...