I Need VBA Assistance to point a variable to a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

I need to know a VBA command to set an integer variable in an Access module
to be pointed to a certain record number in a table so that the variable
takes on whatever value is in the record. Any suggestions? Thanks.
 
if you need to get a record say #25, then you can get top 25 from your
table:

select top 25 * from MyTable

open this query in a recordset, then move to the last record and get
necessary field value
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I Need VBA Assistance To Set a Variable to a table record 2
VBA: How can I use a string variable as autofilter criteria? 4
Example Of VBA SQL Statement 0
How to set the value of a VBA variable with a command button 1
Finding a record with composite key 6
How to export table from outlook into ms access table? 0
Assigning field values to VBA variables and vice-versa 6
Static and Global Variables 9

Back
Top