Ms Access Tabledefs Fields

MS Access VBA code to compare records in a table and combine data where necessary. microsoft access 2010 free download for windows full version 32/64 Bit. To let you access the collection of fields of a table in DAO, the TableDef object is equipped with a property named Fields, which, as its name indicates, is a. I am trying to use the Tabledefs collection to enumerate fields. I had a look at the article but the problem is these are replacement records not duplicates. VBA Express : Access - List all Tables and Fields in an Excel spreadsheet. pdf), Text File (. Append fldNew Set fldNew = dbTwo. However, I still find it a darn good tool for querying, reporting and doing quick edits to data stored in other platforms. Append or TableDef. This code was found in answer to an anonymous question, where you told that you didn't know if the RFC_READ_TABLE accepts more than one Option (Where condition). Name, 4) <> "MSys. For Newsletter. Fields Debug. TableDefs Access / Excel - Microsoft Specialist in MS. CreateField("NewOrigin", dbLong) Set fld = Nothing Set tdf = Nothing Set db = Nothing More importantly, should this data be stored in a related table instead of adding more fields to the same table?--Allen Browne - Microsoft MVP. Il convient cependant d'être objectif, ce n'est pas la solution miracle et ça ne remplacera pas une base de données en ligne du type Microsoft Azure , notamment pour les accès concurrents. I have been manually creating the table including field names, data types, and individual field properties and then automate the Table load from data in Excel. Hey, I'm trying to create a button that will allow the user of my system to create their own table within my database. MS Access 2007: View system tables This MSAccess tutorial explains how to view all of the system tables in the navigation pane in Access 2007 (with screenshots and step-by-step instructions). net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community , the registration is free and takes only one minute. But for whatever reason could not find an answer on the web. then delete the old tabledef and rename the new one. TableDefs("tMyTable"). Despite the fact that ADO is the main tool for interacting with the database Access, it has some serious drawbacks. NET library. I am using some FreeVBCode. This is my code that uses this:. Tables: Creating an AutoNumber field from code. In this article I will explain how you can get the names of all the fields in a table an access database using VBA. VBA Express : Access - List all Tables and Fields in an Excel spreadsheet. That was just an example that I gave. answering "what other tables is this field or group of fields being used in"). To get you started. You may also want to read: Access delete table records. Using Microsoft Access 2007 Description of Field Names in Tables as Variable Labels in SAS® Data Sets, continued 5 CONCLUSION It is a common practice between statisticians and data managers to import data collected in Access into SAS for analysis. Since the diagram shows that TableDefs have Fields, we could learn the number of fields in the first table from db. The Yes/No data type in Access can only be one of 2 possible values:-1 represents True, or Yes, or On; 0 represents False, or No, or Off; Internally, the Yes/No data type is stored as a 8-bit signed number except the capabilities of its storage have been crippled to not to allow any value except -1 or 0. To begin with, let's create a TableDef object and assign it to a specific table in the collection. Applies to: Access 2013 | Office 2013. In Access, you can define up to 255 fields in a table. I wrote this code ages ago to allow me to quickly create linked tables in MS Access for SQL Server tables/views. Carl and Extra Mile Data was the easiest and quickest way to solve my MS Access problems. You can use the following symbols in custom formats for any data type. "Reserved words" are words and symbols that have a specific meaning to Microsoft Access. Why I stopped using Yes/No fields. システム開発 アクセスの備忘録 (Microsoft Access)オブジェクト情報の表示. Upload Access Tabellen zum SQL Server Microsoft ist manchmal notwendig zwischengespeicherte komplett einem hochzuladen Dabei entweder Datensatz uuml einzeln. I'm actually trying Watch the more deeply embedded object CurrentDb. You can't delete a Field object from a TableDef object's Fields collection after you create an index that references the field. Create a Database and Table and List the Tables and Fields in the Database. cc FROM (TableA AS A LEFT JOIN TableB AS B ON B. TableDefs, but I can't do this if the intermediate object CurrentDb. But it could be done, I suppose. If you feel the same way, here's how to automate the whole process. 3270 Property not found. capabilities) being returned to JET by the MyODBC driver. TableDefs If TableDef. OrdinalPosition = 1 Next intTemp End With Set tdf = Nothing db. Click the "Save" button in the Quick Access toolbar to save your structural modifications. On the control of my form i want to give a command for creating fields in a table. Using Microsoft Access 2007 Description of Field Names in Tables as Variable Labels in SAS® Data Sets, continued 2 Figure 1. Append or TableDef. TableDefs(0). For instance, I like to quickly identify tables containing Attachment and Memo fields. June 10, 2010 Set td = db. Data Access Objects, or DAO, is a powerful programming model for database services. mdb so I can creat e queries in database1. e "nullable", "not required", that I would be able to define from Access? Can you give me an example as well? How to add fileds in a MS Access table. From some reasons Access doesn't allow to hold a reference to DAO. I need to get a list of table names, then a list of fields in each table. You should call Tabledefs property each time you want to call nested properties/methods. ÿ Thanks for the help. Once the value changes the database macro sets up the audit fields with the values needed. ,with some tricky code in Visual Basic. This is the snippet Change Field Size in MS Access at Runtime using DAO on FreeVBCode. Thanks for the feedback guys. Access VBA - Change the Name of a Field in an Existing Table I've just been importing some records from Excel to Access using VBA. We can spend a lot of hours to identifying and creating relationships until now: I have write a VBA script to identify MS-Access relationships and create MySQL code with SQL-CREATE sentences, it will be useful after migration process using any free tool:. Unfortunatly I can't give you an example because I'm offline answering on my Android Tab that doesn't run Access. TableDefs If TableDef. lorsque l'on crée une clé primaire en NuméroAuto, c'est pour éviter d'avoir à créer des identifiants. Daniel – While the function will display controls in a database, how does it know that every control is a lookup field?. To repeat what I'm looking for from my previous post: Note I have written "Suspect there is a better way to do this" etc. You've probably noticed that a complex, fully qualified name of an object or a property in Access 2010 or Visual Basic contains exclamation points (!) and periods (. raw download clone download clone. MS Access Tables MS Access VBA Programming 2 responses on " MS Access - List All Lookup Fields " Peter N Roth May 26, 2017 at 12:14 pm. Microsoft Access Tips for Serious Users. To let you access the collection of fields of a table in DAO, the TableDef object is equipped with a property named Fields, which, as its name indicates, is a. Name, Microsoft Access MVP. Name Next fldAny end with Next td. We would need a little background on where the db is and how it is being accessed, it sounds like it would be across a network. Fields("YourColumn"). The field is a type double. How can one search TableDefs for linked tables? ms-access access-vba ado dao. For example I may want to rename the fields in the table from whatever they are to Field_1, Field_2 and so on. Fields(0) Debug. Field etc objects unless they has been just created and not yet added to a correspondent collection. Cette question est étrange en elle-même, car cela ne convient pas, dans une base de données. A TableDefs collection contains all stored TableDef objects in a database (Microsoft Access workspaces only). In fact, the owner of The Access Web is deciding to update the page on The Evils of Lookup Fields in Tables to include this information. I need to add a calculated field to an existing table. Как получить список имен полей таблицы в MS Access? / Microsoft Access / Нужно выпихнуть в DataList список полей для своего конструктора отчетов. Learn All About Microsoft Access VBA Code - VBA Functions, Shortcuts And Much More…! Summary: This tutorial helps orient you to the programming tools i. Accessing MS ACCESS database using Data Environment HI, I have developped a program in Visual Basic 6. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. For Each fld In db. I have to admit I am always collecting odd procedures that I reuse. Import a text file as a table in MS Access using VBA Submitted by Jimbo on Tue, 07/12/2011 - 01:01 MS Access is easily the best-suited software tool for manipulating, cleansing and transforming extracts from legacy systems prior to loading into SAP. Module: DataOperations in Category Microsoft Access : Objects from Total Visual SourceBook Perform data operations through DAO in VBA and VB6. Hi all my favorite Access elves, and happy NewYear. I want to change the table property description with VBA code. Long gone are the days when I did much application development in MS Access. TableInfo() function This function displays in the Immediate Window (Ctrl+G) the structure of any table in the current database. Perth, Western Australia. Related Post "How to Fix MS Access Subscript Out of Range Error" Powershell Query MS Access Database in Microsoft Windows Application Powershell Access Database - Ms. CreateField("NewField1", dbInteger) dbOne. Function ChangeFieldDataType() Dim db As DAO. This table relinking procedure is a really good example of how to use VBA to link your tables programmatically, and how to have MS Access refresh linked tables automatically. You'd most probably reference a specific table or query e. Ms access vba tabledefs keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. I was teaching an introductory Access VBA class and one of the students asked how he could select a random set of 25 records from a table in his database. TableDef in Access. This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database. Nous abordons là un point fort de DAO à savoir la définition des données (DDL). Approach 1 - using the DAO TableDefs Collection. Text fields in Access web apps. TableDefs(" Searchtable"). Access Melalui Coding di VB6 (Visual Basic 6) Ketik coding berikut pada Module Pada posting kali ini saya coba mengulas kembali mengenai pembuatan program dengan Visual Basic khususnya tentang database. 3270 Property not found. Mengenal Tabel Temporer di MS Access. Learn All About Microsoft Access VBA Code - VBA Functions, Shortcuts And Much More…! Summary: This tutorial helps orient you to the programming tools i. Can anyone come up with an EASY way to trim every field in a table via VBA? I'd prefer not to build a query every time with 50 fields in it. Can somebody please tell me where I can find more information about win32com module and attributes. This is among the most basic documentation you need to understand the tables in your database. To get to the TableDef object and its indexing information, this code loops through the TableDefs collection to find the right TableDef. For example I may want to rename the fields in the table from whatever they are to Field_1, Field_2 and so on. Microsoft Access Tips for Serious Users. List all Tables and Fields in an Excel spreadsheet This code was developed to quickly build a list of 90 tables and their field names from an ODBC database, and dump it into Excel. Print fld. g c:\project\app\test. Access Newsgroups. Create your free Platform account to download our ready-to-use ActivePython or customize Python with any packages you require. Reference column name from TableDefs. RecordSource = NomTable. I am still in the early phases of getting an understanding on how to do it, and im allready stumped at simply refering to the tableDef. Under these conditions, here's a module that will create a new database and build all the structure for it. Clearly, this is a common problem. When linking an MS Access database to views in an SQL Server database you can only make the view updateable from Access if you choose a Unique Record Identifier (usually the primary key of an underlying table). I have created all my reports through Data Environment where I have entered the location of my database file (for e. That was just an example that I gave. TableDefs!BOOKS. DAO Programming Code Examples. File Extension of MS Access 2003-2016 Version. Append fld 'обновляем cемейство полей созданной таблицы tdf. DefaultValue = "" End If. DefaultValue = 0 Then tdfProd. I also stick with the older MDB style databases. I have a simple form in an Access 2007 database. I am importing data through a macro, from text files. trying to access fields of the table but not able to thistried these codes. Hi dear experts, My boss asked me to send him all fields from a MS Access database. RecordsetType = 0. Delete strTd(x) (which is technology of ADODB a of the MS Access project /. HELP! Microsoft DAO 3. Dim tdf As DAO. If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. How do you run the function. An Access Yes/No data type corresponds to the SQL Server BIT data type. Thanks a million in advance! Kevin. Count - 1 ' set all fields' OrdinalPosition to 1 ' causes Access to sort the fields alphabetically. The properties of a field describe the characteristics and behavior of data added to that field. Tables: Relink Access tables from code. Append new_field. Database, tdf As DAO. Data Access Objects, or DAO, is a powerful programming model for database services. dbAttachedODBC Or TableDefAttributeEnum. Bila tabel temporer tidak lagi dibutuhkan, maka kita akan menghapus tabel itu dari Access Navigation pane. Default Value, you can spot a function called GenUniqueID(); this is the internal function that Access uses to generate the random Autonumbers. The goal is to record the "who what when where" of edits made in an Access database. dbAttachedTable) Then ' ODBC および 非ODBCリンクテーブル の場合. Which i then review through a crystal report. To remove a Field object from a Fields collection, use the Delete method on the collection. Last updated: April 2010. I have two database files: database1. TableDefs!BOOKS. SELECT Count(*) AS Expr1 FROM A INNER JOIN B ON A. dbAttachedTable) Then ' ODBC および 非ODBCリンクテーブル の場合. June 10, 2010 Set td = db. On the control of my form i want to give a command for creating fields in a table. Using the tableDef and Filed object you can create new fields from within the code. Nous abordons là un point fort de DAO à savoir la définition des données (DDL). En effet, l'objet Database donne accès à l'ensemble des tables, des requêtes et des relations d'une base de données Access. Microsoft Access / VBA Forums on Bytes. 6 Object Library check box is selected. Just grabs all the tables and fields and dumps then in an array (except temp or system tables) then just does an SQL. I copied this code directly from the MS Knowledgebase search results for "change field data type": ACC: How to Change a Field's Data Type at Run Time with Code (Q128016) '***** ' The AlterFieldType Sub procedure requires three string ' parameters. Microsoft Access developers often use the same code to perform functions in many procedures. You can use the Attributes property of a TableDef object to determine specific table properties. That means I need to compa. Access forms with 3D headings and animated controls. I have a specified schema given to me for this *. Help with VBA To Change Field Name property in MS Access I am looking for a little help in using VBA code in MS Access to change the Field Name Property of a given table. access vba subscript out of range currentdb tabledefs - related access database templates. Hi the most easiest way is via DAO - add reference to ms DAO (3. Learn more about data types for Access desktop databases. A category is also called a field. dbAttachedTable) Then ' ODBC および 非ODBCリンクテーブル の場合. mdb) in the Connection properties. how to print all MS Access table/field information like descriptions and sizes. Fields("fMyField"). e, VBA code in Microsoft Access and point you to some resources where you can learn more about programming. Fields without having to open up huge nested objects starting form CurrentDb. I splitted the MS-Access db with forms, reports, objects in one file and tables in the other. Access VBA Programming, User Defined Functions,SQL Queries, Forms, Form Elements etc. One notable exception to this is the Recordset object, for which Access tries to maintain the database reference. Microsoft Access DSN-Less Linked Tables: TableDef. Author(s) Dev Ashish: Personally, I find the manual steps required to link to an ODBC table rather annoying. MS Access 2010 – Simple Function to loop through a list and Print to file an individual PDF Had to move to MS Access 2010 to do this as no facility for direct to PDF print in MS Access 2003 Where the fields in the QUERY-ListofIDtoPrint includes ID / Field02 / Field03 / Field04. For records, expressions can include references to fields in that table. I have tried selecting the Excel. Close Set db = Nothing End Function--Jerry Whittle Light. To get the full story of attaching tables take a look at the February 2013 issue of the Access Wizard. DAO (Data Access Objects) is the object model that lets you get at the heart of Access programmatically. You use the Field objects in a Recordset object to read and set values for the fields in the current record of the Recordset object. Setting field properties in code. Database Dim MyTable As DAO. I want to change the table property description with VBA code. Hi, can anyone help please? I am trying to find the code to add a new field to an existing table. Access vba rename fields keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. Help with VBA To Change Field Name property in MS Access I am looking for a little help in using VBA code in MS Access to change the Field Name Property of a given table. Accessing MS ACCESS database using Data Environment HI, I have developped a program in Visual Basic 6. Long gone are the days when I did much application development in MS Access. id) LEFT JOIN TableC AS C ON C. Which i then review through a crystal report. Here is what the code will do: Relink all linked Access database tables if the back-end and front-end are in the same folder. You'd most probably reference a specific table or query e. What's the most efficient way of enumerating the fields of an Access. Bila tabel temporer tidak lagi dibutuhkan, maka kita akan menghapus tabel itu dari Access Navigation pane. Learn All About Microsoft Access VBA Code - VBA Functions, Shortcuts And Much More…! Summary: This tutorial helps orient you to the programming tools i. TableDefs("tblName"). Microsoft Access Tips for Serious Users. Fields("ID"). Bei Access 2002 (XP) war dies noch genauso, aber mit Access 2003 konnte sich auch Microsoft nicht mehr der Tatsache verschließen, dass sich ADO, mit gutem Grund, bei den Access-Entwicklern nicht durchgesetzt hat, und hat wieder DAO als Standard-Datenzugriffsbibliothek voreingestellt. DeleteObject Method. Make sure there is a "Settings" table in the database with only one row in it. DefaultValue = "XXX" Though you might have to set an object variable along the way; sometimes in VBA it doesn't work the way you expect unless you set a variable to reference an object first, and then use that object variable to access/set properties and methods. В первый раз я выполнил код со строкой db. This is my code that uses this:. TableDefs( MyTable What's with the Microsoft Access TableDefs Collection?. Set tdf = db. Thanks in advance! Alternatively, how can I copy my variable descriptions from MS Access' Design View to another program (SPSS or EXCEL or a text document)? MS Access doesn't allow copying the description fields (only one at a time and I have 900 variables in my tables!!) and importing into SPSS does not include the descriptions. com code to create MS Access tables "on the fly". But for whatever reason could not find an answer on the web. DAO Programming Code Examples. You specify Sort property and Jet Engine finds and uses proper index automatically. Fields Debug. Here is how you can access all columns names in a Access table with OLEDB connection in VB ADO. I am looking for a way to change field names in Access. A TableDefs collection contains all stored TableDef objects in a database (Microsoft Access workspaces only). June 10, 2010 Set td = db. MS Access 2007: View system tables This MSAccess tutorial explains how to view all of the system tables in the navigation pane in Access 2007 (with screenshots and step-by-step instructions). Thanks for the feedback guys. Name = "ETitle" which worked, but of course was informed that the field could be in the second col, or any other col such as the 8th. This can be used in advance of address matching to increase the chances of getting matches in fields that have been collected through a UI with little or no validation. You can use the Attributes property of a TableDef object to determine specific table properties. I am currently working on a class library that requires me to output data into an Access file (*. Since the diagram shows that TableDefs have Fields, we could learn the number of fields in the first table from db. Getting Field Names from Tables in MS Access. Despite the fact that ADO is the main tool for interacting with the database Access, it has some serious drawbacks. But for whatever reason could not find an answer on the web. The form contains two combo boxes. I was hoping that with the loop, it could find the field and then change it, so I don't need to know specifically which col. Hi, ich habe volgendes Problem!! Ich bekomme die Fehlermeldung "Benutzerdefinierter Typ nicht definiert"!! Bei: Dim dbase As Database, tdef As Recordset, i As Integer, fd As Integer, tname As String, j As Integer, iname As String. tsv" ' ' テーブルのカラム一覧を出力します ' Public Sub get_TableColumns() Dim M…. Dim tdf As DAO. TableDefs For Each fld In tbl. " Reserved words have a specific meaning to Access or to the Microsoft Jet database engine. MS Access VBA code to compare records in a table and combine data where necessary. Name, Microsoft Access MVP. TableDef Dim myFIELD As Field. Each time you modify a field or add a field, this count increases by 1. If you set a default value for a table field, Access applies your value to any controls that you base on that field. Introduction. Microsoft Access / VBA Forums on Bytes. How to reading MS Access field properties such as Caption, Description, InputMask If this is your first visit, be sure to check out the FAQ by clicking the link above. I am importing data through a macro, from text files. To give you access to the collection of fields of a table, in the Microsoft Access Object Library, the TableDef object is equipped with a property named Fields that is of type Fields and each one of its items is an object of type Field. I can't figure out how to determine if the field is indexed and how it's indexed. In Microsoft Access, all tables appear in what is called the TableDef's collection. Greg, I am a Die-hard DAO user, so I decided to get into ADO seriously. MS Access 2007: View system tables This MSAccess tutorial explains how to view all of the system tables in the navigation pane in Access 2007 (with screenshots and step-by-step instructions). I found some code that loop thru all the table in the database and export them to Excel, this works great but it only contains the table and field name. I want to change the table property description with VBA code. CreateField("NewField1", dbInteger) dbOne. MS Access などの非ODBCのリンクテーブル リンクテーブルの一覧を表示するサンプル Dim TableDef As DAO. Creating a table in Access is not difficult. Using the tableDef and Filed object you can create new fields from within the code. I need to read the properties of over 100 tables in an Access 2003 database and write those details - table name, field name, type and size - to a file for further documentation. e "nullable", "not required", that I would be able to define from Access? Can you give me an example as well? How to add fileds in a MS Access table. Currently, I'm attempting dao with the win32 package, and I'm able to view all of the table names, but I don't know how to view the attributes of the tables. Link provided by the UtterAccess community. CreateTableDef to make new tables in that external database, then CreateField, set Attributes if it is an autonumber, and DefaultValue if desired for other fields. This example creates a new TableDef object and appends it to the TableDefs collection of the Northwind. Understanding Other Table Properties. Microsoft Access Developer and VBA Programming Help Center Resources for Becoming a Better Microsoft Access Developer and Programmer. TableDef For Each TableDef In CurrentDb. Linked, or attached tables, live outside your database. Using bit mask fields with hexadecimal in MS Access I am having difficulties with how to use the following SQL in MS Access. Microsoft Access / VBA Forums on Bytes. Access 2003 Any way to dump table info into Excel? I do not mean the data I mean field names, data types, field length, Description Is this possible Thanks Dave _____ Information from ESET NOD32 Antivirus, version of virus signature database 5065 (20100427) _____ The message was checked by ESET NOD32 Antivirus. TableDefs(sTable) With tdf For intTemp = 0 To. query How to loop through all Tables in an MS Access DB tables in your database by looping through the DAO TableDefs collection. Microsoft Access Tips for Serious Users. 30 1 When viewed within Microsoft Internet Explorer, you will get a tree view representation of the data structure. Long Text In Access web apps, the Long Text field can store up to 2^30-1 bytes, and is equivalent to the SQL Server data type of nvarchar(max). dbAttachedODBC Or TableDefAttributeEnum. To rename a field in a table in Access, open the table containing the field to rename in design view. e "nullable", "not required", that I would be able to define from Access? Can you give me an example as well? How to add fileds in a MS Access table. Make Primary Key index in each table. Adding tables / fields to a remote backend database Hi All, i have an application (Access 2007), split into FE and BE which is now being used by several clients. Umumnya, tabel temporer hanya akan kita buat saat dibutuhkan. Microsoft provides programming examples for illustration only, without warranty either expressed or implied. in the comments of a line which I think is questionable, so if you do a Ctrl+F for "suspect" then you'll find things I am particularly unsure of. Hi all my favorite Access elves, and happy NewYear. This post will provide you with the needed code to email pdf's from Access. CREATE TABLE statement (Microsoft Access SQL) Applies to: Access 2013, Office 2013. I know it's possible to convert rows into columns, I have done that before, so I'm figuring there has to be a way to do the opposite, which is what I'm trying to do here but I just don't have a clue how to do it other than writing a lot of code, which I'm trying to avoid. MS Access Tables MS Access VBA Programming No Comments Sometimes it can be useful to quickly evaluate the databases tables structures. TableDefs For Each t In td 'loop through all the fields of MS Access VBA – List. Tables: Relink ODBC tables from code. So the way I decided to handle it was to create a table in VBA, and then use vba to have ms access generate a dynamic report. Rename a Field in a Table in Access: Instructions. (A) Access keeps an internal count of total number of fields in a table and has a limit of 255 fields per table. Access 2003 resource Centre on MSDN Access Developer Portal on MSDN Allen Browne's tips for Microsoft Access Allen Browne is one of the web's leading authorities on Access. TableDefs ' Ignore system tables Program Citit Dbf : DBF Viewer, DBF Editor, DBF Convertor Exportar Dbf A Excel Gratis Dbf Bestand Omzetten In Access Dbk Format Dlgconverter Software Xlsx Datei Offnen Als Dbf Sichern Doa Tabledefs Create Dbf Files Javascript Info. Once we have done that, we can access its properties. DAO components work like queries in MS Access, so you needn't to specify index. The FreeVBCode site provides free Visual Basic code, examples, snippets, and articles on a variety of other topics as well. How to Rename a Table in Microsoft Access. Ms access vba tabledefs keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. I use the DAO rather than the ADO when accessing a MS-Access database. MS Access などの非ODBCのリンクテーブル リンクテーブルの一覧を表示するサンプル Dim TableDef As DAO. The article below explains how you can get the name of all the tables in an access database:. A Fields collection contains all stored Field objects of an Index, QueryDef, Recordset, Relation, or TableDef object. Properties(PropertyOfInterest), where PropertyOfInterest is either DecimalPlaces or Format. If, for example, in an Access database you have a table called Customer2 with a field NewId that was a random Autonumber, then if you look in CurrentDB. The field is a type double. In the preceding file, you have a root element, , followed by several other elements; the element contains two child elements,. TableDefs(" Searchtable"). Close Set db = Nothing End Function--Jerry Whittle Light. But it could be done, I suppose.