Search results

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

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

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

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

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

Hi, I have this Query: SELECT periode.Periode FROM periode WHERE ((([Forms]![Urenregistratie]![datum]) Between [periode].[periode_startdatum] And [periode].[periode_einddatum]));This will give me the correct value if the Form Urenregistratie is open in the background. What I want is to present...

Hi, I'm trying to create a db to write labour hours on certain projects. Those project belong to a client. Labour hours are hired men who need to write the hours spend on the project doing specific work All this is defined in the tables and when I look in the table client, a + sign represent the...

Hi, I have this query in VBA: SELECT CInt(Count([id])/2+1) AS Aantal FROM Wedstrijd WHERE (((Year([Datum]))=Year(Now())) AND ((Wedstrijd.Datum)<=Now())); Now the problem is that in case the outcome of Count([id])/2 is 6,5 Access seems to round this up to 7 +1 makes the final outcome 8...