Check List in VBA
in [General]
|
Prev: vertragen
Next: access 2007 add contacts from outlook
From: Tom Wickerath AOS168b AT comcast DOT on 24 Jan 2010 15:16 Thanks John. I've never bumped up against this limit, so I was not aware of it. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ __________________________________________ "John Spencer" wrote: > In Access 2003 I was allowed 24 before I got an error message about too many > line continuations. There is also a line length restriction - which I don't > recall at this time. > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County
From: Larry Linson on 24 Jan 2010 16:11 "John Spencer" <spencer(a)chpdm.edu> wrote > In Access 2003 I was allowed 24 before I got > an error message about too many line continuations. > There is also a line length restriction - which I don't > recall at this time. I'm sure the line length maximum is available, but I tried searching and was unable to find it. Googling for "Visual Basic for Applications" returns a download link for the [MS-VBAL].pdf , the VBA Language Specification. It says that an implementation may impose a length restriction. (When I went to http://downloads.microsoft.com, I could not locate the language spec download on that site, but it downloaded OK from the Google link.) IIRC, in the past that length limit was 255. It may have been extended in recent versions. Larry Linson Microsoft Office Access MVP
From: alex on 24 Jan 2010 18:59
On Jan 24, 4:11 pm, "Larry Linson" <boun...(a)localhost.not> wrote: > "John Spencer" <spen...(a)chpdm.edu> wrote > > > In Access 2003 I was allowed 24 before I got > > an error message about too many line continuations. > > There is also a line length restriction - which I don't > > recall at this time. > > I'm sure the line length maximum is available, but I tried searching and was > unable to find it. Googling for "Visual Basic for Applications" returns a > download link for the [MS-VBAL].pdf , the VBA Language Specification. It > says that an implementation may impose a length restriction. (When I went > tohttp://downloads.microsoft.com, I could not locate the language spec > download on that site, but it downloaded OK from the Google link.) > > IIRC, in the past that length limit was 255. It may have been extended in > recent versions. > > Larry Linson > Microsoft Office Access MVP I was able to put about 60 or so user ids in a horizontal fashion...looks tough to manage though. I hear you about keeping data in a table, Tom! alex |