Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 24-09-2009
Member
 
Join Date: Feb 2009
Posts: 40
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?
Reply With Quote
  #2  
Old 24-09-2009
Member
 
Join Date: Oct 2008
Posts: 38
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.
Reply With Quote
  #3  
Old 24-09-2009
Member
 
Join Date: Dec 2008
Posts: 21
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.
Reply With Quote
  #4  
Old 24-09-2009
Member
 
Join Date: Apr 2008
Posts: 142
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to compare recordsets in access vba"
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


All times are GMT +5.5. The time now is 02:34 PM.