Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. checkOut

    Save Outlook item as *.Msg object

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

    Select Query

    Thanx PH, exactly what I need. Greetz, Gerard
  3. checkOut

    Select Query

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

    Select statement in Recordsource

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

    Select statement in Recordsource

    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 =...
  6. checkOut

    Select statement in Recordsource

    ...Me.lngFabrikant & ") AND " ElseIf Nz(Me.txtFabrikant, "") <> "" Then strWHERE = strWHERE & "(Marktpartij.bedrijfsnaam LIKE " & adhHandleQuotes("*" & _ Me.txtFabrikant & "*") & ") AND " End If If Nz(Me.lngProduct, 0) <> 0 Then strWHERE = strWHERE & "(STALEN_tblProduct.product_ID = "...
  7. checkOut

    Select statement in Recordsource

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

    Select statement in Recordsource

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

    Project administration

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

    Week and Year in query

    Thnx PHV Nice shot! Clear, easy and working
  11. checkOut

    Week and Year in query

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

    Not run Form_current when Form closes

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

    Refresh subforms via Form_Activate is horrible slow

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

    Refresh subforms via Form_Activate is horrible slow

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

    Refresh subforms via Form_Activate is horrible slow

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

    Save Outlook item as *.Msg object

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

    Query the month of January for all years

    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)...
  18. checkOut

    What's wrong with this SQL??

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

    Task with MAPI session is saved as a message

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

    Terminal server opening internet Page

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

Part and Inventory Search

Back
Top