Search results

Marshall, I thought you were also checking/confirming that each table had a PK defined. If you had a routine to do so, it might help in diagnosis. It would be quick running and read-only. (AFAIK) Quick and automated to show that a PK(s) had been dropped/compromised. If all tables have a PK by...

GPG, Interesting observation/experience. Since Marshall has a procedure to check/confirm that Each Table has a PK, routine running of the procedure should identify if this condition( no PK on Table6) exists.

Sounds like a plan--- keep us updated.

Hi Ian, welcome aboard AWF!

Show your revised code "that isn't working".

Amallon, Can you describe how to interpret the graphic to show "30 x chicken currys, 4 x Lasange..."? Perhaps you could tell us more about the current display---the who what, why, when sort of approach... as Pat has asked.

You may find some info at this older thread https://www.access-programmers.co.uk/forums/threads/export-attachments-to-folder-not-putting-attachments-in-folders.309573/

Kev, That wasn't my intent. If they use VLookup everywhere, then maybe they were limited to Excel. Perhaps you are introducing the use of Access --your method to do it -and that was never done before. So from a context perspective --this could be a new process, and you are discovering some...

ilanray, First, I agree with the others that checking that there are records in the recordset (eg Not EOF) is fundamental. Second, do you have any evidence that the recordset has any values? And what those values may be? You could do a recordcount. It just seems that you may be assuming...

Kev, How did they deal with this before you joined the company? Or is this some new process since your arrival?

Does anyone understand the requirement sufficiently well -- and can provide a description of same?

See Form.Form Properties

Suggest you pick a small subset of your data; put it in a separate temptable; get your query working and vet the result; T H EN adjust your query to work with real data. No need to test on 700K records.

Welcome to AWF, CatDad! The articles/links in my signature may be helpful to your learning Access and database.

Here's a link to a youtube video show a listbox trick for adding/removing items from listbox. Iy may offer a method or at least some insight to a solution.

Ben, I am not a developer and do not have any sort of multi-user testing. Have you determined that the Lock is acquired before attempting changes to a record? Can you/have you checked/verified that the same record is locked by more than 1 user at 1 time? Perhaps one of the active developers...

You may get some insight from this Implementing Queue-based applications article by Philipp Stiefel.

Tony, I don't know the significance of Colin's "handle" Isladogs. For a long time he was Ridders. Here's the wikipedia view that I have associated (my guess, probably incorrect) with his newer moniker. I remember hearing Isle of Dogs from a Sherlock Holmes radio broadcast. Perhaps, we should...

asteropi, This thread is marked SOLVED--- what is the solution? It could be helpful to others. Please describe.

Welcome to AWF and back to Access!