 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2007Access Forms_
I have created a form based on two separate tables. One table holds names the other table holds data. I need multple to use the database and to have the name selections save for each auditor separately. Can anyone help?  SignatureAccessDrama >I have created a form based on two separate tables. One table holds names >the other table holds data. I need multple to use the database and to have >the name selections save for each auditor separately. Can anyone help? I have no idea what you mean by "multple to use the database" nor what an "auditor" might be, nor how these tables are related. I would assume that you will need a form with a subform - and possibly an additional field or table indicating who the auditor is, if each auditor is responsible for a different subset of the names records. Care to post a bit more information about the nature of the data and the structure of your tables? John W. Vinson [MVP] Okay, I will try to explain more. I have one table of just names, the other table has other data like loan numbers and related information. I used both tables to create a form. What I meant to say was I need "multiple users" to be able to access the form at the same time, by selecting their own names as well as allowing others to see that they are in a specific loan number. Please can you help again. Thank you SignatureAccessDrama > >I have created a form based on two separate tables. One table holds names > >the other table holds data. I need multple to use the database and to have [quoted text clipped - 11 lines] > > John W. Vinson [MVP] Oh I forgot. The names are in a drop down box on my form. Thanks SignatureAccessDrama > Okay, I will try to explain more. I have one table of just names, the other > table has other data like loan numbers and related information. I used both [quoted text clipped - 21 lines] > > > > John W. Vinson [MVP] >Okay, I will try to explain more. I have one table of just names, the other >table has other data like loan numbers and related information. I used both [quoted text clipped - 5 lines] > >Thank you I'll really need more information to be able to help! Remember that you can see your computer; we cannot. What is the Primary Key of each table? What is the Recordsource of the form? Is it a query joining the two tables, or do you have a form with a subform (preferable)? Do you have a "split" database, with each user getting their own copy of the frontend (a database with the forms, queries, reports etc.) and sharing a backend containing the tables? If not... you really should. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.