Find A File Or Document

May 31, 2005

i have created a form that has data in a field as a referance, i want to use that ref to open a page or PDF file to that referance ,

The idea is that the form is the data input for hard copy documents, i will scan the documents and store them on a hard drive i then want to open the documents as word, or PDF files from the form to the ref of the field in that form

can anyone help

View Replies


ADVERTISEMENT

Forms :: File Or Document Link As Attachment?

Sep 12, 2014

how to manage attachments (Document or File Links).

View 1 Replies View Related

Modules & VBA :: Append To TXT Document Using Variable File Name

Jan 19, 2014

When I execute the below function I get an error. If I use the commented out "Open" line it works fine. I get Run-time error '52'. Bad file name or number.

Private Sub GenerateSSA_Click()
Dim strRA As Variant, strFileNew As String, strFileBlank As String
Dim intFileOut As Integer
Dim rstWork As DAO.Recordset
Dim dbs As DAO.Database
Dim qdf As DAO.QueryDef

[Code] ....

View 7 Replies View Related

Queries :: Hyperlink To A Document - Location Of File In Query

May 23, 2013

I have a query that combines few different tables in order to create a View (Query) that is then used to by and Excel sheet to update a list. The Excel is dynamical updated when new data is inputted in the Access Tables.

But one of the fields in a query is combination of path name and report name (another filed in one of the tables) that crate a complete path to a file that contains some additional information.

Now since the Excel is updated dynamical and users of this Excel sheet are not very advanced. I waned to make it easy for them to just click on the location of the file and the file opens up. But I am not able to make the Query that contains the file destination hyperlinked.

I am using Access 2007

View 2 Replies View Related

Creating A File Upload Function Where Selections Save The Document?

Sep 12, 2014

I work in a school where teachers have to archive their assessments and other documents monthly. Currently they email them to a set email address but I was wondering if it would be possible for me to make something with access whereby they can do this. I'd like to make a form where they selected their name and then attached a file, this file would then be saved in an area I would have assigned that persons name to, does this make sense? I want it to be very simple so just a name section from a dropdown then a file upload section and done.

View 11 Replies View Related

Modules & VBA :: Quick Way To Export ALL VBA Code To A Text File / Word Document?

Aug 4, 2014

Is there a quick way to export ALL VBA code to a text file/word document?

View 5 Replies View Related

How To Find The Author Of A TXT File?

Jun 10, 2006

I have a TXT file in a folder (C: emp file.txt) I have the file's Title property set to 'Log file' and Author property as 'John'

How can I get these property values into my variables var1 & var2

View 12 Replies View Related

Browse [Find A Directory Or File]

May 10, 2005

(Referring to this post (http://www.access-programmers.co.uk/forums/showthread.php?t=75790) by ghudson)


Hi,

This post was very useful, it really helped me out, but I do have one question. My database will be used by multiple users and will be stored on a mapped network drive, just as the files that I want to link to. Now unfortunately not all machines are configured the same, so the same network drive can have different drive letters depending on the machine and this might cause problems. Is there a way to modify the code to get the absolute network path instead of the drive letter?

thx
Luke

View 1 Replies View Related

.mde File Cant Find Project Or Library

Jun 16, 2005

Please help!

Working on an Access 97 database that I have inherited, on win 2000. The database is converted into an .mde file for the users.

I need to convert my new version to an .mde file, it does convert, but then when trying to open it afterwards gives the error below. Believe it's connected with the startup form frmsplashscreen which has 'on current', 'on open' and 'on timer' events

The expression On Open you entered as the event property setting produced the following error: Cant find project or library.

I have gone back to the .mdb it was converted from and compared the startup form to that of a previous version. All the code is the same.
I have also tried commenting out the on open event, which then changes the error to

The expression On Current you entered as the event property setting produced the following error: Cant find project or library.

I don't understand why it does not work, this same form opens fine when it's an .mdb file.

This is the first time I have worked with .mde files...I've looked on the internet, can't locate the exact error but similar ones point to problems with files on my ws (references etc). Previous versions of this database as .mde files work fine though?
Just say if you want the code from the startup form.

Help! Can't see what is causing this issue.

View 1 Replies View Related

Find Out What Users/workstations Have .mdb File Open?

Jun 29, 2006

Hi
I am looking for help related to the “You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.” message when trying to change the design. I have done a lot of reading on this forum as well as googled the subject but have not found anything regarding my specific question. I find that there’s a whole lot of information regarding workgroup security and how to set up and troubleshoot. However, my needs are a bit more simple – I think :) We have a database that is shared among 5-6 users during a couple months out of the year. There are no log-on id’s required and everyone just opens the file and works as needed. Everything works fine; we have no problems with users changing or doing more than they are supposed to. Therefore, I don’t want to break anything by complicating matters…it works and we’re happy with it. The only annoyance is that during these couple months, someone has to make occasional changes to the database in design mode. Of course, we need everyone else out of the database so he can have exclusive access. This entails calling and/or running around asking those people to close the file and sometimes physically checking computers left unattended with the file open. So my question is: Is there any way to find out what users or workstations have the file open? This would make it so much simpler. All the users are on a Windows Server 2003 network and the files reside on a server. Perhaps this is more of a Windows question; I couldn’t think where else to post it! If anyone could point me in the right direction, I would really appreciate it.
Thanks!

View 3 Replies View Related

Microsoft Access Can't Find The Database File

Dec 4, 2006

Hi,
We migrated on DB to a shared network drive. But the users cannot open the DB. It keep give an error message that microsoft access can't find the database file. Please advise.

View 2 Replies View Related

Browse [Find A Directory Or File] Code

Dec 11, 2006

I'm having a small difficulty in using the code example ghudson posted for Browse [Find a directory or file]. First off, the code works great. Thanks a lot for posting it!

The problem I am having is when linking a folder via dBrowseDirectory. The folders I am linking are on a shared network drive and I am trying to figure out how to set the initial directory to default to the networked PC. This way the user doesn't have to navigate to the shared drive every time. All they would have to do is navigate to the particular folder to link (2 clicks instead of 10+).

The dBrowseFiles function allows to set an initial directory, however I cannot figure out how to set it for dBrowseDirectory. Is there any way to do this by altering your code for dBrowseDirectory?

Thanks in advance!

View 5 Replies View Related

Run Time Error 2147467259 Could Not Find File

Dec 14, 2006

Hi
I am running Access 2000 with MDAC 2.8 and SQL Server 2000 database. I have linked the tables of the database in Access. The problem is that it would not allow me to insert/update/delete but only to select from the database.

Here is the code:
Dim strSQL As String
Dim con As ADODB.Connection
Dim cmd As ADODB.Command

Set con = CurrentProject.Connection
Set cmd = New ADODB.Command

Set cmd.ActiveConnection = con

strSQL = " INSERT INTO dbo.crop_demand_yearly (" & _
"geo_id, crop, area, water_value, water_use, date_from, date_to)" & _
" VALUES("

strSQL = strSQL & ((Val(Me.txt_borenid))) & "," & (Val(Me.cbo_crop)) & "," & (Me.txt_area) & "," & (Me.txt_use) & "," & (Me.txt_value) & ",'" & Format(Me.txt_datefrom, "dd/MM/yyyy") & "','" & Format(Me.txt_dateto, "dd/MM/yyyy") & "')"


cmd.CommandText = strSQL

cmd.Execute strSQL


con.Close
Set cmd = Nothing
Set con = Nothing

I dont understand what is the problem! Please help

View 1 Replies View Related

Modules & VBA :: Find All Table Names From External File

Nov 6, 2013

I'm trying to find all the table names inside an external access file from a path.

I have a code for the user to select a file which return a patch to the file.

Then I need to find all the tables names from that file and append them to a list.

so I them can input them into a code and link the tables.

here is the code to get the file patch:

Code:
Function getFileName(path) As String
Dim f As Object
Dim varFile As Variant
Dim path
Set f = Application.FileDialog(3)

[Code] ......

View 8 Replies View Related

Error Using Shortcut To Open A Database - Can't Find File

Nov 5, 2013

We have a new user who is unable to get into a database. Another user in the same office had no problems.

The other user is using:

"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerNameShareNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb

The new user was not able to access the share at all using ServerNameShareNameSFTP until he changed the path to:

"C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /wrkgrp"ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb"

Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)

I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.

View 4 Replies View Related

Modules & VBA :: Function To Find ACCDB File Date Created?

Jun 5, 2014

Is there a function I could use to find the date listed in the "date created" property of an Access file?

View 4 Replies View Related

Queries :: Create Query To Find Certain Records Based On Data In CSV File

Aug 14, 2014

This may not even be possible, but I am looking to create a Query that can locate records in an Access Table based on 2 columns of data that I have stored in a CSV file.

My table contains several fields, 2 of which are "Dept" and "SKU" and has over a million records.

My CSV file contains 3 fields: "Dept", "SKU" and "Total" - total being the number of times that particular Dept/SKU combination is used.

I need to be able to parse the dept/sku values from each row in the CSV to the query and locate only the records that contain the same values in the Access table.

The plan being to delete out those that are identified by the query.

View 6 Replies View Related

Modules & VBA :: Text File Split Into Table - Find Text In Recordset

Sep 5, 2013

I have some vba where I'm importing a text file and splitting it out into a table. For the most part its working just fine.

But I have a line of data that I need to pull out the string right after "Old" - Murphy and right after "New" ZMurphy

Acc# : 111111 This is test data, Person : 22222 Old Murphy New ZMurphy

I'm thinking Instr() could do this but I'm unable to get it to work.

I am using Access 2010...

View 3 Replies View Related

Access 200 "could Not Find File" Error

Jul 3, 2007

Hi,

I am using Access 2000 and created a query:

SELECT [tbl_AccountsInCurrentOutline].[CurrentAccounts]
FROM tbl_AccountsInCurrentOutline
WHERE
tbl_AccountsInCurrentOutline.CurrentAccounts NOT in (Select * from tbl_CoAAccounts.CoaAccounts)
AND
tbl_AccountsInCurrentOutline.CurrentAccounts NOT in (Select * from tbl_AccountsWithData)
;

All the tables used in the query are fine and all the field names are fine yet I get the error:

"Could not find file 'C:Documents and SettingsmjineshMyDocuments bl_CoAAccounts.mdb"

Why is Access think that the table tbl_CoAAccounts (used in the query) is an mdb file? If I remove the first condition form the WHERE clause..the query works...I guess itwould be something really silly but its just not clicking !!

Ne help appreciated.

Thanks,
Jinesh

View 1 Replies View Related

Connecting A Document

Jun 23, 2005

Is it possible to connect a Document to the Access Database. To have a button beside the field in the form allowing you to browze and connect the document. If not does anyone have a way around this. Any help would be well appreciated.

Shane

View 1 Replies View Related

Hunting For Document

Jul 21, 2005

hello

i just inherited a database at work, one which noone likes of course. i was unable to access the table so i exported them into a new database. i'm by no means a database guy i'm just learning how to use because i need to implement a database into the vb program i'm writing.

i'm trying to edit a letter thats generated when certain criteria are met. but i don't where to look for the document.

could someone please point me to a direction

i appreciate it.

View 5 Replies View Related

Import Of Excel Document

Nov 5, 2005

Someone please help!!!
The "file of type" does not display the excel type. . . only type database and ODBC. I'm using MSAccess 2000. Does it not support this type of import? Is there an add-in I need?

Thanks
Cathy

View 1 Replies View Related

Exporting To A Text Document

Mar 6, 2007

I have a query that I am trying to export to a text document. My question is how can I get the data to show up in tab delimited?

View 11 Replies View Related

Importing A Word Document

Mar 30, 2005

Hello all,
In our company we send off a lot of reports for a given sample. Sometimes the office folks need to do a specialized report with tables and other formatting. They would like to be able to a: be able to have another report where they could just write stuff, comments, etc about the sample and b: be able to import these word documents that have the tables and other formatting. If we could not use word at all that would be great but I don't think there is a way to do the formatting necessary in access. So my question is: how do I import a word document and have it displayed in a form and then print on the report. I would like to store the whole document in one field in a table. (is this at all possible?) I have searched this forum and haven't found what I'm looking for. Thank you for any help.

Greg

View 1 Replies View Related

Generate Word Document

Jan 26, 2006

Hello all,

Is there a way that I could put a command button on my form and on clicking it, it would generate a word document (I have a word document saved) but on the word document, it would populate the address field with the information on the form. I have about 5 fields on the form that will be used in the word document.

I thought about creating a report in access instead, but I might want to edit the word document manually, is there a way to do this?

Thanks much.

View 5 Replies View Related

Snapshot To Word Document

Jul 18, 2006

I have the following button on a form:



When I press it a mail is being send with a snapshot attached to it



Instead of a snapshot I want it to attach it as a word document.

Here you see the code that is used. I noticed it says snapshot format on a line but I don't know what the name is for a word document.

Code:Private Sub cmdMail_Click()On Error GoTo Err_cmdMail_Click Dim stDocName As String Dim V_EmailAdres As String If Not (IsNull(Me.HauliersEMAIL.Value)) And Me.HauliersEMAIL.Value <> "" Then V_EmailAdres = Me.HauliersEMAIL.Value Else V_EmailAdres = "" End If stDocName = "TransportOrder" DoCmd.SendObject acReport, stDocName, "Snapshot Format", V_EmailAdres, , , "Transport Order BP", ""Exit_cmdMail_Click: Exit SubErr_cmdMail_Click: MsgBox Err.Description Resume Exit_cmdMail_Click End Sub

Thanks in advance

View 2 Replies View Related







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