Search results

Hi I have a basic insert query as below. basically inserting from another table where ColumnA matches the entered parameter [value] I have about 500 values to enter from a list or a table though and I wanted to use VBA to loop through the list of values and insert into the tableA for each...

Hi I'm using access 2003. I want to execute a make table query saved in another access database. I use the DAO method below but the query has 2 input parameters and I want to pass these with the db.Execute method below. Is this possible? Thanks Dim db As DAO.Database Set db =...