If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Any MS Access gurus out there?

bazman · 2004-04-15 11:44:40

I have 2 Microsoft Access problems: 1. How do I get Access to open an MS Explorer window so that I can select the file I want to process? 2. I have a report & want the page number to reset for each grouping/header. Is this possible?

Options

15-04-2004 12:44pm

#1

bazman

Registered Users Posts: 581 ✭✭✭

Join Date: August 2003

Posts: 526

I have 2 Microsoft Access problems:

1. How do I get Access to open an MS Explorer window so that I can select the file I want to process?

2. I have a report & want the page number to reset for each grouping/header. Is this possible?

0

Comments

Options
#2 15-04-2004 12:55pm
Mick L

Registered Users Posts: 354 ✭✭

Join Date: May 2003

Posts: 333

bazman,

A solution to the page number problem is discussed here on the Microsoft site.

Mick

0
Options
#3 15-04-2004 1:08pm
bazman

Registered Users Posts: 581 ✭✭✭

Join Date: August 2003

Posts: 526

That worked a treat - thanks a mill Mick

0
Options
#4 15-04-2004 1:25pm
bonkey

Registered Users Posts: 15,443 ✭✭✭✭

Join Date: April 2001

Posts: 14635

Originally posted by bazman
1. How do I get Access to open an MS Explorer window so that I can select the file I want to process?

Err...I assume you mean a File Open dialog?

I'm not sure which version of Access you're using, but you can always just do it with API calls.

Here is one link which shows a way to do it.

jc

0
Options
#5 15-04-2004 2:01pm
bazman

Registered Users Posts: 581 ✭✭✭

Join Date: August 2003

Posts: 526

Genius - thanks Bonkey

0