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

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/co.../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



"Anthony" <(E-Mail Removed)> wrote in message
news:B8725ECA-B625-4949-BEC6-(E-Mail Removed)...
>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

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" wrote:

> 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

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" wrote:

> 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" wrote:
>
> > 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

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" <(E-Mail Removed)> wrote in message
news:2585477B-AF48-4069-881C-(E-Mail Removed)...
>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" wrote:
>
>> 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" wrote:
>>
>> > 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

No, I have not. What would you suggest?

"Thomas A. Rowe" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:2585477B-AF48-4069-881C-(E-Mail Removed)...
> >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" wrote:
> >
> >> 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" wrote:
> >>
> >> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:5300FCD9-A2C0-4E4B-AD26-(E-Mail Removed)...
> No, I have not. What would you suggest?
>
> "Thomas A. Rowe" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:2585477B-AF48-4069-881C-(E-Mail Removed)...
>> >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" wrote:
>> >
>> >> 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" wrote:
>> >>
>> >> > 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
>>
>>
>>