Need help with forms and reports--I've just forgotten what to do to connect them properly

[DebP]

Hi,
I built a small access database for my org's IT inventory several years ago so I could track who had what, who'd had it before, etc. I had it working for awhile, but now my forms aren't allowing me to do edits.



I've been going into the specific tables and making the changes, but that's tedious. Anyone out there that could help me get things reconnected?

I have a fairly good grasp of Access, but use it so infrequently I end up spending hours trying to remember what to do and not getting very far. I'm certain most of the fixes will be simple. Only 3 tables, 2 forms and 5 queries...

Thanks!
Deb

[Welshgasman]

You would need to upload the db?
Compact and zip it, if it is too large otherwise.

[orange]

Deb
I agree with WelshGasman--- provide a copy of your current database (compact/ then zip). Also provide any info on process logic, number of users, who does what with respect to the database (backup/changes/reports....). For a reader(s) to help you, he/she needs to assimilate the info necessary to understand the requirement, the current database, any/all tables, queries, forms, reports...
People will help but they need a good base to start.

Here's a generic model for a small IT Inventory that may offer some insight.


Attachment 51768

[DebP]

MHP Equipment.zip

So sorry! I'm only at this job M-Thurs, so I was not been able to answer you quickly.

I've zipped my database and attached (I think).

I'm really the only user of the database. I'm tracking basic info about our equipment, who the machine is assigned to and when. Not much more than that. I have a few simple reports for the auditors.

What's happened is that I can't make changes to the user section of my form, so I end up making assignments manually through the tables. It's not connected properly and all attempts to correct have been for nought.

Thank you!

Deb

[davegri]

MHP Equipment-davegri-v01.zip

See if this helps. Your subform recordsource was a non updatable query (with Data Entry = Yes).
I simplified the junction table. It's primary key should not have been used anywhere, just the foreign keys for the user and the equipment.
User_PK is now primary key in tblUsers.
Added combo box to subform to select/assign user.
Adjusted relationships for data integrity and cascade deletes.
Adjusted the queries to conform to new table structure.
Adjusted the report to conform to new table structure.

Edit:
And make sure your database file is in a trusted location.

[DebP]

OMG! Thank you so much, davegri!!!

Technology is only a part of my job description so spending a lot of time was completely out of the question--my boss kept telling me to use Excel!

You made my day!!!
Deb

[davegri]

You made my day!!!

Happy to help. It's a nice little DB.