Search results

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...

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 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...

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...

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...

Hello everybody, I wondering could give me some guidences on how to print mutiple "invoice-records" I want to print multiple times the same report but with different values ex. invoices (based on a query). I have the report and the queries ready but how can I automate this task? Thanks...

Hello, Anybody still awake for a stuppid/ easy question ? I wondering how I can use this INSERT query to insert the value of max_hoeveelheid_contract into the "AS Expr7" part (end of the strQuery) Dim max_hoeveelheid_contract As String max_hoeveelheid_contract =...

Hello everybody, I looking for a simple trick to refresh the data in a subform in vba code? any ideas? thanks a lot, Koen

Hello There, I am looking for some help or advice with the following use: Dim strQuery As String strQuery = "SELECT DISTINCTROW tbl_data_leverancier.ContractID, Sum(tbl_data_leverancier.[Hoeveelheid Bruto]) AS [Som Van Hoeveelheid Bruto] FROM tbl_data_leverancier GROUP BY...

Hello there, I'm not a programmer, just have written some Access databases for some small local businesses and probarly will need some helps in the futures :-) Kindly regards, Koen