Hi I have a form bound to a table tblsales. On the form is a combo box which
pulls information from tblpurchases. This information is then used to
populate unbound text boxes.
One of the values pulled from tblpurchases is from a checkbox control on

When I create a command button using Wizard it runs through the options
correctly but button does not work and no code is present. On Report Wizard
there are no field options to select from the table or query. These problems
have only happened in the past couple of months on ...

I have a query that returns the date of sale of an item, the month and how
many sales for that month.
However, when i export this to a pivot chart, it orders the data in
alphabetical order not in month order

Would you please show me how to make the toolbox, formatting and report
design tools bars appear?
Some how on the Report design view has only FILE, WINDOWN and HELP. All
other bars are disappeared. Please how me how to get them back.

I have a number of users of my database, some who use laptops with small
screens and some who use desktops with large screens.
My problem is, if i size the forms to fit on the large screens, the laptop
users are scrolling constantly to see things and if i size them to fit the

The in-built date picker is a great function in Access 2007, but anyone know
how to
apply an Event Procedure (eg Refresh or Requery) after selecting a date using
the datepicker? Selecting a date seems merely to enter the data into the

I am currently designing a database to track our memorandum distribution.  
How would I create a button that when pushed would allow you to add the link
to the file on the network to the current record on the form.

Firstly, my apologies for the lengthy post but I wanted to get as much
helpful information provided as possible.
I have had great help from this forum in the past and hope that someone
might be able to point out where my design/programming error lies.  I am

I'm creating a db that our Tech service department will use to log phone
calls. They are requesting that they be able to have multiple instances of
the data entry form open at once. Is this possible? If so, what do I need to
do to enable this?

I have a form with sub-form.  I've decided I want to add mulitple records
associated wth a record on the subform.  When I tried to nest and sub-form in
a sub-form I get a notice about not being able to use "Continuous" in the
"middle" form.  Grr.

I have a subform that is setup to be data entry only; however, when i view it
in subform mode, it displays previous records.  I don't care if it displays
other records, but how can I make the first viewable record the new record?
Any help would be greatly appreciated.

Not quite sure how to word this, but what I am trying to accomplish is to
have the user fill in a few fields, then Quantity.  Once Qty is added I need
to have a list of serial numbers displayed in my subform.  My serial numbers
are created from a DateCode module and then combined ...

I created a combo box to lookup records in my form. Now I can't add records
to the form. I'm sure it has something to do with the filter, but I can't
figure out what to do.

I am trying to identify illogical data entries on the data entry form.
The questions are:
1. Is Form A required? (Y or N)
1.a If yes, was it submitted? (Y, N or N/A)

I have written the code to have a calendar pop up when clicking on a combo
box called Date Shipped.  It worked fine.  I then realized that I had two
more date fields that I would like for this calendar to pop up when clicked.  
One is called "Lease term Begin Date" & "Lease term ...