Search results

I have a code which on pressing command button, it opens email and attaches a file from my computer. If it does not find the file, I get a halt error, "cannot find this file". Is there a way to build into the code to continue to sending the email even if the file is not found/attached...

Yes, that's it! Thank you! (I should have known that! ....I just got over 3 days in bed with the flu. I'm blaming my lapse on that!):D

I thought this would be a very basic VBA code. I'm trying to open a report, using a command button, based on a mutual field in the report and on the open form [positionID]. While it does open the report, it is not limiting the report to that specific [positionID]. ---------------------...

Yes, saw that I had the incorrect file name and modified that as well.

Yes, thank you Gasman. I modified with the .pdf extension!

RESOLVED: Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) FileName = Application.CurrentProject.Path & "\RAS Info" DoCmd.OutputTo acReport, "RAS INFO", acFormatPDF, FileName, False FileName2 =...

I'm just looking to attach two reports from my database, not files on my computer. Using my above code, could someone direct me how to attach two database reports? Thanks!

I've probably exceeded my questions for the week, and maybe my brain is just fried (thank goodness its Friday!).... I have the attached code which sends an email from my database via Outlook. Where/how do I go about attaching two reports from my database to the email as pdf files? -------...

Thank you both.

I have created an unbound field in my form. It is to update to a date when a macro runs. It works great, but when I exit the form, the date disappears! :banghead:

I know (now) that I should have not named these fields with a #. However, at this point, I am unable to change it as it is so embedded everywhere in the database. :(

In the form I am trying to open ("Power CoMorbdities") (and add record ("CCMC#") if not already there) - I have this code: Private Sub Form_Current() If Me.NewRecord Then Me.CCMC# = Me.OpenArgs End If End Sub On the command button on the main form, I have: Private Sub...

I am trying to create a command button to open another form, "CoMorbidities" with mutual MRN#. If the MRN# does not already exist in the "Comorbidities" form, I need to add the MRN# to that form/table based on the same MRN# that is on the open form where the command button is. (Me.MRN#)...

That did it! Thanks NauticalGent!

I have a field [HiringMgr] which is auto-populated based on another field. This field is also a drop down field for cases when it doesn’t auto-populate. [HiringMgr] field also has an after-update command to do something else. This command does not “happen” when the field is auto-populated...

Again, thank you all for your continued efforts. Again, this is simply above my scope.. Gasman, not sure where to post that code, after my code End If? It does not recognize "GetBoiler". I thought adding the Outlook signature might be a simple task, obviously not. In a little over my...

Thank you. I will try and incorporate into my code, however, may be a little over my head. :rolleyes:

I have a code to send an email through Outlook looking up emails from a table. Is there a way to include my Outlook signature? ----------- Private Sub Command272_Click() Dim strFileName As String Dim rst As DAO.Recordset Dim strEMailTo As String Set appOutLook =...

For some reason, it would not recognize the rst! prefix. I kept playing with options - tried the Me! prefix as well. (because the code is on a form behind the button). Using Access 2016 - so not sure why it was acting this way.

Actually the additional .To line did work! .To = .To & ";" & [EmployeeEmail] Thank you Gasman! Appreciate your help!