No announcements
Found 179427 threads
-
0 VotesCreating a DAO Recordset in Visual Studio 2005
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?Answered | 1 Replies | 12255 Views | Created by Kunnath Chandran - Thursday, September 4, 2008 10:14 PM | Last reply by Shrikant Maske - Monday, October 6, 2008 8:30 AM
-
0 Votes
DAO recordset findfirst anomaly (A2007 ACCDB frontend)
Filters seem to work there.Answered | 14 Replies | 7780 Views | Created by JimS-Indy - Tuesday, June 29, 2010 1:28 AM | Last reply by JimS-Indy - Friday, July 2, 2010 1:56 PM -
3 Votes
Dao in VS2015
Having looked at the DAO example on this site that uses square brackets, e.g dbstable!Answered | 14 Replies | 2592 Views | Created by Denis Oxon - Friday, January 8, 2016 12:46 AM | Last reply by Denis Oxon - Thursday, January 14, 2016 11:33 AM -
0 Votes
can i store a table in VS2013 update 4, but free version, and use DAO recordset on data?
https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?Answered | 1 Replies | 1028 Views | Created by PuzzledByWord - Thursday, June 11, 2015 11:39 AM | Last reply by Dave Patrick - Thursday, June 11, 2015 2:31 PM -
0 Votes
DAO: Record Locking problem?
This error can occur when multiple users open a table or create a Recordset and use optimistic locking.Answered | 2 Replies | 803 Views | Created by smj_w - Tuesday, June 21, 2016 11:04 PM | Last reply by Baron Bi - Wednesday, June 22, 2016 8:57 AM -
4 Votes
ADO Recordset Filter Property too slow
The filter is going to be slow with that many records.Answered | 5 Replies | 21237 Views | Created by Jim Oliver - Thursday, March 13, 2008 9:52 PM | Last reply by Bill2Dev - Monday, June 29, 2015 12:11 PM -
0 Votes
Execute RecordSet
I don't think you can use an UPDATE SQL to open a Recordset.Answered | 4 Replies | 1387 Views | Created by Philosophiae - Monday, May 6, 2013 3:19 PM | Last reply by Van Dinh - Monday, May 6, 2013 9:27 PM -
0 Votes
Create a recordset then close database file
At the moment I am using DAO.Answered | 12 Replies | 926 Views | Created by RedGalaxy - Monday, April 6, 2015 5:55 AM | Last reply by Dirk Goldgar - Wednesday, April 8, 2015 3:18 AM -
2 Votes
'Type Mismatch' error opening recordset
That means the function was called successfully, and returned a DAO recordset.Answered | 28 Replies | 1852 Views | Created by AllTheGoodNamesWereTaken - Monday, November 16, 2015 9:17 PM | Last reply by Jawsurgeon - Wednesday, March 28, 2018 7:57 PM -
1 Votes
DAO - Visual Studio 2008
http://social.msdn.microsoft.com/Forums/en-us/home?Answered | 4 Replies | 3493 Views | Created by DC_Dan - Monday, July 29, 2013 10:25 PM | Last reply by Dave Patrick - Thursday, August 1, 2013 2:12 AM -
1 Votes
Handling transactions with DAO while inserting into SQL tables
And this approach means you can stick with DAO.Answered | 3 Replies | 664 Views | Created by AnandBhatta - Tuesday, September 9, 2014 11:33 AM | Last reply by Albert D. Kallal - Friday, September 12, 2014 12:40 AM -
4 Votes
How to eliminate all DAO code?
In that case you do want to ensure the ADO referacne comes after (below) the ACE data engine reference. the simple reason is then code like this: dim rst ...Answered | 8 Replies | 1823 Views | Created by AllTheGoodNamesWereTaken - Thursday, September 17, 2020 3:52 PM | Last reply by Daniel Pineault (MVP) - Thursday, September 24, 2020 9:33 PM -
0 Votes
Recordsource for an Access-Form with DAO?
But it seems there is no way to do it with DAO....Answered | 16 Replies | 2186 Views | Created by Peter Steimann - Monday, May 2, 2016 8:53 AM | Last reply by Albert D. Kallal - Saturday, May 7, 2016 8:53 PM -
1 Votes
DAO for SSMA 7.4
SSMA requires DAO 12 or DAO 14 to access Access databases.Answered | 11 Replies | 8321 Views | Created by Paddy Boocock - Tuesday, July 11, 2017 10:01 AM | Last reply by Vivamex - Wednesday, January 17, 2018 7:20 PM -
0 Votes
Table autonumber Integer increments with Editmode/update methods on ado recordset
Cheese: I try to avoid ADO (unless it is absolutely necessary) because I have had enormous timing problems in the past where the processes that worked fine in DAO would ...Answered | 5 Replies | 2423 Views | Created by cheesenbranston - Thursday, October 6, 2011 7:33 PM | Last reply by Bruce Song - Thursday, October 20, 2011 12:15 PM -
0 Votes
Emergent DAO behavior
In any event, you can also use Command Parameters in DAO, which is preferable to SQL string variable insertion.Answered | 9 Replies | 3540 Views | Created by KevinMarsalla - Monday, November 15, 2010 4:04 PM | Last reply by Paul P Clement IV - Thursday, November 18, 2010 6:00 PM -
4 Votes
Define Query Field As A Recordset
It lets you do stuff like write concise, descriptive for each loops over recordsets.Answered | 9 Replies | 3022 Views | Created by Lawrence Ellefson - Thursday, July 5, 2012 7:09 PM | Last reply by Joshua Honig - Friday, July 6, 2012 12:49 AM -
0 Votes
Using DAO to process header and detail records from one table
Hi, You are working with 2 tables, so you need 2 DAO recorsets, and the process need the girt to handle the second.Answered | 4 Replies | 1347 Views | Created by HighPlace - Wednesday, October 17, 2012 7:17 AM | Last reply by Van Dinh - Wednesday, October 17, 2012 10:00 AM -
4 Votes
DAO Object Library reference in Access 2010
You could use "tbl" as a recordset.Answered | 19 Replies | 24128 Views | Created by Peter Dwyer - Thursday, February 10, 2011 11:25 PM | Last reply by AccessVandal - Friday, February 11, 2011 3:49 AM -
0 Votes
BOM recursive query, Access 2003, VBA, DAO
As far as I know, we can using DAO to get the result and then store the result in a collection.Answered | 5 Replies | 3305 Views | Created by Spektre - Sunday, October 18, 2015 3:45 PM | Last reply by mklaey - Thursday, October 22, 2015 9:00 PM - Items 1 to 20 of 179427 Next ›
No announcements
