Access Vba Findfirst Multiple Criteria

openrecordset("table1") >strCriteria = "PK = 10" >if not rs. Findfirst Recordset Function. There are restrictions on how certain data types can be modified and manipulated so sometimes it might be more useful. " VBA Access (31) VBA Excel 2010 (5). I am sure VBA can help me to get this. SQL does not really update just the update the criteria of the statement, it. I have 2 search criteria each of which works just fine if used separately as an argument in FindFirst, but NOT in combination with one another. I know this is an easy question but I can't seem to figure out. FindFirst "String Criteria Here" with a Record which is more a less a structure with multiple value. Anyway, once I've established the data and how I intend to show compatible HDDs, I need to make a form that will allow me to select computer builds and the compatible HDDs. The use of a command-level database programming language to customize business systems and selectively retrieve information using single or multiple database tables also will be studied. Finding Records Using the Find Method : Recordset Find « Access « VBA / Excel / Access / Word Finding Records Using the Find Method Finding a Record Based. Microsoft Access: Data Access Objects Library (DAO), Connect with Access Databases from Excel using VBA. The DLookup function returns any datatype such as a string, numeric, date, etc. The different between the VBA While and the VBA Do Loop is : While can only have a condition at the start of the loop. SQL Property. You create Standard modules by selecting the Modules icon in the Database window and then clicking New. > So i have written code in VBA (MS Access) which takes bits of information, > copies it to an excel sheet, formats it per the requirement specifications > and then moves it to Outlook. We will mention the more important ones. Many types of files can be stored in a column which has the attachment data type. FindFirst method (DAO) 09/18/2015; 3 minutes to read; In this article. Access 2007 introduced the possibility that a field in a recordset may itself be a recordset. Please help me on following: For some reason FindFirst is not working whenever my search criteria constains a date field and date value. In DAO i can use the FindFirst Method easily, but in ADODB I can't seem to use it. Thanks to internet search engines, users are used to searching for text but unfortunately even the desktop search tools can't look into tables (easily). If you want to stick with a recordset you could use a full SQL statement originally or use the filter property or modify your find string. Want to reply to this thread or ask your own question? You'll need to choose a username for the site, which only take a couple of moments. Many situations in Access require that you create strings that supply search criteria. Locates the first record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only). In order to use this object you may need to add reference to ADODB object library. The FindFirst method has a parameter where you can specify a search criteria, basically a WHERE clause without the Where keyword. The DLookup function returns any datatype such as a string, numeric, date, etc. A table is a special type of range that offers the convenience of referencing named ranges. Microsoft Access modules are either Standard modules or Class modules. A programmer's analysis of the numbers for each type of credit card generates a series of visual basic data validation checks shown below: Private Sub CC_Exp_Enter(). Anyway, once I've established the data and how I intend to show compatible HDDs, I need to make a form that will allow me to select computer builds and the compatible HDDs. Description. Access Vba Create Recordset From Recordset. Web Applications Specialist Certificate. findfirst strcriteria. Though 32-bit Windows is multithreaded, this helps only if the applications running under it are also multithreaded. What version of Access are you using? I think I would blame that strange behavior on some kind of corruption and suggest that you first make a backup copy of front end db. Lets make an analysis of the following simple example. CascadeTree The eXCascadeTree component is a multiple-columns-tree-view component that uses miller columns visualization to display your data. The following diagram has an overview of the OAuth flow:. VBA AutoFilter using Greater Than and Less Than. OpenRecordset(Name, Type(Optional), Options(Optional), LockEdit(Optional)) expression A variable that represents a Database object. > So i have written code in VBA (MS Access) which takes bits of information, > copies it to an excel sheet, formats it per the requirement specifications > and then moves it to Outlook. In DAO i can use the FindFirst Method easily, but in ADODB I can't seem to use it. The select case visual basic command takes the place of multiple nested if statements and makes your VB code clean and much easier to follow by neatly handling the conditional flow of your VBA programming code. Access 2007 introduces the multivalue field. Recordsets act like a cursor or a ruler underneath a row of data. #microsoftaccess #tutorials www. MS Access VBA data type mismatch in function I have a database containing locations of water wells and a ton of properties associated with those wells. Applies to: Access 2013, Office 2013. findfirst on a dao recordset with the criteria from another dao recordset? I'll try to explain more with code that may not be right but you should get the idea. Access data is stored in multiple tables. findfirst in an Access you rs. Description. To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. Recordset, ADODB. In other words, if you select a value in an unbound control for one record all the records will have that control with that value. The first approach is to use an embedded select. expression. You may have noticed that it's possible to tie up Access with a simple bit of VBA code. For instance:. AddMenu Add a custom menu bar/shortcut bar. Access VBA – change Query criteria. Welcome to the p2p. You can use the FindRecord action in Access desktop databases to find the first instance of data that meets the criteria specified by the FindRecord arguments. Access 2007 introduced the possibility that a field in a recordset may itself be a recordset. The word 'Divider' can appear at any point of the 'formname' field, so I would like to have code that sets the Visible property of the checkbox to False if the 'formname' field contains the word 'Divider'. ApplyFilter Apply a filter clause to a table, form, or report. >'AIR CODE >dim rs as dao. You can also send multiple messages using the CC function or looping through a record set and sending each email individually. Welcome to the p2p. FindRecord be used to find records for which a given text field is either Null or zero length string? Can DoCmd. Programming Microsoft Access with VBA can be a lot easier if you know the keyboard shortcuts for the most common commands and tasks and the most common bits of code that you’ll use in the editor and immediate windows as you build and debug your Access application. recordsetclone bookmark findfirst with 2 criteria Modules & VBA. Describes how to programmatically move to a specific record from a Combo Box selection in Microsoft Access. user_id is the corresponding foreign key in widgets. When you OpenRecordset() on a local table, it defaults to a Table type (dbOpenTable. How to find position of first/last number in a text string in Excel? For example, you have a list of text string which is a mixture of letters and numbers. Click the list arrow in a. The button (cmdFind) is meant to find the record for the part # (entered into text box txtFindPart), and then populate the data into In1-52 and out1-52. Re: search a recordset using multiple criteria Is there a particular reason that you want to use something like. findfirst in an Access you rs. However, tables are not created in the same manner as other ranges. Their purpose is self-evident, given their names, and you can use them on all recordset types. Many situations in Access require that you create strings that supply search criteria. For example, proper SQL syntax, proper VBA syntax, and proper referencing of controls are three common points. Note: This method always use with NoMatch property to determine whether the process of finding has succeeded. We can also pass multiple parameters to another form using this method, and the following tutorial details how to perform this task. If your project contains references to both the Data Access Objects (DAO) library and the ActiveX Data Objects (ADO) library, you may see multiple Recordset entries in the list when you dimension the Recordset object. All Index : This page lists all of VB Helper's source code, examples, tutorials, essays, and book content. Instant access. All of the methods here actually carry out an action with the same name as the method. Applies to: Access 2013, Office 2013. "Hi All, I am trying to use a combo box to go directly to a specific record, but i am unable to. The OraAttribute object represents an attribute of a Value or REF instance of an OraObject or an OraRef. To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for. You can use the Option Compare Binary statement in the declarations section of a module to force VBA to make string comparisons that are case-sensitive within the bounds of that module, but this affects only string comparisons made in a VBA module, not comparisons made by the Jet engine. Find record by using Recordset. This is done using the FindFirst method and a SQL expression that supplies the appropriate field name and value. A presentation at TechEd2006 Sydney in August 2006 by Adelaide Dot Net User Group member Steve Koop on Migrating, Converting and Upsizing to SQL Server from Microsoft Access. QueryDefs are stored queries that reside in Access. FindRecord be used to find records for which a given text field is either Null or zero length string? Can DoCmd. blueclaw-db. To add criteria to an Access query, open the query in Design view and identify the fields (columns) you want to specify criteria for. Lets make an analysis of the following simple example. If you want to stick with a recordset you could use a full SQL statement originally or use the filter property or modify your find string. I need to limit the Selection. However, I. We've included the description of the action, rather than the description of the method (which merely calls the action). For more information on how to create a named table, see Chapter 6, “Creating and Manipulating Names in VBA. Manipulate QueryDefs From VBA. OraAttribute Object. dir c: s -h *. This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Access 2002 (Access XP) starts with letter A that have been released. Browse other questions tagged vba ms-access-2010 criteria findfirst or ask your own question. Previously in the article Iterate and Search for Values in a Table, Access VBA I've explained how you can perform searches on a recordset object using a simple iteration. In this article I will explain how you can perform searches on Recordsets using queries. From Access VBA Programming For Dummies. If there is not a reference then you just need to tick the relevant check box. What I thought I could do is use multiple criteria in the rs. Finding a Record Based on Multiple Criteria : Recordset Find « Access « VBA / Excel / Access / Word. There is a lot to data field validation for credit card numbers. column(0) and combobox. You can use the Option Compare Binary statement in the declarations section of a module to force VBA to make string comparisons that are case-sensitive within the bounds of that module, but this affects only string comparisons made in a VBA module, not comparisons made by the Jet engine. This article demonstrates how. Though 32-bit Windows is multithreaded, this helps only if the applications running under it are also multithreaded. If the Find method does not locate any records, the cursor ends up at the very beginning or end of the Recordset (depending on the setting of the searchDirection argument), and the BOF or EOF property will be True. In Access VBA, you can change the Query criteria using QueryDef. Because the Find methods enable you to specify any field in the criteria, they may not be capable of using a table's indexes to execute a search. Here's my sample code:. 1270 Chapter 30 Understanding Universal Data Access, OLE DB, and ADO Connecting to the NorthwindCS MSDE Database Creating an ADODB. Gerard Verschuuren query, or form - something similar to what I can do in queries with wild-cards. Move 3 rstVideos. This includes Visual Basic, Visual C++, Visual Basic for Applications (VBA), IIS Active Server Pages (VBScript and JavaScript), and others. It appears that the executing VBA code ties up Access’s processing, so the multithreaded nature of Windows doesn’t help. Recordsets have many methods and properties to make working with the records in the collection easy. However, I. Instead of opening a recordset try using the DLOOKUP function which accepts a field to lookup, tablename and a criteria statement. recordset >dim str criteria as string >set rs = currentdb. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. " VBA Access (31) VBA Excel 2010 (5). O Scribd é o maior site social de leitura e publicação do mundo. Using a Microsoft Access Combo Box to Search for a Record: In the previous article, we looked at Creating Event Procedures in Microsoft Access. Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Unfortunately most end up using a VBA loop instead of the Find Method. Browse other questions tagged vba ms-access-2010 criteria findfirst or ask your own question. While does not have a Until version. 10+ mistakes to avoid when using VBA Recordset objects. Not surprisingly then, the Find methods are usually far slower than using Seek. Jeg har en fil (Fil1) som indeholder en liste med projektnumre i kolonne A, angivelse af aktiv/lukket i kolonne B og et forecast pr. >'AIR CODE >dim rs as dao. A table is a special type of range that offers the convenience of referencing named ranges. 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. Welcome to Ron de Bruin Excel Automation. Excel Find Method in Excel VBA. FindFirst strCriteriaOf course, you would likely get your variable. For more information on how to create a named table, see Chapter 6, “Creating and Manipulating Names in VBA. The other important factor to consider is that JET requires the date format to be mm/dd/yyyy as opposed to the normal dd/mm/yyyy. OpenRecordset(Name, Type(Optional), Options(Optional), LockEdit(Optional)) expression A variable that represents a Database object. 6 months ago. For a more focused listing, go to the Index Categories or the Search Page. #1 Set your references. For example, proper SQL syntax, proper VBA syntax, and proper referencing of controls are three common points. There are basically three techniques used to dynamically filter recordsets an Access Visual Basic where a continuous form is being used. Das funktioniert in der Form (s. FindNext(Criteria) expression. Building SQL Queries with Date/Time Criteria in VBA. Access VBA - change Query criteria. Using a Microsoft Access Combo Box to Search for a Record: In the previous article, we looked at Creating Event Procedures in Microsoft Access. If the Find method does not locate any records, the cursor ends up at the very beginning or end of the Recordset (depending on the setting of the searchDirection argument), and the BOF or EOF property will be True. findfirst in an Access you rs. Many types of files can be stored in a column which has the attachment data type. What I thought I could do is use multiple criteria in the rs. Can you confirm that there is a reference to the Microsoft Office 12 Access database engine Object Library. When to use a form's recordset and when to use recordsetclone Recordsets are an essential tool of any Access programmer, there are many types and are used in a wide range of situations, today we're going to talk about form recordsets and provide some examples of their use. For instance:. When it comes to matching text values, sometimes there won't be an exact text string to find. If you did, you would be best served by using an action query because queries operate much faster on large numbers of rows than do row processing methods (recordsets). Excel Find Method in Excel VBA. Browse other questions tagged vba ms-access-2010 criteria findfirst or ask your own question. Hola Buenas, gracias de antemano. Is this common or have I made a simple mistake. Sometimes you want to open a second form to the same record displayed on the first, but you still want to have all records available to the user. I think I know what the problem could be. I am unable to access the macro's source code and when I try to record the macro then run the addon, all that is displayed in the macro is to select the cell to start in. Access normally performs case-insensitive string comparisons. In the first tutorial in this series on Access and SQL I explained where SQL fitted into the overall Access picture. You know, you're lucky to get this question answered; after all, this looks as though it's going to be the very last Hey, Scripting Guy! column ever. openrecordset("table1") >strCriteria = "PK = 10" >if not rs. numerical values, alphabetic characters or Boolean values. Can somebody help me with this pls. The DLookup function can be used in the following versions of Microsoft Access: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000; Example. Use the findfirst method 2. Their purpose is self-evident, given their names, and you can use them on all recordset types. Multiple Criteria In FindFirst Multiple Criteria In FindFirst. The first approach is to use an embedded select. Just like all Time Intelligence functions in DAX, each function takes a column of dates as one of its arguments. You can use the Option Compare Binary statement in the declarations section of a module to force VBA to make string comparisons that are case-sensitive within the bounds of that module, but this affects only string comparisons made in a VBA module, not comparisons made by the Jet engine. Tutorial: NotInList - Adding values to lookup tables. > So i have written code in VBA (MS Access) which takes bits of information, > copies it to an excel sheet, formats it per the requirement specifications > and then moves it to Outlook. From Access VBA Programming For Dummies. Well this tutorial is written with the main prospective of how to resolve this particular Access 3615 - "Type Mismatch in expression" error code. This article demonstrates how. If your project contains references to both the Data Access Objects (DAO) library and the ActiveX Data Objects (ADO) library, you may see multiple Recordset entries in the list when you dimension the Recordset object. i just need a code on how to make the output comes out. Ms Access 2007 Findfirst Example windows 10 free upgrade download for xp quickbooks checks printing in reverse order quickbooks for small business reviewsIs it possible to use more than one set of criteria when using recordset. In some cases, the same reason appears on different site lists with different code numbers. Muito mais do que documentos. Gerard Verschuuren query, or form - something similar to what I can do in queries with wild-cards. First of all i'm a novice, so take it easy on me! I have an access 2000 database with multiple. You can use the FindRecord action in Access desktop databases to find the first instance of data that meets the criteria specified by the FindRecord arguments. If perhaps it included alot more photos it would definitely be perhaps even even better. I think I know what the problem could be. Executing SQL Statements in VBA Code By Danny Lesandrini There are a number of ways to execute a SQL Data Manipulation Language (DML) statement from Microsoft Access , besides the obvious process of creating an Action Query and double-clicking its icon. findfirst with another dao recordset What would be the most optimum way to. Application ' Create instance of Access Application object. Microsoft Access; VBA. Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a form or report. ' note that the two VB lines above actually need to be on one line to run the data validation End Sub. findfirst strcriteria. column(1) to get the two values necessary to find the record. Value = "Frank Marshall" rstVideos. Any idea to do this?. Findfirst Recordset Function. My code works fine when FindFirst-ing "Ref='XYZ'", but as soon as I make it "Ref='XYZ' AND CustDate=#12-31-2010#" it freezes and I have to EndTask Access. It replaces greatly the VBA InStr function when needing to check if a certain substring. Multiple Criteria In FindFirst Multiple Criteria In FindFirst. I'm using FindFirst method in Access VBA to find a particular record in a recordset. Can you confirm that there is a reference to the Microsoft Office 12 Access database engine Object Library. Findfirst (locate a string) - code help pls VBA. Manual Vba Access 2007 Recordset Find Total Visual CodeTools manual Supports Office/Access 2010, 2007, 2003, 2002, 2000, and Visual Basic 6. FindRecord to find a record depending on your criteria. FactoryTalk VantagePoint EMI Student Manual For Rockwell and Partner Use Only. Recordset types in VBA on a query or attached table, Access defaults to a Dynaset type (e. Want to reply to this thread or ask your own question? You'll need to choose a username for the site, which only take a couple of moments. Sample Database: LinkingTwoSubforms. Microsoft Access modules are either Standard modules or Class modules. "Hi All, I am trying to use a combo box to go directly to a specific record, but i am unable to. >If you want to find multiple instances of a criteria use the >FindFirst/FindNext methods. Constructing SQL statements in VBA, however, requires additional attention to syntax and is not as user friendly when reviewing someone else's code. All Index : This page lists all of VB Helper's source code, examples, tutorials, essays, and book content. My name is Ron de Bruin and I live in the Netherlands. Find search to alter some text. Each of the subforms have been created from queries. This might be several records, a whole lot of records, or just one. Access Database Design. Because the Jet database engine has no knowledge of VBA or its variables, you must supply the actual values before you apply any search criteria or perform lookups. Edit rstVideos("Director"). Thompson, Microsoft Access MVP. Here is a previous answer by Roger Carlson from the discussion group. Any code that examines the Fields of a recordset or applies criteria is affected. Using a RecordsetClone with Microsoft Access Subforms Provided by: FMS Development Team. i follow and copy some of your code that will help my program but no luck. This sample project demonstrates using the ADO Find method to locate records in a Jet database. Jeg har en fil (Fil1) som indeholder en liste med projektnumre i kolonne A, angivelse af aktiv/lukket i kolonne B og et forecast pr. I have a large table with one of the columns as 'CID' and there are multiple rows in this table with the same CID value. How to Convert Numbers to Text in Microsoft Access. You can sort Access data so you can view records in the order you want to view them, and you can filter data so you only see the records you want to see. FindFirst "String Criteria Here" with a Record which is more a less a structure with multiple value. Access Newsgroups. Sometimes you want to open a second form to the same record displayed on the first, but you still want to have all records available to the user. A table is a special type of range that offers the convenience of referencing named ranges. Thompson, Microsoft Access MVP. Elements Satisfying Multiple Conditions. How to Use Recordset. The VBA Like operator is something so useful I am often surprised how rarely it is used in Excel and Access VBA. Microsoft Access modules are either Standard modules or Class modules. Copy the code in a Standard module of your workbook, if you just started with VBA see this page. Extension method is a static method that we can call from an instance object which implement IEnumerable interface. It is easy to change Query criteria in Query View, but sometimes your criteria may depend on a variable that is not a constant. Tutorial: NotInList - Adding values to lookup tables. I just can't figure out how to use the query to build parameters. How to Use Find in Excel VBA Macros. Open Live Script. The fragments on this page and in the list below are included in the Access VBA library. #microsoftaccess #tutorials www. Access Database Design & Programming, 3rd Edition. Find, and will also reduce the workload for getting the records. OpenRecordset(Name, Type(Optional), Options(Optional), LockEdit(Optional)) expression A variable that represents a Database object. Finding Records Using the Find Method : Recordset Find « Access « VBA / Excel / Access / Word Finding Records Using the Find Method Finding a Record Based. Often you will use this property to perform an operation, then synchronize the form with the underlying recordset. Click the list arrow in a. I have tried using Docmd. Find, rather than opening a new recordset containing the appropriate items? Opening a new recordset will avoid the limitations of. I would like to make a DLookup. In the generic form of the formula (above), name is a full name, with a space separating the first name from other parts of the name. You can check this by opening the VBA editor, clicking the TOOLS menu, and then REFERENCES. These QueryDefs can be opened and modified using VBA. The different between the VBA While and the VBA Do Loop is : While can only have a condition at the start of the loop. VBA is "Visual Basic for application". In fact, QueryDef. The Findfirst command is also useful for coordinating forms that are not part of a master/detail relationship. The different between the VBA While and the VBA Do Loop is : While can only have a condition at the start of the loop. Find and Replace All With Excel VBA The one downside to using the COUNTIF() function is it will not count multiple occurrences within a single cell. eof then > rs. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. Hello, I have spent more than 5 hours so far to make the FindFirst command work for a date value, and still made no progress. A programmer's analysis of the numbers for each type of credit card generates a series of visual basic data validation checks shown below: Private Sub CC_Exp_Enter(). Access Newsgroups. A Recordset object consist of records and columns (fields). and Access would know exactly what you meant. findfirst in an Access you rs. For instance this is the case with a UNION statement, where two tables are to be concatenated one after the other. They work on linked tables too. OpenRecordset("Videos") rstVideos. enter the criteria in the Criteria row. The list is daily updated. For instance:. That difference is that any control in the detail section is really a copy on that control for each row. hi guys, i have this FindFirst criterion block that checks for multiple criteria. No todas las consultas deben incluir criterios, pero si no le interesa ver todos los registros que están almacenados en el origen de registros subyacente, deberá agregar criterios a una consulta cuando la diseñe. For a more focused listing, go to the Index Categories or the Search Page. zip (26K) Microsoft Access makes it easy to see related records on forms. The Findfirst command is also useful for coordinating forms that are not part of a master/detail relationship. The list is daily updated. Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a form or report. FindRecord to find a record depending on your criteria. Recordset, ADODB. The Microsoft Access DFirst function returns the first value from an Access table (or domain). Here's my sample code:. To Switch Views: Click the Home tab on the Ribbon and click the View button in the Views group. >If you want to find multiple instances of a criteria use the >FindFirst/FindNext methods. In this article I will explain how you can read data from an Access table using VBA. There is a lot to data field validation for credit card numbers. Well this tutorial is written with the main prospective of how to resolve this particular Access 3615 - "Type Mismatch in expression" error code. What I thought I could do is use multiple criteria in the rs. You can even learn a lot more about VBA if you want. FindFirst strCriteriaOf course, you would likely get your variable. Often, a pattern or initial letter, prefix, or suffix will serve as the selection criteria. Can you confirm that there is a reference to the Microsoft Office 12 Access database engine Object Library. Rows[1]; Here, the entire first row will be placed in the dRow variable. Description. There is a lot to data field validation for credit card numbers. For my example I've invented 1 field, but you may have a more complex set of criteria to apply (possibly multiple fields and varying conditions / situations to consider). Copy the code in a Standard module of your workbook, if you just started with VBA see this page. You'll also learn how to troubleshoot, trace errors, and fix problems. How to Convert Numbers to Text in Microsoft Access. numerical values, alphabetic characters or Boolean values. In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). So when you want to have data from multiple tables on a data entry form, you set it up to display the data not store it in the form’s Recordsource There are basically four ways to display related data on a form; Subforms, The Column property, DLookups and Listboxes. AutoTextGroup. Hello, I have spent more than 5 hours so far to make the FindFirst command work for a date value, and still made no progress. To Switch Views: Click the Home tab on the Ribbon and click the View button in the Views group. On another page, I have a TotalValue field that takes the sum of the costs for each project, and multiplies it by 1,000,000. I don't think it's possible for a macro to have two criteria in a FindRecord action since it can only access the bound column in a combo box, so I have been trying to do it with a module, since in a module I can use combobox. You gotta type a catalog number whose first character is a letter between A and M. but have NO IDEA why the VBA says what it says and am not at all sure what it's matching to to find the records is legit. The OraAttribute object represents an attribute of a Value or REF instance of an OraObject or an OraRef. Now, it so happens that the majority of Access VBA programming is an example of EDP (it also has some aspects of OOP mixed in), and that's what this topic is all about.