I need help writing code to determine a student's AgeOfRecord.  Given a
student's birthday (DoB) and a Effective Date (DateEff), the AgeOfRecord is
found like this:
if DateEff is Jul 01 - Dec 31, then AgeOfRecord = student's age on Jan 01 of

Have a date field that is a manual input, what I need is a way to add 365
days to show the expiration date. An automatic insertion into the Expired
date field would be exelent.
Johnnie, a Novice user trying to fix an existing database.

I have a hierarchy of tables that start off with two selections, 1)
ingredients and 2) packaging, then it goes into a sub table, 1)
ingredients would have a) commodities, b) crop items, c) dairy, 2)
packaging would have a) Glass b) Plastic c) Corrugated, etc, then

I have 3 check boxes with 3 text boxes adjacent to them. I
have code where which ever check box I check the other two are
disabled. So i.e. in checkbox1 I click it checkbox2 and 3 are
disabled. So in textbox1 I type in the quantity, and this works, but I

My database has several combo boxes with "Not in List" events, so the user
can easily add new items to the drop-down list if necessary. However, she has
requested that she be able to maintain these lists by getting rid of old
selections that are no longer needed.

Is the fields collection still available after .update?
On Error GoTo TryNext
  Do While Not rs.EOF
     If Nz(rs.Fields("LockUser").Value, "") = "" Then

I am running Access 2003 and I have a subform with two fields amongst many
called "Quantity" and "Price". I need to add another field called "Total" and
I need the DB to auto calculate the total for each record. Currently the
folks that deal with the database have to manually add ...

I have a continuous form where I have added a button to perform a
calculation.  i want it so that when the button is clicked it update the
textbox on the form with this calculated value.  the problem that I have is
that when I click the button it updates every records value with ...

Im working on a simple program right now,What I was doing is that I disable a
text box until a button is pressed. This button runs a macro which actually
set the value on that text box into enable.When I open the form and test the
macro., I does what it intended to do.How ever, ...

I've used Stephen Lebans SHTML Editor utility to create a form at start up
alerting users to new database features. Have extended this with undo / redo
icons etc. This form is used together with code which dims the background
when the HTML message is displayed. The idea is that ...

I have a form that could open 4 other forms.  I want them to open
sequentially.  i.e. frm 1 open, frm 1 close, frm2 open etc.  I have the code
in the one form as such
           DoCmd.OpenForm "2010BubbleSequenceDescsubform", acFormDS, , ,

Can someone please tell me what it means when I go on a record and I get a
pop up saying "Invalid Arugument" and all the text is Chinese?
Thanks!!

I have VBA code I've written that Prints 10 reports I've created.  I need in
code to first have the default Printer Dialog box appear to allow the users
to select the printer of their choice, once they print OK then ALL 10 reports
will print consecutively without the Printer ...

How do you go about creating your own error message when a duplicate record
is entered by the user into a continuous form that has a composite primary
key (two fields)?
I have searched and seen that some code can be written and placed in the

I own a "purchased" piece of software that actually allows me to
access the Access databases it uses. One of the fields on the main
table is called "REPLICATIONID" which is an AUTONUMBER field. The
field contains eg "{38E21AAC-2C0F-49BD-B658-896E0B0E54D7}"