Recent content by DylansStrings

thanks, I figured out how to do it in VBA too Dim dbCurr As DAO.Database Dim rsCurr As DAO.Recordset Dim qdfCurr As DAO.QueryDef Dim strFolder As String Dim strSQL As String Set dbCurr = CurrentDb() Set rsCurr = dbCurr.OpenRecordset("SELECT column1 FROM table1") On Error Resume Next...

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...

Thanks figured it out with QueryDef Dim db As DAO.Database Dim MyQueryDef As DAO.QueryDef Set db = DBEngine.Workspaces(0).OpenDatabase("C:\Mydatabase.mdb") Set MyQueryDef = db.QueryDefs("MyQuery") With MyQueryDef .Parameters("[Year]") = 2012 .Parameters("[Month]") = 8 End With...

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 =...