Hi Everyone,
Am attempting to use MS Access 2000 and ArcGIS to build a comprehensive Land Referencing system, that is orientated to the new and inexperienced user, while also being versatile enough so as it can be used on different projects,
I know this sounds like a relatively simple bit of code but every time I’ve look around other forums I get lost and confused, my VBA understanding is still rather basic so I apologise if this request sound stupid.
My question is how I create custom VBA control that allows me to specify a folder in a text field and then be able to browse its contents at the click of an associated button.
I am familiar with creating a hyperlink field in a table and just displaying the field in a form, but as I am creating a simple user interface, I would prefer to have the user freely able to modify path.
Cheers for any help.
3 7029
You'll want to take a look at the filedialog class.
Hi Everyone,
Am attempting to use MS Access 2000 and ArcGIS to build a comprehensive Land Referencing system, that is orientated to the new and inexperienced user, while also being versatile enough so as it can be used on different projects,
I know this sounds like a relatively simple bit of code but every time I’ve look around other forums I get lost and confused, my VBA understanding is still rather basic so I apologise if this request sound stupid.
My question is how I create custom VBA control that allows me to specify a folder in a text field and then be able to browse its contents at the click of an associated button.
I am familiar with creating a hyperlink field in a table and just displaying the field in a form, but as I am creating a simple user interface, I would prefer to have the user freely able to modify path.
Cheers for any help.
Just subscribing - will return later.
Hi Everyone,
Am attempting to use MS Access 2000 and ArcGIS to build a comprehensive Land Referencing system, that is orientated to the new and inexperienced user, while also being versatile enough so as it can be used on different projects,
I know this sounds like a relatively simple bit of code but every time I’ve look around other forums I get lost and confused, my VBA understanding is still rather basic so I apologise if this request sound stupid.
My question is how I create custom VBA control that allows me to specify a folder in a text field and then be able to browse its contents at the click of an associated button.
I am familiar with creating a hyperlink field in a table and just displaying the field in a form, but as I am creating a simple user interface, I would prefer to have the user freely able to modify path.
Cheers for any help.
Before you do anything, set a Reference to the Microsoft Office XX.XX Object Library.
Assuming a Text Box on your Form named txtFolder and a Command Button next to this Text Box, in the Click() Event of this Command Button, place the following code. This code will enable you to Browse the Folder you specify in [txtFolder], if the Folder doesn't exist, the My Documents Folder will be open: -
'If nothing is in txtFolder then get out!
-
If IsNull(Me![txtFolder]) Then Exit Sub
-
-
Dim varItem As Variant
-
-
With Application.FileDialog(msoFileDialogFilePicker)
-
With .Filters
-
.Clear
-
.Add "All Files", "*.*"
-
End With
-
.AllowMultiSelect = False
-
.InitialFileName = Me![txtFolder]
-
.InitialView = msoFileDialogViewDetails
-
If .Show Then
-
'not needed at this point
-
For Each varItem In .SelectedItems
-
Next varItem
-
End If
-
End With
Sign in to post your reply or Sign up for a free account.
Similar topics
by: dave |
last post by:
I first started using HCW.exe to compile .rtf filew created with MS Word a
couple of weeks ago. I used the file | new
menu then selected New project in the dialog box and everything worked as...
|
by: Altramagnus |
last post by:
I have 30 - 40 type of different window.
For each type I need about 20 instances of the window.
When I try to create them, I get "Error creating window handle"
My guess is there is a maximum...
|
by: Yuri Vorontsov |
last post by:
Hallo!
We have troubles (post XP SP2) to open local folders from the web application:
- the web application allows users to select a local file (input type=file)
- the system DOES NOT upload...
|
by: Jon96 |
last post by:
I know this posting may seem redundant, but I have not been able to get around this problem
I am currently using Windows 2000 Professional with Visual Studio.Net 2002 and IIS 5. I am not on a...
|
by: santel_helvis |
last post by:
Hi there,
I wanna open the folder using asp.net. I am using anchor link to do
that. But in href part how shall I give the location. Anyone plz help
me out.
Thanks in advance
|
by: William LaMartin |
last post by:
I just received my Visual Studio upgrade to 2005 and tried to create a new
web site via File | New Web Site with location http. Unfortunately I
received the following error:
"Visual Web...
|
by: shanthsp2002 |
last post by:
well friends i have a small tip here which may be helpfull for u
there may be situations where we need to use a customized dilogue box while doveloping setup and dyployment project, so u can do...
|
by: Arno R |
last post by:
Hi all.
When I need to search for pictures, I always have too choose thumbnail-view manually.
Is it possible to open the common dialog in thumbnail-view programmatically?
Example ??
At the...
|
by: DKn |
last post by:
Hello All,
I am having an ACtiveX Control developed in C#.Net 2.0 windows Control Library. I have tested this control.TCS through ACtiveX Control Test Container.
It is working fine, But the...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |