Search results

I then need to export the query results to an excel file. I have found similar code that will edit a query already in existance, I'd like to just create the query. Here's what I've found: Dim db As DAO.Database Dim qdf As DAO.QueryDef Set db = CurrentDb Set qdf =...

Thanks, we're getting a closer. If within the vba code behind a form, I have created a select statement based on selections the user has made on the form. I'd like to have VBA that would create a query based on the select statment. I'd like for this query to be displayed on the query list.

Thanks for the quick reply. I didn't write my question well enough. If I have a select statement, how do I go about creating a query that can be selected from the query object list?

I can't figure out the correct vba code to make a query out of a select statement. SELECT [tbl Import IPG Raw].Date, [tbl Import IPG Raw].Title FROM [tbl Import IPG Raw] Thanks in advance!!

I just figured that out. Thanks for working me through this!!

Within the original VBA code, I have a query. It requires a date. Currently the query has an input box for the user to enter a date. I thought I would create a form, use the calendar function to make it easier for the user, then pass that date to the query.

Let's see if I can make this more clear. Form A has a control button with VBA code behind it. What I need to do, is after the control button is clicked, I need to open Form B, get some info from the user, then pass this info to the VBA code within Form A. Right now, when I click on the button in...

Within a form, I have a command button that I've written VBA code that works properly. What I'm needing to do is after this command button is clicked, I need to open another form, get some info from the user, then pass control back to the original VBA code.