Hello,
I'm not totally certain to your purpose of using SQL to accept a DLOOKUP. However, maybe the following will help you by bypassing the SQL statment and directly attributing a value to a variable from the DLOOKUP.
MYVARIABLE = DLookup("[ID]", "qryListCopiesT oDelete", "[ID] >1")
Hope that helps you.
Bugran
Bugran
Last Activity: Nov 4 '08, 04:56 PM
Joined: Oct 22 '08
Location:
-
Hi there,
I believe - at least part of your problem - may reside in the DLOOKUP ...
stRecip = DLookup("email" , "cust", "[cusname]='" & Me!ORDER & "'")
Where "email" should be in brackets "[email]" ...
You may also want to be very careful in name comparisons and use the Trim$ to be certain niether the server name or form...Leave a comment:
-
I hope this may help you some.
Due to the large number of reports (letters) where some have signatures and some don't, I came up with the following solution:
#1 The bmp signatures are created and put into their own report (all by themselves).
#2 Each letter has a subreport - sigs - attached to it. All the subreports with the bmp signatures are included inside - sigs - (so as not to populate ALL the different...Leave a comment:
-
First off, thanks for the responses!
The nutshell of the problem WAS I could not move 19k characters to a server table directly from a single textbox on a form. After 510 characters, I basically got junk.
Since SQL has no issues moving table to table, my solution was to create a 'local' table with a hidden form bound to it as this allowed the forms contents to be copied - in it's entirety - to the local table memo field....Leave a comment:
-
In a nutshell, no, the form/textbox is not bound (actually no forms in this system are bound due to the server tables and number of users). Also, the system would only - possibly - be creating new records (multiple letters/forms created for our applicants with a single action based on selections from other screens). The save/print/add to batch is from a 'print/save form' opened from any number of other forms and relating to different back-end tables...Leave a comment:
-
Copy a large textbox value from a form to a memo field (Access 2003)
I am trying to copy a textbox field on a form (which basically contains the body of a letter) into a memo field in a table (Access 2003) for later printing later. Of course Access queries/SQL will not copy that many characters. I have considered breaking the text box into blocked character sets, but it seems there must be an easier method. Thanks so much for your help!
No activity results to display
Leave a comment: