Search results for query: *

...is opened, the event procedure I have got working so far works for any given row. The code goes... Private Sub Form_Open(Cancel As Integer) '***** set up the rows to visible if there is a task defined If Task1 > "" Then Task1.Visible = True Complete1.Visible = True...

...stage without your help in clarifying my mind as to what I was trying, wanting and needing to do - so a star! Your efforts were not wasted and I thoroughly appreciate them. Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...It may (probably) looks as though a serious redesign would be a sensible answer - both of the database and my question! - and I shall feed back later... however things work out. ************************************* OK, I'm stoopid. But I'm good at it! *************************************

Trying again! ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...into total implosion and formed a black hole in my cranium and I'm admitting defeat on a simple question. Can anyone save the sanity of me, and thus the wife and cat? TIA Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

PHV Can't really see a difference - but I am stoopid! Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

Simultaneous replies! Bear with me while I try. Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...clicking 'Start Filter'. I could live with this. But... Is there a way of creating a recordset that is empty on opening and then populating it with the result of the filter? Chris ************************************* OK, I'm stoopid. But I'm good at it...

Aaahh!! A bit of progress! The form opens - with old data visible. But as soon as I click 'Start Filter' the sheet clears. Now to try and start with a clean sheet! Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...shows the last filter used - so I have this sort of feeling that if there was a way of clearing this as I loaded the QBF, I'd be on my way. But I've not found a way. Yet. Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

Interesting... That last one lost me some data! ************************************* OK, I'm stoopid. But I'm good at it! *************************************

Hi THWatson Had a go at that. As soon as I start the filter, I get the last entry (still); but, interestingly, when I apply the filter, the form goes blank with no result! Hmmm... ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...to remember the last query. Is there a way of opening a new QBF which (programmatically) clears the last query on opening? I bet it's there, but I just can't find it! TIA Chris ************************************* OK, I'm stoopid. But I'm good at it...

...once you know how! NorthNone. That's a sort of way I was trying to go - with a hidden attribute coming in. I got in even more of a tangle! Again, megathanks for the help! Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...However, using this method, there is a distinct 'flash' between forms. Is there a way to open the new form first and then close the old one 'underneath' it. TIA Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...a length of 15 characters, the overall Customer Database table (that it is copied to) has a field length of 6 characters! See, I told you I was stoopid. Now I've proved it! [blush] ************************************* OK, I'm stoopid. But I'm good at it...

Refresh please? I'm still stuck on this one. I've tried recreating the table and even giving it another name; and I'm still stuck at 6 characters! ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...I'm puzzled as to why this might have an effect. Other combos on the same form have the same properties, but not the same fault! [sadeyes] Could it be a little deeper than this? ************************************* OK, I'm stoopid. But I'm good at it! *************************************

p.s. Sorry - on Access XP Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************

...Has anyone seen anything like this before? If so, how did you cure it please? I'm on UK time, and finishing for the night. I will catch the thread again tomorrow. TIA Chris ************************************* OK, I'm stoopid. But I'm good at it! *************************************