473,385 Members | 1,357 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,385 software developers and data experts.

Opening an explorer window with access

My goal here is to get access to open a folder that is related to the
current displayed record. For example, if the customer's last name is
Smith, i want the folder "//server01/jobphotos/Smith" to pop up when
you click the Job photos button.

So far this is all I have for it...

RetVal = Shell("explorer /e,/root, //server01/jobphotos/Smith")

This works on a one time basis, but i need it to be variable so it
bases the folder name on the last name of the contact record. Any help
would be greatly appriceated. Thanks

Aug 10 '06 #1
1 2181
ky***********@gmail.com wrote in
news:11**********************@m73g2000cwd.googlegr oups.com:
My goal here is to get access to open a folder that is related
to the current displayed record. For example, if the
customer's last name is Smith, i want the folder
"//server01/jobphotos/Smith" to pop up when you click the Job
photos button.

So far this is all I have for it...

RetVal = Shell("explorer /e,/root,
//server01/jobphotos/Smith")

This works on a one time basis, but i need it to be variable
so it bases the folder name on the last name of the contact
record. Any help would be greatly appriceated. Thanks

RetVal = Shell("explorer /e,/root,//server01/jobphotos/""" &
Lastname & """")


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 10 '06 #2

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

Similar topics

3
by: Clinton Goff | last post by:
I am attempting to write a javascript app that will open a second browser window, load a url, such as www.google.com (foreign url) and perform a <File-Save As> function on that window. I am able...
3
by: Usman | last post by:
Hi All, Is there a way that if I know the IP address of a computer, I can open a popup window on that IP remotely from another computer? It is somewhat similar to netsend but the type of window...
5
by: ASD | last post by:
Hi Is this doable: I have a shortcut on my desctop that points to web location. When a user clicks on it the Internet explorer opens the web location but without the navigation bar...
14
by: D. Alvarado | last post by:
Hello, I am trying to open a window containing an image and I would like the image to be flush against the window -- i.e. have no padding or border. Can I make this happen with a single call to a...
1
by: drunkfool28 | last post by:
When I have Windows Explorer open and then launch an Access application,another Windows Explorer window opens that is titled MS Access.This causes poor performance by Access. I can work around...
2
by: Matt Hamilton | last post by:
I have an application page with a datagrid with a checkbox on each row. The user should check the rows they want to modify and then click a button. When the button is clicked, I have a Click...
1
by: sandy21380 | last post by:
Hello, Is there a way of opening an Access form without opening the Access window? Right now when I open the form, the Access window is a lot bigger than the form so I have to resize the Access...
0
by: bbrewder | last post by:
I am struggling with some MSAccess automation issues. Basically, we have a .Net application that uses MSAccess for reporting (legacy code). We are able to launch MSAccess fine and even work with...
3
by: Salad | last post by:
I have 2 apps; one written in A97, the other in A2003. If I open an app in A97 then close it, then open Explorer and dbl-click on the A2003 mdb, I'm informed it's an unrecognized format. If I...
1
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...

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.