Search results for query: *

I want to be able to send out an email, but instead of having my email appear as being the sender, I want to have another email appear.

Does anyone know how to get a list of all the table names in the database.

Now I'm getting a mismatch error. Well, the reason for me converting the field to ShortDate was because my query didn't return what I was asking. I am grabbing dates from multiple tables each table's datetime format is different. When I query for today's date, it only returns the dates with...

i get the same data type error message.

Well, I guess I'm doing this incorrectly then. strFld was suppose to be the field name in my table. I wanted to convert everything in this field to short date. How would I go about doing that? Thanks,

I am getting a data type conversion error. WHY? strFld is already of data type DateTime. strFld = "MEMBERCALLEDDTE" Set rst = db2.OpenRecordset("tblUNION_UserCallResults") Do While Not rst.EOF rst.Edit rst(strFld) = FormatDateTime(rst(strFld), vbShortDate)...

is there a way to find out who has last opened or modified an Access file?

Is there a way to transition to the next slide by double clicking instead of one click?

The databases I am working with do not have a datestamp on each row.

I am tring to find out when data in a table was last modified. I don't want the details from the properties, because I can go from selecting forms to tables and it records the file as being last modified. I just need to know when data was actually modified within the database itself. Thanks

If (txtResponseDate <> " ") Then IssuedDate = txtDateIssued 'gets date from txtfield ResponseDate = txtResponseDate 'gets date from txtfield ResponseTime = ResponseDate - IssuedDate Time1 = Format(ResponseDate, "hh:mm") 'get hour/min portion Time2 = Format(IssuedDate...