Inserting PDF or internet address into Access form

Is there a way to insert a pdf or internet address into Access form?

Users would like to click on something on the form to bring up this webpage.

Any thoughts or comment much appreciated.


Post your answer or comment

comments powered by Disqus
Hi

I have a mulitple page report. I need to insert into it PDf or Word documents.... I cannot find a way to import these within the report tools.

Does anyone have any ideas how I can do this. Basically we are are wanting to put certificates within the document.

Thanks

Hi, is it possible to inside 2 or more data into 1 field using a listbox and show as a single record with multiple data?

For example, i would like to insert both 'Red' and "Yellow" into the field 'FavColour' as Serial Number 1. So when i select serial number 1 from the select query, the record serial number 1 will show something like " Red, Yellow" in the field 'Favcolour'.

Below is my attach file. In the Insert Form, all those that are in listbox need multiple select to insert.

Bean

Hi,

I have a form that is based on a query of 2 tables: 'Job Number Table' and 'Client Table'. The form automatically displays all of the relevant info in text box fields based on a combo box (CboJobNumber) that selects the job number. That is, the user selects a job number from the combo box, and the rest of the form updates to include all of the relevant info for that job, like client name and address, site details etc.

Now the complicated part (at least for me) is that i would like to have another combo box down the bottom of the form that selects information from a different table [Employee Table] that includes an OLE object (a small signature image as .bmp). I just can't figure out how to get the signature onto the form based on the result of the combo box (CboEmployeeName).

I think i need some VBA code that After Update identifies what the combo box selection is (which is linked to the [Employee Table]), finds that record from the [employee table] and then grabs the corresponding OLE object (the signature) and puts it into a field on the form.

Now i should say that the whole point of this is that i am trying to get these fields onto a form so that i can use all of these form fields to populate a Word template (into corresponding bookmarks). I have the code already to get the word doc up and running, just without the signature showing up..... So i will also need to figure out how to get the image from the Access Form into the Word Bookmark. ie: will this work

Private Sub CmdBtnMrg_Click()

Dim SignatureVar as Object

SignatureVar = CboEmployeeName

'Start MS Word
Dim Wrd As New Word.Application
Set Wrd = CreateObject("Word.Application")

'Open up Template
Wrd.Documents.Add "C:FilepathLetterTemplateOnePage.dotx"
Wrd.Visible = True

'Replace Bookmarks with data
With Wrd.ActiveDocument.Bookmarks
.Item("SignatureBookmark").Range.Text = SignatureVar

End Sub

Please Help

I have a situation where I need to insert a table of horizontal and vertical lines( I mean the one similar to the table in MS-WORD and not the database table of Access) into a form.

I need this to print an entry pass like ticket for an event.
The participant comes and tells his membership number, I just enter the number in the search box of the form, and then the form should pull all the necessary details of the participant on to the form.

I want to have tabular columns and rows(horizontal and vertical lines) and place the fields of the database table into different cells of the table for proper alignment and for the rectangular shape of the ticket.

By the bye, how are we refer to a table of horizontal and vertical lines, when we are dealing with issues in Access? Is there a word for it. I mean a non-database table.

Dear Sir

Our company is involved in customs clearance. we often use to search/view the pdf files in various range. the question is that how can i open a pdf file in access form
for example i have a pdf file namely "12-05-08" in "rate sheet" folder in my document. If i design a form in which there is a combo box showing all the files in that specific folder, How can i view this file by clicking preview report.

I'd like to put an internet window into a form that takes me to a specific URL and then lets me browse from there.

I know how to open an IE window from MS Access but have no clue how to open one up in a form.

Please help
Kip

Hi,

Im going to create a form in access that pulls in the data i have stored in an excel file and piece together. Eventually hope for it to display a list of tasks relating to each user aswell as enter new details.

Firstly im trying to read in my excel document into access 'without' importing the data into a table (i dont wish to go back and forth updating, i want to update the excel doc via setting the recordset). Ive not been able to find how to read in the data allowing me to have each users record on a seperate page of the form without all fields being imported. can anyone guide me?

Thanks

Hello!

I have an access database that is used to generate microbiology test reports; i want to be able to tweak it a little bit so that i can avoid redundant data entry. The way it is being done now is, data from food samples are entered(by sample collectors) into an excel file and sent to the 'data entry person'/'lab technician' who then enters the excel data in an access form along with her own test result data and then saves this as a new record into the access table. What i would like to avoid here is having to manually enter the excel data onto the access forms. I want to be able to import the data from the excel files to populate onto the new access form and then have the 'data entry person'/'lab technician' enter her test results onto the remaining fields in the form and then save all this as a new record into the access table.
How i visualize this is, using a command button that,when clicked, opens up a "browse" window from where we choose the excel file to import; after the file is chosen it populates the excel-data onto the appropriate fields in the access form and then the 'data entry person'/'lab technician' can then enter the test results portion of the form and then save all this into the database.
Will anybody lead me in the right direction here?

Many Thanks!

Hi

I am trying to find a way to build custom scrollbars into Access forms that are linked to say a textbox, and moving the scrollbar or slider, (where a min and max value could be set), updates the value in the textbox.

Excel has useful form controls such as scrollbars, spinners etc. that can be linked to a cell value and I'm trying to find a way to utilise this in Access.

I am developing a database where users can set parameters for a process that runs on a weekend update as per the current parameters. For instance, the total stock return qty a warehouse can handle in a week is 4000 lines, but a planner has the flexibility to set this between 0 and 4000.

I think this would be more interesting than just having a standard textbox for people to freetype into. Hopefully the attached Excel file shows where I'm coming from.

I am aware there is not standard functionality for this and I haven't been able to find anything on this so far, but hopefully someone will be able to help.

Many thanks

1. i'm doing my first steps in the program right now,

I need to embed youtube clip without downloading it to my computer.
is it possible in some way?

2. is there anyway to import pictures into the form so they'll link to a web address?

thank you very much 4 any help!

I've got a survey that was created in Word, and I'd like to make it into an Access 2003 form so that someone could easily enter the responses from the survey into Access.

I set up the table (with lots of check boxes), and created a form with the wizard. My idea was to copy and paste the doc, and then just move the controls on top of the doc's text.

The OLE object remained on top, in both design and form view. I could still tab between fields and activate a check box, but only by pressing the tab key; I could not click a check box with the mouse pointer and activate it.

I'd really rather not try to duplicate this long survey (only the first of about 10). Any ideas?

I have a relatively small database. It has in it data relating to orders. The orders table has maybe twenty customers and their corresponding open orders. The number of customers with open orders will fluctuate from month to month.

I want to send via e-mail a PDF or Excel file - monthly - showing the status of each customer's open orders. However I don't really want to create a new report fro each customer, instead I am looking for a way to just generate a separate report for each account that has open orders at the end of each month, and, preferably each report would be auto-named with the customer name.

Or in other words: I am trying to streamline a process so the user does not have to click and run twenty some odd reports and supply names for each, individually - it seems time consuming and open to possible keying errors.

Does anyone have any ideas?

Thanks!

I have a DB with the date/time field in Sharepoint. In my Access form I have the same field which I need to have automatically enter the GMT Time based off of the computer time and location.

I have been able to create a auto entry for my current location by calculating now()-.0125 and changing the format to get it to show 1930Z (Still having issue with missing the first zero with times between 0000 and 0959) anyway I would like to give the same access form for users in a different time zone and have them be able to update the SP list with the correct GMT Time.

I could get around this by creating a new form for different timezone users and changing the now() statement but I would prefer to have it correct so any user can load the access form from the web without confusion. There is also the issue of daylight savings time as well since GMT time does not change.


Thanks

Sav

Hi

I'm trying to use dlookup to find a suplliers address from the table "tblSuppliers" and insert it into the corresponding address fields in a form "frmPurchaseOrders"

So far, I just keep getting "#Name?" in the "address1" field

I'm not sure if i'm putting the dlookup in the correct place, I've tried adding it in 'after update' on the suppliers name field and also using it as the control source for the address line 1 field but keep getting the same results.

I have the field 'SupplierName' which is a combo box where the user can scroll down and find the correct supplier name. What I would like access to do, is when the correct name has been found, it auto populates the address lines and telephone number into the form to save them having to type it all out each time.

I've got the combobox "Combo52" with suppliers names working ok and have the following code as the control source on 'SupAddress1'

DLookup ("[SupAddress1]", tblSuppliers, [SupAddress1] & Me!Combo52)

Any suggestions?

Many thanks in advance! :-)

Is it possible to extract just an e-mail address from access, and insert it into the 'To' field in outlook? For example if 'Email Address' were a control on a form, or a report, could code be written to extract just that?

Thanks for any help!

Hi,

I've been following the info from this tutorial: http://msdn.microsoft.com/en-us/libr...ffice.10).aspx to create an access database which can automatically import data from microsoft word forms.

I've been running into problems as I'm using Office 2010 whereas the tutorial is designed for Office 2000. Below is the code for the module to gather the info from Word and put it into Access.


	Code:
	Sub GetWordData()
Dim appWord As Word.Application
Dim doc As Word.Document
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strDocName As String
Dim blnQuitWord As Boolean

On Error GoTo ErrorHandling

strDocName = "C:Contracts" & _
	InputBox("Enter the name of the Word contract " & _
	"you want to import:", "Import Contract")

Set appWord = GetObject(, "Word.Application")
Set doc = appWord.Documents.Open(strDocName)

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
	"Data Source=C:My Documents" & _
	"Healthcare Contracts.mdb;"
rst.Open "tblContracts", cnn, _
	adOpenKeyset, adLockOptimistic

With rst
	.AddNew
	!FirstName = doc.FormFields("fldFirstName").Result
	!LastName = doc.FormFields("fldLastName").Result
	!Company = doc.FormFields("fldCompany").Result
	!Address = doc.FormFields("fldAddress").Result
	!City = doc.FormFields("fldCity").Result
	!State = doc.FormFields("fldState").Result
	!ZIP = doc.FormFields("fldZIP1").Result & _
		"-" & doc.FormFields("fldZIP2").Result
	!Phone = doc.FormFields("fldPhone").Result
	!SocialSecurity = doc.FormFields("fldSocialSecurity").Result
	!Gender = doc.FormFields("fldGender").Result
	!BirthDate = doc.FormFields("fldBirthDate").Result
	!AdditionalCoverage = _
		doc.FormFields("fldAdditional").Result
	.Update
	.Close
End With
doc.Close
If blnQuitWord Then appWord.Quit
cnn.Close
MsgBox "Contract Imported!"

Cleanup:
Set rst = Nothing
Set cnn = Nothing
Set doc = Nothing
Set appWord = Nothing
Exit Sub
ErrorHandling:
Select Case Err
Case -2147022986, 429
	Set appWord = CreateObject("Word.Application")
	blnQuitWord = True
	Resume Next
Case 5121, 5174
	MsgBox "You must select a valid Word document. " _
		& "No data imported.", vbOKOnly, _
		"Document Not Found"
Case 5941
	MsgBox "The document you selected does not " _
		& "contain the required form fields. " _
		& "No data imported.", vbOKOnly, _
		"Fields Not Found"
Case Else
	MsgBox Err & ": " & Err.Description
End Select
GoTo Cleanup
End Sub

The code is generating an error when trying to load up the Access database. Access 2010 databases dont use the extension .mdb anymore so i tried replacing this with .accdb but I get the error- unrecognised database format.

If anyone knows of how I would go about sorting this error out i'd really appreciate the help, it would be great to know if there are any other obvious lines of code that would generate errors because of the changes in Access 2010. As you can probably tell i'm new to all of this so if there are any updated or more streamlined ways of goinng about this it would be great to know!

Many Thanks,
Will

Hi,

I'm helping a friend build an access database and have a problem.
I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my friend to update the list of links later on (as he does not know much about Access).
I wish to be able to create a button in the form that can automatically read each hyperlink (each cell) from the excel file, and insert them into a sub form table within access.
So that later on when my friend wants to add new hyperlinks, he can simply add them via Excel/Word (the hyperlinks can either be stored in Excel or Word)

Does anyone know how to do this? I am only familar with the Access interface design and macros, but not very familar with VB.

Your help will be most appreciated,

Raymond

Guys - hopefully a quickie
I want to insert a pdf file into my email (same pdf file for all)

it lives on my C: Standardxxxx.pdf

I have been using a D/b from the samples fromt hisd website (thanks to whomever) but I need it to insert the above instead of the access report (or both) - coding is not one of my strong points below is the code i have ben using

regards




Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEmail_Click

Dim strDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As String

strDocName = Me.lstRpt
strEmail = Me.txtSelected & vbNullString
strMailSubject = Me.txtMailSubject & vbNullString
strMsg = Me.txtMsg
'& vbNullString & vbCrLf & vbCrLf & '"Your Name" &
' vbCrLf & "MailTo:youremail@nowhere.com"

DoCmd.SendObject objecttype:=acSendReport, _
ObjectName:=strDocName, outputformat:=acFormatHTML, _
To:=strEmail, Subject:=strMailSubject, MessageText:=strMsg

Exit_cmdEmail_Click:
Exit Sub

Err_cmdEmail_Click:
MsgBox Err.Description
Resume Exit_cmdEmail_Click

End Sub

I have a form in Access (2003), from which I would like to transfer data to an independent web page (meaning I don't own the page, it's on our companies intranet). I've created a hyperlink, and I would like to insert data from my Access form into the web form. Does anyone know if this can be done?

I got new task where I need to design one access form. The page has two sections.
Section 1: I want a give option to user where they can click on button and select PDF file by using Application.FileDialog. After selecting the file, I want a transfer the PDF file to the Access/SQL database and store the pdf file into the database.

Section 2: I want create the image box or any other object where I can display the uploaded file from Access/SQL database.

User need to upload the file to database table and then pull the imported file from database and display as picture on image box or any other control box.

I have done browse the file by using Application.FileDialog and import the selected text file to Access database. I haven’t transferred PDF file to database and pull the file display on screen. Can anyone help me out here.

Spent hours searching the internet before resorting to pleading for help. Im trying to import a CSV file from excel into an access form that I have already made. Simply put I don't want to have to type data twice and im trying to eliminate any room for error. Any tips or ideas would be greatly appreciated.

Hi,

I'm helping a friend build an access database and have a problem.
I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my friend to update the list of links later on (as he does not know much about Access).
I wish to be able to create a button in the form that can automatically read each hyperlink (each cell) from the excel file, and insert them into a sub form table within access.
So that later on when my friend wants to add new hyperlinks, he can simply add them via Excel/Word (the hyperlinks can either be stored in Excel or Word)

Does anyone know how to do this? I am only familar with the Access interface design and macros, but not very familar with VB.

Your help will be most appreciated,

Raymond

Hi all

i made an application with access as the front-end and an sql server as back-end, not something very unusual

As far as i know access self can generate an autonumber and get the default values from a table and puts them on the screen when adding a new record.
I know sql server can't do this so i thought: When you click for a new record the "BeforeInsert" event is triggered and i am going to put some code in there to save the record so i can get all the default values and autonumbers.

my idea works only the problem is, i can't get it to save on time. It only saves/inserts to sql when the record lost its focus or when you close the form

i did try to make use of runcmd accmdSaveRecord, it gives no errors but inserts nothing into the sql database.

when i try to use accmdInsertRows, it says it isn't available right now.

could anybody give me some help on this one ?

Hi,

I am new to this forum.

Following is my query:

I have two documents one in word and another in PDF format.

I want to import word document into an access as a Form. This word document has fields: Name, address, date of birth etc.

When I enter the data in this form I want it to be saved to access database (so that data can be accessed as and when required)

Next step..

I want to add .PDF into access as form as well. This also has fields such as Name, Address, date of birth etc (same as above). I want these fields to be automatically populated with data from first form.

Please suggest how should I go about this. I am Systems Admin by profession, not very good at programming.

Your help will be much appreciated.

Adarsh


Not finding an answer? Try a Google search.