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 wOOdy-Soft 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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