Save Attachements To A Central Folder

Dec 26, 2007

Hello,

I have searched and searched for this but I dont seem to find a solution that suits me.

This is the situation. I have a a database wich is used by multiple users through a front-end. The back-end resides on a server.

Is it possible to select an attachement (word, excel, picture, etc) with the front-end and automatically save it to a folder on the back-end?

This way all the attachements are in a central place and NOT in the database.

I know I can easely solve this problem by saving the attachtments to the database itselve but I dont think that attachements belong in a database.

i hope that you guys can help me.

Thanks in advance

View Replies


ADVERTISEMENT

Modules & VBA :: Save Access Report As PDF And Save To Folder

Jan 10, 2014

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?

View 4 Replies View Related

Modules & VBA :: How To Take Screenshot And Save In A Specific Folder

Jul 25, 2014

how using vba i can take a screenshot of my screen and save the pdf or whatever form its in into a specific folder path.

View 1 Replies View Related

Tables :: Exporting OLE Objects Fields To A Folder And Save These

Oct 25, 2013

One of my tables has a couple of OLE Object fields. This has embedded Word, Excel, and PDFs. I'd like to know if there is a way to export these to a folder. Ideally, I'd like to save them with the record id and then a dash and then the file.

The fields are Attachment1, Attachment2, and Attachment3

When I view the table for these fields, if it's a word doc all I see is "Microsoft Word Document".

I'd like to save these like this:

123-Attachment1.doc
123-Attachment2.xls
123-Attachment3.doc

View 1 Replies View Related

General :: Save A File To A Specific Folder On Server

Feb 23, 2013

We have a server that we use to run a Microsoft Access application. This application creates folders, subfolders and files on the server.Users are in 4 different offices. Each office has at least 3 computers. Some users also work from home.

Users creates file through word, or scanning a document or by saving an email on their local pc.My problem is that users need to be able to save a file to a specific folder on server.

View 1 Replies View Related

General :: Extract Embedded Images From Database And Save In Folder

Nov 21, 2012

Many years ago I created a database that has one embedded image for each project.

I am now redoing this db in 2010 format and I want to extract these images and save them in a folder so I can link them to the new db based on the project ID number

The table is [Project main], the unique project ID is [R&D ID#] and the image file is stored in [Item image] as an OLE object. i would like to save them to C:db images

View 1 Replies View Related

Modules & VBA :: How To Save File From Attachment Field To External Folder

Sep 5, 2014

I have a table with an attachment field called email, where a .msg file is stored for each record. Looking for code to save this contents of this field in a folder in my drive.

View 1 Replies View Related

Adding Attachements To A Access Form

Aug 22, 2006

Hope someone can help on this. I have an Access database, nothing flash, that is now required to keep a spec sheets as an attachement. I am at a loss as to how to do this.
Thanks

View 1 Replies View Related

Uploading Forms To Central Database

Jun 14, 2006

Hi there,

I have a problem and wander if anyone knows a solution?

I have a central database that runs on a stand alone machine (soon to run on a server with VPN connection), it has a form that enables us to report faults this works fine however i would like to be able to send the form out to our operators (all over the world) for them to fill in when needed. then what we would like is for them to send it back to usand then for us to upload it to the central database.

is this possible or is there any other option?


Thanx tom

View 1 Replies View Related

General :: Merge All Data To Identical Central Database

Jan 20, 2015

I have started working on an existing MS access application (Front-end & Back-end) built with VBA. The frontend linked to a back-end access database which contains only tables. Because of the nature of the work involving vehicles. Each user has their own copy of identical databases with their individual data stored in backend.

Right now we just copy each back-end database via ftp and store it as usr_backenddb_date.accdb Back end databases contain around 16 tables with most of them containing a autonumber field as a primary key. Further tables are connected with each other referencing the primary key as a foreign key .

I would like ideally create a function in vba that lets me select the database and merge all the data from that database to a identical central database. For the initial part, I am thinking of combining each individual table in each database and changing the autonumber field with SQL with possibly trying to cascade the change so the refrences remain intact.

Constant Access to one back end db via internet (or server) is not really possible as the users are able to connect to internet (network) only few times a day. There are over 100 backends (for each vehicle) with over 1000 records in each.

View 9 Replies View Related

How To Open A Dialog Box To Move Files Inside A Folder That Is Setup As Current Folder

Sep 2, 2015

I'm trying to automate a process of selecting a set of file/s and move them in a folder. When I click on a button, it should open a current folder that is setup in the code.

Lets say that I have a folder C:documents est, and very time I click on the button, it should open the dialog box with that path so I can select the files from another folder, drag them there and they will be saved in that folder.

This will form part of wider automation that will send an email stating that those file/s where placed in that folder.

I have in the same form where the button is placed, 3 check boxes that needs to be passed to the email as well that one or all the files where placed in the folder.

View 10 Replies View Related

Modules & VBA :: Open Folder Nested Inside Main Folder?

Mar 16, 2015

I'm trying to open a folder based on a BIN nr. This folder could be in a main folder that has diferent subfolder. As there where differnt naming used to create the folderes, one of the things they have always is the BIN nr. It alwasy start with a unique number and maybe I could use it to scan the subfolders and open that one that the BIN nr is equal as in the field BIN.

Now we have serveral 1000th of folders and finding them takes time.

View 3 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

Modules & VBA :: Save As Dialog Box - Allow User To Save Copy Of Current Database At Desired Location

Feb 12, 2014

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

View 2 Replies View Related

General :: Open Save File Dialog - Select File From Text Box And Save To Selected Location

Aug 8, 2013

I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !

View 1 Replies View Related

Create A New Folder

Oct 25, 2005

I would like to create a new folder with a specific name.

example

I have a k: drive where i want the new folder created

I want to name the new folder under the k: drive.

Im sure this is very easy to do, but i can't seem to find an example in the forum.

thanks in advance

View 1 Replies View Related

Does A Folder Exist

Feb 21, 2007

Hi,

I've got an Access 97 piece that imports text files, copies and moves the used files and several other things.

I've now been asked to enable it to create a fairly complex folder structure.

I've done that, but I'd like to be able to issue a warning if the root folder already exists, can someone please show me how to check if a particular folder exists (I don't particularly care if its full or empty).

View 3 Replies View Related

Moved Folder

Feb 21, 2008

Hi

I have just found out that my admin team have re-named all my folders so now teh folder that my DB was in is called a different name, so now my DB wont open as it says that it can't find teh file (as its still looking for teh origional folder name).

Is there an easy way around this? (I cant change the folder names)

Thanks

View 14 Replies View Related

Clean A Folder Contains

Jun 17, 2005

I've built a Database which creates XML Files to import into another program. It just adds files to the program in a batch, so ever time I run the Export I want to Delete all the existing files for the holding folder. Have anyone done this before?

View 1 Replies View Related

Import From DB In Web Folder

Jul 7, 2007

Hi all

I have a few DBs operating in a few geographic locations. I'd like to update them all... could I use a command button in the DBs that I distribute to import new forms etc... from a DB that sits in a web folder?? Kind of like a web update?? This way end users can update it themselves.

Or maybe theres another way to do this??

Ideas are much appreciated.

View 2 Replies View Related

Putting Queries In A Folder

Jul 31, 2005

Hello,

I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible?

Having 40 queries all inside the database window is not so convinient...


Thanks in advance for any replies.

View 1 Replies View Related

Shared Folder Problems

Feb 1, 2007

I'm currently having problems with splitting my database.

The situation as present it:

- I have a shared folder on my laptop, to which i have given full permission rights to a collegue, in this folder is the backend of the db which i split from a database also sat in the shared folder

- I can then go to the front end of my database either on my desktop or shared folder and update tables

- However, this is where the problems start. The copy of the front end that my collegue has (an exact replica of mine) cant access or open any tables. Even if he opens the exact front end that I'm successful with in the shared folder. The following error message appears

"Could not find the file 'D:Testdb_be.mdb'"

the D drive on my computer is where the shared folder 'test' is stored.

Any hints or advice on why this isnt working?

Thanks in anticipation

Ross

View 10 Replies View Related

How Do I Link Images To A Folder?

Mar 30, 2005

Hi there.....

I have a minor problem......if anyone could help me on this one, would be much appreciated.


I have a field "OLE Object".

Great!

BUT!! .......I want to be able to LINK my products to pictures from a file.

IE:
Product 1 = AB1.jpg
Product 2 = AB2.jpg

Both images are in C:/images

So...product ID1 is linked to image AB1.jpg...product ID2 is linked to AB2.jpg.

The images must also appear as images in the FORM.


Any ideas on how I can do this ?

Thanks in advance.

Chris

View 1 Replies View Related

Copy From A Drive To A Folder

Feb 27, 2006

Hi.
I have been searching previous threads and the help file and got half way, but have got stuck.

I want to copy all files from a floppy disk to a drive on a directory on a server. I can check to make sure the directory exists and if not, can make it. All I want to do is copy all the files from the floppy disk drive (A drive) to the direcory I have just created.

I got this from the help in access:-

FileSystemObject.CopyFolder "c:mydocumentsletters*", "c: empfolder"

but can't get it to work......is this the way I want to go?

Can anyone help?

Thanks.

Frank.

View 3 Replies View Related

Fusing Form And Folder

Jun 14, 2006

Okay, so I know how to open variable folders with a button or combobox from Access...but I think I want to have my cake and eat it, too;) Is there any way that an Access form and an Explorer folder can be meshed into one object?

I had an idea where after the user selected a value from the combobox (afterupdate) then the folder corresponding to the combobox value would open (this part I know how to do)...but the folder would open in a specific part of the form. Like binding windows explorer into an object box and then having it jump to different folders as the user changes the combobox selection, aand the user would still be able to drag stuff into WE from the desktop or wherever.

Am I being vague? Can something like this be done? I think if I just knew how to open a folder in a specific place and size I could work something out.

Any help with this would be awesome, I haven't been able to find anything like this in the forums!

View 4 Replies View Related

Current Folder/path

Jun 11, 2006

Hi all

How can I change the output string in the command below to simply save the document to the same folder that the DB resides??

DoCmd.OutputTo acQuery, "qryAwardsExportWord", "RichTextFormat(*.rtf)", "C:dataawards.doc", True, "", 0

any help is appreciated

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved