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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Expression Size Limits
I know this isn't a VBA problem or question, but any help would be greatly appreciated. I'm trying to build a query expression that has nested IIf's. The help says that it's limited to 1024 characters. Once my query expression exceeds 512 characters and I try to save it, I get a message...- codedog
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Size limits for query expressions
I'm trying to build a query expression that has nested IIf's. The help says that it's limited to 1024 characters. Once my query expression exceeds 512 characters and I try to save it, I get a message about an incomplete IIf. Then when I zoom on the expression, it gets truncated by this...- codedog
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Oracle Connection
This is probably a dumb question, but I'm new to VB, MS Access 2000 and Oracle 8i. I am working on an application that uses an Oracle database on a server with Access forms used as the front end and VBA as the programming. If I have the acronyms right, we're going ODBC with ADO controls. I...- codedog
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
