Search results

So just and update... I took the old database (my backup) before i created the referential integrity relationship and deleted all the data in both those tables, did a compact and repair (to reset keys to 1) and then created the relationship. That seems to work and it won't enter random...

Ok so I pulled up the backup database that had the previous records (that I deleted) and compared it to the DB that I sent you (that have no records) and the data it's pulling (the random personnel names) isn't random and are the names that were on the records that I deleted. So if I deleted...

I just attached the whole database. I'm also open to any criticism people may have in regards to it. I'm not an access expert and am learning on the fly. I'm sure there are a lot better and easier ways to doing things I've done. The database I attached has not data in both tables because I...

So I just learned about referential integrity and I got it working on my database. I deleted all my "test records" and did a compact and repair to reset the primary key back to 1 and now it's acting all strange and adding random values to the table. Background: I have a pretty complex database...

Thank you everyone! It works!!!! golly something so simple. I do have that function in a module and not in each form. I have each form call that function from the module

Hello All. So I'm creating a database for the fire department I belong to. It's basically to log calls and create reports based on those calls. I will also log other things like problem tickets, apparatus checks, etc... Anyways I have it set up with access permissions. Each employee has a login...