Can somebody guide me for hyperlink in form field. I have seen northwind db sample emplyee form and exactly I want this for my db. but not image but the link for *.pdf file.
Here issue is I have 400 documents and I want code which will automatically pick up the path of file using the id or number of form field. Means one designated folder and access field will pick up path matching the number.
Can it be made possible?
special request to genius caliboi.
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......
Im trying create a new form to add our current database that will password protect excel, word and if possible pdf documents when they are dragged onto it.
For now I only have 2 boxes 1 containing the password to be applied and the other to drag the file onto.
I have it all working so once its dragged on it works out if its a word doc, opens a hidden instance of word which then resaves it with a coded password.
The problem comes when change it so the user enters the password to protect it, when they enter a password or click on the drag box it doesn't allow the drag. it seems once they have entered the record the drag option is not available anymore.
I'm using access 2007. I have a table with 2 fields:
phtolink - hyperlink
phtopath - text
I am loading the table with existing data from a spreadsheet. The hyperlink field imported correctly into phtolink.
Now I need to convert the hyperlink field to a text field that displays the path to the photo referenced by the hyperlink.
I updated the text field with the hyperlink field but it didn't display the hidden part of the hyperlink.
How do I convert a hyperlink to display the path in a text field?
I am using MS Access 2010. I have a code that I am using that loops through a folder gather all the names of the files in the folder and inserts them into a table (shown below). The table is named "tblFiles" there are two columns in the table titled file name and file path. What I want to do is to also loop through the same folder to find the file path of the files and insert them into the file path column has a hyperlink where users can just click on the hyperlink and the file opens.
Private Sub Form_Load()
Dim fs, f, f1, fc, s
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("tblFiles")
[Code] .....
I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.The location filed looks like
M:New1234.pdf
M:New1111.pdf
M:New2222pdf
M:New4444pdf
If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.
Till now I managed to publish and save all in C:Reports. What I'm trying to do is Save to path specified in Path. DB attached.
Private Sub PrintAll_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyPath As String
Dim MyFileName As String
[Code] ....
i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?
View 6 Replies View RelatedAfter some help from one of the threads here I managed to install a Browse button in a form that inserts a file path to a text box. What I need is the folder path from that file path in another text box. For example if the file path is
C:Documents and SettingsmixupSketchesowl.jpg
I would like to get either
C:Documents and SettingsmixupSketches
Or,
C:Documents and SettingsmixupSketches
in my second text box.
I do not have much experience with Access; therefore please give a little detail on how to accomplish this.
Thanks.
I have a split dbase and have been running the backend on a server which was linked using a mapped network drive letter and path.
Now I'm trying to connect it to a path like this. Is it possible?
\aaat.comFoldersUS-SitesNY-JunctionPassdown-passdownfilename.xxx
Trying to get the app path of the database I have open to insert into my connection string. Currently using the following:
sPath = App.Path
Receive this error when debugging:
Run-time Error '424'
Object Required.
Thanks
Hi,
Ans1:
MyShortcut.TargetPath = "C:Program FilesMicrosoft OfficeOffice10Msaccess.exe "
Ans2:
MyShortcut.TargetPath = "C:Program Files..Msaccess.exe "
The Ans1 works fine.
The Ans2 doesn't work.
I want to work the Ans2, because every user machine's Office path is different.
For example:
MyShortcut.TargetPath = "C:Program FilesMicrosoft OfficeOffice10Msaccess.exe "
MyShortcut.TargetPath = "C:Program FilesMicrosoft OfficeOffice11Msaccess.exe "
MyShortcut.TargetPath = "C:Program FilesMicrosoft OfficeOffice12Msaccess.exe "
MyShortcut.TargetPath = "C:Program FilesMicrosoft OfficeOffice13Msaccess.exe "
So, I want to create the link with the target
MyShortcut.TargetPath = "C:Program Files...Msaccess.exe "
How can I do it?
Please let me know, thanks.
Hi all,
Can I set the default path for a dialog box to look in when called?
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
Anyone know how to find the path of your backend database using VBA code?
I am trying to determine whether the application is using a database via a network path.
Anyone got any ideas how to get the directory path where the database is running?
Thx in advance
Bob
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?
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
Hi
I have a table with this fildes:
name - family - PathImage
I have 400 records.
and I have 400 pictures for 400 person to a folder
and I want fill them, but is an easy methode for finding and filling pathImage for each person? and insert it to table cell?
I want insert Name of image file to PathImage filde.
Is there any thing such browse bottom to find file name?
Thank for your lead
Hi,
In MS Access,
DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, "P:Appr.rtf", False
I want output the file in the current directory,
the above code is specific the path,
how can I edit the current path, so whereever the the database is either drive, they still can work.
The concept is like that
DoCmd.OutputTo acOutputReport, "Appr", acFormatRTF, currentdirectory:"Appr.rtg", False
Please let me know, thanks.
How can i let a db find out the folder path, without its own file name, and save it in a variable?
merci
I have very very basic skills in Access and have been attempting to work with a database that a previous employee from my office designed. The other day another person in my office moved the folder on our office network that contains the link to open the database and today when I entered our database and tried to click on one of the forms to enter data it is telling me that the path name for that form cannot be found. How do I edit the path name for a form?
Thanks,
Veronika
Hi,
If I use Visual Studio 2005 to create a package for my clients, they can run the mdb/mde file, right.
But, if I create the shortcut to let the user to open the database with command, do they work?
"C:Program FilesMicrosoft OfficeOffice10Msaccess.exe" "E:Databasesinvoices.mdb" "cmd 12344"
If I create the package for them, do they have same path and exe file ("C:Program FilesMicrosoft OfficeOffice10Msaccess.exe")?
I have transfered an MS Access file to my PC from another, but when i try to open the forms in the database, an error occurs.It states that the path is not valid.
How can i correct the path?
Do i have to define the path for each form, report an etc seperately?
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 :)
I need to ascertain the current link path for my back end DB tables.
Using Application.CurrentDB.Name returns the current MDB file - but I need the DB file for the linked tables? Any ideas please?
THanks in advance.
Guido :rolleyes: