Search results

First off, thank you very much for the attachment DjKarl, a quick demonstration is worth a thousand explanations with programming, and so I appreciated it very much. Please bear with me, my post is a lot shorter than it looks! I was actually referring to the records themselves, next record...

Does anyone know where I can find an online sample/example with usage of ADO movenext, ADO moveprevious? I specifically want to fill two controls (NextDate and PreviousDate) with information from another control (TheDate): NextDate showing the next date in the recordset and PreviousDate...

Dr Karl, Could you please show an example of how you'd use this function - perhaps a small table. How do you reference it from a sub so that a previous value or next value appear in PrevValue/NxtValue controls on a form.

Hello forum, How do you keep users from viewing a form in its "design view" format?

Thank you very much guys. Your solutions were really clever and most of all, they worked perfectly for what I needed.

Does VBA have a "timer" constant that allows it to figure out the amount of time someone spent logged on?

Shirley, if it will help, here's a demonstration from Microsoft using DAO. I found parts of it difficult and esoteric to understand without use of an actual recordset in the demonstration - perhaps you're a lot smarter and will find better use of it! PREVIOUS AND NEXT RECORD...

:D :D :D Can Understand Shirley's frustration! This question has dogged me for so long and i have asked so many questions related to moveprevious and movenext but got no simple & direct answers. Is there a reason MS made it so mind-bending to pull out a value from an adjacent field...

I was very happy to find the above solution to a problem similar to mine...until I tried the solution using the tables in its example and also copying and pasting the code into a new standard module. Just to test it out, I made tblSKU and tblLinkedList along with the fields and datatypes used...

This was a problem someone else proposed on a different site. Greetings. I need help writing a Query or Visual Basic code in MS Access. I'm not sure which is the solution. I'm trying to create a table that will find the next and previous sequential records in a table. Additionally, this...

Yes Keith, I did (foolishly) forget to mention my ID field. The tblTimeSheet does in fact have a Primary Key. However, after the filter is applied in the form (according to the worker's name), the number ID's rise with each row but by unpredictable changes. I suspected that the calculated...

Doc This is a very informative post. Thank you very much. I will try out the bookmarking tips after some further reading on how.

Thank you Keith, The table/form in question is really intended to calculate the hours that contractors in a company spent working as well as the hours inbetween jobs. Here's a description of the objects involved: Table: tblTimeSheet Fields: Starttime, EndTime, HrsWrkd and TimeInBtwn...

Thank you Bob, The current record to the one preceding it and the one immediately following without use of an ordered ID field. For example, I have two columns one for start time one for end time, I would like to compare the last end time to the current start time and the next start time to...

It seems that comparing records is tougher than I thought too. I've been trying to get help on the same subject for a long time.

How do you calculate the difference between dates in adjacent records? The records are filtered by the way, so I can't use Dlookup because they do not have an autonumber-type ID. For example, if we're calculating the number of days between listed Holidays - Christmas (25/12/2007) is followed...

Does anyone know how to do either of the two above?

Thank you very much for the response, Bob. I appreciated it a lot. Is there a simpler way to place a next value in the current row? Nothing seems to be working - not even the dmax. All I got when I attempted to create the autonumber-like count you suggested in my query expression was the...

Does this problem have an easier solution?

Thank you mhartman for the response. I'll look up your suggestion. Hopefully it will work a lot easier. By the way, there are JUST a few parts that I am not understanding what to do with in this Microsoft formula for previous dates. I have underlined them: ' PURPOSE: Retrieve a value...