Hi

The brevity of your post is impressive but is a little limiting when it comes to providing you with proper advice. So posting the code behind the Save button...

Thanks for that Gail. I'll stop obsessing over them and get on with looking at things that are really amiss then 🙂

Cheers

Hi Gail.

Thanks for the response.

Is it normal for them to have to wait so long - I can't imagine any of our processes which might have that sort of delay....

Hi

When you say "=deleted" do you mean "#deleted"?

If you do then I think you have an issue with the primary key on one or more of your tables. One...

With all the previous post it sounds like you are well underway with a solution - many people using one MDB would have been the cause of your data display...

Hi Val

To understand your problem I need clarification on a couple of things. I have experienced linked tables causing forms to display #Deleted, but not the data disappearing from...

Good news that you have a suitable stored procedure working.

I think I have run across the timeout issue myself and I think all I have done is to increase the...

Hi Srini

Your exec command looks correct and I assume you have tested it to make sure it works. To execute it from within Access I think you have the...

Hi Pete

This is probably not the correct forum for your questions as they are more about database design than the frontend. Even so, I am a little surprised to...

Hi

From what I can see in the doc you attached in your earlier post, you are looking into a macro which opens a form - SET DATE PARAMETERS.

I don't use...

Hi

If I have understood your problem correctly, you could use a combination of the AfterUpdate event of each control and a hidden control(s) on the form. (An alternative to...

Glad I could help.

What I forgot to add in my initial post was a broad explanation of what is happening, in case anyone else ends up reading this thread. ...

Hi

In my opinion Access is fine as a front end tool if you are not planning to distribute the app to a large number of users. But the suitability...

Hi Paul

I see a post has slipped in while I have been preparing my reply.

Personally I like to keep my code simple and direct so I wouldn't write the dlookup...

Hi Paul

My apologies for not having followed up earlier - time zones and a very busy day getting things finished before going on holiday.

OK, you are actually very close. ...