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

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

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

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

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

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