473,241 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

How to open a file dialogue box in Access97

Sam
I would like to allow the user to choose a file in Access97. I believe
it should be a "common dialogue" control, but it's difficult to find
information on it. If someone could give me some direction, I'd really
appreciate it.

thanks in advance,
Sam90
Nov 12 '05 #1
2 3159
See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

That approach is *much* more stable than the common dialog control, even if
you can find it somewhere.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sam" <sa*******@hotmail.com> wrote in message
news:e2**************************@posting.google.c om...
I would like to allow the user to choose a file in Access97. I believe
it should be a "common dialogue" control, but it's difficult to find
information on it. If someone could give me some direction, I'd really
appreciate it.

thanks in advance,
Sam90

Nov 12 '05 #2
Sam
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...
See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

That approach is *much* more stable than the common dialog control, even if
you can find it somewhere.


Thanks very much! I prefer using an API anyway, since I distribute the
application and didn't want to include a huge OCX. Actually, I used an
API do do it in Access 2.0, but somehow or other that original API
disappeared...

thanks again,
Sam90
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kevinm3574 | last post by:
So, I'm doing the following in a php script so that I can fire a download dialogue AND redirect the page (after clicking submit in a form). I'm doing it this way because of the problem with...
46
by: Steve | last post by:
Access97 Database The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include...
15
by: dixie | last post by:
I have a command to open the Access Options dialogue from code: DoCmd.RunCommand acCmdOptions It also opens the Database Window behind it. Is it possible to open the Options without having...
2
by: Jefferson Humber | last post by:
Is there a supported/official way to backup open Access Databases ? We have an Access97 DB that is open 24/7, that ideally needs to backed up every night without disconnecting every user/process....
5
by: kevin | last post by:
Hi, Any help with this would be really appreciated! I'm trying to download a file from a remote server. The access permissions is okay but the problem I'm facing is that the file is getting...
5
by: Mr Gordonz | last post by:
Hi all, I want to put a button on a page, and when the user clicks it, the standard Windows "Open File" dialogue box opens, and the user can browse/select a file on their PC. Having selected a...
1
by: Keith | last post by:
I have a minor problem with a piece of code I have written to download a CSV file in an ASP.NET application. It works fine except that if the user presses the Open button on the IE6 download...
1
by: Scott | last post by:
Hello- I have a contol button on a form that I want to code to open a report (rptReviews), then display the print dialogue box so that users can select a printer. This report needs color, but...
8
by: harvindersingh | last post by:
Hello guys I have some custom events in my application i.e. KeyPress such as full screen for pressing F11 and so on. Currently this works fine but only when the main form which is listening tot he...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.