Search results for query: *

Ok. I got to work, but not in the way I wanted. But it'll do for now. I took a couple of your suggestions and decided to go the macro way. First to insert the data into a temp table which activates the parameter popup.Once in the temp table I then have it open up in the form!subform so the end...

Pampers - That's kind of what I'm trying to avoid. I have a situation here where I have alot of different queries to run and each will require an output to Excel. It would be more streamline if I can keep the exporting to a click of a button rather than maintaining a bunch of action queries and...

ProgramError - That is correct. It is a parameter query, which will have a couple of pop up dialog boxes to help filter the needed data whenever the query is ran. I guess the only other way of kicking out what I want is to somehow grab and export the subform's record after the querying is done...

I borrow this from someone else. I'm not quite getting this to work. The code is giving me "Run-time error '3061' Too few parameters. Expected 3. When I go to debug, it is highlighting the "Current Dim StrSQL As String CurrentDb.Execute "Delete * from Temp" StrSQL = "Insert into Temp " & _...

Hello - I have a subform within a Form that get it's data from a parameter query. I would like to be able to export the data from the subform into Excel without having the parameter of the query pop up each time I run my command button. Here's what I currently have. Any suggestion will be...