Search results for query: *

Using a client side cursor seems to make a huge difference, so Filter may be fine. Thanks for your help Golom!

Filter doesn't seem to be an option unless there's some way to optimize a recordset for Filter use. I've tried it three times and Access literly freezes for about 5 minutes when applying the filter (for a single search).

What is the best way to search a recordset on multiple columns if the Seek method is not supported? We're moving a growing table out of an Access MDB and into an Oracle DB. Every day 500-3,000 records are processed from a flat file and compared against what's in this table and records are...

Thanks again PHV! That does work. It feels a little clunky, but it works. I'm a *little* concerned about how it will affect the performance of my forms that already have a timer on them. Such as one that functions as a near-real-time agent monitor and refreshes every 6 seconds. Private Sub...

I'm not sure what you mean by a one time Timer? Just to test, I tried setting a timer on the form and doing this but got the same result: if i=0 then me.move 0,0 i=1 end if The Timer even fires before the toolbars are removed. I guess I could set the timer interval out to say 20...

I get the same result with all three events (Form_Load, Activate and Current).

Thanks for the suggestion PHV. Unfortunately I get the same results with Activate as I do with Form_Load (gap between top of window and toolbar).

Is there any event that indicates form rendering has completed? I want to reposition/resize a form based on the available space in the main access window. In the Form_Load event, if I do: Me.Move 0, 0 ...that should move the form to the very top left of the main access window under the menubars...

I may be over simplifying this, but my understanding is your skill or product field has data values like "skill", "skill_1", "skill_2", etc and you just want to group by "product". If that's what it comes down to then here's an ugly way of doing that. For this example, let's say you are just...

That does it. Thank you Remou! I just had to include the format(job_date,"w") in the select part as well.

I left out that I'm using "select DISTINCT". When I copy the SQL string into a query, I get an error message saying "ORDER BY clause (format(job_date,"w")) conflicts with DISTINCT". However, if I change it to "order by format(job_date,"ddd")" I don't get the error, BUT I also don't get the...

Hello, I'm using an SQL string to populate a multiselect listbox with dates. It's something like this: select job_date, format(job_date, "ddd") as Day from job_list; ...and I want to sort by Day of Week in order (i.e. Mon, Tue, Wed, Thu, Fri, Sat). So I tried this: select job_date...

Thanks for your reply PHV! That's quite a bit faster than the code I was previously using, however it's still slow (the union query takes about 3.5 minutes). Right now I'm linking the tables from 6 Oracle databases, and running the SQL off the them. I've read that opening the tables directly...

Hello, I need some help in finding the best way to compare records in a Access table to the records in 6 different tables (with millions of records each) in an Oracle DB via ODBC, using VBA... Notes about the tables in the Oracle DB: (1) It's not an option to modify the them, (2) Access...

Thanks Duane. This worked for some things, but I still wasn't able to find a way to set criteria for a field in the query that needs to check to see whether it should look at a multiselect box or one or two text fields for a range (based on whether or not a checkbox is checked), for example, I...

Duane -- Thanks for your reply! In my original post I only mentioned the need to filter by date... There's actually more criteria on the form, including a couple of list boxes I need to extract the selected items from (if a checkbox next to the listbox is selected). I gave your suggestion a...

I have a report that shows sales rate by employee, and I want to be able to sort the report by sales rate (desc). The query I'm pulling from has multiple records per day per employee, so to get a summary in the report I group by employee, and don't display any detail. I can't create a summary...