I wanted to duplicate a record on my form, so I thought I'd use the
Duplicate Record button that the wizard builds for you on the form. I
thought this would be simple, but something seems to be wrong. The
copied record is missing a couple of fields.

Can someone tell me how i couldfind the difference between two date in years
and months in access.
one field is named start date and i would like it to give me the years and
months. for example my start date is 11/13/89 i have 16 years 3 months.

I have created code to automaticly create a hyperlink address base on user
input from a click of a command button.  We are linking to pdf file on our
server to a field in a table.  Each pdf has a unique name that is associated
to field in a table.  That field is set to hyperlink. ...

I have a master form with a sub form.  I want to force the user to enter a
lab number first, before any other information on the subform (for new
submissions).  
Any ideas?

I have a query that sums my totals for 2004 and 2005
Year,Total
I display in on continious form, so 2005 shows rigth under 2004.
I'd like to have a control that shows difference in totals between 2005 and

I am trying to use the format function to right-pad strings.
For instance, i have a string x that must have a length of 365 characters
(to match a custom data type).  After a user enters a value for x (which may
not be 365 characters), i have to convert it to a string with a ...

I have a form that gets data for a query's three fields.  client requests to
hit enter to move between fields after entering paramters.  I have gone into
options and selected the "move after enter" property to be "move to next
field".  However it isn't working - continues to go ...

I have created a Option Group using the Wizard. I crated two option
groups, one called Preview Report and the other called Upload Report
using radio buttons. Once the wizard created the two radio buttons, I
cannot switch between them. This is the first time that I have used a

I want to control the actions of the Enter key.   I have a form that wants to
go to the next record when the Enter key is hit, but I just want it to go to
the next control till it gets to the last control, THEN go to the next record.
Please tell me there is a form property to ...

Hello, i am trying to check a checkbox with the click action of a command
button but i can seem to be able to do this.
i have entered
Me.[checkbox] = Yes

I am getting message error "RUN TIME ERROR 3000 - Reserved error (-1517)" -
"There is no message for this error"!!!
ACCESS 2003 - Everything was working just fine until today  when  this ugly
error occured.I repaired the database and solved the problem but I want to

I have a table that has the school name and their account numbers.  I am
trying to create a form in which you pull up the school name and the account
number is displayed in another text box automatically.  Please point me in
the right direction!

I made a form that contains a subform. Both main and subforms have the same
fields. The difference between the two forms is that the subform contains a
list of all records with the same document number field. The main form is
used for editing the information in the subform. My ...

I am trying to create two combo boxes where the selection in the second
box is related to the selection in the first box, and these combo boxes
are in a subform.  I have searched the web for guidance on this issue,
but every solution that I have found does not work.  Do I have to ...

I have a combo box with two columns in the row source.  I would like when the
user selects that both columns of info would show in the box instead of just
the first column.  This is an unbound box and would like it to stay that way.
I will be taking what the user selects and ...