469,647 Members | 1,690 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Lookup and copy file in ms access

3 2Bits
Hi
i have a MS access data base with multiple users running on it and i"m using the attach a file option and slows down the application i would like to create a CMD that should open file dialog and ask user to select the file that he wants to attach and it should copy the file to a different folder and copy link in a field
Nov 1 '20 #1

✓ answered by cactusdata

Use the
Expand|Select|Wrap|Line Numbers
  1. Application.FileDialog
to pick the file, then
Expand|Select|Wrap|Line Numbers
  1. VBA.FileCopy
to copy it. Finally, link it with
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferDatabase
, if that is what you mean with "copy link".

4 3438
cactusdata
184 Expert 128KB
Use the
Expand|Select|Wrap|Line Numbers
  1. Application.FileDialog
to pick the file, then
Expand|Select|Wrap|Line Numbers
  1. VBA.FileCopy
to copy it. Finally, link it with
Expand|Select|Wrap|Line Numbers
  1. DoCmd.TransferDatabase
, if that is what you mean with "copy link".
Nov 5 '20 #2
73429
3 2Bits
thanks for your answer i do have no an issue that the file does not open when you click on the link since its located on a server how do i set that all files should automatically get the quotation after inserting into field
thanks for your help
Nov 8 '20 #3
cactusdata
184 Expert 128KB
Sorry, but I don't understand your question. It should make no difference where the file is located.
Nov 8 '20 #4
73429
3 2Bits
when its stored in a network location you need to add double quotations in the beginning of the link and the end in order it should work
Nov 8 '20 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by daniele m | last post: by
6 posts views Thread by Donald Grove | last post: by
2 posts views Thread by stinger5900 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.