Search results

Password Query I am trying to limit what a user can see when accessing a database in access. I am only testing with this in access before taking it to SQL server. I have 3 databases and I combined the data into one set of tables and now what i am trying to do is a certain user can only view...

Bob: Thanks!

Hello, my question is in Access 2010 I am currently in the property sheet at a combo list i just added to a form to be more percise with the data the user will look for. My question is I know I have to be in Control source in order for the combo box to select the data that I entered from the...

I want the combo box to select what data from the old data bases they need. The three databases are railroad companies and the data in one table for example is invoices so someone making invoice or looking for an invoice for one company does not need all three. I added a field to the table...

hey, I combined 3 databases and I now combining alike tables so I will have only a set of each table instead of 3 right now. I added a new field to the forms a combo box but I have been looking around and a lot of people are saying I will have to recreate the forms. I added a combo box so...

Do i do that on the sub switchboard? Or on the form they are trying to open from the sub switchboard?

Thank you!

hello all, I recently combined 3 databases into 1. Now I am trying to get rid of the duplicates of forms so when you click on the business from the main switchboard it takes you to a sub switchboard to view or create invoices. My question is how or what kind of query (if its what I need) do I...

Thank you for your response, but I looked no unique indexes, and while i was waiting for a reply I did run C&R on a copy of the database and it ended up finding all but 18 records so I ran another unmatched query on both tables because I am assuming that its not the 18 records I was missing from...

I am transferring data from 3 data tables into a separate table that is the combination of all 3. the First table appended no problem, the second one appended all but 18 records of the 4989, and the 3rd table errored and did not append 1272 records of 6662 due to key violations. Sad thing is...

David, I do apologize for my post , thank you and I will give it a try! Chris

Hello all, I was reading some past posts on this site about doing this but my situation is a little bit different. I have 3 different databases some with the same queries and data but not all is the same. Can anyone help me out at least on where to go to learn how to do it ? Thanks, Chris L