I was using this function to do various updates and searches, and then changed it to read like this: Public Function aSQL_Util() sqlstring = "SELECT a220_Modules_List.Module_ID FROM a220_Module...

When I create a new master record, I must create some associated records in another table. I am currently using RUNSQL to do an insert, but the user is asked to confirm the insert. How can I keep i...

I have a do.cmd runsql "insert table (field1,field2) values (value1,value2) command and want to turn off access asking me do i want to perform the the append operation on 1 rows. can this be done...

I am trying to create an SQL UPDATE command, but it has 2 where clauses. I want to copy the value in "Package.PackagePODate" to "Product.PODate" where "Package.PackageID" = "PRODUCT.PackageName"...

Hi all, i'm using the runSQL command to insert into a table.  Problem i'm having is when the user inputs invalid characters.  I need to assure that the sql command is /valid/ Thanks