Record Source-Length of SQL Statement

[Chrisbi]

I have a form created in 2002 Access to be run on Access 2000 (I set to 2000 file format). Forms runs fine on XP computer but first time I oepn the form on 2000 machine, the record source sql on the form is truncated & form can't run. This is a pretty complicated form pulling data from a number of tables. Is there a limit on lenght of statemen in 2000 but not in 2002? (Row Source set in properties in form, not in vba code).

 

[Wocca]

Do you have the actual SQL as the form's record source?

If so you can have the code in a (saved) query & use the query as the record source.

Hope this helps.

Regards
Warwick

 

[Chrisbi]

I will try that approach... I'm still curious though about why sql statement was truncated as I have other complex forms & will need to take this little quirk into consideration...

Many thanks.

 

[MakeItSo]

If you reach "String" variable limitations, you can also split your SQL into three parts:

Dim SelClause as String, FrmClause as String, WhrClause as String

assign the statement parts to these strings (don't forget a trailing or leading space) and then

Set rs=CurrentDB.OpenRecordset (SelClause & FrmClause & WhrClause, dbOpenDynaset)

Or however you process the sql...

Regards,
MakeItSO

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos