Replies

Hi Hans, and thanks for the reply.

I’ve taken a look at post 117856, and the problem there was that a VFP database (.dbc) was being set up as a free table directory, and I am pointing to the .dbc file and not trying to set it up as a table directory.

MarkD’s post 174958 seems to rely on a properly set up DSN, which mine doesn’t seem to be, since if it was properly set up I should be able to link and wouldn’t need that code, unless I’m misunderstanding what is happening. I think that my problem is in setting up the DSN, but I can’t seem to locate what the problem would be. I’ve followed the instructions I found in Knowledge Base Article #197893 , but I still get that blank table screen.

Whoops, I meant the BeforeUpdate Event (there is also BeforeInsert stuff as well for the creation user/time but I never have a problem at insert.) I removed the code from the BeforeUpdate Event and I still have the same problem.

I open it into another form because it is easier to enforce and modify data check items from a separate form. Also, it is for the interest of consistency, since sometimes (not in this case) there is additional dependent/child information. In this instance the users are entering case notes relating to the client, so it is useful to have the continuous form where the worker can scroll through many case notes, but to have a nice large window for entering/editing the notes.

the backend is using record -level locking. and I’m on SP3.

There was no error message for the users when the changes were dropped. The error message comes from the SaveRecord command.

-karl

Whoops, I meant the BeforeUpdate Event (there is also BeforeInsert stuff as well for the creation user/time but I never have a problem at insert.) I removed the code from the BeforeUpdate Event and I still have the same problem.

I open it into another form because it is easier to enforce and modify data check items from a separate form. Also, it is for the interest of consistency, since sometimes (not in this case) there is additional dependent/child information. In this instance the users are entering case notes relating to the client, so it is useful to have the continuous form where the worker can scroll through many case notes, but to have a nice large window for entering/editing the notes.

the backend is using record -level locking. and I’m on SP3.

There was no error message for the users when the changes were dropped. The error message comes from the SaveRecord command.

-karl

Makes sense. I was looking at the event list for each page.

Thanks Hans.

Makes sense. I was looking at the event list for each page.

Thanks Hans.

perfect. as always, Hans, you’re the greatest.

-K

perfect. as always, Hans, you’re the greatest.

-K

That sounds like a good idea – I am indeed running this over a network. I spent some time last night testing different approaches, and the linking of the merge source sometimes would take over two and a half minutes… I’ll give this a try.

Thank you Charlotte.

best,
Karl

That sounds like a good idea – I am indeed running this over a network. I spent some time last night testing different approaches, and the linking of the merge source sometimes would take over two and a half minutes… I’ll give this a try.

Thank you Charlotte.

best,
Karl

Charlotte,

Thanks for answering and taking a look at the code. I was hoping that there was a magic answer… Last time I did this same calculation in a different database I used this nightmarish amalgam of union queries, IIf statements, temporary tables… And now, knowing a little about ADO, I felt like I had the magic answer. So now it is time to blend the two. I’m going to experiment with pulling various items out of the function and into the query and wotk from there.

thanks again,
karl

Charlotte,

Thanks for answering and taking a look at the code. I was hoping that there was a magic answer… Last time I did this same calculation in a different database I used this nightmarish amalgam of union queries, IIf statements, temporary tables… And now, knowing a little about ADO, I felt like I had the magic answer. So now it is time to blend the two. I’m going to experiment with pulling various items out of the function and into the query and wotk from there.

thanks again,
karl

Rupert,

For some reason the attached ZIP file appears empty to me…

… but I have largely solved my problem thats to the code originally written by Ken Getz posted at http://www.mvps.org/access/api/api0001.htm%5B/url%5D

thanks for the assistance. I was completely lost there for a while.

best,
Karl

Rupert,

For some reason the attached ZIP file appears empty to me…

… but I have largely solved my problem thats to the code originally written by Ken Getz posted at http://www.mvps.org/access/api/api0001.htm%5B/url%5D

thanks for the assistance. I was completely lost there for a while.

best,
Karl

Thanks Hans. You’re the best.

Thanks Hans. You’re the best.