Search results for query: *

Ideally, I would like to put the sequence in code, but I would like to break it up into logical steps. Some of the queries are fairly complex and are hitting huge tables....so some queries take 5 or 6 hours to run. My main problem is that I don't know how to write the code to run a query that...

Hello, I have three databases that are currently working "together". Example: One database has tables that are used as a basis to summarize data in another database. Tables between the databases are linked. The three databases have sets of queries that must be run in a specific sequence. It...

ALRIGHT! It worked. You guys are the best. That will eliminate a lot of headaches for me in the future with a lot of the financial reporting I have to do. Thanks! Craig.

I'll give that a shot when I get into work on Monday.

the control on the form is named "txtFromDate". The form name is "frmMainMenu". In the criteria of the query I put: GetFormValue(Forms![frmMainMenu]![txtFromDate]) I simply used it just like I would any other function. I think this would be a great way to get around my issue if this works...

John, I tried to use that function in my database, but it didn't work. Here is the function I typed into a separate module... Option Compare Database Function GetFormValue(strControlName As String) As Variant GetFormValue = Forms![frmMainMenu].Controls(strControlName).Value End Function...

Thanks for your input guys. I'd rather not create any more tables in this database. It's getting to be huge. John, Do you have an example of this function? All I want it to do is give me the date value that is on the form. I'm also not sure what you mean by passing a control name to the...

Hello. I am trying to export a select query that references a crosstab query to Excel. I have the VBA code that exports regular queries and I'm using that code to automate the exporting process. I have a form that supplies a specific date range for the user and I want to query my crosstab...