No announcements
Found 2924944 threads
-
2 VotesMS Access Query - make a field join with fields of differences in text
You could use SELECT TableA.FieldA, TableB.FieldB FROM TableA INNER JOIN TableB On Replace(TableA.FieldA, " Ltd", "") = TableB.FieldB (this ...Answered | 2 Replies | 1707 Views | Created by JohnnySo - Tuesday, June 26, 2012 8:19 PM | Last reply by Hans Vogelaar MVP - Tuesday, June 26, 2012 8:33 PM
-
1 Votes
Access Text field size limit
Yes as Gina said, a Text Field has a limit of 255 characters.Answered | 3 Replies | 15283 Views | Created by Janet_Needs_Help - Monday, June 20, 2011 3:32 PM | Last reply by danishani - Monday, June 20, 2011 3:57 PM -
0 Votes
UNION query not providing full results in memo field
[Title], PlainText(T.Notes) FROM ( SELECT [Project], [TrackingDate], [Title], [TrackingNote] AS Notes FROM [qryTracking-Task] UNION ALL SELECT [Project], ...Answered | 7 Replies | 352 Views | Created by NoviceVBAuser1775 - Wednesday, March 29, 2017 3:54 PM | Last reply by .theDBguy - Wednesday, April 5, 2017 3:02 PM -
0 Votes
tunning simple query with full-text
I also don't understand why MS doesn't add polish language to full-text search.Answered | 15 Replies | 1454 Views | Created by Lutador83 - Monday, December 23, 2013 10:45 AM | Last reply by Erland Sommarskog - Friday, December 27, 2013 11:03 PM -
1 Votes
MS Access 2010 - Changing Text Field Size Across DB?
Well, you only described the fields as text fields, it is not mentioned these were PK-FK fields.Answered | 5 Replies | 2728 Views | Created by Kypros Charalambous - Friday, July 27, 2012 11:59 AM | Last reply by KCDW - Friday, July 27, 2012 4:09 PM -
0 Votes
Ranking Aggregate Field in Access Query
Hi Pix, Using of a sub-query to perform a ranking operation on an aggregate field is rather complex.Answered | 5 Replies | 946 Views | Created by Pix Elliot - Sunday, February 15, 2015 2:53 PM | Last reply by Edward8520 - Monday, February 16, 2015 8:40 AM -
0 Votes
ms Access QUERY
The function can then be called in a query which computes the current balance per material type on the basis of the functions return values, not the values stored in the ...Answered | 3 Replies | 584 Views | Created by SAMA25 - Monday, May 25, 2015 8:03 AM | Last reply by Ken Sheridan - Tuesday, May 26, 2015 11:53 AM -
0 Votes
Full text performance of a certain query
I'm almost positive that you could reproduce this on any full-text index.Answered | 8 Replies | 4912 Views | Created by Chris Holt - Monday, August 23, 2010 1:18 PM | Last reply by Chris Holt - Wednesday, October 27, 2010 5:51 PM -
0 Votes
Full Text Index Not Working
I'm not really querying a table, as much as I'm using the "Find" button on our access 2007 front end.Answered | 3 Replies | 3291 Views | Created by David92595 - Wednesday, May 9, 2012 12:03 AM | Last reply by Ajith Krishnan - Thursday, May 10, 2012 4:58 AM -
0 Votes
Best way to short circuit a full text query
However nothing beats a direct run of the direct full text query.Answered | 6 Replies | 3163 Views | Created by APBoston - Wednesday, August 3, 2011 9:30 PM | Last reply by APBoston - Friday, August 5, 2011 3:52 PM -
2 Votes
MS Access Query
You could get data of MS Excel/MS Access through a good OLE DB provider like Microsoft.Jet.OLEDB.4.0 or 'Microsoft.ACE.OLEDB.12.0' instead of ODBC ...Answered | 1 Replies | 8470 Views | Created by PipeSpies - Saturday, December 17, 2011 4:15 PM | Last reply by Shehap - Monday, December 19, 2011 2:28 AM -
0 Votes
sp_prepare and full-text search
I need to create prepared statement for Full-text search: select * from dbo.Table_1 where contains(FirstName, 'someInfo').Answered | 1 Replies | 6086 Views | Created by Irina Svirkina - Thursday, August 26, 2010 6:01 AM | Last reply by Ai-hua Qiu - Friday, August 27, 2010 7:53 AM -
0 Votes
Updating MEMO field in MS Access table using access update query throws extra characters
can you please show me how to use update query with plain text function in query designer?Answered | 7 Replies | 9165 Views | Created by zaveri cc - Thursday, December 1, 2011 3:51 PM | Last reply by zaveri cc - Friday, December 2, 2011 8:15 PM -
0 Votes
MS ACCESS select Query with full text field size
User-1199946673 posted Is there any way to pickup dynamic column field size instead of putting it static 15?Answered | 3 Replies | 28 Views | Created by Anonymous - Friday, March 16, 2012 6:42 AM | Last reply by Anonymous - Tuesday, March 20, 2012 5:04 PM -
3 Votes
MS Access 2010 : Operation must use an updateable query
Hello, I am trying to update a field in a table with a select query that uses another fields in the same table multiplied with a ...Answered | 7 Replies | 18996 Views | Created by ricostrydom - Tuesday, November 13, 2012 6:10 PM | Last reply by ricostrydom - Wednesday, November 14, 2012 6:51 AM -
0 Votes
MS ACCESS select Query with full text field size
User1109032460 posted See http://msgroups.net/microsoft.public.access.queries/Padding-Fields-with-spaces Note the comments, but this will tell you ...Answered | 3 Replies | 5 Views | Created by Anonymous - Friday, March 16, 2012 6:05 AM | Last reply by Anonymous - Friday, March 16, 2012 8:32 AM -
0 Votes
SQL Server 2008 Full Text Search error: Word breaking timed out for the full-text query string
Hello Prabhakar, Thank you for your post!Answered | 2 Replies | 11115 Views | Created by Kondap - Friday, October 3, 2008 2:47 PM | Last reply by Shrikant Maske - Friday, October 17, 2008 10:29 AM -
0 Votes
Hide Ms Access queries permanently.
The truth of the matter is if someone want into an Access database, they will always be able to.Answered | 3 Replies | 837 Views | Created by Santosh Vi - Friday, June 24, 2016 7:51 AM | Last reply by Imb-hb - Saturday, June 25, 2016 7:05 PM -
0 Votes
SharePoint Field validation to MS Access
It seems that the field validation formula ISNUMBER([FIELDNAME]) is not supported in the Microsoft Access.Answered | 4 Replies | 1104 Views | Created by Praveen Kumar Padmakaran - Monday, July 6, 2020 9:09 PM | Last reply by Praveen Kumar Padmakaran - Friday, July 17, 2020 1:53 PM -
0 Votes
Appending field values to a new table or query Access
The Sharepoint list is set as a number and the Access field is set as Short Text.Answered | 13 Replies | 298 Views | Created by cruiserbill - Tuesday, April 3, 2018 8:03 PM | Last reply by .theDBguy - Wednesday, April 4, 2018 4:51 PM - Items 1 to 20 of 2924944 Next ›
No announcements
