Recent content by Paulcliman

Yes .................. that worked !

Once again - many thanks for such speedy responses. Fascinating results. I made two copies of my database and used each to try out each of your ideas. Missinglinq - yours worked & sent me straight to today's record DCrake - yours worked (sort of) sending me directly to YESTERDAY'S record ! Maybe...

here it is .....

Corrected the typo - did the Ctrl-G thing and got the value 0 Saved everything and went back to the db, but the form still opens at record 1

Well, I've just given this my best shot, but the debugger doesn't like Date() and insists on removing the brackets?? Also, can I (dare I) question the first bit of your line: I = Nz(DCount(*","YourQuery","[YourDate] < #" & Date() &"#"),0) is there really an asterisk in there or should it be...

Indeed - it occured to me later that my question must have been an irrelevance ! This is what I came up with as a procedure on the OnLoad event of the form : Private Sub Form_Load() On Error Goto Err_MyProc Dim db as Database Dim rst As Recordset Set db = CurrentDb()...

Maybe I've misled you - in fact, the data entry form I want to adjust actually loads from a switchboard form. Does that make a diiference to your suggestion?

My "Weather" database is working well, thanks to help & advice here. The data entry form poses a problem for me. Since the last record will be 4 days in advance (it being forecasts) and the first record becomes increasingly distant in the past as days go by, is there ANY way of making a form...

Been fishing this morning - caught enough to keep me fed for weeks. I'm told it's very good for the brain too ! Thanks again for your help

Thanks Simon for your version of my problem -aprreciated. DCrake - this is for you specifically - I thought all was well until I came to enter data this morning and discovered that, for some reason, the night image forecast does not remain on the form. What I mean is that I select a "night time"...

I have done all my homework, tried to follow your reasoning and what you have done, deleted the old tables, redirected the image file paths, added the code, and .................... IT WORKS ! I am now up and running (until the next advance I seek) and I REALLY cannot thank you enough especially...

Hello Simon, Thanks for your interest & help. Here attached (& still have some work to do on them but that's not important for now) are the images..

Thank you for your advice, but I don't really understand what change you are suggesting. I am SOO close to getting what I need thanks to DCrake and I just need to know how to add the last piece of code (file attached again) Everything works as I hoped it would apart from the "night forecast" bit...

I am guessing you are / used to be a teacher ! Thank you for making me work; however, I have done everything (I think) except the OnCurrent Event. First I tried replicating it and using all the "night" references, but it didn't like the fact that there were now TWO identical events. Then I tried...

Hello again Thank you for the help. I fear my ignorance gets me deeper & deeper into trouble. I have made all the changes you mentioned 2 tables now changed to a text (bitmap path) rather than OLE package. Changed the OLE bound boxes to Image boxes. I have added your code to my "day forecast...