Search results

I've added the "Automation" function to a module. My problem is not knowing where to call the module "Email" from within Private Sub. I presume I have to replace the "DoCmd.SendObject" part, just not sure at all on how to do this. I'm probably barking up the wrong tree.... Private Sub...

ok, I'm stumped :( my homework hasn't worked, I've play around with this and a couple of other snippets found, I sort of get it but just can't work it out. I've read that I can't call that function from within the Private Sub. not sure where to start now!

thanks Cj, I'll try that.

not a problem Gina, I really appreciate your assistance. It made me think about it, no just copy and paste :) I'll give your new code a try tonight. thanks again.

that worked almost, thank you. What it doesn't do is create individual emails like the previous code I provided which splits the main report into a single user report and saves to a directory. Below is the code you gave me the link to which is creating one email and one report, it puts all...

hi all, I'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open. can anyone shed light on code required to do this please? Private Sub btnDetail_Click() DoCmd.OpenForm "fJob", , , , , , Me.Name...

hi All, newbie needing some help please? I found the vba to generate multiple pdf's from a single report which is working well (see below). The script below generates about 15 pdf files and stores them in the specified directory I'd like to be able to now email these to the individual users...

Hi All, this code below worked a treat for us. Now they want me to email each PDF to each person, is this possible? SCName = person SCEmail = email address Private Sub cmdSC2PDF_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT DISTINCT [SCName] FROM [Schedule];"...

I get the impression Macros aren't popular here!

Did the above make more sense?

Hi namliam, irgore my comments, I switched to Option 3 on Join Properties and its returning the values I want. thanks

Hi namliam, that worked a treat, thank you. after a few video's I'm off and running. However, I'm still getting #Error where no values OrderDetails exist. I tried the Nz function without any luck. please see if the SQL below helps. thank you SELECT tblOrder.OrderID...

I've attached a screenshoot which shows the ProjectDetails subform, the arrow is indicating the field, PrimaryStakeHoldercbo the combo above that is the the problem - CompanyIDcbo in CompanyIDcbo I've set the Event AfterUpdate to requery PrimaryStakeHoldercbo in PrimaryStakeHolder I...

thank you for the feedback, points taken. I'll research your response "make a left outer join with your orders and do a group by-sum query" as that is still beyond my comprehension.

I've got a subform that has a filtered combo box based on another combo box and are getting a parameter error on loading the form through the Navigation Form. Main Form = ProjectMain SubForm = ProjectDetails Combo Box = CompanyIDcbo I've tried the below combinations to get it to work but no...

I've got this currently where I'm summing multiple orders for an project ProductSubtotal: Round(CCur(DSum("[TotalOrderDetail]","OrderDetailsQuery","[OrderID] =" & [OrderID])),2) my problem is if an [OrderID] doesn't exist, then the Nz function still won't work for me and returns #ERROR I'm...

I've got a Navigation Form set up and are looking to requery the subtotal of one of the forms AFTER I have added data to a subform within it. (Image zipped) The subform requery's the totals ok when I add a product, just can't seam to get the form to requery without having to put focus on the...

New to Access I've done a lot of searching before posting, but aren't searching on the right terms I guess. I've got basic relationships established on tables which works in most cases. My concern is when I build a query those relationships are established in design view. The information...