Hi I am trying to create a subform (Purchase details) on a master form
(purchase order), yet every time I use the subform wizard on the toobox the
subform automatically opens as an unbound form. I try to set the source
property to the query on which it is based, then when I try to ...

We all know that Access mdb apps bloat with use and must be compacted
periodically.  I think I read somewhere why this happens but I can't recall.  
On an app I am working on, I noticed I was up around 50MB and compacted
before I had to send to another developer by email.  ...

I would like to use the tab function in Access only I have no idea how it
works.  I would like 3 forms to be grouped together using tabs.  
Information for the three forms are gathered at the same source and I would
to have the forms grouped together for easier data entry.  My ...

I have a mainform with a subform on. On my mainform
I also have a combobox containing names of the 12 months.
When I choose a month in the combobox I want all the
customers from that month to be displayed in the subform,

I have a form that lists the donations history for a donor.  I would like to
have 2 subtotals - one to subtotal the donations for the current year and one
to subtotal the donations for the prior year.  Do I use Sum Iff?  If so, what
is the syntax?

Alright I was successful creating two combo boxes that are now synchronized.  
Thank you...I referenced Microsoft help "Basing one combo box on another.  
Now I want to add a few more and synchronize them all together.  How do I do
this?  What if I want to skip the first combo box ...

I know this has probably been asked a lot, but I can't find anything on it
doing a search.  I want to be able to update the city and state fields when
a zipcode is placed.  I know I do it On Update.  I also have a query that
pulls the three fields.

Using Access 2002.
My application is designed around 1 main form that is used as an interface, i.
e holds login info, displays time and date etc.  all other forms and reports
open over this main form, i.e the property is set to popup on all forms and

One Form: Many tables
I have created a form to view a table in an Access97 Database.  This
database contains only one table with many colums (more than 20) which makes
it hard to view in Datasheet view.  By using a form(or I could have used a

I have a custom toolbar for my users and I disable all the standard
toolbars for them.
One little thing that is kind of a pain (for me, not them) is that when
I open the database in design view to make changes and such, the custom

Is there a way to set up a form that will not automatically send data to the
table until I instructed it to(possibly by a add record  button)?
Any help would be appreicated.

I have a workorder form which has a Combobox, which generates all the
information from a customer table. How can i put a message box that will ask
the user if all the information is correct? If select yes he can continue, if
selected no, it will open the form to allow the user to ...

In my form i have txtNumber and txtDate. If i typed  for example to 'txtDate'
field = "02/26/2006" and my txtNumber ="11" then i need to update my table.
For example my table named 'tblDates' with filds name Number and date, i have
3 records where Number="11" in my table. I will ...

On a form there are 12 text box named UP1 to UP12. The user enter text in
these box when we click on a calculate button, the values from UP1 will be
transferred to UR1 and so on. I used a loop to generate the text box named. A
sample file is attached for 5 text box.

In the criteria of my query I have:
Between [BeginningDate] And [EndingDate]
to select the date. I would like to have a calendar that would pop up
and let me pick the date so there is no typing involve.