Hello, I have a form named frmcalendar with a subform named
frmReviewReminderSubForm and I want the subform to be visible= false if a
control named txtDateOfHire on my subform is null. The control is a date so
im getting an error "You entered an expression that has no value" here ...

I created a form based on a table I created called contracts. when I switch
to database view I can add new records but I can't see old records? Any clue
to what I'm doing wrong?

I have a data base that records, amongst other things, Purchase order
numbers along with the items ordered
I have done a query that displays all the POs raised but it displays the PO
Number as many times as there are items on it

I would like to know if anyone can help me or direct me to an access d-base
that can track and BF (bring forward)

This is really doing my head in...
I have a field named 'lastupdate' which I need to display the current date
when a record is updated on my form 'clientDatabase'.
I have allready searched this site and everyone says to put some code in the

I use Access 2003 and when on a new computer with Vista I tried to run
it, everything works except reports.  They are not generated nor
printed.  My printer is HP LaserJet 1020.
Thanks for guidance.

I am trying to calculate the expiration date for automatically renewing
contracts.  I want the final form to calculate the current expiration date by
calculating renewal periods but just showing the final one.  The contract is
first signed for a 12, 18, or 24 month period while ...

I am trying to start a new project.  I am asked for an SQL server but I hve
no idea what that is or how to get on.

Hello,
I am having problems with one of my queries.. I right clik to add a new
record and fill out everything correctly but then when I click on the above
or trying to make another new record is automatically gcopying it.. I tried

I have a form for inputting data but some of the fields shall ahve the same
information, is it possible to get this information to copy automatically
thanks john

I have successfully used the OpenReport macro for two reports.  The WHERE
clause selects the records which contain the field value that I am selecting
records for.  For a third report, however, I am unable to show the records
containing the field value - I see no records at all.  ...

For some reason my Menu Bar is missing.
I did Ctl + G for the Immediate Window and type in
Application.CommandBars("Menu Bar").Enabled = True
Then hit enter.  But I have to do this everytime I open a database.  Any

1.calculating the current age using date birth field by access query. 2 nd
how can I seperate the Name field (full name ) in to two name field like
First name and last name using query.
3.Please provide me the web site address or various functions  formula tips

Hi out there,
I have various tables with various OLE-Objects. So I mentioned
ExtractInventoryOLE from Steven Lebans is the right tool for me.
I did an export on a table with 246 OLE-Objects. But only 130 where