Recent content by ChrisTheAncient

I did try this thought process in the vb forum, but I now feel it is more Access specific than vb specific. I'm using Acc XP with a need to later convert 'down' to A97 as well. My form is based on a table with three fields... Task - a text field, Complete - a yes/no and Score - an option...

Back again... willir... Now had a chance to really read and inwardly digest all your wisdom. It's great and now reinforced my thoughts of today (that you started) that I'm going around this in a most 'cack-handed' way. Yup, you're right! I was trying to do a M-M type of thing - but in an...

Hi Willir Thanks for coming back. Your reply looks very detailed and needs time for me to think about - and I'm short of time until later today (UK time). I'm very appreciative that you have given the problem so much time and thought and it needs an appropriate amount of time to read and...

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

I've been going round in circles until I'm not sure what I've done and tried. My brain cell has just imploded. And I know the answer must be simple!!! That just makes it worse. Somehow I can't seem to find a similar problem in the FAQ's or search. Anyway, the problem... I'm making a...

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! *************************************

Correction My mistake... It opens with all records from the main database (which I suppose is logical!). Then the me.filter = "" clears things on 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...

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! *************************************

PHV Sorry for the delay, I had to go out for a while. I had a couple of goes at some forms of blanking - but (probably through my inabilities more than anything) didn't seem to have any luck. The other disadvantage that I hit trying that was that as soon as I went to Start Filter, the last...

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! *************************************

Working on my nice little database in Access XP. I have a well-working Query by Form facility that (seemingly) does all I want it to do. Except... When a new QBF starts, the form seems to remember the last query. Is there a way of opening a new QBF which (programmatically) clears the last...

What a fabulous response. Thanks folks - I'm dead happy. I tried PHV's first and it does exactly what I want. Thanks. Looks like Evalesthy was the same. Where I was going wrong was with my syntax on the CloseFrom commad. Easy once you know how! NorthNone. That's a sort of way I was...

I call up a new form - from an existing form - with a button click... DoCmd.Close 'close the existing "CustomerDatabase" form stDocName = "ActiveCustomers" DoCmd.OpenForm stDocName, , , stLinkCriteria However, using this method, there is a distinct 'flash' between...