473,396 Members | 2,154 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,396 software developers and data experts.

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 3795
cactusdata
214 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
214 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

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

Similar topics

8
by: Jerome Ranch | last post by:
Okay So I've got pivot tables setup in Access 2003. Only about 30K records in the current 2005 databases...the pivots summarize the info in a number of nice ways. I need to get the pivot tables...
5
by: daniele m | last post by:
hi, I'm a new user of this newsgroup and I have a little question for you. is it possible to copy (to backup) an access file while this file is opened? can the copy be not coherent? if it is...
6
by: Donald Grove | last post by:
I do programming in Access 2000 and 2003. I don't have a copy of 2003 myself, though. I have read about the adp software that comes with Access 2003, that converts an application to an access...
4
by: shreyansghia | last post by:
Hello , Can anyone help me in understanding how do we use Vlookup ( as we use in Excel) in MS access. Thanks much in advance
1
by: sateeshpatil | last post by:
Hello..... While I am trying to take back up,its giving error like permission access denied cz of .ldb ,Please tell me how can i copy locked access database...... Regards, Sateesh R Patil
2
by: stinger5900 | last post by:
Can someone Guide Me to Sample code on how to copy an Access Database Using Microsoft Visual C++ 6.0 I am a beginner with C++
1
by: AccessHunter | last post by:
Hi, I am trying to find a way to copy an access database and all the objects in it. I need to make a copy of an existing database and modify some tables for each Fiscal Year. The whole manual...
1
by: Pam70 | last post by:
In trying to copy my address file in Access 2003 to a flash drive in order to transfer the data to my new computer and Access 2013, it copies in an HTML format, which I don't want and will not open...
5
by: sbadvipour | last post by:
I have been asked to create a copy button in an access form to copy the Data in the fields that users enter so they can paste it in an internal system. I crated button and created VBA code "on the...
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: 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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
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...
0
tracyyun
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...

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.