Search results

No problem I am very grateful for your help. Had visual basic error pop saying: Run time 91, object variable or with block variable not set Then error on this code? Public Sub CreateEmailWithOutlook( _ MessageTo As String, _ MessageCC As String, _ Subject As String, _ MessageBody As String)...

Ok thanks have renamed it ModUtility which makes sense. Now have error on cmd button code in yellow? Private Sub Command181_Click() Dim strDocName As String Dim strPath As String strDocName = "Report" ' save report to myDocument strPath = SpecialFolderPath("MyDocuments") & "\" If...

Ok couple of things, Does it matter what I call the module? When I run this the follow code appears as red error: Thanks Option Compare Database Public Sub CreateEmailWithOutlook( _ MessageTo As String, _ MessageCC As String Subject As String, _ MessageBody As String) '...

Arnelgp Thanks very much great response time too, so so helpful, worked great Is it possible to send that email in silence i.e use the .send code somehow? So I dont need to keep pressing send within Outlook. Thanks

Hi I have a form called: frmNewWork and a table tblNewWork which I use to create new jobs for then email the report to the relevant team member. At the moment the Cmd has a fixed email address in which I type in the new email address I wish to send to. On my form I have a drop down list with...

RuralGuy Hi Well I am relative beginner so still spending a lot of my time trying to learn to read the code that others have either publised or helped me with, and then adapt and try adding small pieces of extra code myself. I often get confused because some code I seem to be able to duplicate...

Hi Guys This one ive been struggling with for ages. I use the following code to check for dates within 30 days of today for some Fire Certificates from a table called: tblTenancies. This code works fine but I want it to also check the dates in a second field called: GasCheck and obvisously...

Thanks for that HiTechCoach worked perfect and makes total sense now to test if a file exists first in the code.

Hello No my db is not a web app. In simple terms I have a copy of the db local on a few different machines but have my tables stored in Sharepoint so data is always saved securely and shared by any user. I have a business One Drive Account which ive created as a mapped netword drive labelled...

Thanks Yes I have already been reading many posts but as a beginner struggling to stay on track. Ive used the code Application.FollowHyperlink for example to open open files etc but Im not sure how I get the code to look for the specific path of each different record within the table. My...

Thanks OK heres the problem I am having work great if I set the field to a Hyperlink the problem is I share the table information on Sharepoint. For some reason sharepoint wont let me upload table with the hyperlink fields in. Is there anyway I can keep field as Short Text with the path stored...

Hi Guys Advice on how best to display a link to a PDF file or image from a form. I have a table which contains information about safety records. Within the table I have a field called: GasCheck. This field contains the file path to a scanned copy of a Gas Safety Certificate or PDF document...

Is this possible. When txtone displays no text (for example when the main form first loads its blank.) That neither command button is displayed? Thanks

Thanks so much So simple but couldn't see wood for trees. Thanks again

Hi Everyone Ok so I have been trying to get this code to work for ages but as a beginner keep getting lost. I have a form that depending what is in a specific field will display a specific command button to another form. I have read through and downloaded some of the following code I have a...

and where should i be placing all this could on the Cmd button? thanks

Thanks Sorry my knowledge isn't great with code as Im still learning, so im completely lost on what code to here. For my own interest could you explain why we have to create a temp copy, is it not possible to create a piece of code that emails whichever record I have open within the form but...

Thanks We issue a lot of invoices daily so just want to send copy of the invoice directly from the Invoice form, we also share our Tables through sharepoint to allow us to access our database from various sites. I prefer my reports to be stored within the database and then just email whichever...

Hi I currently send a copy of an Invoice report using the following code that all works fine: Private Sub Command81_Click() Dim stDocName As String stDocName = "ReportInvoice" DoCmd.OpenReport stDocName, acPreview, , "[ID] = " & Me.ID DoCmd.SendObject acSendReport, "RptInvoice"...

Ok update I noticed a piece of code hadn't been copied across The code now runs when I open the form but its only alerting me to dates due within 30 days from the NextCheckA field from the table and not looking at the NextCheck field any advice? Thanks Here is the updated code: Private Sub...