I have been trying to figure this out for ages but I cant seem to get the code right or find any info on it.

In my database i have a mail merge on a button click which creates a new merged word document. I then need a way of when the user saves the document in word, bringing back the file path and putting it in a table called tblHistory with the correct customer ID in there too.

I have created a file sweeping program in Microsoft Access via VBA in a few modules. The program simply reads certain files in certain directories, and determines if, when, and where to copy those files based on certain user inputs.

One of the features I would like to add would be to upload the files that meet that criteria to a conventional FTP server requiring a username and password. However, the last few days of research all tells me that it is not possible to perform FTP functions in Microsoft Access or in VBA.

I am just wondering if that statement is really true? I figure the worse case is that windows has its own version of FTP.exe that you can execute in a DOS window ... would one be able to perhaps create a command line execution via VBA? Any simple ideas or is it not worth the trouble trying to FTP upload some files via Microsoft Access with VBA?

When I do this I get the following error:"Path/File access error :"VB4.tmp"Press okay and then I get this . . . "Name conflicts with existing module, project, or object librabry.Press okay and then I get this . . . "No Current Record"

Upload CSV Data To Access
I have converted 6 Excel spreadsheets to one CSV text document distinguished by their sheetnames. Where I am stuck is trying to import that CSV file into 6 separate tables in my Access database. Does anyone have any ideas how to do this using VBA. I am still a newbie at this, so any help would be appreciated.

Specify Path To File With UNC
I went to the Microsoft knowledge base (304408) and found a routine that automatically logs off users with a short warning. It works fine, but depends on the presence or absence of a small text file which is named chkfile.ozx. The file is referenced in a form timer function as follows:

I nave a code which allows the user to upload a file to a folder "images". I want to be able to record the filename and path in a table called "attachments". But I am not sure how. Can anyone help

Private Sub Command0_Click()

Dim FD As FileDialog Dim Name As String Dim Name2 As String Dim Pathx As String Dim Path As String Pathx = Me.Application.CurrentProject.Path & "Images" Path = Me.Application.CurrentProject.Path Set FD = Application.FileDialog(msoFileDialogFilePicker) Dim vrtSelectedItem As Variant With FD .AllowMultiSelect = False 'Add a filter that includes GIF and JPEG images and make it the second item in the list. .Filters.Add "PDF", "*.pdf, 1"

'Sets the initial file filter to number 2. '.FilterIndex = 2

If .Show = -1 Then For Each vrtSelectedItem In .SelectedItems Name = Dir(vrtSelectedItem, vbSystem) Name2 = Pathx & Name If Name2 = vrtSelectedItem Then Else FileCopy vrtSelectedItem, Pathx & Name End If

File Browser To Specify PATH Only
i am using file browser to save a file in MS ACCESS forms. However, i want another file browser to allow the user to specify the folder he wants, then from the folder he selects, i will generate a series of codes. Any advice on How can tat be done?

I am wonderin if it is possible to create an automated procedure that will export several access tables into XML format and then using a server upload them into a SQl Server database.

The reason for this is I want to keep the information on the website as up to date as possible whice means taking the data from the access and firing it accross. currently we have a procedure in place that we run to create the xml documents and then i run a ASP script that deletes the SQL table and then creates a new one using the xml, this is quite timely and means the website is not consistently up to date.

can any of you think of a way for me to automate this procedure and to make it more effecient.

File Search To Return Path String
Hi, I have a command button that opens a pdf file. However i will be distributing the database as a runtime package and need to account for people having different versions of adobe reader so need to search for the filepath string where Acord32.exe is found. This is the code I have but I am stuck! Ay help aprpeciated!

I have a question:Is it possible from a form to have a field (hyperlink - I suppose) where when the user cliks it opens windows prompt (like when you do a "Open" in a word document) and the he/she can select a desired file/folder then click OK (or something) and it puts the exact path to the previously selected file into the field!

Ii have a database running on Access 10.0, I am using the insert hyperlink dialog box (access by Ctrl K) to allow users to insert a hyperlink to a file (could be any sort of file), into a text box.

The problem I have is most of the files are held many directories above where the database is (we have a BAD directory policy, 10's of folders within folders) and it gets a little painful to get the user to go up so many levels, due to the hyperlink dialog opening in the "current folder" view, ie where the db is located.

Simple quest, or so I thought. Can I change the default directory "Current Folder" that the dialog box starts in ?

I have already tried chdir"c:" but to no avail.......not that obvious then...