By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,177 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Word form can link to Access db, as a data entry form?

P: n/a
Is it possible to create a Word form as the data entry form for an
Access database? I didn't see any reference to this possibility in my
Access books, so I'm sorry if this is a question that is rather
off-the-wall. I was asked to ask this question, to see if a Word form
can be linked to an Access database and then emailed to various
end-users for them to complete task requests using this form.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"intl04" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
Is it possible to create a Word form as the data entry form for an
Access database?
Do you mean you want to import data from a Word form that you have
distributed to users?
I didn't see any reference to this possibility in my
Access books, so I'm sorry if this is a question that is rather
off-the-wall. I was asked to ask this question, to see if a Word form
can be linked to an Access database
Mail merge?

Linked can mean many things:)
and then emailed to various
Now this is what I need to know... how to do a mail merge then email each
seperate merged page to that person's email addresses???
end-users for them to complete task requests using this form.


Do you then want that data to go back in your database??

If it were me, I'd consider setting up a web page form directly linked to my
database (or another database that I can import from if I want to keep my
other data elsewhere) :)

If you only want to generate a form in Word that is static (send to users
for them to view) then probably easiest to create a report and use
DoCmd.SendObjects to email it to each user....
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Nov 12 '05 #2

P: n/a
Bradley,

You said in another post --

<A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.>>

Can you give a simple but practicle example on how to do this?

Thanks!

Steve

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40******@nexus.comcen.com.au...
"intl04" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
Is it possible to create a Word form as the data entry form for an
Access database?


Do you mean you want to import data from a Word form that you have
distributed to users?
I didn't see any reference to this possibility in my
Access books, so I'm sorry if this is a question that is rather
off-the-wall. I was asked to ask this question, to see if a Word form
can be linked to an Access database


Mail merge?

Linked can mean many things:)
and then emailed to various


Now this is what I need to know... how to do a mail merge then email each
seperate merged page to that person's email addresses???
end-users for them to complete task requests using this form.


Do you then want that data to go back in your database??

If it were me, I'd consider setting up a web page form directly linked to my
database (or another database that I can import from if I want to keep my
other data elsewhere) :)

If you only want to generate a form in Word that is static (send to users
for them to view) then probably easiest to create a report and use
DoCmd.SendObjects to email it to each user....
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

Nov 12 '05 #3

P: n/a
(Note: this is a very quick, simplified and off handed explanation!:)

All you do is insert VB code into a HTML document. This code is being passed
a value for Personnel_no and CompanyNumber which has been set when the user
logged in. This is then used to show data for that employee.

eg.

Code is surrounded by <% %>
An equal sign will return the result of the code into the resulting HTML
document
eg. <%= rsEmp![EmployeeName]%>

---------------------------------------
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Dim MM_core_STRING
MM_core_STRING = "DRIVER={SQL
Server};SERVER=INSERTSERVERNAME;DATABASE=INSERTDAT ABASENAME;UID=INSERTUSERNA
ME;Password=INSERTPASSWORD"
response.expires = 0
dim rsEmp
dim mySQL
dim pid
dim cid
dim company
pid = session("pid")
cid = session("cid")
company = session("company")
mySQL = "SELECT * FROM tblSPStatement WHERE [Personnel_no]='" & pid & "' And
[CompanyNumber] = '" & cid & "';"
Set rsEmp = Server.CreateObject("ADODB.Recordset")
rsEmp.ActiveConnection = MM_core_STRING
rsEmp.Source = mySQL
rsEmp.CursorType = 0
rsEmp.CursorLocation = 2
rsEmp.LockType = 1
rsEmp.Open()
%>
<html>
<head>
</head>
<body>
<%
Do Until rsEmp.EOF
%>
<p> <%= rsEmp![EmployeeName]%> </p>
<%
rsEmp.MoveNext
Loop
%>

</body>
</html>
---------------------------------------

I'm sure there are lots of web site that explain how to build ASP pages
better than I:)

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response
"PC Datasheet" <sp**@spam.nospam> wrote in message
news:gp*******************@newsread3.news.atl.eart hlink.net...
Bradley,

You said in another post --

<A simple way to do it is to embed a connect string to your
database that your code uses to access your database then use code to
determine what the person can see/access.>>

Can you give a simple but practicle example on how to do this?

Thanks!

Steve

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40******@nexus.comcen.com.au...
"intl04" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
Is it possible to create a Word form as the data entry form for an
Access database?


Do you mean you want to import data from a Word form that you have
distributed to users?
I didn't see any reference to this possibility in my
Access books, so I'm sorry if this is a question that is rather
off-the-wall. I was asked to ask this question, to see if a Word form
can be linked to an Access database


Mail merge?

Linked can mean many things:)
and then emailed to various


Now this is what I need to know... how to do a mail merge then email each seperate merged page to that person's email addresses???
end-users for them to complete task requests using this form.


Do you then want that data to go back in your database??

If it were me, I'd consider setting up a web page form directly linked to my database (or another database that I can import from if I want to keep my other data elsewhere) :)

If you only want to generate a form in Word that is static (send to users for them to view) then probably easiest to create a report and use
DoCmd.SendObjects to email it to each user....
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.