Adding Searchable Database to website

Anthony · May 19, 2008

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 · May 19, 2008

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 · May 19, 2008

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 · May 20, 2008

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.

Wayne-I-M said:
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.

Anthony said:

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

Click to expand...

Thomas A. Rowe · May 20, 2008

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
==============================================

Anthony said:
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.

Wayne-I-M said:

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.

Anthony said:

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

Click to expand...

Click to expand...

Anthony · May 20, 2008

No, I have not. What would you suggest?

Thomas A. Rowe said:
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
==============================================

Anthony said:

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.

Wayne-I-M said:

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

Click to expand...

Click to expand...

Thomas A. Rowe · May 20, 2008

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
==============================================

Anthony said:
No, I have not. What would you suggest?

Thomas A. Rowe said:

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
==============================================

Anthony said:

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

Click to expand...

Click to expand...