Re: Refer to the first row of the table

Thank you very much indeed ! Ig was a great help !


Dirk Goldgar wrote:
Thank you so much indeed ! Your line of code which i think is very
clever, gives me a syntax error and i must have written something
[quoted text clipped - 9 lines]

End Function

You've left off one of the parentheses I had in my original SQL
statement. Try this:

StrSQL = _
"DELETE * FROM TblClients1 WHERE afid > " & _
"(SELECT Min(T.afid) FROM TblClients1 As T)"

Also, don't name your function "str". There's a VBA function named
"Str", and giving your function the same name will interfere with its
use.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200708/1

.

Relevant Pages

  • Re: Refer to the first row of the table
    ... Syntax error in query expression 'afid>SELECT MinFROM ... Dim StrSQL As String ... FROM TblClients1 As T)" ... don't name your function "str". ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to define the assignment operator in Ruby ?
    ... :16: syntax error, unexpected kEND, expecting $end from:16 ... the default clone and dup methods perform ... attr_accessor:str ...
    (comp.lang.ruby)
  • Re: iterating over two sequences at once
    ... Dan wrote: ... > for c in str: ... I would be very surprised if there isn't another clever ...
    (comp.lang.python)
  • Re: datatable.compute
    ... I am getting a Syntax error in the compute method of a datatable. ... SUM the qty field based on a ... filter expression and the expression contains 3 fields. ... TotalPickQty = Convert.ToInt32", str)) ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: A Unicode problem -HELP
    ... The problem is your usage of str() to "render" the output. ... i.e. an ASCII byte string ... Then you don't have to drop the parentheses from a anymore, ... print "GLOSS IS", repr ...
    (comp.lang.python)