Recent content by RobInAZ

Thank you again for the help. I really appreciate it.

Thank you it worked. One other question. What would the code look like to allow entry in any of the three fields: Email and/or E2 and/or E3

I have a database that stores expiration dates of department charge numbers. The database emails personnel, that I enter into each record, at 15 and 30 days prior to expiration using SendObject. I have a total of three fields where I enter an email address for each record; Email, E2, and E3...

CJ, Thank you for your help. The code you provided fixed my issue. -Rob

Trevor, I have been working with the code you provided for hours today. I made some progress but I am getting an error on: strRecipient = rsEmailee.FindFirst("Email = ' " & rs!Email & " ' ") CODE: Public Sub ProvidedCode() Dim rs As Recordset Dim rsEmailee As Recordset Dim strBody As...

Trevor, Thank you for your response. I really appreciate it. I am working with the code you supplied right now. -Rob

This is my first post and I have limited experience with Access. I hope that my terminology is correct. I have a table titled 3MesaMstr that has four fields including EstComplDate (date/time), ActivityID (text), Email (text), and 30DayRmndr (date/time). I have a Select query that selects...

Rich, I looked all over for the multi select option. Can you give me some directions. I am using Access 2000. Thank you, Rob

My database has a section that lists a bunch of street address in a continuous form. A user needs to select one address (via a check box) and then click a command button to move on. The problem is that a user can by mistake select two or more addresses and click the command button. If two or...

Thank you all for your assistance and quick responses. I used shacket's suggestion and it worked perfect. Here's what the query looks like: Field: Right([DocNum],2) DocNum Table: Documents Sort: Ascending Ascending Show: X Criteria: Or: Thank...

shacket, Thank you I will give it a try tomorrow. -Rob

I have a field that has entries like: 1234/SA/002-98 184/SAPPF0012-97 2234/7843/094-96 B23334/SSHSJU002-01 1234/SA/002-98 999/JHSU4/003-96 I would like to sort by the last two digits of the entry and then sort by the beginning of the entry excluding the last two digits all to be displayed on a...