Recent content by brendanmc

Thats interesting, does that mean I can not get around the problem of the recurring value without major redesign of the form or record? Maybe I could do a query which calculates the value as an extra field and use that as the query record source? - which should hopefully give me the value. (I'm...

Hi, I have a continuous form which displays each record in a table. The form displays the records OK, but each row also has a total calculated field. The calculated total field works OK for one row but the total repeats itsself for every row instead of recalculating for each row. The...

Good news indeed, a solution has been found. Thanks for all your help on this, it has really helped. As you mentioned, there are alot of places to search. So using that logic I thought I'd recreate the form from scratch, see if it would work and then compare with the one that did not. In the...

you are right about the criteria. It seems to be falling apart on the recordset clone. So the code seems to be fine. I added the following code to determine the source table's contents (it works OK): Set db = CurrentDb Set rs = db.OpenRecordset("file_tracking")...

Thanks for the suggestion. I'm still working theough the overall problem, but by adjusting your suggestion to use recordset instead of recordsetclone I was able to get more of an idea where I am at.

Thanks, I will continue tracking down the offending criteria. My thinking must have been backwards re the double negative. The positive side is that my VB skills are improving along the way.

Hi, I currently have another thread open in which I'm trying to correct a recordsetclone problem. In the meantime, is there quick and easy routine that lists the contents of a recordsetclone, for example something that I can list in a msgbox? Thanks Brendan

HI, I've added the line into code (see below) and while running it skips straight over the if statement and into the remaining code and I recieve the no current record error. It still occurs at the same point: Me.Bookmark = RecordsetClone.Bookmark I'm guessing it must be finding something since...

A good idea. I will give it a go when I'm next at work and let you know how it all goes. Thanks Brendan

Hi, I've been trying to nut this out for days with no luck (doesn't help that I program very rarely) I am receiving a runtime error 021. no current record. I can confirm that the record exists. I am using a form, that when opened is set to default as a new record. There are four fields. The...

Thanks Dking & GodofHell. I ended up fixing the problem a while ago by ensuring the first tab stop was at the beginning, it was fixed. So it matches up with exactly what you both said. Now I think about it I should have posted it myself - my documentation is lacking!!!!

A good idea. I removed the header and footer of sub page with no luck. I then tried adding a header/footer to the main form thinking it might override access setting the top of the subform at the top of the page, no luck there either. I'll keep digging. Thanks Brendan

Thanks, I'll look a little closer and let you know.

Thanks for the response Herman. It could well be. when using the subform you need to scroll down to get to the end of the form. I was surprised that the main screen wasn't used as the default for centering the screen. Is there a way to override the subform being used to center the whole scree...

Hi, I have form. Within that form is a tab box. Within the tab box is a subform. Whenever I click on the tab the screen position changes to the top of the subform, hence cutting of the header at the top of the page and the tab selections. Users then have to scroll up to see the top of the...