473,659 Members | 2,980 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

choosing folder in vba-access

Hi All

i'm trying to build a parallel function in vba access that appear in
excel:

FileDialog(msoF ileDialogFolder Picker)

does anyone know how to choose only a folder through VBA in Access?
Jan 18 '08 #1
1 1532

"thread" <ya******@gmail .comwrote in message
news:7c******** *************** ***********@l32 g2000hse.google groups.com...
Hi All

i'm trying to build a parallel function in vba access that appear in
excel:

FileDialog(msoF ileDialogFolder Picker)

does anyone know how to choose only a folder through VBA in Access?
Code for using the Windows API function "Browse for Folder" can be found at
http://www.mvps.org/access/api/api0002.htm. That site, by the way, is laden
with good information and tips -- it's a resource you ought to remember.

And, one comment... I believe the Excel method you describe requires an
ActiveX control, with attendant hassles in including and distributing the
ActiveX. The API method does not... it uses Windows functions that are
already on the user's machine.

Larry Linson
Microsoft Access MVP
Jan 18 '08 #2

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

Similar topics

3
4948
by: Mong | last post by:
Hi, I have an application which has several hard coded references to "C:\My Documents". Shortly our network setup will be changed so that a users My Documents folder will be on a mapped network home drive, and nothing will be written to the local C:. So my question is, how do I explicitly code the path to the users My Documents folder so that it will use it no matter where it's sitting (whether it be on C: or a network drive)?
20
1595
by: John | last post by:
Hi When I create a setup for my application, it installs all files for the app in C:\Program Files\MyCo\MyApp folder. How can I have some of the files to be installed under :\Program Files\Common Files\... folder instead? Thanks Regards
2
5037
by: John Regan | last post by:
Hello All I am trying to find the owner of a file or folder on our network (Windows 2000 Server) using VB.Net and/or API. so I can search for Folders that don't follow our company's specified folder structure and naming conventions and then send a Net send message to those users telling them to rectify. The information I want to get is when you select the file/folder and then: Properties -> Security Tab -> Advanced Button -> Owner Tab ->...
0
1525
by: steven.shannon | last post by:
Hello, I'm writing an app that involves deleting all the items in a specified Outlook folder regardless of item type (i.e. Contacts, Tasks, etc.). This code was ported from VBA where it worked okay, but now in .NET it is exceedingly too slow when attempting to delete large collections (roughly 10,000). It is on the order of 10 items deleted every 30 seconds. My function is as follows: Private Sub DeleteAllEntries()
3
22312
by: antuantuan | last post by:
Hi. How can I initialize a FolderBrowserDialog choosing a particular RootFolder? I saw that FolderBrowserDialog has a RootFolder member, but it accepts only an Environment.SpecialFolder (but I don't want to choose a SpecialFolder for my FolderBrowserDialog). I hope I've been clear. Thanks in advance
6
6115
by: jodyblau | last post by:
I am using the following code to open a folder: Dim folderstring As String Dim rs1 As DAO.Recordset Set rs1 = CurrentDb.OpenRecordset("Select * from tblMisc_Settings where Description = 'Clients'", dbOpenDynaset) folderstring = "explorer.exe " folderstring = folderstring & rs1!Data
1
4081
by: Simon | last post by:
Dear reader, I have a table with two fields, the fields are FileNameOld and FileNameNew. Now I am looking for VBA code to search in a system folder for the FileNameOld and change the filename to the FileNameNew. I am thankful for any help. Kind regards, Simon
3
6686
by: spamsink42 | last post by:
hello how do i create a dialog to allow the user to choose a folder? i tried FolderBrowserDialog but encountered a couple of problems: - when you specify the starting location (property RootFolder) you have to supply a constant such as MyComputer, you're not allowed to supply a literal value such as "C:\path\to\whatever". - once you specify the RootFolder, the user isn't allowed to navigate any higher than that in the directory tree.
2
1391
by: ashutosh11 | last post by:
Hi all, can anyone please help I am a new to VBA and need help here. I am trying to store EMAILs depending on the senders Email Domain. I should write a VBA script that will run everytime a new Email has arrived and if matches with the Email Domain, outlook should store it in a local folder. Thanks and Regards Ash
3
1491
by: GreggaR0und | last post by:
Hello; I have an application where a set of text files, all with the same record format, are contained in a folder. I wish to read in these physical files as one logical file to update my table. I have created an Import Specification for the record format. Do you know how I can import the entire contents of the folder using the Invalid Specification? Thanks, Gregg
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8528
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8627
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6179
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2752
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1976
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1737
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.