Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Upload File Path To Access Database


Hi all,

Im working with DAP's and i need to have an upload button on one. I only need to store the file path and name into the database but i cant seem to do it.

Any sugestions?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
MS Word File Path > Access Database, Possible?
Hi All,

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.

Any help appreciated

Thanks

Alex

View Replies !   View Related
Adding FTP Upload File Capability To Sweep Function In Microsoft Access
Hi Folks,

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?


Thank you very much,

Joe

View Replies !   View Related
Split Database: Back End File Path (via Vba)
Hey guys,

How can I change the tables' splitted file path via vba?

Ex.: c: ables.mdb -> c:ew path ables.mdb

thank you.

View Replies !   View Related
File Upload To A Directory
hello good day. hope im inthe right place.
can someone point out to me if there is a way to do a file upload using ms access 2003 and not just stor the file path...thanks

View Replies !   View Related
Linking A Database To Access On Network Path Level
Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View Replies !   View Related
Linking A Database To Access On Network Path Level
Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View Replies !   View Related
Path/File Access Error: "VB4.tmp"
All I am trying to do is import a Report from one MS Access db into another.

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"


Any ideas??

View Replies !   View Related
Excel To Access Upload
Hi All,

I have an existing database in access now I need to add records (10000 rows) in this table from excel. When I try to do an import from Excel to Access it gives me an error.
Please Help!!

View Replies !   View Related
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.

View Replies !   View Related
Upload Data From Excel To Access
Hi all,

I have an access mdb file and just added a new field to one of the tables.

I also have several spreadsheets with bits of information that I would like to use to update the newly created field for each record.

Not sure what is the best way to approach this. Can I use a query that will look into the spreadsheet and copy the specified cell to the newly created field using an if statement? or

Do I need to get all data into a table and upload as a new table in Access then use query to update the records?

Please keep in mind that I do not wish to append new records, I need to update existing ones.

The above represents my thoughts on how to approach this task, I would appreciate any help.

I must also state that I am totally new to access and would appreciate as much detail as is possible in the response(s).

Thanks,
Wingale

View Replies !   View Related
Get Path Of File
I have a button that allows a user to select a file using the windows select file dialog using the following code:

Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)

With fd
.Title = "Select A Text file to Import"
.Filters.Add "Text File", "*.txt"
.FilterIndex = 1
.AllowMultiSelect = False
.InitialFileName = CurrentProject.path
result = .Show
If (result <> 0) Then
Me!txt_path = Trim(.SelectedItems.Item(1))
End If
End With

Is there a way that I can capture the path of the file they select in a separate text box?

Thanks!

Vassago

View Replies !   View Related
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:

Dim StrFilename as String
strfilename = Dir("c:MyDirectorychkfile.ozx")

The function then tests for its presence and does its thing. You trigger the logoff by going in as sysop and changing the name of the file so it is no longer found.

The problem I have is that on the network, I use the backend file on the network and different users map different letters to it. I get around this by linking using UNC eg. \ServerNameSYSData_be.mdb.

I put the chkfile.ozx into this directory since all users presumably have access to it.

I tried changing the trigger function to

strfilename = Dir("\ServerNameSYSchkfile.ozx")

but the program doesn't recognize the presence of the file. When I map it as "F:SYSchkfile.ozx" it works, but since all users will not be mapped to "F", it really isn't a solution.

Does anyone know the proper syntax to include in the Dir method for UNC naming?

View Replies !   View Related
File Path Help
Hi,

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

Next vrtSelectedItem


Else
End If
End With
Set FD = Nothing

View Replies !   View Related
Path Of The Db File
How can i let a db find out the folder path, without its own file name, and save it in a variable?

merci

View Replies !   View Related
How To Upload Data From Ms-Exell Ms-Access Table Automatically?
I am Oracle Guy & new to Ms-Access. I want to load the data from Ms-Exell into Table in Ms-Access automatically through Procedure / Macros. How to do this process?. Help me, if anyone knows.

Regards,
GKS:mad:

View Replies !   View Related
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?

thks

FT :)

View Replies !   View Related
Create An Automated Procedure To Export Access Tables To XML And Then Upload To Web
Hi I'm not sure if i am posting this in the correct area but i'm guessing that since i am starting of in access this is the best place to start.

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.

any and all help is greatly appreciated.

Paddy

View Replies !   View Related
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!

Private Sub Command4_Click()

Dim stAppName As String
Dim stPathName As String
Dim fs As Object

Set fs = Application.FileSearch
With fs
.LookIn = "C:Program Files"
.SearchSubFolders = True
.FileName = "AcroRd32.exe"
.Execute
????? stAppName = .FoundFiles
Set fs = Nothing
End With

'specify path name for version of adobe acrord32.exe
'stAppName = "C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe "
stPathName = GetIniSetting("C:WINDOWSSSI_DL3_PROGRS.ini", "DIR", "REPORT_FILELOCATION") & "HOOF.pdf"
Shell stAppName & stPathName, vbMaximizedFocus

End Sub

View Replies !   View Related
How To Get File Address Path Thru Windows Prompt?
Hi there!

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!

Do you get what I mean? Is this possible?

Thank you for your help

View Replies !   View Related
Insert Hyperlink Dialog Default File Path
Hello everyone and happy New year.

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...

All help greatfully received...

Any help greatly received......

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved