Recent content by RitaM

In design view, I click on "Property Sheet", but I'm unable to click in any of the fields. Does anyone know what makes the property sheet unaccessible?

I loved them!!!I created this database years ago. I feel like starting all over again with fresh tables/field names, but I don't want to mess up the form. I have taken a SQL course and advanced Access Classes. I've learned more, though, from designing database and figuring things out through...

IT WORKS!!!!!!!!!!!! Thank you so much!!! You are amazing!

When I open the form [Kits], it seems it's working with the exception of plugging Component Part numbers. isn't getting added. To see what's left in inventory, I open the form [Products] on the switchboard. It should show kit's completed. A while ago I changed the field name from "component...

I'm not sure what happened/what I've messed up now. Now when I open "fKits", this message is popping up "formulare!fkits!qKits". I've been trying to figure things out, but I'm not getting anywhere. I did go back and saw this in the earlier file "qKits". I am attaching the front and back end...

Here is the front end.

Thank you so much for all the extra work you did. I did spent time getting queries renamed and forms working. I was hoping I could just go in and copy/paste the code into the form Kits. I can't even work with the forms, because I'm getting errors. I hate to bother you when you've done so much...

Sorry for the delayed response. It took me several days, because the database was a mess!!! Ugh. The next time I innocently change table names and fields I'll think twice. It really messes everything up. It took me awhile to get all the forms & queries working again. I'm just in awe of your...

My inventory totals are generated from the table [Inventory Transactions]. I enter finished product and it autofilled!!!!! You are amazing. I have to run my son to football practice now, and I just had a second to look at this. I'm soooo excited!! I can't wait to see how you got this to work...

OK I changed field names so I'm embarrassed to send you this very "messy" database. I thought I would have time to clean it up, but I haven't had time to do it. It is split so you'll have to relink "HopePacks" to the back end. It opens to a switchboard. I put the form in RED "Kits". I explained...

How to autofill? My form KitID: [1] Autonumber Date: [1/1/13] Finished Part: [2404] dropdown list from Finished Part's Table Quantity: [10] Subform************************** KitID: [1] Foreign Key Component (component parts automatically fill?) Part Quantity...

Structure Explained I'm sorry for not explaining the database better. Finished Parts Table: (just numbers--example 2404 for International School Kit) Component Parts Table: (dropdown field for finished part and component part #) Inventory Transaction: (table for all transactions--adding...

I created an inventory database for a nonprofit. I have a table for finished part numbers and another table for component part numbers. Now they are assembling school kits (20 items for each kit). I'd like to create an easy form for data entry. I'd like to have a form where they could just...