Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum length on Where Statement in VBA 1

Status
Not open for further replies.
TimTDP

TimTDP

Technical User
Feb 15, 2004
373
ZA
In Access 2000, I filter report records using the following VBA code:
DoCmd.OpenReport strReportName, optReportOutput, , Wclause

Wclause is dimensioned as a string.

What is the maximum allowable length of the string I can use for Wclause?
 
Sort by date Sort by votes

My F1 key when cursor is inside OpenReport word, reveals the help on that issue, where you can find the limit of interest to be greater than the Where Condition action argument in the Macro window

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
535
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
489
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
373
TheAceMan1
TheAceMan1
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
431
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top