By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Maximum Length of Query String is 512 Characters?

P: n/a
Hello:

I have a form (record source: tblMasterTable) containing a MEMO
field named "FASTA." I have used a double-click event to trigger a macro
that runs the following query:

SELECT SNPID, OrderNum, RefNo, FASTA
FROM tblMasterTable
WHERE Forms!frmFASTA!FASTA=FASTA;

I can double-click on a record's FASTA field (in form view) and a table view
will show
me that same record and any other records with matching FASTA fields.

My problem is that the query will not work for FASTA fields which are larger
than 512 characters. Can anyone help me with this? TIA, Stuart

Stuart E. Wugalter
Statistician II
Building: PMB B100
Mail Code: 9011
Department: Zilkha Neurogenetic Institute
Division: Keck School of Medicine
University of Southern Californa
Telephone: (323) 442-1080
FAX: (323) 442-3054
E-Mail: wu******@usc.edu
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.