Re: pages from database?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thomas A. Rowe (tarowe_at_mvps.org)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 15:36:55 -0500

The database components will allow you to set the filter for what records are to be returned, just
go thru the wizard after you have imported the database into the web, and created the connection.

I can't really help you beyond the basics with the FP database component, as I only do hand coding. 

-- 
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"Glenn" <nospam@yahoo.com> wrote in message news:ezRILTGFFHA.1396@tk2msftngp13.phx.gbl...
>I am running a Windows 2000 server.  Is there anything additional I need to do to it?
>
> Also, are there instructions somewhere on how I can create the filter so that only a specific 
> department shows up?  Or, do I just do that in Access?
>
>
> "Thomas A. Rowe" <tarowe@mvps.org> wrote in message 
> news:%23l9$3qFFFHA.3780@TK2MSFTNGP09.phx.gbl...
>> Yes. Use the FP database components, however your site must be hosted on a Windows IIS server.
>>
>> -- 
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Glenn" <nospam@yahoo.com> wrote in message news:uwNFBfFFFHA.1292@TK2MSFTNGP10.phx.gbl...
>>>I have a Microsoft Access database that has a list of my employees and departments in it.
>>>
>>> I have a site for each of my department's.
>>>
>>> I'd like to have a page on there that lists the employees of the department. I'd like to have 
>>> that list come from my Access database - just showing that department.
>>>
>>> I'd also like the list to update automatically when I add new employees.
>>>
>>> Is this possible using Front Page & Microsoft Access?
>>>
>>> Thanks in advance.
>>>
>>
>>
>
>

Relevant Pages

  • Re: update not working
    ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >> Ok, now you need to wait for someone that use the FP database components, for help, but here is ... pass the record id of the record you want to edit, ... the form page will then load the record in to the update form, so that it can be edited. ...
    (microsoft.public.frontpage.client)
  • Re: database results mix and match
    ... The Operators are basic VBScript operators, they are not unique to the FP Database Component, anyone ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >> accomplish a lot more outside of using the FP database components and in many cases a lot less ... unfortunately, I'm not hand coding. ...
    (microsoft.public.frontpage.client)
  • Re: Database now returning errors
    ... When you learn to hand code, you learn ASP/VBScript. ... which is just not possible to implement when using the FP database components. ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... What is the rationale for promoting hand coding? ...
    (microsoft.public.frontpage.client)
  • Re: update info form
    ... FP uses Access by default with the Database components. ... You will need to review the help file. ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >>> updated on his website calendar for all his salesmen to ...
    (microsoft.public.frontpage.client)
  • Re: Need help with FP2003, MS Access, ASP and text boxes
    ... Are you writing your code by hand or with FP database components? ... Member = Request.Form ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... > How can I display a fields value from a recordset within a text box ...
    (microsoft.public.frontpage.client)