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

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

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

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

Hi I want to save an open form as a data access page. Is there any code to do this and bring me directly to the file location dialog or do I have to use the DoCmd.RunCommand acCmdSaveAs command and then choose data access page from the dialog box? Also, is there a way of saving a form as a...

Hi I am trying to change the data source of a form via code. The form I which to change is called "template" and the query name I wish to change the data source to is the same as the value in a field in a visible form i.e. Forms![frm Recs tracked jobs]![Job]. (A query of that name was created...