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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
RECORD SOURCE PROPERTY LENGTH
Hello, I am changing the recordsource on a subform programatically with various SQL statements. One of my particularly large SQL is not working and giving back the error 'the setting for this property is too long'. The length of the SQL statement is 2155 characters. Does anybody know how to...- turns20
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
COM Objects
Hi, I have just taken over responsibility for mainting a website that somebody else built and it has recently been moved to a new server. One of my ASP pages calls some dll files as COM objects eg. set objCategory=server.CreateObject ("IKMS_Category.Category") I have registered...- turns20
- Thread
- Replies: 12
- Forum: Microsoft: ASP (Active Server Pages)
-
Date format changing during Access to Word Merge
Hi, I currently have an automatic merge running of multiple access queries. This is all working fine except for one of my queries takes a date value which in the Access table is set to "medium date", eg. 14-Oct-03, when it merges into a word document it returns the format as a long...- turns20
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
