My users would like the area code to be defaulted but allow then to change
it.  So I create the input mask and set the default value.  However, if they
don't type in a phone number then the record gets stored with the area code
default.   So I kluged a way to go through the ...

i have trouble with e-mail window

My boss and I are stuck trying to figure out how to make our calculations be
stored in our database table. Currently our calculations are in the design
view of the form. We are able to see the anwer to the calculations, but they
are not stored in the database table. What are we ...

I would like to create a reminder in access to let me know when a date field
is overdue.

When I click on new blank database, it opens as an MDE with 5 hidden and
uneditable tables locked in. They are as follows. MSysAccessStorage,
MSysACEs, MSysObjects, MSysQueries, MSysRelationships.
How do I open just a blank Access database application so I can add tables

I have an Access VBA Form that uses information from various tables.
The form I have used uses a subform.
I am trying to set up a query so that it displays what work an employee has
done. The user would select an employee from a list. That selected Employee

I have a form with two textboxes, both tied to field names in the table I am
using for the form.  The two fields are GroupName1 and Groupname2.  I need to
build a query or macro to run where if there is any text in Groupname2, to
transfer the text to a new record where the text ...

Im sure this has been asked 1000 times before but i couldnt find a
definitive list.  I have built an access 2007 database that is split into
frontend/backend components.  I need to distribute this to my end user and
also from time to time update the frontend.  Some frontend ...

I have two tables, one contains product information (Code and Name) the
other containes the bulk of infomration. This is variable depending on
situation. What I want to happen, is that I select a code # from a drop down
list. Once the code is selected, it automatically completes ...

I am planning on having an Access database that stores multiple years of
data.  The size of each year is around 600 MB.  For example, if I store 10
years worth of data, the database would end up to 6 GB.  
Do you guys think Access can handle that capacity?  Assuming that I have a

Hi every one, I am using  M.S Access Xp, I am trying to multiply a number
(Currency Format) with another number for the currency rate (Number
format –Single).
When the currency is a large number, the result will not be accurate??

Hi Iam really struggling with creating a stock control system on access. I
have set up the table with all the info required these cover three tables, in
stock, delievered stock and out stock I would like all these to add up and
show me what I currently have in stock, but I am ...

I transfered an Access database from my old computer running with XP on my
new Tablet PC running with Vista professionnal. I use this database to make
clients folders. Since I work as a psychologist, I receive my clients at my
office and take notes at each appointment with them. I ...

I am fairly new to access and i am trying to build an inventory database that
lists all our grounds maintenance equipment. I have all the records typed in
but would like a button for adding new equipment as it is purchased. Ideally
the button will take me to the next new record ...

I read in a question posted that someone had their Access Database on a Web
Server. Is this possible without having a serious problem with corruption or
speed? I thought that this would be like file sharing where when using
Access, parts of the program are loaded into ram on the ...