05-14-2013, 10:10 PM #3 masoud_sedighy Newly Registered User Join Date: Dec 2011 Posts: 93 Thanks: 43 But your second solution seems to make sense to me. draytond, Apr 6, 2012 #5 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 Are there any "Ands" in the code anywhere?

Please Wait... The item string is only 33 chars long. You can alsoways create several queries and have each join/union with another for a master query that will make it easier to manage and shorten the final query dramatically. That does the trick.

So now I'm trying to make the Filter button simply set the recordsource of the subform to a query that uses the main form's entered information as criteria. Do you get a binary for the image? Cheat Death. http://stackoverflow.com/questions/22405162/vba-access-run-time-error-2176-the-setting-for-this-property-is-too-long Please post a thread in the appropriate forum.

union " & _ "select *...... Privacy statement Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy I could be wrong though. However, there are only about 250 records in the entire database...

So, when all things look bad, I go back to the Northwinds example database, I was originaly going to look at the 2003 version; however, you've said you are using ACC2010 By joining you are opting in to receive e-mail. Maybe too many have the word "island" since this is a database of island projects! This is what I do as it keeps the datafile smaller.

So there's no need to subtract 5 characters from the right side of the WHERE clause. this website Looking at the 2007 version, it appears that MS has actually done something worth while - the attachment field data type. >NOTE> If you use this field upsizing later more than But then I get: run time error 2176- The setting for this property is too long. If you can post a sample (preferably including at least 2 or 3 Unions), we may be able to reduce it for you. (July 2007 to June 2017) . . .

Register now while it's still free! It works so far and the user can view the contect in a larger box. Guest, Jul 1, 2005, in forum: Microsoft Access Form Coding Replies: 5 Views: 2,421 John Griffiths Jul 2, 2005 3,000+ character SQL string - Setting for this property is too long http://axisnice.com/access-error/access-error.php Last edited by oceanboy; Aug 9th, 2007 at 09:46 PM.

TonyB25 replied Sep 29, 2016 at 9:01 PM Music Application/Music.UI.exe? For example, if someone types the word "active" into the text field, it works perfectly. strSQLWHERE = "[SummaryDescription] LIKE '*" & Me.txtSearchString draytond, Apr 3, 2012 #3 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 Is it this line Me![frm_project_search_results].Form.Filter = strWhere Have you

I have a text box with the name (txtsearch), when user type in the text box and press search button it searches every field in the table for finding contained word,

Funny that the same program could be run on that pc before but not now. OBP, Apr 10, 2012 #15 Sponsor This thread has been Locked and is not open to further replies. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Loading...

FlexGrid: fill from recordset .. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. When you need the image, then you append the stored filename to the image path. see here izy currently using SS 2008R2 Reply With Quote Quick Navigation Microsoft Access Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server

Note: the problem is not that there are no records with the required keyword - there are several with the word "island." In fact, maybe that's the problem. You can enter SQL WHERE clause statements of up to 32,768 characters in VBA. Thus, you can use the application.path property to get the current path to the where the database is located and then build the path to the folder. if the length of cate grows by just one character, you get 14 characters nearer to the limit (for 100 characters longer, that's 1400 nearer the limit).

However, it works fine on my own laptop and another pc (A) but the error message like in the title came out when i run the ACCESS VBA application on the So I tried that but it didn't work. Yes, my password is: Forgot your password? union " & _ "select *......