Search results

Thanks, but was thinking something less complicated..:confused:

Hi, I always have the same problem getting started with a new database. I created a few, level is beginner, but with reading a lot, I managed to make a customer database. Now I need a very simple invoice system. No customers included, just some articles, a variable taxrate (2 values) buying...

I have an invoice, where user can fill a few lines like quantity, description, price. Of course there is only one total How do I get all the lines with descriptions etc, copied to the summary file? I have a piece of working code, but this only copies the lines which is most down. (I transfer the...

It looks like this does the trick! Thanks man !! :D

I feel terrible, but when I run the query on the complete table, I stil see addresses appear twice, have no clue why... Maybe another approach: Klnr should only appear once I will edit more data in the table and repost it if that is oke with you. Will test run it before posting :-) Thanks...

This is the query result you posted earlier?? When I look in the table, Klnr 10, 14 and 15 appear twice (same adres and huisnr) and need to be filtered as this picture shows.. Weird.. Can you post the db back or the query you used here? Maybe I did something wrong..

Ok I attached a slighly modified db. Still enough data in for testing purposes. Thanks for your time and patience :-)

Hi JHB, Thanks for your response, but when I run the query to the real table, I still get (altough less then before) duplicate fields for the Adres en Huisnr fields. So we're almost there, I guess.. :-) The combined data of Adres & huisnr need to appear once, no matter what the other fields...

Just a Clientnumber. For example a husband and wife get the same number. I'm creating a directory, named with this number where the documents are stored. Still, every record has its own KLID, which is the PK.

Isn't there anither way? I'm not to happy about creating another table, how would I keep this up to date with the Klanten table? And which fields should be in the Klnrs table? Thanks for support!

Oke some sample data and desired result. Hope it makes sense :-) Klnr|Voorl|Tussenvoegsel|Naam|Adres|Huisnr|Postcode|Woonplaats 012|M.|van|Geest|Pentur|12|1166 PW|City B 013|M.F.||Rosheuvel|Wesselstraat|123|1611 RM|City A 014|A.||Giesen|Distelstraat|56|1317 LP|City A...

Hi all, I can't get my Query right. :banghead: I only want unique address records. With this query I still get the same address multiple times. SELECT DISTINCT ([Klanten.Adres] & " " & [Klanten.Huisnr]) AS Adres1, Klanten.Voorl, Klanten.Naam, Klanten.Postcode, Klanten.Woonplaats FROM Klanten...

Yep, spreadsheet is ok..

Yes, this has worked for quite some time. The error says that the Excel file is not in the right format.. I also tried other acSpreadsheetTypeExcel types but all gave error.. Got no clue how to proceed..

Hi all, Got a problem with a office 2007 user. The database which holds this code, is used by different people using different Office versions.. (yes, I know...) Anyone knows how to solve the problem? The error is referring to the acSpreadsheetTypeExcel3 part. Private Sub...

Oke Big Booty :-) Going to try this later this evening. Thanks for replying.

Yes have tried both, but I can't get it right. This is what I have which isnt'working UPDATE Facturen, projecten INNER JOIN registratie ON projecten.projectid = registratie.projectid SET registratie.factuurnr = [Facturen].[Factuurnummer] WHERE...

Hi, I have this query which in facts Concatenate a Bill number (factuurnummer) I want to save this value for later reference, but how to get the value (Factuurnummer) into my table (registratie.factuurnr)? This is the query that produces the Billing number: SELECT Year([datum]) AS jaar...

myperiodeveld = DLookup("[Periode_naam]", "Periode", "[registratie].[datum]" Between (#" & [periode].[periode_startdatum] &"# .AND. #" & [periode].[periode_einddatum] & "#))Isn't woking either. Let me try to clearify what I'm doing... Table Periode has 4 columns Id | Periode_naam |...

Hi, Got this attempt to update a field in table "registration" on the fly.. myperiodeveld = DLookup("[Periode_naam]", "Periode", "[registratie].[datum]" Between "[periode].[periode_startdatum]" AND "[periode].[periode_einddatum]") Me.txtImport = myperiodeveld Me.txtImport.RequeryKeeps giving...