Getting Index of the current record in an access table

Expand Post »

I'm trying to make an event procedure in VBA that will compare the same field of two records for a conditional statement. Here is some psudocode of what I want:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
If myTable.thisField[currRecord] == myTable.thisField[currRecord+1] then
   // Run a Query
If myTable.thisField[currRecord] == myTable.thisField[currRecord+1] then
   // Run a Query

Does anyone know the VBA code for this? Thanks.

Last edited by SlyMaelstrom; Dec 27th, 2006 at 11:58 am.

Similar Threads

sql query problem with MS Access and C# in C#
Shopping Cart Not Working in ASP.NET
How to set permission to access a table on another database? in MS SQL
computer making loud clicking noise when booting up! what does it mean in Storage
Problem Amending Database Table in Visual Basic 4 / 5 / 6

SlyMaelstrom

Reputation Points: 15

Solved Threads: 2

Newbie Poster

Offline

21 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: license code

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Mail Server Question

DaniWeb Message

Cancel Changes

User Name
Password