I want an input mask where the date is entered automatically before the date
which is entered. Sort of like this:
"date()"-
Thanks,

       This is probably so simple I can't seem to figure it out.
I have a Table(tblACCOUNTNO) which has only one field called ACCOUNT NUMBER
and starts from number 1.
I want to add code to a form button which will add a new record to the

This is a newbie question, but here goes.  My form has a combobox in the
header (cboYear) where the user selects a year, say 2007.  The detail section
of the form then shows customer records in a continuous form.  
One of the fields is txtDate.  I'd like the user to just enter, ...

Even though I used to work with databases years ago, I have never worked
with Access 2003. Presently, I need to create a very simple application
that is similar to one that a credit card company uses, as an example.
If you have ever called your credit card company, after you give ...

I am opening the same form but in different states i.e Read Only, Edit and
Add New.  using Event Procedure from three different command buttons.  Is it
possible to change the caption of the form being opened to remind the user
which state the form was opened in?  If so can ...

I am trying to create a form that allows an employee to select their
name and click a command button to store the time they leave for lunch
and another button the time that they return.  I have each button
coded to be written to a table, but I would like to have the in and

Does anyone have a good way to limit the days selectable in DTPicker?
I want the user to only be able to select Wednesdays.
Any help would be appreciated.  Thanks

When the Access 2007 Developer Extensions and Runtime tools were announced I
thought great and as soon as they were released I immediately down loaded and
installed them studied there use and applied then to a database for a
installation on a computer with no Microsoft Access ...

I have a graduate student database that tracks courses and requirements.  A
foreign language requirement needs to be fulfilled 2 years after they start
their graduate program.  Start dates are tracked as follows:
200701 = Fall, 2007

I am trying to calculated the number of days between to manually entered
dates.Example.... Start date=02/05/08 and due date=02/08/08.... 3 days right?
how do i get it to show on my form and entered into my table?

How can I insert a picture in a form, just by putting its address in the
related table?
How can I do it with or without writing a code?

I know there must be an easy way to do this.
I have a form that uses the OnCurrent event to update the form's caption
with specific information (in this case, information on the current record).
The problem is that when applying a filter to the form, I have to use the

I have a little problem...
I am wanting to use access buttons to navigate through the records.  this i
can do with ease but my problem comes when i am wanting to pick up some of
the data straight away and use it to lock down some fields.  It all words in

I have a combo box(officename) in a a form in which I select the office name
and I want that result to be shown in a text box. I did it but I get the id
of the office i select in the combo box (officename) and not the name.
Please help me!!

I have this code for a not in list event:
If MsgBox("Do you want to add " & [NewData] & "to the list?", vbYesNo, "Add
A Program") = vbYes Then
DoCmd.OpenForm "ProgramInfoPopup", acNormal, , , acFormAdd, acDialog, NewData