Recent content by shura30

I'm improving the code as I go, I've noticed that as well and made some other big changes I had another version of this code, was using date/time for the locktime field and everything was working as intended as soon as I switched to unixtime to not have to deal with format behavior, it stopped...

this is the piece of code, most of the function that does the locking/reading of the table: On Error GoTo ErrorHandler Dim locking As Long Dim lockQuery As String Dim selectAndLockQuery As String Dim lockedID As Variant Dim rs As DAO.Recordset ' Impedisce la...

While debugging I tried with and without the transaction to see where the code is failing, at some point I've opened the table in the background to see in real time the records affected, that's where I noticed it would work and the lockQuery would actually return a value instead of null I...

Then why would this work flawlessly if the table is already open?

The 'ID' is the auto number I typed the code just to have an idea, we can exclude syntax errors

So I'm having this issue where I can successfully update a row but fail to retrieve one of its fields immediately after. I have this piece of code in a module: Private objMyDB As DAO.Database Public Function myDb(Optional bolRefresh As Boolean = False) As DAO.Database...

tasks come from an external crm, they often come back with an updated status. Also no point in keeping a huge tblTasks as the one where edited records are stored is worth (for analysis purposes) anyways, the update method still allows the same record to end to two different users, I really have...

@ebs17 according to what we did so far, we change me.recordsource with a query from within vba, is there a way to unbind after loading without losing the values? this is the scenario: user loads a task, admin deletes that task from the main table I still wish for the user to complete it, assign...

Great resource thanks, this is the exact scenario I need to address and it's literally the article, almost word for word Looks like the UPDATE statement is the way to go quotes from the article:

What do you think of running the update query instead of a select like we're doing? I was referring on general access behavior not the code you posted. If we look at this from the update statement point of view at some point 2 users might run at the same time something like: Timelocked = now...

I my case, users have no added value but wasted time in seeing a record they can't use/edit they get their task, work on it, release and move to the next how does access engine handle simultaneous update requests? I was thinking to change the way we look at this by using an update query...

The full quote mentioned the GoForEdit field, I'm not using another table to store an indexed row as in my opinion it would wield the same results the table I mentioned is part of the database design, users get a record from tblTasks, add a note and an exit value then that record is saved to...

sadly this is what most tutorials teach right from the start, in my case, I moved away from closing and reopening the form each time and every query has where clause. Best practices aren't really explained anywhere without digging. Tested with a few users working on the file and in the span of...

no worries, I look for pointers not spoonfeeding, thanks anyways for your support so far still learning!

I would like to understand better what do you mean about dragging the whole table across the network the file has been modified quite a bit since I opened the post, I can't really select randomly as tasks need to follow a FIFO pipeline. Since they have a opened date and time stamp I might...