Recent content by checkOut

anyone knows a solution for this? Many thanx in advance, Gerard

Thanx PH, exactly what I need. Greetz, Gerard

Hi to all, I have problems with the following query: SELECT DISTINCT PROJECT.leadnummer, IIf([offstatusRef] In (2,3,5),"B","A") AS LeadStatus FROM PROJECT LEFT JOIN OFFERTE ON PROJECT.leadnummer = OFFERTE.projectnaam WHERE (((PROJECT.blnDelete)=False)); This give a output of 2 columns; 1...

Thanx, it works. Strange but when I dim cPrijs1 as currency, cPrijs2 as currency it doesn't work. When I give no property, thus dim cPrijs1, cPrijs2 everything do correct! Anyway: Thanx! Greetz, Gerard

SELECT STALEN_tblProduct.product_ID, STALEN_tblProduct.pr_beschrijving AS Product, STALEN_tblProduct.MP_Id, MARKTPARTIJ.bedrijfsnaam AS Fabrikant, STALEN_tblProduct.Staal_Prijs, STALEN_tblProduct.blnDelete FROM STALEN_tblProduct INNER JOIN MARKTPARTIJ ON STALEN_tblProduct.MP_Id =...

Yes, I set the code below: Private Function setZoekSql() As String Dim tmpSQL As String, strWHERE As String tmpSQL = "SELECT STALEN_tblProduct.product_ID, STALEN_tblProduct.pr_beschrijving " & _ "AS Product, STALEN_tblProduct.MP_Id, MARKTPARTIJ.bedrijfsnaam AS Fabrikant, " & _...

Thanx PHV for your reacion, that was what I try. But the value is coming from a field: Prijs1 (Currency;euro) I can't format that field to ##0.00, if you can help me that way, its very useful!! Thanx in advance, Gerard

The sql-statement below drives me crazy, i can't found what's wrong in it. Prijs1 (10,3) is from a currency (euro) field on a form SELECT STALEN_tblProduct.product_ID, STALEN_tblProduct.pr_beschrijving AS Product, STALEN_tblProduct.MP_Id, MARKTPARTIJ.bedrijfsnaam AS Fabrikant...

I searched on the net for an free application. I can modify it a bit. Easy structure: Project, Client, Orders, Products. I need to put orders on a project and print that orders. Has anyone such an application for me or knows a location to find it? Thanx in advance, Gerard

Thnx PHV Nice shot! Clear, easy and working

What is the best way to restrict a period in a query. f.e. : week 34, 2003 t/m week 3, 2004. 3 fields: dteFact, descFact, currFact. I understand to set wk as datepart("ww";dteFact) and yr to datepart("yyyy";dteFact) but how can I restrict the period? Thanx in advance Gerard

How can I prevent a form to run the Form_Current event when I want to close the form. I have a form that most of the time is invisible/visible instead of closed but one moment I need to close the form but in this case I not want to run the Form_Current (much things are checked that moment and...

Thanx for your tip Hennie, I knew it decrease the speed, but my results after deselect the option is not much better. Do you have more tips? Maybe only the FORM_Activate is false Is there a faster way to upgrade the refreshing of the subpages? Greetz, Gerard

THanx for your Reply PH, Do you have good information documentation for me about indexes. I'm ashamed, but I never use them before.. Greetz Gerard

I have several forms with 3 or 4 subforms. Now I want to have the data in the subforms uptodate when the form is active. Now I choose to requery all the subforms in Form_Activate, but this is so slow that I can't believe there's a better way to do this. Have anyone suggestions to upgrade the...