Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ejm8
  • Order by date
  1. ejm8

    Alternative to using Seek method on Oracle DB for multi-column search

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

    Alternative to using Seek method on Oracle DB for multi-column search

    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).
  3. ejm8

    Alternative to using Seek method on Oracle DB for multi-column 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...
  4. ejm8

    Event indicating form rendering has completed?

    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...
  5. ejm8

    Event indicating form rendering has completed?

    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...
  6. ejm8

    Event indicating form rendering has completed?

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

    Event indicating form rendering has completed?

    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).
  8. ejm8

    Event indicating form rendering has completed?

    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...
  9. ejm8

    Querying Data with variable end string

    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...
  10. ejm8

    Order By day of week using Format(date, "w")

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

    Order By day of week using Format(date, "w")

    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...
  12. ejm8

    Order By day of week using Format(date, "w")

    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...
  13. ejm8

    Comparing records in an Access table to multiple tables in Oracle DB

    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...
  14. ejm8

    Comparing records in an Access table to multiple tables in Oracle DB

    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...
  15. ejm8

    Sort a report by group totals

    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...
  16. ejm8

    Sort a report by group totals

    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...
  17. ejm8

    Sort a report by group totals

    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...

Part and Inventory Search

Back
Top