I got a text box namely [Date]
How to change it to date picker just like in infopath?
Any ideas?
Thank in advance

I love this site and it has helped tremendously with access.
I would like to further my skills with the programming aspect of access and
have no clue where to start or what to start with. Such as VB, visual
basic.net, c++ etc. and is their courses on line that you would recommend?

Is there any online chat discussion regarding msaccess?  If yes please let me
know the web address etc.....
Thanks in advance.

I would like to use the Enter key to enter my form data.  Using it will get
me to add a new record, but will not put the cursor in the first field entry.
Why and howdo I get it to do so?

I was cracking my head on this one yesterday, I need some examples of how
to make a hidden form and to store a value there and refer to it from a
field in another form. I managed to use AutoExe macro to open form and then
run "WindowHide" command, it works, but the data is lost or ...

I am unable to add new records to Form I created.  
The Form was created from the fields of 4 tables, using the Form Wizard.  
After completing data entry for first record, and then clicking "add a new
record" button, I get a "You cannot add or change a record because a related

How to you referer to items in a listbox that are not selected using vba, it
does not seem to have a property for items that are not selected.
/Lars

This message is directed to Jeff Conrad.  
Last week you answered a question for me regarding the cursor not appearing
on the first line of my form after the 'add new record' button was clicked.
Following is the entire thread:

Pls inform me, can I send a details of database which I have to make. Would
appreciate in case somebody create it and send it back to me after completing.

  I have 2 subforms on a Tab Page on a main form.  (frmParts)
  One sub is a small "continuous" form showing just a few fields from each
record, and with each record having an key [IDNo].   (frmPartsDetail)
  The other form is a "single" form (based on the same query as the

I am getting "Ambiguous name Detected" error for a command that no longer
exists on my form.
The following is a copy of what is in the module behind the form, but I
don't know what to take out or leave in.

I have two tables:  tbltripheader (primary key is tripnumber) and tbltripdata
(primary is flttripnumber).  Relationship is defined between the two on the
primary keys being equal.
On a form (control source is tbltripheader) the user begins the header

I am trying to check on a sub-form (Time and Hours) on my main form
(TimeCards) as to whether there are more than 2 hours or not on the sub-form
footer textbox Text95
The result I am getting is 2 times Text430 no matter what the hours are???

In Access 2003 I need to define a Find Box to permit user to specify initial
record to be displayed in a Form.  The Combo Box Wizard has worked fine until
now.  Currently when I select Combo Box, the boxes are created on the form
but the Wizard is not invoked so I have not been ...

Using the following Code the Progress Bar does NOT update. Everything else
works great in an Access 2002 Project using Anonymous Merge Pull Subscription
over the Internet. It is based on the ReplSamp.vbp in
C:\Program Files\Microsoft SQL