Search results

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

in the case of ebs17 suggestion, could you elaborate more on this?practically what am I supposed to do with that piece of code?

I've adapted @ebs17 solution this db assign tasks to users that other aren't allowed to touch hence the issue to prevent a record from being visible to others but admins that have access to the tables to be more clear: a suggestion I got elsewhere was: in the last version of the code, VBA...

I'm using this, looks like what I want I have no experience updating a recordsource from vba, how do I change the fields values I show in the form? say that one of the fields shows the ID of the task how do I assign the source to myID? I hate the double quotes in vba and they hate me apparently

Yes everyone has their own FE But that's not the issue, I'm trying to gather ideas on how to automatically assign a task exclusively to a user preventing as many issues as I can. Once a task is inUse no one else should be able to load it in the form

This would defeat the purpose of having a centralized database

Then another FE would get an error. I'm trying to setup a flow of records in a way where everyone gets their own without causing interruptions to others

Hello everyone! I have this database in order to assign a task to each logged on user. The db is split between be and fe already and everything is on a network drive. Admins import tasks on the main table where there is a 'inUse' boolean column defaulting as false. A query reads a few fields...