Recent content by Robbie1974

I have the following list: What i want to archieve is to exclude the records that have a DC* value in Document No_, but also the other records with the same Item No_. Is this possible? I tried with a total query but cannot archieve what i want. Do i need VBA to archieve this? Posting Date...

I'm trying to populate the captions from the buttons on my form with names from my table. I have a table captions with the field names. I have a form with 30 buttons not visible. All have the same caption button0. This is the code I have so far: Dim DB As DAO.Database, rst As DAO.Recordset...

Problem solved Thanks

I'm having trouble with some calculations on my form. It's a form for making quotes. All the articles in the database have quantity discounts and there is sometimes an extra customer discount on top of that. For example: if a customer buys 1 pack of paper he pays $4.36 if he buys 10 packs he...

I have a table with the numbers formatted as example 9999,99. My mysql database i'm exporting to uses the point as decimal sign. Can I change my query so it outputs the decimal sign as point instaed of a comma? In my international setting decimal is a comma and should stay a comma. Thanks

Works perfect. Thanks for your help. I had made a solution in excel, but it was too slow. You're the best, thanks

Anyone an idea, please?

I have a table with the following fields: productid productdescription It is filled like this: productid productdescription AAA1123002 Papierklemmer AAA1123002 Papierklemmer AAA1123002 SMILE / SMILEY / PAPIERKLEM AAA20014 Printrollen houtvrij 60g/m² rollengte 44m wit (50) AAA20014...