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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
String length problem
I'm attaching the code per your request -- it's pretty hideous, and I'm sorry for that. Formatting makes more sense in the Module editor. Cost_Item table has a FK from Person. Note that my problem here is that I'm trying to create an entirely parameter-driven function to get the same values...- jlh4u
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
String length problem
There's probably an easy answer for this, but I'm stuck. I'm compiling a big string to execute as SQL in an OpenRecordset, and for some reason the string won't grow any longer that 255 bytes. I'm using Access97 and the help tells me I should have at least 64k bytes to use. My declaration is...- jlh4u
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
