Search results

After hours getting lost in the Access world, I finally figured it out that an append query works just fine. I add the record, then store the primary key generated into a variable. I then use an append query to append the records in the related table using the primary key that was stored in memory.

Reason for me wanting to use unbound forms is that the database sits on a shared network drive. Currently the forms are bound and I'm trying to steer away from that because users start creating a record and don't complete the task. Because of Access' auto save feature, blank records are created...

I'm exploring that option - use the recordset as the rowsource on the subform. I'm new to this and trying to figure out how to implement that. I'm picking bits and pieces here and there. Thanks.

Thanks, Gina I'm currently using the recordset's AddNew method to add records to the main table. I have also used a SQL statement to add records. However, the problem arises when tyring to make it so that the main form displays its related records in the subform. I guess what I'm trying to do...

I just got introduced to Access VBA and recordsets, and I have been trying my hands on a few codes. Using recordsets, I am able to navigate through records, search, etc. The issue now is this: I have three tables - tblEmployees, tblDepartments, tblPayrate A primary key is used to link...

Hi all: I am a full time employee with a security firm based in the U.S. Recently, I decided to switch gears and get in school for network security. I have gained a keen interest in programming. It's quite gratifying to write a code and sit back to see how it works (instant gratification I...