473,385 Members | 1,465 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.

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 3794
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...
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
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: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: 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.