Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Locating a file with code.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CD Tom - 28 Mar 2008 23:18 GMT
In my application I have a backup that exports the data to a .txt file. This
allows the user to take the data to another computer and restore that data.  
This works great and don't have any problems with that part of the program.  
The problem is that before the restore works I want to be sure that the file
is where the user points.  I have setup a code to look for the file first and
if it isn't where the user pointed they will get an error message that no
backup file was found. I am using the fReturnFilePath module.  This works
fine on my machine but when I sent the program to my user when ever he tries
to do the restore he gets the error message I put out about not having any
backup files.  I've connected to his machine and look in the folder where he
has his back and everything is there.  After this long explanination does
anybody have any clue as to why this will not work on his computer.  
Any suggestions as to what to try would be greatly appreciated.
Thanks.
Bob Quintal - 28 Mar 2008 23:53 GMT
=?Utf-8?B?Q0QgVG9t?= <CDTom@discussions.microsoft.com> wrote in
news:0B1A47C3-DE8F-4533-A8D2-1D0492E574A0@microsoft.com:

> In my application I have a backup that exports the data to a .txt
> file. This allows the user to take the data to another computer
[quoted text clipped - 12 lines]
> work on his computer.  Any suggestions as to what to try would be
> greatly appreciated. Thanks.

the page where I found a copy of freturnFilePath had this note

"Before using the code, make sure "Microsoft Office 8.0 Object
Library" (typically referenced to MSO97.DLL under Office folder) is
selected under Tools/References."

so it may be a missing reference.  

I prefer to make the user brose for and select the file using
ahtCommonFileOpenSave() from http://mvps.org/access/api/api0001.htm

Signature

Bob Quintal

PA is y I've altered my email address.

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.