Search results

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

I have changed things. I'm not trying different approaches, I'm just trying to get it done now. At first I enjoyed it but now it is just a thorn in my side but I want to get it done. The fields in the form are unbound because after I got the autofill with the combo box figured out, everytime...

Yes. I want it to bring up a blank record on the main form and subform if possible. I tried what you suggested and it still didn't bring up a blank form. So I attached the database and see if I did something wrong. Tracy

Yes. I am just doing this as an extra precaution so that the user has to actually think about whether they want to save it or not. The person that I am making this for I'm not going to tell him that access automatically saves the record for him. I will tell him he has to click the save record...

First let me say, I am sorry for all the questions lately. I thought once I got to the forms part of my database it would be smooth sailing boy was I wrong. Anyways, I have a form called Contractors and a Subform called ContractorsSubform. I need to add two sets of buttons one for the main...

Never mind I got it. Thank you from one pennsylvanian to another. Tracy