[AccessD] Urgent help please - Can't open htmlpageinFrontpagefromAccess form

Jim Lawrence (AccessD) accessd at shaw.ca
Thu Sep 16 18:40:12 CDT 2004


Hi Kath:

It is a interest dilemma. One side the users is having difficulty
understanding the changes created to a translated word document and on the
other side accepting the complexity of building a document/web page in
FrontPage.

The resultant FP created documents will have to be stored in directories, on
your server running IIS, below the tree location
\\MyServer\Inetpub\wwwroot\WebDocumentDirectory\.... then they will be able
to be run/displayed from anywhere on LAN. When the web based files are
stored in this location your IIS server manages their display. I.e.
\\MyServer\Inetpub\wwwroot\WebDocumentDirectory\MyNewFPDocument123.html,
would run and display from anywhere accessed on your network. Note: If the
file, being accessed has an extension that is not supported/configured (not
web files like .html, .htm, .php, .pl, .asp, etc... depends on how the IIS
is setup), IIS will attempt to download the file to the station selecting
it.

Hope this is not confusing or over-stated. If it is confusing just ask for
clarification.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath Pelletti
Sent: Tuesday, September 14, 2004 10:04 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Urgent help please - Can't open
htmlpageinFrontpagefromAccess form


Hi Jim - thanks for your comment - these particular users really don't
understand (or accept) that the doc. will look different once displayed in
the browser, eg. if they have created it in Word and then it is converted by
Microsoft to html....and I understand where they are coming from.

They have accepted that to create it as a web page they need to do so in
Frontpage and then they can see how it will look once it goes live. My
problem (and I can't believe that I'm still stuck on this) is providing a
link for all staff in the office to be able to open the documents they
create, edit them and save them.

It is essential that it happen from the database because I am storing a
history of documents (just path/s and filename/s) they create and they have
complex selection criteria for nominating which clients eventually *see* the
doc on the website. Given that it is so easy to create / and link to a doc
in Word or Excel from an Access form I thought it would be pretty
straightforward to do something like this in Frontpage. I'm still sure that
it is.....just not there yet.

Kath
  ----- Original Message -----
  From: Jim Lawrence (AccessD)
  To: Access Developers discussion and problem solving
  Sent: Wednesday, September 15, 2004 1:03 PM
  Subject: RE: [AccessD] Urgent help please - Can't open html
pageinFrontpagefromAccess form


  Hi Kath:

  If the file is in html format and saved with the html extension. I.e.
  test.html, then any station with an active browser will display it. Even
if
  the file is originally a document file it can be saved as an html file and
  Microsoft will do the conversion for you...sometime it is not very pretty
  but it is simple. All that has to be done for each station to view/run it
is
  that the html 'document' has to be stored in a common shared directory.

  HTH
  Jim

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath Pelletti
  Sent: Tuesday, September 14, 2004 4:12 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Urgent help please - Can't open html
  pageinFrontpagefrom Access form


  I don't have VB Drew.......

  Kath
    ----- Original Message -----
    From: DWUTKA at marlow.com
    To: accessd at databaseadvisors.com
    Sent: Wednesday, September 15, 2004 12:01 AM
    Subject: RE: [AccessD] Urgent help please - Can't open html page
  inFrontpagefrom Access form


    If you have VB, you can just 'preview' it for them in a simple VB
browser.

    Drew

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com
    [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath Pelletti
    Sent: Tuesday, September 14, 2004 6:47 AM
    To: Access Developers discussion and problem solving
    Subject: Re: [AccessD] Urgent help please - Can't open html page
    inFrontpagefrom Access form


    Thanks Eric - I am finding this so confusing.

    Yes - I have IIS running here - so my file must be in a folder from
    C:\Inetpub\wwwroot?  I need to allow the database users to share a
common
    file - can it find a web in a network location?

    To go back to the basic requirements - what I am trying to do is allow
  users
    to click on a button in the databse which will open a document which
will
  be
    published to the web. I want them to be able to create and edit that
    document by following a link from an access form, because the letter
that
    the users 'create' will be linked to recipients from my database.

    They could theoretically do it in Word or Notepad (or even within
Access),
    but I want them to see how it will preview on the web before they
finalise
    it, so formatting is done. I don't want to have to worry about whether
  they
    are running IIS or create web folders or whatever - just open and edit a
    simple html file in Frontpage so they can see how it would publish. Am I
    going about this the wrong way?

    TIA!
    Kath

      ----- Original Message -----
      From: Eric Barro
      To: Access Developers discussion and problem solving
      Sent: Tuesday, September 14, 2004 11:31 AM
      Subject: RE: [AccessD] Urgent help please - Can't open html page
    inFrontpagefrom Access form


      Kath,

      FP webs expect to open these web folders in reference to the web root
    folder in IIS.

      For example:

      You have IIS (web server) running on the machine and you have a web
  called
    MYWEB. IIS sees this as http://localhost/MYWEB. The physical location
    (assuming the web root is C:\INETPUB\WWWROOT) is
  C:\INETPUB\WWWROOT\MYWEB\.
    So...if MYWEB is in a different folder...say
    C:\INETPUB\WWWROOT\ANOTHERFOLDER\MYWEB\  FP won't be able to recognize
  that
    as a web location.

      ---
      Eric Barro
      Senior Systems Analyst
      Advanced Field Services
      (208) 772-7060
      http://www.afsweb.com

      -----Original Message-----
      From: accessd-bounces at databaseadvisors.com
      [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kath
Pelletti
      Sent: Monday, September 13, 2004 6:13 PM
      To: AccessD at databaseadvisors.com
      Subject: [AccessD] Urgent help please - Can't open html page in
      Frontpagefrom Access form


      I have wasted ages on this so am now begging assistance........

      I have an html file (empty at present - later it will have some basic
    text)

      I need to my code to
      - Make a copy of the template.html file (I can do that) and
      - give it a new name, eg. Template_BHP_140904.html (I can do that)
      - Open the html file just created in Frontpage for users to modify the
    document (That's where I'm stuck....)

      My problem is a total lack of knowledge of files vs. webs and
therefore
    the syntax I need. Questions: -

      - Do I have to have a 'web' or 'web folder' - can't I just have an
html
    file and open it?

      - If I can, what is the alternative syntax to .webs.open - eg. I am
    looking for a .pages.open property or .files.open ?

      Here's my code so far - when I run it I get an error  - There is no
web
    named "/E:/SDS/Clients/CPP/WebLetters/Template.html"



    ------------------------------------------------------------------------
--
  --
    ----

      Private Sub CmdOpenFP_Click()

      Dim oFPweb As FrontPage.Web
      Dim oFP As FrontPage.Application
      Dim FrontPageRunning As Boolean

      'Determine whether FrontPage is alredy open or not
      FrontPageRunning = IsFrontPageRunning()

      If Not FrontPageRunning Then
          MsgBox ("Frontpage is Closed")
          Set oFP = CreateObject("Frontpage.Application")
      Else
          MsgBox ("Frontpage is already open")
          Set oFP = GetObject(, "Frontpage.Application")
      End If

      'add code here later to make a copy of my file

      'open file in front
page------------------------------------------------
      oFP.Webs.Open ("E:\Sds\Clients\CPP\Webletters\template.html")
    'STUCK HERE

       ' Show FrontPage
       oFPweb.Activate
       'Set oFP = Nothing

      End Sub


    ------------------------------------------------------------------------
--
  --
    ----

      TIA


      Kath Pelletti
      Software Design & Solutions Pty Ltd.
      Ph: 9505-6714
      Fax: 9505-6430
      KP at SDSOnline.net
      --
      _______________________________________________
      AccessD mailing list
      AccessD at databaseadvisors.com
      http://databaseadvisors.com/mailman/listinfo/accessd
      Website: http://www.databaseadvisors.com


      --
      _______________________________________________
      AccessD mailing list
      AccessD at databaseadvisors.com
      http://databaseadvisors.com/mailman/listinfo/accessd
      Website: http://www.databaseadvisors.com
    --
    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
    --
    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
  --
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

  --
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list