Search results

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...

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...

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...

I have a form called contractors. It works exactly like I want it but it won't let me edit it. The form is based on a query. I have checked the query as stated to do on some areas of this forum and I am able to change it by typing something in a field and it also updates the form for me but I...

I have a form that is locked unless they click the command button to edit records. I want a msg box that when they click the close button it pops up with something like save edits? Just as an extra precaution. But I only want the message box to pop up if the form is in edit mode. Is this...

Okay, I am ready to throw this database out the window but I am so close to being done that I want to see it through to the end so I guess I will continue plugging away at it. I have a Contractors form and Contractors subform. I have made the allow edits, allow deletions and allow additions...

I am attaching my database so you can get a better understanding of what I need. I want to make a form called clients based on either the clients query or clients table I also want a subform based on my order details table(I can create a query as well) however, when I do a subform using my...

I am making a database for a somebody who sends some of his work to subcontractors. He needs to be able to pull a monthly report on the work that his subcontractors have done along with the amount of money owed to them and I don't know how to do this. I know I should make a query but how do I...

I have been searching this site and I have found numerous postings that people are having the same problem as I am but I still can't seem to grasp it so I am posting myself. I have a form that has 12 fields plus a subform. The fields are Client Number, Client Name, Client Address etc. The...

Hi everyone, I am a newbie to the more advanced stuff in creating a database in Access so I would really like some input. So I have a few questions. Question 1: I would like to create a macro or some code so that you can import data from spreadsheets with different file names with a click of a...

I have a database that a client of mine has started to create. He wants to be able to import data from an excel spreadsheet into a table in Access. I created a macro that works fine but now I am having an issue with importing additional data. His excel sheets consist of Agency ID numbers, first...

I have a database that a client of mine has started to create. He wants to be able to import data from an excel spreadsheet into a table in Access. I created a macro that works fine but now I am having an issue with importing additional data. His excel sheets consist of Agency ID numbers, first...