FrontPage Form / Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form that submits the information into a Access database.
Certain form fields will have to be filled in at a later time compared to
other form fields. Is there a way to create a form that sends the info to a
Access database but then at a later time enter certain information (i.e.
company name or customer number) and have what you previously entered
populate in the form?

If this is possible please explain as simply as possible since I'm still
learning FrontPage and Access.

Thank you!!
 
Or you can use ASP or ASP.NET to do this. See www.asp101.com for samples.
What you want to do is an INSERT the first time and then the next time you
want to look up that record and do an UPDATE where the record ID is the same
as the record that's being updated.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
 
Hi thank you for the help. I have created a web page that shows the
information from the database. It's set up as records where I can click
through until I find what I want. Is there a way to set up so that I can
enter a customer number and the record connected to that custmer number
populates?
 
Create a "search" page where you enter the Customer Number into a form
field. Then, when you click submit, have the form ACTION go to a page that
grabs the result of Request.Form("FIELDNAME") and put it in a variable.
Then use that variable in the WHERE clause of your SELECT statement and
display the record.

Ex:

Page 1 would have something like this

<form method="POST" action="processform.asp">
input type="text" name="CustomerNumber" size="20">
</form>

Page 2 (processform.asp) would have something like this

<%
strCustomNumber = Request.Form("CustomerNumber")

strConnection = Application.Contents("YOURDATABSECONNECTION")
Set adoCN = server.CreateObject("ADODB.connection")
Set adoRS = server.CreateObject("ADODB.recordset")
adoCN.Open strConnection
adoRS.ActiveConnection = adoCN
adoRS.CursorLocation = adUseClient

strSQL = "SELECT * FROM TABLENAME WHERE CustomerNumber = " & strCustomNumber
adoRS.Open strSQL
%>

Then to display the record you'd create a layout, like a table, and put
<%=adoRS("FIELDNAME")%> - one for each field you want to show - in the
layout. Then you have your results.

NOTE: The sample SQL Statement above assumes that your field is a number.
If it's a text field change it to be:

strSQL = "SELECT * FROM TABLE WHERE CustomerNumber = = '" & strCustomNumber
& "'"

The code above is straight ASP code. If you're using the FrontPage
Database Wizard see the tips at
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
 
I'm sorry, you have to explain a lot more simpler. I'm still learning and
have no clue what the "computer language" means.
 
Then you should start with getting a book on ASP (Active Server Pages) or
looking at some of the many tutorial sites out there such as www.asp101.com
since it would take too long to break this all down in simpler terms if you
don't understand ASP programming.
 
Or you could give me a link to a page that explains the step by step process
as others have done in the past.

Thank you!
 
There isn't always a link to the step by step process. Some types of coding
needs to be learned. I gave you a link to a web site. Start with the
samples there. You can also do a search for ASP sites.

Sorry, but I can't teach you ASP programming in a few posts.


--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


ChrisLouie said:
Or you could give me a link to a page that explains the step by step
process
as others have done in the past.

Thank you!

David Berry said:
Then you should start with getting a book on ASP (Active Server Pages) or
looking at some of the many tutorial sites out there such as
www.asp101.com
since it would take too long to break this all down in simpler terms if
you
don't understand ASP programming.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


ChrisLouie said:
I'm sorry, you have to explain a lot more simpler. I'm still learning
and
have no clue what the "computer language" means.

:

Create a "search" page where you enter the Customer Number into a form
field. Then, when you click submit, have the form ACTION go to a page
that
grabs the result of Request.Form("FIELDNAME") and put it in a
variable.
Then use that variable in the WHERE clause of your SELECT statement
and
display the record.

Ex:

Page 1 would have something like this

<form method="POST" action="processform.asp">
input type="text" name="CustomerNumber" size="20">
</form>

Page 2 (processform.asp) would have something like this

<%
strCustomNumber = Request.Form("CustomerNumber")

strConnection = Application.Contents("YOURDATABSECONNECTION")
Set adoCN = server.CreateObject("ADODB.connection")
Set adoRS = server.CreateObject("ADODB.recordset")
adoCN.Open strConnection
adoRS.ActiveConnection = adoCN
adoRS.CursorLocation = adUseClient

strSQL = "SELECT * FROM TABLENAME WHERE CustomerNumber = " &
strCustomNumber
adoRS.Open strSQL
%>

Then to display the record you'd create a layout, like a table, and
put
<%=adoRS("FIELDNAME")%> - one for each field you want to show - in the
layout. Then you have your results.

NOTE: The sample SQL Statement above assumes that your field is a
number.
If it's a text field change it to be:

strSQL = "SELECT * FROM TABLE WHERE CustomerNumber = = '" &
strCustomNumber
& "'"

The code above is straight ASP code. If you're using the FrontPage
Database Wizard see the tips at
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


Hi thank you for the help. I have created a web page that shows the
information from the database. It's set up as records where I can
click
through until I find what I want. Is there a way to set up so that I
can
enter a customer number and the record connected to that custmer
number
populates?

:

Or you can use ASP or ASP.NET to do this. See www.asp101.com for
samples.
What you want to do is an INSERT the first time and then the next
time
you
want to look up that record and do an UPDATE where the record ID is
the
same
as the record that's being updated.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support
see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote
in
message You might try the FrontPage Database Interface Wizard:
http://www.microsoftfrontpage.com/content/articles/dbpower.html
http://msdn2.microsoft.com/en-us/library/aa218651(office.11).aspx

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


message
I have created a form that submits the information into a Access
database.
Certain form fields will have to be filled in at a later time
compared
to
other form fields. Is there a way to create a form that sends
the
info
to
a
Access database but then at a later time enter certain
information
(i.e.
company name or customer number) and have what you previously
entered
populate in the form?

If this is possible please explain as simply as possible since
I'm
still
learning FrontPage and Access.

Thank you!!
Click to expand...
Click to expand...
Click to expand...
 
Yeah thanks anyway. I got a reply from someone else who was able to teach me
what I needed to know and I've now gotten what I needed and it's working
perfectly.

David Berry said:
There isn't always a link to the step by step process. Some types of coding
needs to be learned. I gave you a link to a web site. Start with the
samples there. You can also do a search for ASP sites.

Sorry, but I can't teach you ASP programming in a few posts.


--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


ChrisLouie said:
Or you could give me a link to a page that explains the step by step
process
as others have done in the past.

Thank you!

David Berry said:
Then you should start with getting a book on ASP (Active Server Pages) or
looking at some of the many tutorial sites out there such as
www.asp101.com
since it would take too long to break this all down in simpler terms if
you
don't understand ASP programming.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


I'm sorry, you have to explain a lot more simpler. I'm still learning
and
have no clue what the "computer language" means.

:

Create a "search" page where you enter the Customer Number into a form
field. Then, when you click submit, have the form ACTION go to a page
that
grabs the result of Request.Form("FIELDNAME") and put it in a
variable.
Then use that variable in the WHERE clause of your SELECT statement
and
display the record.

Ex:

Page 1 would have something like this

<form method="POST" action="processform.asp">
input type="text" name="CustomerNumber" size="20">
</form>

Page 2 (processform.asp) would have something like this

<%
strCustomNumber = Request.Form("CustomerNumber")

strConnection = Application.Contents("YOURDATABSECONNECTION")
Set adoCN = server.CreateObject("ADODB.connection")
Set adoRS = server.CreateObject("ADODB.recordset")
adoCN.Open strConnection
adoRS.ActiveConnection = adoCN
adoRS.CursorLocation = adUseClient

strSQL = "SELECT * FROM TABLENAME WHERE CustomerNumber = " &
strCustomNumber
adoRS.Open strSQL
%>

Then to display the record you'd create a layout, like a table, and
put
<%=adoRS("FIELDNAME")%> - one for each field you want to show - in the
layout. Then you have your results.

NOTE: The sample SQL Statement above assumes that your field is a
number.
If it's a text field change it to be:

strSQL = "SELECT * FROM TABLE WHERE CustomerNumber = = '" &
strCustomNumber
& "'"

The code above is straight ASP code. If you're using the FrontPage
Database Wizard see the tips at
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


Hi thank you for the help. I have created a web page that shows the
information from the database. It's set up as records where I can
click
through until I find what I want. Is there a way to set up so that I
can
enter a customer number and the record connected to that custmer
number
populates?

:

Or you can use ASP or ASP.NET to do this. See www.asp101.com for
samples.
What you want to do is an INSERT the first time and then the next
time
you
want to look up that record and do an UPDATE where the record ID is
the
same
as the record that's being updated.

--
David Berry
Microsoft MVP - FrontPage
FrontPage Support: http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support
see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
-----------------------------------


"Kathleen Anderson [MVP - FrontPage]" <[email protected]>
wrote
in
message You might try the FrontPage Database Interface Wizard:
http://www.microsoftfrontpage.com/content/articles/dbpower.html
http://msdn2.microsoft.com/en-us/library/aa218651(office.11).aspx

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


message
I have created a form that submits the information into a Access
database.
Certain form fields will have to be filled in at a later time
compared
to
other form fields. Is there a way to create a form that sends
the
info
to
a
Access database but then at a later time enter certain
information
(i.e.
company name or customer number) and have what you previously
entered
populate in the form?

If this is possible please explain as simply as possible since
I'm
still
learning FrontPage and Access.

Thank you!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top