Recent content by Idealsteve

Hi I have a order form for bus tickets which a person puts the number of the first bus ticket in the book they have ordered and the last number. Is it possible to do something maybe an append query which will fill out all of the numbers in between the numbers they have put in, into a...

Yes the line I am using in the query is [Forms]![Access Fund 2004]![Text3549] Thanks Steve

Thanks for this but is still coming up with the same error I removed qrySQL = "SELECT * FROM [" & QryName & "]" And replaced it with Set rstQry = CurrentDb.QueryDefs(QryName).OpenRecordset Thanks Steve

Hi The error is occurring on the following line. Set rstQry = CurrentDb.OpenRecordset(qrySQL) The code works fine and exports all of my queries if I type my own values in the queries. The problem occurs when I am using the value in a text box on a form to run the query. the error I keep getting...

Thanks For your reply All of the queries are select queries Thanks Steve

Thanks for you reply Do you know where I would put the docmd.openquery code in the code above so it runs all of the queries I have in my list. Thanks Steve

am pretty new to visual basic and I have created some code which exports a load of queries to excel based on query names I have stored in a table, however I am encountering problems with a few of the queries as they run based on a value I have put in a form as it creates an error as it says I...