Re: Setting Import Path
- From: "ruralguy via AccessMonster.com" <u12102@uwe>
- Date: Tue, 01 Jul 2008 22:30:08 GMT
Helping is what we do here. We enjoy it or we wouldn't do it.
You may just want to verify the path when the use selects the folder and
don't set it if it is not correct. You may also want to provide another means
to set the path in case it moves for some reason. Please post back if you
need more help with this.
chris@xxxxxxxxxxx wrote:
Not sure I would agree with your use of the word "simple", but...
thanks a million, I've now got it to work just as I wanted!
One last thing (and I apologise for trying your patience even more) -
it would be nice to be able to halt the import if the user had
mistakenly selected the wrong folder for their csv files.
As the import macro is now a module, could I add something along the
lines of
If not exist MyPath() & "\localities.csv" then goto error
before deleting records and importing?
Can you suggest any pointers?
Many thanks again, and feel free to ignore if you've had enough!
<u12102@uwe> wrote:
Your Function can be as simple as:
[snipped code]
--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.
Message posted via http://www.accessmonster.com
.
- Follow-Ups:
- Re: Setting Import Path
- From: chris
- Re: Setting Import Path
- References:
- Re: Setting Import Path
- From: chris
- Re: Setting Import Path
- Prev by Date: Re: Setting Import Path
- Next by Date: Copying Relationships from one mdb to an other
- Previous by thread: Re: Setting Import Path
- Next by thread: Re: Setting Import Path
- Index(es):
Relevant Pages
|
