Recent content by InspectorJoe

Using Access 2000. I don't know about the reinstall though --- all other tables in the database function correctly. This error occurs only with one table. Additionally I have multiple copies of this database and all other copies allow access to all tables. It appears something happened to...

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

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?

Thanks. I guess I was having a brain fade. I didn't think of using the quotes. When I would just enter the list name it would error because it would not recognize it as a legit email address, but the quotes took care of it. Thanks again!

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

Thanks. It worked like a charm.

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

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

Am I to use that code to create a module? I guess I not sure where or how to implement the code you suggested.

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?

Worked like a charm! Thanks so much.

I think that will work, however, the date and time are already being captured in separate fields. Is there any way to take the short date and short time fields and combine them to a general date that includes both date and time? Then I could implement the solution you suggested. Thanks.

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