Search results

I'm still having issues. I think it's because the records in tblA that I am trying to delete do not have any corresponding records in tblB If you have a moment, look at the attached. Using the fdsReportStart form, add a new report using a specific date. Close all and run the fdsReportStart...

By the way, I'm constantly impressed with the willingness of you all to help out. It's really incredible. Thanks Uncle Gizmo, jDraw, vbaInet , and others for having such amazing help available and the donation of your time!

UG- The select query will work. From what I could learn, looks like I'm making some typical beginner mistake. jdraw- let me work through this. I can't thank you enough!

I cannot get this to work: DELETE tdsReportData.dsReportID, tdsReportData.dsReportDate, tdsIndivData.StaffID FROM tdsReportData LEFT JOIN tdsIndivData ON tdsReportData.dsReportID = tdsIndivData.dsReportID WHERE (((tdsIndivData.StaffID) Is Null)); Please help! I'm sure it's something fairly...

I'm gonna check this out.....

How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form? In other words, how to auto populate the primary key to multiple records displayed the subform? HELP!

This is definitely got me on the right track- thanks Galaxiom! Greatly appreciate the help!

I have a form that supervisors use to input employee accountability for each day. Once supervisor completes the input, a command button is selected and records are appended to an archive table and then deleted from the "live" table. End of the month, reports pull from the archive table to...

Thanks Paul!

Greetings everyone! Like many, I'm here for help. I've been tagged by my supervisors to create a database for our department. Along the way I've come to love Access and am very eager to become proficient. Looking forward to meeting some new friends! Watson