Recent content by Soundje

Thanks for the feedback, Database structure contractID Datum Weight 2018 01/01/2015 45 2018 01/01/2015 50 2019 01/01/2015 49 2019 05/01/2015 17 2018 06/01/2015 28 2020 05/01/2015...

Hello I am wondering if anybody could help me on finishing this code/query or tell me what is wrong? ' count records in query Dim rs As DAO.Recordset Dim db As Database Dim strSQL As String Dim beginDatum As String Dim eindDatum As String Set db = CurrentDb...

Thanks a lot that worked fines for me.. Again many thanks, Koen

Thanks a lot Plog for this, I am almost there but do not need to know the how many time each value is in the table. I need to know how many entries there are in the table of the unique field so one number this is the query that I have tried: SELECT tbl_data_leverancier.ContractID, COUNT...

Hello everybody, Can anybody help with this... I have the following code: Dim rs As DAO.Recordset Dim db As Database Dim strSQL As String Set db = CurrentDb strSQL = "SELECT DISTINCT tbl_contract_lev.ContractID FROM (tbl_leverancier_gegevens INNER JOIN tbl_contract_lev...

Hello, I have tried myself some things: I am able to create the report based on the correct query all information is in one report (see attachment knipsel.jpg) I marked the lines in yellow these are the header, what I want is to have for "each" header a new report that includs each time the...

See attachment for the relations, Thanks Koen

The multiple records for contractID are handled as LineItems within the same invoice.. I have included inthe attachment some screenshot for the reports that I am currently already using, this is already working fine, The thing that I still need to find a solution for this the automatic printing...

Hello jdraw, First of all my excuses for the delayed answer but due to end of the year holidays i was not able to answer earlier.. I have my query ready as much as possible; here is already a extraction of it;see attachment.. just some more informations: I want to have a report (invoice) for...

Hello, I want to print mulitple reports with different content based on a query. It is like printing invoices of different customers based on a date selection at once/ automated Current I have it working so that I have to select 1 customer at the time... Any ideas who I should be...

Thanks for the tip, Now I am getting the error 2293 The message can not be send from XXX

When I execute it I am getting following error: Error 2487 while executing: The argument ObejectType for the action of the method is blanc or invalid and then it highlight this line in the code: DoCmd.SendObject acSendReport, rap_factuur_klant_pdf, acFormatPDF, sAddr, , , sSubj, "BLA...

Hello everybody, Can any help me what I am doing wrong; i am trying to send a email with a pdf-report attached based on a report (rap_factuur_klant_pdf). I am using MS Access 2007 and Outlook 2007.. Dim sAddr As String, sSubj As String, sFor As String Again: sAddr = InputBox("E-mail...

Thanks a lot everybody.. I used the "double" and that one resolved my issue.. Once more thanks for all tips..

Hello i wondering if anybody could help me with this "simple" question: I need to declare a variable (max_nog_leveren ) but that variable may not be rouded or only after 5 digits so as example 15,xxxxx I am now using it as a "Integer" but that is not working very well.. Can you help...