Recent content by Kenny2003

Hi Remou, What can I say except Thank You, your suggestion was exactly what I was looking for and worked first time. Thank you again, Kenny

Hi gang, For some bizzare reason I am having terrible trouble setting up a simple query. I want to have a form where the user types two values into two text boxes (FirstName and LastName)and the user then clicks a command button. When they do access will open another form that shows the...

Hi earthandfire, Thank you for your reply. I have tried to get the functions that are on the site you suggested to work in my db but no luck. Is there another way, the major drawback of the example on that site is you have to get the user to install a DLL file first before thay can use the...

Hi all, If I place my cursor anywhere in my db window and move the "middle" mouse wheel access scrolls through it's records. Now I have a set of custom navigation buttons on my form that I created (with help of members of this forum) and I would like to have it so that access only scrolls the...

Hi TheAceMan1, What can I say - You really are a complete star!! It all works great, thank you so so so much, I am really in your debt. I can sincerely say that I am very grateful indeed to you for helping me and staying with it. Thank you so much again, Best Wishes Kenny

Hi TheAceMan1 Thank you so so much for taking the time to help me. I especially appreciate the fact that you looked up some stuff in your library, not everyone would do that -thank you. OK, I did exactly as you suggested and.. yes, yet again rotton old Access threw up an error. As soon as I...

Hi RoyVidar Thanks for the post and the suggestion. You code kinda worked, the text box CurRec simply displayed "1 of 1" regardless of which record I was viewing. I think we are getting close to cracking this but I am at the mercy of you guys. Thanks again, Kenny

Hi RoyVidar, Thank you for the reply and code suggestion. It kind of works, it displays "1 of 1" no mater what record you are looking at and no matter if you click the Next Record, Prev Record and so on. Any further suggestions please? Regards, Kennyh

Hey Ya TheAceMan1 I tried your suggestion but I get the exact same error as before. I am using Access 2000 (9.0.2720) Kenny

Hi TheAceMAn1, Boy oh boy am I making you work tonite - Cant express my gratitude enough. OK, I did exactly as you said above except I changed the line "Set frm = Forms!frmMain" to Set frm = Forms!frmPlant_Main as frmPlant_Main is the name of my main form which has the text box CurRec - Is...

Hey ya TheAceMan1, Thanks for the suggestion. I tried out the code as you suggested but Access throws up Run-Time error '2455' You entered an expression that has an invalid reference to the property CurrentRecord. I have tried referring to CurRec in various different ways but I just cant seem...

Actually let me update my question about record counters. I have worked out the following code which I have placed in the subforms "on Current" event. It works fine except that when you open the form it says "Record 1 of 1" even though I have 12 records in the database. It only displays the...

Can I be Cheeky and throw a wild card question at you guys, well two questions if I may be so bold. As I have the custom navigation buttons working, I would like to add a record counter to display something like "Record 1 of 10". I have searched this forum before asking and the few posts I can...

Indeed, but in my case its normally dim to dimmer but its YOU guys that make it a supernova :)

DAMN Guys, It works !!!!!!!!! Its like a weight has been suddenly lifted. This shows my lack of knowledge in Access matters. I did not know about the Sub-Form control name can be different to the actual sub-form name. I have learnt a big lession here and I want to thank you both. Thank you, I...