I have split my data base and created a mde file. However i am limited to getting into the database if someone else is in it. I have verified that my...

I have built the switchboard and button to exit the database. How do I also make that button on the main switchboard close access completely?

I have over 1,800 Microsoft Databases in 1,104 schools. I designed a special table for an international testing service. I noted the table name in my...

I have a field with dates formated as text mmddyy Examples 120149 should be 12/01/2049 030130 should be 03/01/2030 021796 should be 01/17/1996 061797 should be...

Hi All, I am trying to get my combo box to look at a stored procedure. It always looks at the first column to fill the combo box. How do I get the combo...

I'm building a log that needs to be able to spot duplicate IDs, but not block them. They won't always be exactly the same, so I need it to flag "similar" IDs...

I have a combo box that opens a macro "After Update". The macro opens a selection query. I have tried to put the combo box selection in the selection...

Hello, I am trying to export 2 tables which contain the paths and names of files. When viewed in Access 2003 the order of the paths/file names appears the...

Access 2007 service pack 2 I have three tables (clientsw, eligibility and eligibilitynotes) that have matching number fields (casenum). I joined these three...

I have a fairly complicated list box on a form, and in an earlier post it was suggested that I change the list box for a combo box. Is there an easy way...

Can anyone give me some ideas for creating a small database to record annual leave for members of the same department, but in different groups (about 30...

I'm using a switchboard in Access 2007. I require a 'password' to get to the operations which follow after clicking a particular button on the main ...

I built an form that needs to be in edit mode. The form was built off a query but I am unable to edit the information in the form. Any ideas

Is there anyway to turn off the pop up calendar that appears next to date controls in Access 2007 by default. I know I can do it individually on each control...

I have a table for my customers which is linked to a table for activities on the customer name. Over the years most customers will have multiple records in...

In Access2007 I noticed sometimes tab controls have white pages and sometimes they just use the color of the detail (or whatever is behind them). No matter...

Hello all, using Access 2007 w/ service pack 2 on Window XP service pack 3. I created an append query that is supposed to select fields from two tables in a...

I have a BE of Access 97 and a FE of Access 2000. I have linked to the A97 files from the A2000 and created a query that produces the corrent results. The...

Hello all, using Access 2007 w/ service pack 2 on Window XP service pack 3. I created an append query that is supposed to select fields from two tables in a...

Hi All, I've got a main form (frmProductUsed) with a drop down list (cmboProduct) that contains our products. It's ordered by Product Code that's usually 2...