|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
How to compare recordsets in access vba I am trying to create a report that uses a public varible to update the reports recordset. I have 2 tables, parent categories and child categories relating to products for an online shop. But, at runtime the report opens as if there is no recordset. What am I doing wrong? |
#2
| |||
| |||
Re: How to compare recordsets in access vba The Recordset property returns the recordset object that provides the data being browsed in a form, report, list box control, or combo box control. There are different types of DAO recordset, with different methods. When you OpenRecordset() on a query or attached table, Access defaults to a Dynaset type (dbOpenDynaset). When you OpenRecordset() on a local table, it defaults to a Table type (dbOpenTable.)If a form is based on a query, for example, referring to the Recordset property is the equivalent of cloning a Recordset object by using the same query. |
#3
| |||
| |||
Re: How to compare recordsets in access vba Changing a form's Recordset property may also change the RecordSource, RecordsetType, and RecordLocks properties. For recordsets based on queries, SQL statements, and attached tables, the RecordCount property returns the number of records accessed so far. Also, some data-related properties may be overridden, for example, the Filter, FilterOn, OrderBy, and OrderByOn properties. |
#4
| |||
| |||
Re: How to compare recordsets in access vba I know how to do it in queries, but I think I need to use VBA because i am firstly using user selected fields, When you first OpenRecordset(), Access grabs the first record, and keeps processing your code while the others load. So, if you test RecordCount immediately after you OpenRecordset, you typically get 0 (from a form) and secondly, I am not checking for duplicates, I am basically going through a list of transactions to find any returns. |
![]() |
|
Tags: access vba, child categories, compare recordsets, excel password, public varible |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
compare 2 spreadsheets like recordsets? possible? | jacDaRippa | Windows Software | 1 | 14-01-2012 06:35 PM |
Compare HD+ vs FHD | Bon-hwa | Hardware Peripherals | 4 | 12-09-2010 07:12 AM |
Beyond Compare for Mac OS X | Gillian Anderson | Windows Software | 5 | 27-05-2010 10:40 AM |
How to Compare Two Strings in C | Pratim | Software Development | 3 | 28-12-2009 11:10 AM |
Compare T1 and DSL Connections | BakshiK | India BroadBand | 3 | 19-06-2009 09:27 AM |