Microsoft Access Modules VBA Coding Forum. Join your peers on the Internets largest technical computer professional community. Its easy to join and its free. Heres Why Members Love Tek Tips Forums Register now while its still free Already a member Close this window and log in. Join Us             Close. I have a JET table with an autonumber as the primary key, and I would like to know how I can retrieve this number after inserting a row. I have thought of using MAX. Type Mismatch on ADODB. Recordset. Microsoft Access VBA Forums on Bytes. Professional forum and technical support for computerIT pros for Microsoft Access Modules VBA Coding. Includes problem solving collaboration tools. The equivalent in Access SQL dialect is CREATE TABLE Tasks Description LONGTEXT, Category VARCHAR100, DueDate DATETIME MySQL. Arise Program St. Cloud here. Im trying to use these functions to manage an attachment table without using the in Access interface so people cant delete or break stuff, however, Im getting. Use VBA to get the correct number of records in a Recordset object. Does your Recordset return 1 for its RecordCount property If yes, this article will be able to. Experts Exchange Questions MS ACCESS 2010 VBA loop through multiple recordsets and update a recordset with a value This article shows you how to validate email addresses in VBA by using regular expressions. I currently get a ADODB Recordset via a SQL call using Function based table, its complex so i dont wish to replicate it in VBA via SQL.