I just installed Access 2007 the other day (had 2003 previously) and it
introduced a problem that I can't figure out.  I have a form (Form1) with a
button that opens another form (Form2).  It used to open Form2 in an
unfiltered state, which is what I want.  Since installing ...

I'm building a db of pictures with captions, and am creating a form to
display 30+ images together with picture numbers that allows them to be moved
around within their order, copied, etc, similar to the slide browser in
powerpoint.

With your help last summer, I put in the following codes and it worked
beautifully.  This year I have Access 2007 instead of Access 2003 on my
computer and they are not working.
In this one, two notices should appear if this is a new record.  Neither

Somewhere there's a routine to loop thru a directory(folder) and print files
in directory.  I've searched all the MVP sites and more and cannot find it.  
I've got the print routine working -prints pdf or doc files.  Can anyone
point me to an example of looping thru a folder?

I have created a small db with 2007 (saved as .mdb) - no "hand-crafted" VBA.
Simply a form with a combo box and several buttons to open other forms and
generate reports.
However, nothing works in 2003 - when i click on the buttons - it just sits

I have an Access 2007 database for handling customer queries, to start each
query we enter name and address details and then carry on with the entering
rest of the query on the form. One record = 1 customer query.
What I need to do is where a customer has multiple queries, is to ...

Does anyone have a sample database they can share that I could use as a
template for people to take tests & have them automatically graded?

Is this possible? Can I create a hot link in an Access (2007)  report.
I have found one poster saying that this isn't possible. I am able to
store & retrieve the hyperlink without any problem. I am also able to
display it in the report. But the link is "for display only".

I'd like to set the default value of a field to the last day of the year the
starting date is in.  For example, My starting date is 04/12/2008.  I'd like
the end date to default to 12/31/2008, even if the record isn't actually
created until sometime in 2009.

I used the standard AfterUpdate coding on the first box and no row source on
the second box.  The second box dropdown shows the proper data upon data
entry and displays properly after selection.
The problem is the second box is blank for all records later on.  Each box

I have an option group, that I placed in the Forms header, containing all of
the possible locations for devices.  I then have a subform, in the Detail
section, that I would like to display all of the devices that are in the
location selected in the Option Group selected in teh ...

Before the report generates, a prompt called "Enter Parameter Value" pops up.
This was a checkbox on my user input form that helps generate the report.  
How do I keep this prompt from coming up?

I wrote a VB module attached to an event on a form.  The name appeared in the
navigation pane as a module. It was working fine.  I clicked on "File" on the
tool bar and "Save DBname".  A list of thing came up which appear to be thing
tht I had changed or had open.  some were ...

i must be totally dumb. i have been coding for a good 2 years on this app
and yet for some reason i cant get this to work.
Private Sub btnCloseSite_Click()
On Error GoTo Err_btnCloseSites_Click

Attempting to clean up an existing table and seem to have the need to
select a group of items as follows.
FG15120H and FG15050H are item part numbers and are in a text field
In the query grid I have the following two expressions