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!

  • Congratulations bkrike 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: *

  1. InspectorJoe

    Table inaccessible with JET error

    One table in my database seems completely locked: can't open, edit, export -- keep getting "object requires newer version of Microsoft Jet engine" I downloaded a standalone copy of JET 4 ran it on the db and it errored out. Tried to run with 3.x compatability, then with 4.x, neither...
  2. InspectorJoe

    Filter before SendObject

    I need to send a report, but only for the current record on screen. How can I filter/query using SendObject to email a report in snapshot format for only that record?
  3. InspectorJoe

    Send Object Email List

    I need to send a report (use SendObject) in a snapshot format to a number of recipients. My list of email address exceeds the character limitation for all fields (TO,CC,BCC). All addresses that I am sending to are in an exchange environment utilizing Outlook 2000. In Outlook I have a...
  4. InspectorJoe

    Changing format of numbers to date field

    I have been given an employee data extract of 2500+ records. Each employee's birthdate is stored in the "PRDOB" field. It's data type is set to Text. The data is YYYYMMDD with no separator characters. I would like to convert this data to a new Date field "DOBedit" which...
  5. InspectorJoe

    Generating Specialized Auto Numbers

    I am looking to create a tracking number for each record. Ideally, the number would appear as 01-0001. "01" signifing 2001 and "0001" as the first record in 2001. This number would increment by one for each new record (i.e. 01-0002) Finally, this number should automatically...
  6. InspectorJoe

    Email to Pager from access

    We have pagers with email addresses. The pagers, however, cannot view attachments. Is there a way to send a query object where the query being sent is in the body of the email text instead of an attachment?
  7. InspectorJoe

    Calculating # of Hours from Date and Time Fields

    We have a short date1 field (00/00/00) and a short time1 field (24:00). We need to compare date1 and time1 to the current date and time when a date2 field is null. The result will be the number of hours from the date1 and time1 to current date and time. Example: Date1: 01/01/01 Time1...

Part and Inventory Search

Back
Top