Re: DateCreated

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rob Kings (greeneggsandham_at_greymouse.co.uk)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 19:04:21 -0000

Al

Well I tried that, and then for good measure I tried cutting the SQL right
down to

    sSQL = "select IDNAM from Identity"

and it still doesn't work.

Rob

> My gut feeling is if you change vbCR to vbCRLF or vbNewLine it will
> work. I will see if I can knock something together to prove it.

Relevant Pages

  • Re: DateCreated
    ... and then for good measure I tried cutting the SQL right ... I posted a follow-up. ... I will see if I can knock something together to prove it. ...
    (microsoft.public.vb.database.ado)
  • Re: missing the basics
    ... I haven't done with the Command Box and I ... I'm curious as to how Rob would define parameters in the Command Box (an ... We almost always need to pass SQL ... >> tried entering a parameter with a manual SQL statement. ...
    (microsoft.public.vb.crystal)
  • Re: missing the basics
    ... I'm interested in hearing more about what Rob said re defining ... I haven't done with the Command Box and I ... > totally different than doing a manual SQL statement as I describe on page ... We almost always need to pass SQL ...
    (microsoft.public.vb.crystal)
  • Re: Listbox Scroll behaviour ?
    ... I'm sorry Rob but I only have acXP. ... active in the form of a SQL that I use for the listbox.rowsource. ... it will be called each time the user sets focus to the control. ... HTH - RuralGuy acXP WinXP Pro ...
    (microsoft.public.access.forms)
  • Re: Dynamic Send Port
    ... Rob hi, ... another option would be incorporate the logic in the transformation process ... > and have each one send the message to different SQL ...
    (microsoft.public.biztalk.general)