Good Morning,
Here is my situation. I have a created a database that will allow a user to enter information on a form once that information has been entered the save button is clicked. After the save button has been clicked the user is allowed to Review Report once that button has been clicked the user will be able to e-mail the report to the correct firm. However some of the things are not working correctly and I need some assistance. I think the my main problem is I wrote a query to create a TempReport_Table using my main Table TrackingSystem3 and in oder for me to populate information in the TempReport_Table i have to double click the TrackingSystem3 Query in order for that to work. Here is the query that I am trying to use
SELECT TrackingSystem3.FirmNumber, TrackingSystem3.NumberofAccounts, TrackingSystem3.EmployeeID, TrackingSystem3.ErrorCodeDescription, TrackingSystem3.ErrorCodesandCorrections, TrackingSystem3.Agreements, TrackingSystem3.TypeofCommunication, TrackingSystem3.Time, TrackingSystem3.[Opened Date] INTO TempReport_Table
FROM TrackingSystem3
WHERE (((TrackingSystem3.Time)=(select Max (Time) from TrackingSystem3)));
If i had a clue on where to add this query in my current VBA code so the TempReport_Table is populated automaticaly i would be a very happy person but at this point i am very confused and I need some assistance. This is just one of 3 issues that i am dealing with right know if i could get some assisatnce on this one i could deal with the other 2 over the long weekend. Again I am very new to VBA and anything that someone could do to assist me would be appericated. I have attached a copy of my database and again...Thank You so much.....