I have a form with 2 subforms. The main form has a combo box
Department. The subforms contain combo boxes with lists dependant upon
the main form's Department choice. How do I requery the lists of the
subform combo boxes?

I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
calculation where it calculates the difference between the two dates.
Therefore the output will display the number of days.

I have a main form called “customers”
I have a subform in the “customers” form called "billsopenvalue"
I have a commandbutton on the “customers” form which is opening a pop-up
form with the name “receivedpayment”.

I have a database with a field that we want to hyperlink to image files. If
the images are jpegs then the hyperlink is fine, but when they are PDF's it
does not seem to want to open the file.
We have both Reader 7 and Acrobat installed, so that should not be a problem.

I am designing a database in Access 2002 and want to offer the options of
Complaint, Compliment or Enquiry. I am using yes/no box for each option and
want to create a rule whereby only one box can be picked.

I have a dream!
But I also have a report.......
That report has a subreport with a subreport. With the following code
I change the caption of a label.

I have a REPORT with in it a subFORM Now I have this label (lblMonth)
that I want to change. How should I do this? What would be the proper
event to do this? The lblMonth should contain the name of the month as
jan 07 Any ideas?

I'm working in Access 2002/3. I want to avoid writing out a sequnece of
dates... I want a piece of VBA code which sequences all the dates, between
two given dates.
For example, putting in a Admission Date 23-mar-2003, and a Discharge Date

1.5*5.5 = 8.25
In Access 2007 forms and tables 1.5*5.5 = 8.20 (which is not correct)
Detail---------------------------------------------------------------------------
It is a textbox. I get value from textbox1 and put the result into textbox2.

Does anyone know of a way to print a listing of all your reports in the
Reports Object section.

My company supplies clothing to different companies. With this
particular company, I have their employee list. To create a bill for
the last shipment, I have set up a report which filters out what their
last shipment was. So, there could be 6 blue shirts for a certain

I have an database that i have been developing and zipping and sending to
someone else to use - this has been working fine for some time but for some
reason when i sent it to her last night it seems to have corrupted a little
bit.  Some of the controls are showing errors on the ...

My users have asked it I can change the function behind some key.  - Disable
the left/right/up/down key whilst they are in an option goup.  The reason for
this is once you tab into the group hitting any key with action the
AfterUpdate event.

I am creating a new database and ideally would like one form only to enter
the relevant data, but that means it has to update two or more tables from
that. Is that possible?
Thanks

I have a .txt file that I wish to import into access (using an automated
method). Some of the field names have full stops in them.  When I import it
using the wizard these import correctly.  If I try and use transfertext the .
get replaced by #