Search results

I had your sample working the way you suggested. Open the access file, open the form, and then run the VBS by double-clicking on the VBS file. By using the only command I could find online to call the VBS (as I have no idea how to write a code to call the VBS), I managed to improve it from...

Thank you for the comments. It helps in a deeper understanding of the processes, which I as an access enthusiast don't have. That is exactly why I am hoping to get Isaac's loop working. The timer is doing the job already, Loop can improve things if we get it to work, and later, when I am free...

It is great that you are not accusing me of lying. As much as the support I am receiving on this forum is valuable, nothing is worth taking the offense. It is great that we can run the civilized conversation. I agree that there is a lot of misunderstanding. If by "backlog" (one of the words I...

Sorry, Isaac. I was testing your solution in the time gaps during the workday with lots of distractions. When writing the post #55 I was under wrong impression that the code worked if called from the VBS but not if from the VBA. The code is not working regardels if it is called from the VBS or...

Thanks Isaac for pointing out the VBScript option. I was not aver it existed. It is a great trick. Opens new possibilities. Using the VBScript file implies having another file to worry about. As the simplest solutions are the best, I tried to avoid having the VBScript file and to use form's...

On the contrary. I am interested in your solution, but don't understand it from the description in your post #45. Once I resolve the issue of refreshing the form, I will have to deal with the issue of overlapping automatic requery with entering the task. It would be great if you would explain...

Thank you Isaac for the sample. I like the idea. (I edited the post as I found a way to start the VBS from the VBA) The option to assign a task to a person is already available. There are options per person, person+person as a team and everybody (includes all the people). It that is what you...

Is it File>Options>Client Settings "Refresh interval (sec):" section that you are referring to? It is set at 60 in my case. Will try it. I will first try to make a loop that Isaac suggested. I see the mouse move event as the next best choice.

Correct. If I find a way to implement Isaac's suggestion, I think I know how it will be possible to control the form Requery when the form is being used. Regarding your solution in the description in post #45... If a person is working on the form on a certain PC, other forms are somehow locked...

Thanks Isaac! It would be great to create what you suggested. Please look at my response. The flickering is solved as described in post #37, but the bad side of using the timer is a setback. Never used Tableau. Not sure how difficult would be to learn Tableau from scratch. Sounds very...

I was trying to make things simple by keeping information on a minimum. Let's change that.... 1. How many PC's are you talking about? Two PC's 2. Is this going to change in the future? if so in what way? Unlikely, but it could come up to 3 PC's. 3. Does each PC needs to refresh all the other...

First of all, Doc, I honestly appreciate your dedication to this case. I don't know if that is usual approach on the forum or not, but I am very grateful for the attention. Regarding the vague descriptions, please note that English is my second language and computer-English is an additional...

I used the timer as it was the last resort from the beginning. Solved the flickering by the condition. The form's timer is set to 1 sec., but the me.Requery action is carried out only if the condition is met. (I have a "scrapbook" table with several number and text fields that I use for...

A new task is being created in the unbound field on the main form and is triggered on "After Update" event. So, no worries there.

The same street address, but separate office spaces. Also, tasks (and later chat) need to go back and forth between remote computers. So, thanks Doc for the effort :) , but the setup you suggested is not a solution in this case.

In the previous response to Doc I explained in detail what are the requirements. Thank you for your attention in any case.

Thanks The_Doc_Man. You've been very helpful. The software is being used in my company and I am adapting it for myself. So, the domain admin will not object to anything :). Forms listing tasks are already built. The reason why I want to build the chat in addition to the tasks is that all...

There are two persons each sitting on their own PC. When person 1 enters a task on the PC1, person 2 should see that task immediately on the PC2. As mentioned, the next step will be to build the chat. Again a similar event will be required. Immediate update on the PC remote to the PC the...

I was hoping the code to refresh the form on the remote PC would be simple. Something similar to the code I listed. Action active only when necessary and immediately stopped after the task is completed, seems to me as a slicker solution then having the timer runs all the time. Also, I did...

The forms that needs to be updated are showing tasks. Tasks are listed in continuous form. When a person on either PC enters new task/delets old task...., the form on the other PC needs to refresh and show current updated information. Next step will be to include the chat to the same form...