Search results for query: *

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

Code below I find on the forum here, I rewrite a bit and use the code often for sending email without outlook. But now I need a way to save the send message as object in a mapping like C:\Project\subj_110303.msg Anyone has an idea? Thanx in advance, Gerard Public Function fctnOutlook1(Optional...

You need something like SELECT install_date, service_date, DatePart("m";installdate), DatePart("m";service_date) FROM tblDate WHERE iif(isnull(install_date),service_date = Date,install_date = Date) AND SELECT install_date, service_date, DatePart("m";installdate), DatePart("m";service_date)...

After inserting the Iif Function, the code doesn't work. So I think the error is in there, Maybe an IIF function doesn't work in SQL? Any help appreciated. Gerard ------------------------------------------- SELECT tbl_ControleOnderaannemers.RegelID, tbl_ControleOnderaannemers.MPRef...

The code below saves the item in the task folder from outlook but it's just a message and not a task! Do anyone know what's wrong with this code? Public Function fctnOutlookTask() Dim objTask As MAPI.Message 'All item types are called Messages in CDO Dim objTasks As MAPI.Messages Dim...

Hi all! I've a tricky question. My client uses Term server only for the several Access Applications we've build. Internet is restricted in the Term server so we can't use it. Now we have a field that contains the www from our partners e.g. Is it possible to send the user outside the client to...