Solved

Access 2007 recordset question

Posted on 2008-10-31
3
307 Views
Last Modified: 2013-11-27
2nd Access question of the day

pretty simple code here but i'm doing something wrong at the end
I have a table named Checking and a field named Balance but the message box comes back empty

Dim db As Database
Set db = currentdb

   Dim rs As DAO.Recordset
     
   
   Set rs = db.OpenRecordset("Checking")

   
 rs.MoveLast
 
   
   MsgBox Balance

any help is appreciated

0
Comment
Question by:TSTechNA
  • 2
3 Comments
 
LVL 82

Accepted Solution

by:
hielo earned 500 total points
Comment Utility
try:
MsgBox rs.Fields("Balance")
0
 

Author Comment

by:TSTechNA
Comment Utility
thank you
0
 
LVL 82

Expert Comment

by:hielo
Comment Utility
you are welcome
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now