Recent content by InstructorGirl

I don't know if I should be posting this question here or if this is a programming question. I have two identical Access tables, for example tblDataYesterday and tblDataToday. The data from tblDataToday has updated data changes in it that are different from tblDataYesterday. I have a maximum of...

I may not have stated this correctly. I need to ask some more questions. I will re-post later. Thank you.

My table is tblReleases My fields are: ReleaseReceived ReleaseCompleted CMSEntry JRSEntry CRBApproval All of these are date/time data types. My form is frmDataSelection. I want to put these fields on a form and have the ability to select any field and enter a start date and an end date between...

Here is the rest of the procedure: Dim rs As DAO.Recordset Dim EmailTo, EmailSubj, EmailText, EmailFrom, EmailAtach Dim oFSO, sFile, sSig, oFile, sText, oFileA, sCurPath Set rs = CurrentDb.OpenRecordset("Select Distinct tblTechnicians.TechNumber, tblTechnicians.Email FROM tblTechnicians WHERE...

I've made a couple of changes to my procedure. I debugged it and it is stopping at this line in the procedure: If oFSO.FileExists(sFile) Then The error message says: "Object doesn't support this property or method." Does anyone have any ideas why this is happening? Help!!!!

I am not a programmer and am trying to send reports to multiple recipients from my Access database using Outlook 2010. I am getting a message box that requires me to click on allow for each email. This process will be sending out individualized monthly reports to about 300 technicians so it's...

Hi, my name is Alicia, I live in the United States in the midwest. I am an instructor and from time to time I get questions and/or software problems from students. I'm glad to be part of the forum! :)