Is it possible to open windows explorer to a particular directory, maybe
even select a particular file, from Access VBA?
I have a DB that is loaded with a file list - certain files I open in their
native program, others it would be nice if I could open explorer up to the
files location.
If anyone can give, or direct me to a code sample, I would greatly
appreciate it.
Thank You
--
/ Sean Mc /
"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
4  6495 
are you trying to shell out to an application that opens the file?
Then just format the filename/path as a hyperlink.
What-a-Tool wrote: Is it possible to open windows explorer to a particular directory, maybe
even select a particular file, from Access VBA?
I have a DB that is loaded with a file list - certain files I open in their
native program, others it would be nice if I could open explorer up to the
files location.
If anyone can give, or direct me to a code sample, I would greatly
appreciate it.
Just shell the directory name using the ShellExecute API (Google: "VB
ShellExecute")
--
[Oo=w=oO]
Thanks for the helpfull pointers - I'm sure I'll be able to get it going
with all the helpfull examples I've turned up
Thanks again
--
/ Sean Mc /
"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
"What-a-Tool" <Se****@IHateSp am.Com> wrote in message
news:3yF6e.4792 4$AL.23346@lake read08... Is it possible to open windows explorer to a particular directory, maybe
even select a particular file, from Access VBA?
I have a DB that is loaded with a file list - certain files I open in
their native program, others it would be nice if I could open explorer up
to the files location.
If anyone can give, or direct me to a code sample, I would greatly
appreciate it.
Thank You
--
/ Sean Mc /
"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: BjoernJackschina |
last post by:
Hello,
I want to set off WinExplorer by a C++ programm and it should to be on
a webpage. Is that possible?
If yes where can I get some information about it.
Many thanks
Bjoern
|
by: Kenneth Courville |
last post by:
Hello, I'm looking for assistance with the Access object model. I know
this is VB, but I'm building an Office Add-using C# directed at Access
2002. I'm literate in VB, so you can reply in VB... I think my problem
mainly lies in knowing the quirks of the Access object model.
Basically, I'm looking for a method of determining if an Access database
is open yet. AND I'm looking for a method that doesn't not require
checking for an...
|
by: TheAd |
last post by:
At this moment I use MsAccess and i can build about every databound
application i want. Who knows about a serious open source alternative?
Because Windows will be a client platform for some time, i prefer a
solution that (also) supports Windows.
On the net I found a number of products that i looked at, but none of
them gave me the impression of a serious candidate at this moment
(KNoda, Gnome DB Manager, InterBase...).
2 additional...
|
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in '/CinemaBookingSystem' Application.
--------------------------------------------------------------------------------
ERROR General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
|
by: jyuan |
last post by:
Hi, I am new in .NET. Can some body point out if I can open windows explorer from web application by clicking on a link button? I have tried this:
Protected Sub lbOpenFolder_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lbOpenFolder.Click
Dim dblRetVal As Double
Dim sCmdLine As String
Dim sPath As String
sPath = "\\servername\directory name"
sCmdLine = "EXPLORER /E," &...
| | |
by: Bob Alston |
last post by:
Looking for someone with experience building apps with multiple
instances of forms open. I am building an app for a nonprofit
organizations case workers. They provide services to the elderly.
so far I have built a traditional app, switchboard, forms, etc.
Part of this app is to automate the forms they previously prepared
manually.
After the app was built and works just fine, I find out there are
several case managers using MS word...
|
by: ConfusedMay |
last post by:
Hi,
I've created an access 2003 database that has a form with button called "open complaint database." This complaint database is also in access 2003. Here is my code to open the complaint database
Private Sub cmdOpenDb_Click()
Dim objAccess As Access.Application
' Open Access database
Set objAccess = CreateObject("Access.Application")
With objAccess
|
by: existential.philosophy |
last post by:
This is a new problem for me: I have some queries that open very
slowly in design view.
My benchmark query takes about 20 minutes to open in design view. That
same query takes about 20 minutes to open in datasheet view. As an
experiment, I deleted all rows in all tables; after that, the query
took only seconds to open in both design view and datasheet view. From
these facts, I conclude that Access is evaluating the query when I go
to...
|
by: SimeonD |
last post by:
Hi
I have an access database called Sales.Mdb
In vb.net 2005, I'd like to open it. Which I can do.
What I can't figure out is how to figure out if Sales.Mdb is open already.
If so, I want to open that instance.
Any ideas how I would do this?
Thanks
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
