Search results

Plog, I hope we can get on the same page hear. Please understand if I seem direct it is only because I am frustrated at my lack of ability and understanding to get this done the way I want to: The best and easiest way and most sensible ( for the user that is), certainly not for me creation...

I understand and do have a form for every table. Now, finally I hope, I am creating a form from the Materials_Returned table to enter returned materials and populated the Materials_Returned table? The thing is I want to show the user of the form the Last name, First name, Material _Name...

Sorry missed the attachment.

Okay, the new relationship is attached and I understand this was your original suggestion. It is clear to me and I thought the same. But, when I do this and create a form....and insert a Combo Box should I only select the items listed in the Material_Assignment table as the row source...

Will a snap shot of the relationships give you enough information? A snap shot is attached. As you can see I added the Return_Materials Table and linked it to the Material_Assignment via Asset_ID(FK) to Asset_ID(PK). This Obvious, I hope, because only materials assigned or "checked out" can...

Plog, Can't get it to work. The fields are not displaying like I need them to in the Returned_Materials form. I have a mess. Dale

Plog, Not sure I understand what is going on here. Now that I have removed the Date_Returned and Quantity_Returned fields and now have a look-up field that indicates if the material is Allocated and Returned which by-the-way works for both deleted fields, why do I need the "Return_Quantity...

Got it Thank you. Let me chew on this and make the changes. Be back in a few days with another post. Hopefully all will be working.

But this presents a problem because I need to know when a product was returned and how much for two reasons: 1: because the amount of time a piece of material was out is how much we charge for the usage and 2: because some materials in large quantity are not all returned at once. I think I...

Finally got my DB straight so I am not using calculated fields however can't figure out the best way to handle the Combo Box so I do not show closed records ( Item checked out and item returned). Please see the attached table of materials checked out and materials returned. Will someone...

CJ, simple and effective, Nice! What more could you ask for. This has helped a lot thank you.

Okay, I'll give it a good look tonight. One simple question, I see no relationships between the table. Is this because of the access 2010 conversion? Thank you.

Wow! Your code is precise. Still trying to follow it. Sorry but still not quite sure how to do this. Can I copy the entire contents of a record listed from an unbound Combo Box? If so, what would be the index for that new record so I can update the fields.

You all have been a great help and I Thank you but now I am not sure how to proceed. Please offer advice and perhaps code statements to help. Please allow me to explain: I have a parent table with two child relationships as follows: Parent: Material_Assigment Child: Materials Child...

If you work like me to upload what I have done so you can take a look and try, I would be happy to. Thank you very much for your support. Dale

Not quite, the Materials table and Employees table are both completely populated and for the most part fixed except when new materials or or new employees are added. The Assigned_Materials Table is populated with records of each employee that checks out a material indicating the Employee...

Please reference the attached screen shot of the DB's relationships. Needless to say this screen shot shows all tables, table fields and parent child relationships. I don't want to be over bearing with this explanation however I am not quite sure which details will help explain the problem...

I hope my experience will be of help to some people because now I am in over my head in a job that has taken three times longer then I ever expected. I was volunteered to create a DB which simply tracks the equipment at our facility and who the equipment is assigned to. I volunteered simply...

I think so too. I am one of those "old time" basic programmers who created a few DB's using Basic in the 90's. I thought I would help out the boss here and create a DB to track our equipment and who it is issued to. These applications (Access 2007, 2010) have come a long way and so has the...

Thank you, just thought I would let you know, the field name is "date_returned". so should not be a problem. In any event, I have come to realize, I am using a calculated value in my parent table "Materials" to calculate the amount of a material remaining. This is a mistake and should be...