Search results

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...

Thanks again for your responses. Rabbie - I started afresh and followed your instructions and example. However, it still doesn't work. When I try to select a weather condition, the debugger pops up and a line is highlighted in yellow Me.OLEBound36.Picture = "D:\XYZ\Weather_images\sultry.bmp" as...

Ah .............. found it .......... here is my DB thus far:

I would be overjoyed for you to look at it (such as it is !) Can you tell me how and where to do such a thing ? Do you read French or shall I make a copy in English ? No problem for that. Paul

Rebonjour ! I have copied & pasted your suggestion code and receive the following error message: << Microsoft Office Access can't find the macro 'If me' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname...

Again, thank you for all your time & effort in responding so quickly. I have copied and pasted your code into the "on change" box of the properties of my "forecast.day" combo box ............. and get exactly the same error message ! Beginning slowly to despair ! Any other way of doing this ? PC