Re: SQL Query in VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
Date: Tue, 12 Apr 2005 10:25:16 -0700

=?Utf-8?B?Smlt?= <Jim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in news:1AFDCD7C-
C55E-4D8E-B57A-E76FEA107CF2@xxxxxxxxxxxxx:

> eventholder = DoCmd.RunSQL("select max([event id]) from events")
> Forms![LogIn]![ActiveEventID] = eventholder
>

Forms!Login!ActiveEventID = DLookup("Max([Event ID])", "Events", "")

You could also use

DMax("[Event ID]", "Events")

Hope that helps

Tim F

.

References:
- SQL Query in VBA
  - From: Jim

Prev by Date: Re: Copy Record With VBA (Access 2000)
Next by Date: Invalid Argument
Previous by thread: Re: SQL Query in VBA
Next by thread: SQL Query in VBA
Index(es):
- Date
- Thread