I just upgraded to Access 2007 and when I opened a database I created with
2003 it just does not work.  My logo form pops up but then does not go away
(even though it is on a timer) to reveal the main form.  The buttons (that
run queries, forms, reports, etc.) on the main form do ...

I am trying to base the options in one combo box ([Held]) off of another
([Type]).  I have this for the AfterUpdate code of the first combo box.
The "Else" part of the code works.  However, if [Type]=k, then the combo box
just shows the exact text :"SELECT [Por] FROM [S A M]"

I have users to like to copy data in all fields of a form and paste to a new
blank record.  The form has many fields and this method makes data entry
easier for them.  However, I had a problem with the form that when users use
right arrow on record selector to advance to next ...

I have suddenly started experiencing a very strange phenomenon.
If I edit a report and change anything in it, when I click on save,
Access shuts down completely without saving the changes !
I have tried all of the various compact and repair scenarios, I've

I have two tables and I have a form that pulls information from one table and
I copied the form and remaned it diffrent and I want it to pull data from the
other table, but when I click on Field List it only shows the list for the
one table.  How can I make that form pull data ...

So I have a main form with about 3 subforms on it. It works pretty well
except when I add a new record to the main form, the 3 subforms do not
appear. I know this is because the Primary key to the main form has to have a
corresponding foreign key to the data sources on the 3 ...

Can anybody give me a solution how I could freeze the first two columns of
my form (based on a cross-tab query), which contains the row headings. The
form has many columns and the first two columns should be always visible on
the screen when the user scrolls the table left/right. ...

I have textboxes in the Form Header of the Main Form ; and have a SubForm in
the Detail Section.
On the last box in the header area I put in the OnExit event:
Me.SubForm.Form!ABCtextbox.SetFocus

is anyone else frustrated with the number of time, when editing a
project..., Access 2006 crashes, leaving behind a corrupt, un-repairable
file (or somtimes just a corrupt form, never-the-less: frustrating)?
short of going back to an earlier version of the program, does any one ...

I created a simple Access database for entering names and addresses etc. for
a rock climbing club and created checkboxes for 4 types of rock climbing
activities (Lead Climbing, Belaying, etc.) that must be checked if applicable
as part of a liability/assumption legal requirement.

Is there any way to find out whether a query is being used, and by which
reports or forms?
Thanks,
Dean S

I would like to alert users when a value is limited by an external but
related device on a transmission line.

When I size a control all the contols/labels resize along with it.
How do I "ungroup" controls so that when I size one I'm not sizing them all.
Cutting and repasting them onto the form breaks this behavior but is
cumbersome.

I am fairly new so I still don't understand some things. I would like to
create a form from numerous queries. I don't want to build one large query
with all my data I need for the form because it would be too large. When I
try to add queries in form wizard, I get the message "You ...

I'm thinking this will be an easy one.  I have a form that has a lot going on
and some folks who are not real comfortable with computers.  I have created
another small form with instructions on how to enter data into the main form
and a place on the main form for them to click to ...