Search results for query: *

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

PHV, looks like we have a solution. The criteria you gave me helped with my not exists syntax, so thanks for that (I put a star on a previous post that you entered). What I was doing was comparing the ID number from a table that lists every single ID in the system, hence no results. I ended up...

An interesting result this time. I have no rows returned at all. I removed all other criteria to no effect. Comparing the results manually, I should have about 25 rows. Would the conditions in the subquery be causing issues? I tried changing the subquery so it only returns ID number to no...

Thanks PH. Unfortunately I get the message Query to complex. maybe its related to MS access being version 97? I tried both suggestions. (If I remove the NOT so it only has IN, it works, but I get the reverse of what I'm after) I tried replcaing NOT IN with NOT EXISTS but got syntax errors. The...

Hi, I'm trying to get a list of patients in one service that are not being seen by another service concurrently. I'm basing the consition on the patient ID. I have a subquery which lists all patients currently being seen which are not in the service I am trying to get the results for('2327' in...

I have an environment where there are users on Access 97 and Access2000. The database has been designed in access 97. When people login to the DB using access2000 they are prompted with a message to convert the database to version2000 or leave it as is. Is there a way to prevent this option...