Search results

On occasion, I have the need to export a recordset to Excel. Sometimes I use it to check the recordset content without wading through the Locals Window; sometimes I use it as the end result of a process. Anyway, I'm posting the code I use to do it; I'm wondering if anyone has a more elegant...

Mr. Booty, Thanks for your quick reply. In addition to the issue with 'missing records', there are a few other items that push me away from using an autonumber solution. Namely: If the query returns a filtered list (which it will most of the time), the first record (i.e. number 1) may not be...

I'm interested in having a sequentially numbered field show up in a query. The reason is that the results of the query will be directly exported to Excel, and as the file is sorted and filtered, it would be helpful to have a field that tracks what number the record was. As I'll be distributing...

What I suggest doing is creating a graph on the form where it will reside. Use the wizard to feed it the data that you're interested in, including the information for both the bar and the line. Then, after the graph is displayed, double click on it; this will allow you to edit the graph's data...

If you have a form set up to view the data in the table, you could write a function that would return this value. I think you'd have to use a form, as I don't believe that you can write a custom function and have it be the default value in a table, but you can in a form. Create a new Module...

I've had the same type of issues in a situation that was similar. After some time and frustruation, I set up a form on the front end that was opened and hidden upon the user entering the FE. Every time the user opened or closed another form, the timer on the hidden form was reset. If the...

If you are open to having a single query for each time frame, turn on totals and then add the date field twice. You should end up with two fields with the record source being today()-date_created or something like that. In the totals row, set one to Avg. In the other, set it to Where. In the...

You may want to try a Union query. Go into the SQL editor of a new query and type Select * FROM query_name1 UNION ALL Select * FROM query_name2; If the queries are congruent (the same number of columns), this should 'stack' the queries information on top of each other. You should be able to...