[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