[AccessD] brain farts

Hey, have you looked at the LWS stuff?  It's starting to get exciting.  I
have a video database up as a demo, with the LWS forms residing out in the
LWS MDA and getting their data out of the video database using a syntax
like:

    strSQL = "SELECT [usystblLWSGroup].[LWSG_ID],
[usystblLWSGroup].[LWSG_Name] FROM usystblLWSGroup in '" &
CurrentProject.Path & "\" & CurrentProject.Name & "' ORDER BY
[usystblLWSGroup].[LWSG_Name]; "
    Me.RecordSource = strSQL

Notice the

FROM usystblLWSGroup in '" & CurrentProject.Path & "\" & CurrentProject.Name
& "'

Cool stuff, allowing me to keep the forms themselves in the MDA and yet load
the data from the FE.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael R
Mattys
Sent: Thursday, October 30, 2003 12:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] brain farts


By the way,

bAnd, bOr, bXOR, etc are all reserved words
in Jet 4 and, although I haven't used them, the word
is that you can use them in queries for joins as long
as you are willing to give up the QBE Grid.

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com