Recent content by smiller

here is the database with the current master list tables

Ajetrumpet, If you don't mind revising it some and setting me off in the right direction, I would greatly appreciate it. If you are too busy or just don't want to revise it, i understand. I have tried reading a book and other help notes but still greatly struggle. Thanks again for everything!

thanks so much for all the advise. If you don't mind reworking it and have time that would be awesome. I haven't touched it at all yet because I didn't want to push it anymore in the wrong direction. I'll look at all the instructions and play around with a copy of the database and see what I...

ok lets see if this works....

I have attached the database I am creating so you can take a look at it. Currently, all the base data is contained in "Lathe Master List" and "Mill Master List." The forms then that I will be using to input transactions are "Insert Request Form--Lathe*" and "Insert Request Form--Mill*." The...

I have one table that contains all the base data for parts that I have. Numerous fields identify a part. No one category can 100% define it. I have another chart that I want to link to each part in the main table. I am going to be inserting values as parts are inserted or removed for use...

I have parts that go into and out of inventory. Each time a part is removed or returned, the user inputs the number into the computer. I was wondering how I could link the numbers so that as parts were removed or added, the total number in inventory and the total number on the floor...

ok i put in a relationship too just to make sure that wasn't it. I realized now that if I put information into the subform, it sometimes reappears and sometimes not. I have the form and subform linked by type, spec #, and description. All parts have both a type and spec #. If the description...

if you are referring to the link child and master fields in the properties of the subform then yes I did. I currently have the 2 forms linked with 3 categories. If you are talking about anything else then no I have not linked them.

I have a part that is specified by two categories--type and spec #. I have multiple of each part that I need to chart the in and outs of. I was trying to create a form that would give the part and then have a subform in it with which I could see past transactions along with insert new data...

I'm sorry but I am not very good with access. How should I go about what you said to do? thanks

When I set up my chart, I made the part number of pieces the primary key. I then made a form in which I could look up or enter the data that goes along with the part number. I used a combo box so the user could type in the part number and find the part in a list of all the parts. After...

On my forms, I have a button that prints that specific record which works great. Now I need to print page "____ of ___" only if a certain criteria is true. I know how to always print it but is there any way I can print it at certain times and not others? Thanks

What do the validation rule and validation text in the properties box do? Thanks

right now there are over 900 entries and that number will just increase as time goes on. What I was thinking would be best is something that searches for the ID number (i think i made something that does this already) and then I can input that ID somewhere in the form sheet to locate the...