Recent content by PortyAL

Hi Simple question - is it possible to export a multipage access report to a single page HTML file, i.e. with no Next, Prev tags at the bottom of each page? Thanks AL

Many thanks! This appears to have solved the problem! AL

Hi I use the following code to create an e-mail. (The original code is quite lengthy so I have deleted sections which are not relevant to my question). Private Sub Command184_Click() If IsNull(Forms![form1]![PAR Due1]) = True Then GoTo norespdate Rem On Error GoTo nofiles Dim strbody...

Hi I have a machine running Outlook 2002 and Access 2002. The code below searches a subfolder in my inbox called "Temp", finds any messages flagged as "complete", displays the emails and saves them as HTML files to a folder as specified in the field "docfolder" in the open Access form "form1"...

Hi What I want to do sounds simple but obviously isn't. I want to save an e-mail received in Outlook to a hard drive folder as specifed in a field in an Access form. I have the following code but need something that would select the highlighted e-mail in my Inbox (or the active open e-mail if...

Brilliant! Working now! Much appreciated. AL

Thanks but... If I try that I get the message Object doesn't support this property or method I've tried it with several fields but get the same error. AL

Hi I have a form and I want to disable some fields depending on whether a check box on the form is ticked. I've tried: Forms![formname].Controls(fieldname).Enabled = False but I get an error message: "Run-time error '2164': You can't disable a control while it has the focus." Any help...

Hi I use the following code to create a Word document from Access. Set objword = New Word.Application With objword .Visible = True .Documents.Add Template:=("i:\ia manual\templates\quality assurance review.dot") .Selection.Goto Name:=("job") .Selection.TypeText...

Hi I have a form "frm Recs Tracked Jobs" in which there is a subform "tbl Additional Files subform" in datasheet format. I wish to run a routine (see below) to create an e-mail using info in the chosen record in the subform by clicking on a field in the subform. Private Sub Miscemail() On...

Forget the last post. Got it sorted. Thanks for your help AL

Hi Having a little bit of bother with this. Getting an error - "invalid use of Me". The data I'm looking to send to word is in a subform called "tbl Control Objectives subform". The field I'm looking in this subform is called "control objective". Is it possible to incorporate the "With...

Thanks. I'll give it a go and report back. AL

Hi I've a database of audit jobs. I'm using the code below to create a Word doc from a template and insert text and various bookmarks based on field values in an open form ("frm Recs Tracked Jobs"). Everything works well, but there is additional info in a subform ("Objectives subform") in the...

Hi I am trying to use the following code to open a Word template, insert text based on the field [Job] and then save the document to folder as per the field [docfolder]. Sub msq() Dim MSQname As String MSQname = Forms![frm recs tracked jobs]![docfolder] & "\" & Forms![frm recs tracked...