Recent content by Lilli

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.