Search results for query: *

Shooting from the hip here, but you can give this a try. You could creat an entirely new table (something like tblPartsComments). It would have 3 fields: CommentID - Autonumber, PartID - Number, and Comment - (either text or memo depending on the how long you want the comments to be) In your...

If you'll be able to get all three tables to join up, then you should be able to create a query as well, that contains all of the data from all three tables. Once you have created that query, in the ClientID field you could add criteria to match the ClientID textbox on your main form like this...

Hmmm...are the Client Numbers the same in each table? Are you wanting to combine all 3 old tables into one new table? If the Client Numbers are the same in each table you can create a "Make Table Query" linking off of the Client Numbers. If you want to leave the data in 3 seperate tables, you...

There are probably prettier and better ways of doing this but, one way you could accomplish this is to create 2 unvisible text boxes on your form. Change the control source of one to =Me.DocList.Column(0) and the other to =Me.DocList.Column(1). Base your subform off of a query with criteria...

It sounds like you "may" want to use a Union Query if your field names are the same. Create a New Query. In Design View select View->SQL View In the resulting window type something like this: (The following union query uses the UNION ALL statement to retrieve all records, including...

I have been incorporating the Drag and Drop procedure (found in the Microsoft Knowledge Base at http://support.microsoft.com/?kbid=287642) to drag data from one listbox to another on a form. It works great, but I'm having one small problem. Once I "mouse down" on the item that I want to drag...

Could anyone tell me if it's even possible to export/import linked tables with autonumbered fields and have them line up correctly in the imported database?

Thanks for the reply. Yes, this would definately be the way to go if all users were connected. I have created a few of this type at my primary job. However, we are located in various areas across the nation and I don't have nearly the skills required to develop an online database. That's why I...

A group of managers and myself all use a Microsoft Access database to quickly assign different individuals to different teams depending on which requirements are required for different circumstances. Each team consist of 4 groups of 6 individuals each. I have 3 seperate tables linked by their...