What is a phone number input mask that would result in the first case 916.723.5828 and second case if 916 is not entered 723.5828 notice the first "." is...

I recently upgraded to Office 2007 Pro. I use a mail merge of word and access for invoices and customer lists. When I open the word document it is linked...

I am having the same problem in Access 2007 but do not know how to solve it. I have already change the Primary Editing Language to "English" in Office Button...

I am using Windows XP SP3 and Access 2003 SP3. I get the "windows cannot find..." when I open via a short cut on my desktop, which can apparently be fixed by...

I'm going to add one way quickbooks integration to one of my Access 2007 databases so transactions can be exported out of my database and imported into...

Hi All, I am entering timecards into a database. On the timecard I have Truck_Num, Material, Loads (simplified) I have a query that gives me the data I want...

My database is split into back and front ends. I already have one text field that allows multiple values in a combo box with value list. When I add another...

have 2 db with autonumbers, when i append a record from 1 to other, it now changes the autonumber to 1+ the number from record appended. in 2003, i could...

I have the following command buttons on my form; New, Save, Undo, Delete and First, Previous, Next and Last. I'm having problems trying to enable and disable...

I suppose I shouldn't be concerned, but my record autonumbering jumped from 135 to 432,233 when I was trying to copy and paste common info. Any way to...

I have inherited an A2007 adb with a connection to SS2K5. I have recently begun trying to follow the various VBA code compiled by four different consultants...

My Access 2003 application was working for years. I then received "There is no object in this control" when I opened one of my forms. The form references a...

Hi All I have an MS Access 2003 database that has been operatiing fine for 6 months. All of a sudden I have a problem where after adding a record with VB MS...

Access 2007 - I have to label each claim with a claimtype based on a combination of fields and I'm not sure how to do this. In AS400 query, I used...

I have a database that has jumped in size drastically - properties show over 200 mg - did a compact and repair and it got it down to 74 meg but that still...

I'm in the process of upgrading an Access 97 application to Access 2003. This has mostly been pretty smooth, but I'm having major problems with a process...

I setup a briefcase that contains an Access 2007 database file. When I made change to the DB in the briefcase and try to sync with desktop, get an error...

I may have an opportunity to do some freelance work on an Access db. Has anyone here done this before? I'm wondering what I should charge for the service. Do...

Hi All I have developed a MS Access 2003 application for a client. It is spilt into two with a data back end and a forms/query/modules front end. The majority...

i have got a query looking at Sales History against Forecast and want to see the accuracy to forecast as a percentage in a pivot table. The fields I have...