I have a table with several fields set up. The first field is Product # (AutoNum) and the last field is Unit Price. I want to create a form with a combo box...

How do I create a drop down menu in excel?

I am creating a P/L in Access 2007 reports and have brought over all of my data and grouped and sorted by types with sum totals. I now want to take these...

I am using Access 2007 and am new at this. I am trying to take a text field, a GL account number so it is numbers but exported as a text field into Access,...

of course i would need a clients table, but i need to have criminal and private. want to add offences or matters. also want to be able to link an invoice etc....

I have somehow lost my staskbar with the start menu on which is usually at the bottom of my desktop. Can someone please help?

I have a table that has School data in it. I need to be able to indicate that a specific school has numerous options that can be designated to it - or not....

I have 2 functions that find the user name and machine name. I want to set these functions as the default value for the respective fields in the Table design...

I am new to Access (using 2007) and partly as a learning experience, I’m trying to build a database to handle training records for my division. So far I...

I am trying to determine how best to choose multiple selections from a list and I'm having difficulty. I have a list of approx. 50 acronyms in a seperate...

I have a database with multiple tables & forms that all tie back into one the main data table called "Contacts". I want to have the fieldname "LastName" a...

How do I use Access to create a test bank?

Hi I am trying to avoid being able to do double bookings in a form. I have a combo box holding 3 options eg AM PM All Day. Based on the date of the...

I have an Table tblassets which has a field fldcurrentloc. In another table tbltransactions I have another field fldlocationto. What I want to ensure is that...

I have a database which is split front end/back end. When the user starts the front end I want them to be prompted to select which back end to use. How do I do...

I know the work around is to use the IIF(,"Yes","No") statement, but is this going to be fixed or is there a need to have it this way from now on?

Office 2003 SP3 This one is much harder. It seems when you like Access tables to SQL Server tables, and one or more of the joins are via GUIDs or in Access...

I'm getting weird problems in Office 2003 SP3. The first one is simple to reproduce. 1) Create a new blank database. 2) Add a new table "Table_1" and add a...

This is not a drop dead issue, yet is there a way to remove empty input mask entries or old ones that have been created? I've seemed to have collected a few...

help how do i make up a table , record sheet with names, date, amount payed, signature on it ?? i have never had to use any of these programs before and am...