Recent content by cubbyamber

Thank you, it worked like a charm. Tracy

I have successfully imported GHudson's browse forms, table, and modules into my database. I need to import an excel sheet into my database. I have tried to change the code on the import with different codes I found via this forum. I have changed the import table name to my import table name...

The only problem with linking a spreadsheet is that I might have 20 or more spreadsheets from different clients. Tracy

I do have one more question: I have attached the database for reference. I'm not understanding how to do a pop up form so that I can add the client number to each record. My problem is my append query doesn't give me the option to put a client number in it. I hope this makes sense. BTW, my...

Thanks, it worked like a charm. I didn't get any warning messages but that's okay now I just don't have to stop them. Tracy

I got the append query done. I can't do a macro to run it because the Sql is more than the allotted 256 characters. I did however, create a command button to run the append query which works fine however, I don't know how to make it so that after it appends the data it deletes it in the temp...

Wow, you guys are quick. If I use a macro to do a delete query can I make it so I need no interaction from the person using the database or do I have to create another command button? Tracy

Okay, I follow you but if I use a temp table, shouldn't I do a delete query as well so that my database doesn't get bloated? I am doing this for a person who is Access Illiterate worse than I am so this is my thinking: Putting an import button on the switchboard Also having an append button...

I want to import an excel spreadsheet into my database. The import works fine but I was wondering if there is a way to assign the records to a specific client. Here's what happens: A client sends me 2000 orders. I import it into the tblOrderDetails. I want to assign a client number (which I...

RG, I just sent you a PM let me know what you think. Tracy

Okay, I see what you are saying. I made an Order details form so that when my client gets new orders he can place them in the order details form and assign each order to a specific subcontractor then it populates the table. Tracy

RG, I'm not sure I am following you about using the contractor Id when using the client form and Client Id when using the contractor form. The clients and contractors are two different things. They are not connected to one another. The Client sends a list of People that they want my client...

RG, I am working on the other form that I need done called clients. I have gotten it so that it automatically selects the right record but I can't get it to do anything with my subform. I am attaching it so you can hopefully tell me what I am doing wrong. I also noticed that the autonumber...

That is great. It is what I wanted. Here is what the contractors form is suppose to accomplish: The guy I am making it for is a PI and he gets "orders" from clients of people he is suppose to find which he in turn sometimes sub-contracts out to other people so I was making a form to keep track...

Thank you. that would be greatly appreciated considering I have been working on this for three weeks now. Everytime I think I'm getting somewhere I hit another roadblock. Thanks again. Tracy