Adding Searchable Database to website

[Anthony]

I have an access database and I was wondering how I can add a search box
using frontpage to my website and then if they enter an item number is the
searchbox it will search my database and then list the results. If you could
please help.
Thanks, Anthony

 

[Kathleen Anderson]

Is your web site hosted on a Windows server that supports Active Server
Pages and Access databases? If so, here's a tutorial to help you get
started: http://www.microsoftfrontpage.com/content/articles/datintro.html

--

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

 

[Wayne-I-M]

The "very" basic code to run that would be something like (to find one record)

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[SomeIDNumber] = " & Str(Me![YourFormFieldName])
Me.Bookmark = rs.Bookmark

To find a number of records you would need to fillter the base data (this
could be done from the form). Something like this

SELECT TableName.FieldName
FROM TableName
GROUP BY TableName.FieldName 'Not req if not needed'
HAVING (((TableName.FieldName)=[Forms]![FormName].[Form]![ControlName]))
ORDER BY TableName.FieldName; 'Not req if not needed'

You would need to work this into your website code but ther access bit is
quite simple

 

[Anthony]

I tried to follow the instructions, but do not understand. I do not want to
add data to anything. All I want is if someone types in an item number it
will search this file and display the results. Let me know if I'm missing
something. Thanks again for your help.

The "very" basic code to run that would be something like (to find one record)

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[SomeIDNumber] = " & Str(Me![YourFormFieldName])
Me.Bookmark = rs.Bookmark

To find a number of records you would need to fillter the base data (this
could be done from the form). Something like this

SELECT TableName.FieldName
FROM TableName
GROUP BY TableName.FieldName 'Not req if not needed'
HAVING (((TableName.FieldName)=[Forms]![FormName].[Form]![ControlName]))
ORDER BY TableName.FieldName; 'Not req if not needed'

You would need to work this into your website code but ther access bit is
quite simple






--
Wayne
Manchester, England.

I have an access database and I was wondering how I can add a search box
using frontpage to my website and then if they enter an item number is the
searchbox it will search my database and then list the results. If you could
please help.
Thanks, Anthony

 

[Thomas A. Rowe]

Have you considered a pre-written shopping cart application, even if you don't plan to sell via the
internet?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

I tried to follow the instructions, but do not understand. I do not want to
add data to anything. All I want is if someone types in an item number it
will search this file and display the results. Let me know if I'm missing
something. Thanks again for your help.

The "very" basic code to run that would be something like (to find one record)

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[SomeIDNumber] = " & Str(Me![YourFormFieldName])
Me.Bookmark = rs.Bookmark

To find a number of records you would need to fillter the base data (this
could be done from the form). Something like this

SELECT TableName.FieldName
FROM TableName
GROUP BY TableName.FieldName 'Not req if not needed'
HAVING (((TableName.FieldName)=[Forms]![FormName].[Form]![ControlName]))
ORDER BY TableName.FieldName; 'Not req if not needed'

You would need to work this into your website code but ther access bit is
quite simple






--
Wayne
Manchester, England.

I have an access database and I was wondering how I can add a search box
using frontpage to my website and then if they enter an item number is the
searchbox it will search my database and then list the results. If you could
please help.
Thanks, Anthony

 

[Anthony]

No, I have not. What would you suggest?

Have you considered a pre-written shopping cart application, even if you don't plan to sell via the
internet?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

I tried to follow the instructions, but do not understand. I do not want to
add data to anything. All I want is if someone types in an item number it
will search this file and display the results. Let me know if I'm missing
something. Thanks again for your help.

The "very" basic code to run that would be something like (to find one record)

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[SomeIDNumber] = " & Str(Me![YourFormFieldName])
Me.Bookmark = rs.Bookmark

To find a number of records you would need to fillter the base data (this
could be done from the form). Something like this

SELECT TableName.FieldName
FROM TableName
GROUP BY TableName.FieldName 'Not req if not needed'
HAVING (((TableName.FieldName)=[Forms]![FormName].[Form]![ControlName]))
ORDER BY TableName.FieldName; 'Not req if not needed'

You would need to work this into your website code but ther access bit is
quite simple






--
Wayne
Manchester, England.



:

I have an access database and I was wondering how I can add a search box
using frontpage to my website and then if they enter an item number is the
searchbox it will search my database and then list the results. If you could
please help.
Thanks, Anthony

 

[Thomas A. Rowe]

You would need to do a search for using the following or similar terms:

ASP based shopping cart application

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

No, I have not. What would you suggest?

Have you considered a pre-written shopping cart application, even if you don't plan to sell via
the
internet?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

I tried to follow the instructions, but do not understand. I do not want to
add data to anything. All I want is if someone types in an item number it
will search this file and display the results. Let me know if I'm missing
something. Thanks again for your help.

:

The "very" basic code to run that would be something like (to find one record)

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[SomeIDNumber] = " & Str(Me![YourFormFieldName])
Me.Bookmark = rs.Bookmark

To find a number of records you would need to fillter the base data (this
could be done from the form). Something like this

SELECT TableName.FieldName
FROM TableName
GROUP BY TableName.FieldName 'Not req if not needed'
HAVING (((TableName.FieldName)=[Forms]![FormName].[Form]![ControlName]))
ORDER BY TableName.FieldName; 'Not req if not needed'

You would need to work this into your website code but ther access bit is
quite simple






--
Wayne
Manchester, England.



:

I have an access database and I was wondering how I can add a search box
using frontpage to my website and then if they enter an item number is the
searchbox it will search my database and then list the results. If you could
please help.
Thanks, Anthony