Search results

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

Hi I have a routine which creates a data access page from a form, the objective being to allow external users to enter data. I have found that the DAP created will allow data already entered to be amended, but will not allow data to be entered in blank fields. Is there any way round this...

Hi Got it sorted. Used the following calculated field in the code: HyperlinkPart([document folder],1) AL

Hi I use the routine below to create and save a snapshot file of a report ("rep recommendations"). The file location is determined by the path name entered in [Document folder] in the form [frm recommendations]. The name of the file is determined by the value in [job] on the same form. Sub...

I have a form with a OLE field. I want to be able to run a macro which inserts a particular jpg file (a scan of my signature) into the field and show the picture rather than the filename. I tried the following code but it gives the error message "Invalid use of Null" Sub copysig_click() Dim...

Hi I have a open form which I want to save as a data access page. I appreciate I can use "File" "Save as" , choose "Data Access Page" etc, but I wanting to automate the proces and go directly to the file location dialog if possible. I found the following code: DoCmd.RunCommand...