When I startup my Access 2007 application, and read the printers collection
from Application.Printers - there current, i.e., they list the printers that
are currently in the end-users printer and fax form associated with their
network login.

I need help with combo boxes.
I'm currently designing a database to keep records of individual vehicles
operated by particular companies and the depot that they're allocated to.
For example. Bus 154 is operated by Big Bus Company and is allocated to

This was originally posted on March 23 at 11:14 pm.....sorry, I have a
deadline on this and am getting a little anxious on a few things.
Hi Groupies:
I have a continuous subform that keeps track of employee transactions

 I have an Access app that opens up maximized.  There are buttons that
change the source of a subform control.  When I click on the inventory
commanc button all is fine but two strange things happen.  One there is a
control thats Control source is =Weekday([txtInvDate]) it does ...

I've made a form and added buttons to open 2 queries and 1 form. The
form opens perfectly.
I used the Command Button Wizard to create the button and selected the
Miscellaneous category to get to the Run Query action. The 2 queries

I'm using the following code to try and open a pdf file if the New2 is equal.
Example:  If in the new2 field the value was 12345 you would click the
command button and if 12345.pdf exists then open, if not then some message.
Is the code below correct?  When I click the button ...

My application is in Access 2003 with SP 3 applied.  I have a form that is
opened by a Command Button Click event procedure.  The form contains 3
subforms that need to be synchronized.  The layout of the form is as follows:
Form-A

Access03    Form is sourced from query;  only using query to alphabetise
order by name field...otherwise could be on table itself.
One open button has form open argument to a selected geo area i.e. state
Another open button has form open argument to a selected interest i.e. fishing

With a combo box as soon as you click the drop down arrow it displays a box
with 10 rows of records (or whatever you set in the properties).
When I open the form containing the combo box, it displays a single line
till I click the drop down arrow.