By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

still problems with movelast

P: 58
Hello again,

I have a table that once the user logs in, it adds the crews info (crew, date, and keeps track of numbers that the user adds during the day). It also has an autonumber. The problem I am having is that the addnew works great, it adds the user and their info. Problem is later on during the program, when the user adds info during the day, I open the recordset and change the numbers as the user enters the info (eg. number of bags, number of cans). This is supposed to be a running total throughout the day. When I open the recordset and put in rs.movelast, it only goes to like 10 records in and adds all the numbers on to that record. So the record gets all the numbers. It adds the numbers correctly and changes all the info needed to be changed, it just does not go to the last record. I do not know why this is.

Andrew
Oct 15 '07 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,487
I'm not sure why you'd use MoveLast in your logic. Surely there is data in the record which identifies the one you need to update (uniquely). Is it even safe to assume all day that the record you want is necessarily still last?
This issue should never arise as you should always be specifying the record you're interested in.
Oct 15 '07 #2

P: 58
actually i was just thinking the same thing after i posted it. Thanks

Andrew
Oct 15 '07 #3

NeoPa
Expert Mod 15k+
P: 31,487
No worries Andrew. Another easy one then ;)
Oct 15 '07 #4

P: 58
You guys have no idea how much help you have been. And very quick at replies too.

Thanks alot.

Andrew
Oct 15 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.