Re: select statement sql

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Martin Walke (martin.walke_at_spamvega.co.uk)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 17:03:49 +0100

Oops - you're right Jeff

"Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
news:eyHMUOCkEHA.2500@TK2MSFTNGP09.phx.gbl...
>
> "Martin Walke" <martin.walke@spamvega.co.uk> wrote in message
> news:%23CAvAAAkEHA.1800@TK2MSFTNGP15.phx.gbl...
>
> > > There's no need for [ ] when accessing fields in a recordset.
> >
> > Just be careful when there's a space in the field name, and if you're
used
> > to doing cross application development i.e. Access and VB
>
> Again, this has nothing to do with the RECORDSET, only the SQL statement
to
> retrieve the records.
>
>

Relevant Pages

  • Re: Looping or Do While statement?
    ... Here are the fields and tables Jeff. ... Order tbl (this is the table that contains the data I need to insert into ... Temp tbl ... For each returned item I need to loop through my recordset of old ...
    (microsoft.public.access.formscoding)
  • Re: Looping or Do While statement?
    ... What else whould you like to know Jeff? ... We will receive a RMA or returns document along with the returned items. ... checked in the system for each item where the ordered qty matches the ... I can move onto the next item in the recordset. ...
    (microsoft.public.access.formscoding)
  • Re: Coding Syntax and Methods?
    ... Although I am looking to iterate thru a complete recordset, ... VBA from a string that makes up a query. ... Jeff; are you suggesting that I actully create the query and use that to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access + Asp + multiuser + table lock
    ... It's hard to tell without knowing the exact error, ... was the recordset is being held open while you perform your ... multiple users. ... Jeff ...
    (microsoft.public.inetserver.asp.db)
  • Re: How walk recset in DAO, do AddNew & return to CurRec B4 AddNew?
    ... Oops. ... well as appending a record to the underlying table. ... I was walking the recordset looking for records whose ... This not only added a record to the underlying table, ...
    (comp.databases.ms-access)