Displaying A .PDF File

Mar 27, 2007

I am having a proble displaying a .pdf file on a command button action.

Here is the part of my code that calls up the file:

Dim StrProg As String
Dim StrFile As String

StrProg = "C:Program FilesAdobeAcrobat 7.0Reader.exe"
StrFile = "C:Program FilesPolaris Medical Chart Ver3.3example.pdf"

Shell StrProg & StrFile, vbNormalFocus

Exit Sub

I get a file not found error. Any thoughts??

Thanks

View Replies


ADVERTISEMENT

Displaying PDF File In A Form?

Oct 29, 2012

In my table of assembly numbers where each assembly number has a set of work instructions as a pdf file. I'm wondering if it is possible to display the pdf file as an object within a form..?

I know its possible to open this document as a hyperlink but I want it to be embedded within the form.

View 1 Replies View Related

Reports :: Adding Images To A Report - Only File Path Displaying

Oct 15, 2014

I have to add 2 company logos and a phone graphic to a report.

I can only seem to add one logo and if i try to copy and paste a graphic it just displays the file path.

View 3 Replies View Related

Forms :: (Upload File) Button Stopped Showing All File Types

Oct 7, 2013

I recently upgraded a DB from 2003 to 2013 and ran into the following problem.

I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.

In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.

Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
Dim Yourroute As String
Dim yourrouteName
Yourroute = fileDump.SelectedItems(1)
yourrouteName = StrReverse(Yourroute)
yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1))
FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
End Sub

View 1 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

Oct 5, 2014

I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

View 4 Replies View Related

Text File To MS Excel Multiple File Import Application

Jul 20, 2006

hello,

I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).

I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?

Tokunbo

View 3 Replies View Related

Modules & VBA :: Determine Excel File Type Without Opening The File?

Aug 14, 2015

Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?

I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.

I'm using Office 2010.

View 3 Replies View Related

Forms :: Storing File Location And Opening File From A Form

Dec 5, 2014

i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text

i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.

View 4 Replies View Related

Modules & VBA :: File Open Dialog Does Not Allow Selection Of All File Types

Oct 4, 2013

I recently upgraded a DB from 2003 to 2013 and ran into the following problem.

I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.

In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.

Here's my code and a screenshot is attached.

Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show

[Code] ....

View 3 Replies View Related

Modules & VBA :: Filesystemobject File Picker Does Not Highlight Initial File

Jun 20, 2014

I am using the following code to select files using Microsoft Office's file dialog:

Public Function fTestFilePicker() As String
Dim fdFileSelection As Office.FileDialog, lstrFileName As String
Const kInitialFile = "F:TestbedTest.txt"
Set fdFileSelection = Application.FileDialog(msoFileDialogFilePicker)
With fdFileSelection
.AllowMultiSelect = False

[Code] .....

When I execute it, the file picker goes to the right folder but does not highlight the file test.txt even though that file name shows in the File name text box. Is there any way to correct this?

View 7 Replies View Related

Import A Text File Weekly Within A Batch File

Jan 30, 2006

hello everyone, i really need some detailed help as the deadline is approaching and I need to find a solution for this. Any help would be greatly appreciated

I currently have a batch file that ftps a text file from a Red Hat Linux Server to my W2k C:. I would like to make another command in the batch file that imports this text file into an existing access table. I would like the text file to repopulate the table everytime it is imported. I do not want the data added on to the existing data in the table.

Thank you for your time and insight.!!!:)

View 3 Replies View Related

Can't Read Recent File Names On File Menu

Oct 19, 2006

I'm using Access 2000. When I click the File menu to go to a recently used file, the entire path is shown. With my file system, the File drop down widow is about 50 characters too short to show the entire path all the way out to where I keep my database. Is there a way to shut off the viewing the entire path "feature?"

View 2 Replies View Related

Backup Current Access File Using Vba While The File Is Open

Jul 11, 2007

I have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?

I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.

View 3 Replies View Related

General :: Make Accdr File Out Of Accde File?

Sep 10, 2012

How do I make an accdr file out of an accde file?

View 9 Replies View Related

General :: Follow Hyperlink To A File Without Using File Extension?

Sep 6, 2012

Is it possible to follow a hyperlink to a file without using a file extension?

I have links being created based on the name of a file, but because I haven't used a file extension it crashes.

I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.

I'm potentially using 3 different file types, Word, Excel and PDF's.

The hyperlink works if I just reference a drive/folder, or if I add the file extension.

View 3 Replies View Related

General :: Batch File To Check (version) Of A File?

Aug 28, 2012

I use a batch file to distribute the front end of a database application. Currently, everytime the user clicks the shortcut on her desktop, the batch file executes and copies the front end from a network location to user's local machine. The FE is updated like every couple of days. The users run the database more frequently.

I would like to modify the batch file so that it checks some attribute of the FE file to decide whether it needs to be updated. I can't rely on file size, since the FE includes temporary tables. I essentially need something like the "tag" property of form controls, only for files. It would be ideal if it was me who sets this property, like "version number". Except it has read without opening the file itself.

View 14 Replies View Related

Forms :: Converting Accde File To A Normal File

Apr 22, 2013

I saved my database as ACCDE file which is executable now the problem i am facing is i can't edit my database since i can not view it into design view.

How can i change it to its normal file format

View 4 Replies View Related

Relink Backend File Using VBA With Password Protected File

Nov 5, 2013

I have a code to relink a 2 backend files at start up. The problem is one of the files is password encrypted.

Code to input the password?

Dim dbsTemp As Database
Dim strMenu As String
Dim strInput As String
' Open a Microsoft Jet database to which you will link
' a table.
Set dbsTemp = CurrentDb

[Code] .....

This part is calling the password protected database

Code:
ConnectOutput dbsTemp, _
"Usernames", _
";DATABASE=C:UsersquicoDesktopWeight_estimate_software_Usernames.accdb", _
"Usernames"

View 2 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.

Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?

View 2 Replies View Related

How To Make Setup File From Access File

Dec 7, 2006

i have develop an application in Ms Access, now i want to have setup file for that, how a setup file can be created.

View 3 Replies View Related

Modules & VBA :: Get Full File Path And File Name?

Oct 28, 2014

I'm having another one of those days but I'm getting a file path and file name from a dialogbox and forgotten when the VBA property is to return the full file path and file name.

This code works fine for return the filename only:

Code:

Private Sub TEST()
Dim f As Object
Set f = Application.FileDialog(3)
f.AllowMultiSelect = True
If f.Show Then
For I = 1 To f.SelectedItems.Count
MsgBox Filename(f.SelectedItems(I))
Next
End If
End Sub

Instead of using 'Filename' what else can I use to return what I need?

View 3 Replies View Related

Open Text File Using Only First 7 Characters Of File Name

Nov 7, 2013

I need to open and process the data from a text file on the network.

The first 7 characters of the file name will be the same every day.

The rest of the file name will change from day to day.

There will only be one file in the folder that has those first 7 characters.

There are a total of about 120 text files in the folder every day - give or take - including the one I need to open and read.

View 6 Replies View Related

Displaying One To Many To Many

Feb 21, 2007

Hello!

I have been struggling with this problem for a while and I'm so deep into it I can't look at it clearly anymore. I hope someone can give me some advice.

I'm trying to set up an orders database, but instead of one "product" I have a service with many specifications. One service part can have many kinds of inspections, which in turn have many inspection criteria.

That part seems okay to me, I guess. There's a one to many relationship between services and inspections, and a one to many between inspections and criteria. The problem is displaying that in a form in a way that's not confusing to the users - I can't put all that info in one line, and I can't put subforms in continuous forms, the best I can come up with is to have separate subforms that display the inspection types when the part number is selected and the inspection criteria when the types are selected. The users I tested it on are totally confused about it. What's the best way to go about displaying it?

I secretly just want it to look like this!

PartNumber Service Criteria Price
1001 Gauging (for) Length $100000!
(for) Diameter
Sorting (for) Rust
2222 Sorting (for) Rust $10

Maybe that's just as confusing. A fresh perspective would help.

This forum has been such a wonderful resource to me and I've learned a lot. I feel kind of embarrassed posting because I know my questions are access-ignorant, but I'm really having trouble figuring this one out on my own. Thanks for any ideas.

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

File Already In Use With No Ldb File And No Rights Issue

Aug 9, 2005

I have a web based application that loads data from Access97. From the application, I choose the database and it uploads data from the chosen db.

However, after the upload is done, I am not able to open the db again till I shut down my system and start it again. The db is on my local hard disk drive and so there are no rights issues (maybe I am wrong). I also do not see any hanging *.ldb files. I even checked to see if there were any hidden *.ldb files but found none.

Could someone please help me with this issue?

View 1 Replies View Related







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