Search results

I want to thank you Paul and dave for helping me out. I've got a working module wich I will post when I cleaned up the code. I got a workaround for the parameter issue and for me It's working perfect. Thanks again and perhaps till some other time. Jaap

Oke Paul, Everything is working super right now. There is one thing on my mind. Would it be possible to ask for a time period for query "DigitaalFactureren" let's say the code asks for Which time period? Answer will be for example march 2014. And the query displays only the records of march...

Oke Paul, I´m allmost there. Just one problem. I´m testing with two customers/invoices. When nr1 mailadress is empty I get two same reports. When nr2 is empty it´s working allright, could this be the place of the End If. Myself am just reading and can't test it so that's why i'm asking instead...

Paul, For one or another reason it's working like a charm now. Don't now why. But still I want to select a printer. Would this be possible? Thanks a lot allready, Jaap

Paul thanks for your reply, It's working perfect but two things. Is it possible to choose a printer and would it be possible to store the report by docmd.output anyway no matter if it is printed or send by mail. Thanks in advance Jaap

I've uncomment some lines now. It's sending the mails with the correct attachments to the correct mailadresses. Now I stil want to build in the decision to mail it or to print it, based on if there is a mailadress available or not. Is this possible? My code now it looks like this Public...

I'm still working on this issue. What I got working right now is the following. It stores the split up report in the right folder as .pdf. What I want right now is to print or mail it I want the code to decide this based on if there is a mailadress or not. Wouls this be possible(get the...

Dave the more I look at your suggestions the more I like it. I think however that I can't come to the solution all by myself. Let's say I have a table which holds: Customer_ID, Invoicemonth, Invoice_date and Invoice_number. The two last columns are empty till the day I want to print/email the...

Paul, When I implement the code you suggested to open the report I get 'invalid use of keyword Me". What am I doing wrong? Jaap

Paul, I tried to change a code I was allready using for a newsletter. Actueally it's a code from Jephens. I try to make this do my invoicing. Right now it opens the complete report and(offcourse) it didn't attach them allready(this will be the next step). Is it possible to filter the specific...

Paul I've tried some more right now. The asking for the Invoice_ID was something in my report which I've changed. The effect from that change is that I get a 3464 error. What I've asked in my last reply about 2007 or 2010 is related to the Send method for mail is this possible in 2007 or do I...

No I don't have a smtp there, but first I want to ask is this also for access 2007 or just 2010? The created pdf.1 is a report with 3 pages where I want a 1.pdf, 2.pdf and 3.pdf But why does de module ask me for Invoice_ID and VARBOrder.Invoice_ID? Thanks Jaap

Oke Paul this is what I've tried: Private Sub MakeReportSendEmail_Click() Dim MyDB As DAO.Database Dim MyRS As DAO.Recordset Dim strSQL As String Dim strRptName As String Dim count As Integer Dim strFilter As String Dim imsg As Object Dim iconf As Object Dim flds As Object Dim schema As...

Allright Paul, Thanks for your quick reply. Then another question. I'm still not able to reproduce the next part to my own situation. DoCmd.OpenReport strRptName, acViewPreview, , "[TableWithNames].Name='" & ![Name] & "'" DoCmd.OutputTo acOutputReport, strDocName, acFormatPDF, "C:\Pdfs\" &...

Hello joaolabisa, Good this worked out for you so well. Now this is where i'm really looking for but I think I have some questions. I want to start with this one: You have the following line: strSQL = "SELECT * FROM MyQueryNameEmail ORDER BY Name" Where does the * stands for? Hope you will...

I told in my introducing on this forum that i'm looking for more functionality in my own made DB. What i really would like is this but i dont know if it is possible. In my DB i make Invoices every first of the month. I do the numbering of the invoices by hand and when i click the button...

Hello I'm a grower of plants from the west of the Netherlands. I build my own DB with access allready years ago. With this DB i do my invoicing, CRM, stockreports. Now I'm trying to get more functionality. I make a mailmerge system working for a newsletter, but I'm looking for more.