Search results for query: *

Hi I use the code below to select an email in my inbox and carry out various tasks with it. At present I choose the email I want to work with by "ticking" it as "Complete" and then running the code from a button in a form. The code works by checking each email in turn and using the one with...

Hi I have a form in a project database which contains a list of links in a sub form to various files. The main form also includes a default document folder that project. When inserting hyperlinks the "Insert Hyperlink" dialog box initially displays the folder the database is contained in, which...

Hi I use the following code to select an email from my inbox, save it as a file and create a link to that file in an Access application: If Me.docfolder = "" Then GoTo nofolder Dim ns As Outlook.Namespace Dim sent As Outlook.MAPIFolder Dim temp As Outlook.MAPIFolder Dim I As...

Hi I have an Access 2010 database which uses VBA to select and save emails from my Outlook 2007 inbox as files in a folder. The database also creates and sends emails via Outlook. This works well with my current Outlook 2007 setup but we are currently being upgraded to Office 365. Is it...

Hi I have an Access database which includes code to identify e-mails in Outlook and perform various actions with them. Up to now I've used the Complete flag to identify the e-mail I wish to select: Dim ns As Outlook.Namespace Dim sent As Outlook.MAPIFolder Dim temp As...

Hi I used the code below in Access 2002 to save an Outlook e-mail and any attachments to a specified folder. I recently upgraded to Access 2010 and have found that the part of the code that saves the attachments (in bold below) no longer works. I get an error message Compile error: Method or...

Hi I have a Access 2002 database for the recording of fixtures and scores etc. in a local sports league. I also have a website for this league. I export reports from the Access database into webpages which I then upload onto the site. One of the reports I export includes a hyperlink to a page...

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

Hi My apologies in advance for the length of this post! I use the following code to create e-mails from access. Rem On Error GoTo nofiles Dim strbody As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Dim MailTo As String Dim attnameDR As String rem Dim fso As...

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 I have 2 desktop PC's and a wireless laptop on a home network. One desktop (XP Prof) has a wired connection, the other (Win 98 SE) is connected via a Linksys 11b USB wireless adapter. Each PC has a static IP address assigned with default gateway and DNS servers also manually assigned...

Hi I'm looking a way to save via Access an e-mail received in Outlook to a folder as determined in an open Access form. The code I'm trying is along the lines of: Sub SaveEmail() Dim myOlApp As New Outlook.Application Dim objEmail As Outlook.MailItem set objEmail =...

Hi I'm trying to use VBA (the HyperlinkPart function to be precise)to insert a hyperlink into a hyperlink field in a form. I am trying the following code: Forms![events log]!Link = HyperlinkPart("c:\folder\filename.doc", acAddress) Forms![events log]!Link = HyperlinkPart("file"...

Hi I don't think it is possible to do what I want to do but here goes anyway: I use the following code to create an e-mail from Access: Private Sub DREmail() If IsNull(Forms![form1]![Response Due By]) = True Then GoTo norespdate Rem On Error GoTo nofiles Dim strbody As String Dim...

Hi Just wondering if is there is a VBA command that will automatically close all open forms and reports etc. (including hidden ones), but leaving the main database window open? Thanks 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 have a form "frm Risks" to record and evaluate risks. This form includes 3 subforms in datasheet format: "control subform", "causes subform" and "actions subform". The bulk of the data is in the subforms. I want to be able to duplicate a record including the data in the subforms. (Once...

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