I have a subform on a client form which shows all the invoices specific to a
particular client.  On the subform (which is continuous) I have InvNo,
InvDate, InvAmount, Overdue,PaidDate, PayType
The Overdue txt box calculates the amount of days overdue if the InvDate is

I have two forms that don't work right after I use the package wizard.  I
have a start up form that the user enters data into one time and then checks
a box to not see it again.  However, this form never comes up, but goes
directly to the form that opens when this one is closed.  ...

I have to tables; 1 contains reference data (2 fields, ID, Product
name), the second table contains Orders (numerous fields including
product name). when I look at the orders table directly, it happily
displays the product (as text). however, when i display the order via

I am a new Access 2007trying to limit the size of a newly created form;
however,  when i I try limiting the form size in design mode and select veiw
form it still takes up the entire screen.
Is there any easy way to limit the size of the form or is this a issue with

On several websites using combo box, you can enter the first letter of the
word you are looking for several times until you find the right word.  for
example, if I'm looking for Canada, entering "C" will get me to Cameroun.  
However, if I keep entering "C", I will eventually get ...

I have a form that I am using for data entry for a table "Ordered Items".  
I want to use the form to edit the value in one field of existing records in
this table.
There is an unbound listbox A on my form which displays columns from a query.

Access 2003
I have a button on a form I want to close with the following code
DoCmd.Close
It will not close and gives an error

I have a hidden field on a form [df3] and want to update this field with the
current date once a record is changed.
I have added to the forms AfterUpdate:
Private Sub Form_AfterUpdate()

I have a table called tblDeptVisits with a fields ID, Dept, Service,
VisitingDate, Visiting Time.
I have a form where the user just has to press a command button and it
tallies up the number of visitors by all the criteria listed above into the

I very recently starting building my first database with access 2003.
I designed a pretty simple form and related it to a table and everything
worked fine.
Then i copied the form and table because i needed to make a very similar

I have a client form (frmClient) and on that form is a tab control that has
two tabs (Jobs &Contacts)  Each tab has a subform showing, in the case of
the jobs subform, all the jobs relating to the client displayed on the main
form.

I usually just make duplicate forms and just edit the properties (data
entry).
Can I code open buttons to open the same form but with different
functionality?

Problem: I have a simple form showing Category on main form and
Subcategories on subform. On opening the form, the first category
shown matches its subcategories below, but if I navigate to another
category, the sub-categories are not correct for the new record.

Using VBA coding, how do I change background color on a subform control.
Form name = Matrix
Subform name = sfrmAdvertise
Control name = cboProducts

I've got a split form that has 2 date entry boxes up the top ('From' and 'To')
, and the data that is displayed in the table part runs through a query that
uses the 2 dates entered in 'To' and 'From' to filter the data. But whenever
i open the form, i have to hit F5 (refresh) to ...