Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / March 2006

Tip: Looking for answers? Try searching our database.

Error in query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PJ - 24 Mar 2006 19:39 GMT
I have the following expression in my query and I'm getting this error "The
text is to long to be edited". Is there a different way to write this?

Capital Markets Name: IIf([Capital Markets
originator]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets originator]) & IIf([Capital Markets
Derivatives]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Derivatives]) & IIf([Capital Markets
Distributor]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Distributor]) & IIf([Capital Markets Jr
Support]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Jr Support]) & IIf([Capital Markets
Referral]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Referral]) & IIf([Capital Markets Backstop
Originator]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Backstop Originator]) & IIf([Capital Markets Backstop
Trader]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Backstop Trader]) & IIf([Capital Markets Referral
Secondary]]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital Markets Referral Secondary])

Thanks in advance
PJ
Jerry Whittle - 24 Mar 2006 20:45 GMT
Also if you are running this in the frmReportCriteriaMarketer form, you could
simplify things like
[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName]  like so:
Me![txtEntertheMarketerName]

Renaming your frmReportCriteriaMarketer to something like frmRCM would save
a lot of text. Same goes for then names of controls on the form.
Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have the following expression in my query and I'm getting this error "The
> text is to long to be edited". Is there a different way to write this?
[quoted text clipped - 18 lines]
> Thanks in advance
> PJ
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.