Search results

Thank you for the detailed response The_Doc_Man! I appreciate your effort. Yes. It sounds complicated and I hope this is not the only way to avoid using the timer. If so, the timer will be the solution.

I am sorry for the confusion. What I need is to refresh the continuous form on the remote computer, if that form is active on the remote computer.

All files are already linked to the backend DB. I need an immediate response on the remote PC, as mentioned above.

Works like a charm. But only on the PC where it is triggered. I need to control the file on the remote PC. Both PCs are on the same location with full network access all the time they are active. The network is secure and without internet access. I am also in the same location as the PCs. No...

All 3 files are located on the PC1. Let's call the files beDB, feTargetDB and feTriggerDB. The beDB is a file containing tables only. All data is being stored only on the beDB file. Both feTargetDB and feTriggerDB contain tables linked to the beDB. The file feTriggerDB runs on the PC1. The...

My method opens the database on the PC1 where it is triggered. The activity needs to be performed on the PC2. And that is if the targeted db is closed. As it is always the case that the targeted file is already opened on the PC2, the file is locked and the event makes a mess in addition to not...

Thanks! All files are frontend and are linked to the backend db file containing only tables. The timer can do the trick. Still, I would prefer to learn the code to control the form as mentioned. This is exactly what I am after. I can try a code you think may work. If you are happy with...

Thanks arnelgp! The timer is what I am trying to avoid. The system is under my full control all the time. No worries about the location of the db. All files are having full rights. What I need is the code that will refresh the form data on another db, on another PC. The form is a...

Hi guys! Simple code that successfully controlls the form on another Access file, on the same PC is: Funcion RefreshAnotherForm(strDbPath As String, strFormName AS String) Dim objAcc As Access.Application Set objAcc = GetObject objAcc.Docmd.OpenForm strFormName...

Thanks. The slicker solution, in this case, was to have an immediate and one-time event. Using form timer sometimes makes the form glitchy as the task is triggered according to the interval set. As the form, in this case, is always on, your suggestion to use the bound field was preferable...

This is correct. Bounding the field did the trick. Thanks. It takes some time for the field to update, with one of the machines even up to a minute, but it does function. This problem is solved, but I am still curious if there is a way to trigger an event from one access file to another. Is...

Hi and thanks. Both DBs are already linked to the third access DB file which contains tables only. Both DB-1 and DB-2 are using the same data source. DB-1 and DB-2 are two copies of the same software and are on different machines. The form that needs to be updated is displaying the number of...

I need to input data to unbound form field from another Access database file. The event is to be triggered by a button in DB-1 and should input data on the form DB-2. Basically, when the button is pressed on the form at the DB-1, the unbound field at the DB-2 form should display a certain...

Thanks for the comment. Not sure what you are trying to say. How would you organize codes in this case? I am not a professional programmer.

I am sorry, I still don't understand how to set the condition at Function "DoSomething". What should be listed after "Select Case" in the Function "DoSomehting"? Please see both codes as they are at this stage: Function CreateMenu() ' Creates right-click menu Const MyString As String...

Where should this be listed? The function that triggers the contect menu, or Function DoSomething()?

The Tag value from context menu. If "button1" (option one in right-click menu) selected, do "action x". Using "bt.Tag1" as condition.

It looks as if you understand what I wan to do. I am not sure how to write the rest of the Function "DoSomething". How should I make a connection between bt.Tag from Function that triggers the menu and Function "DoSomething()"? Could you please write a sample?

Hi Guys, I want to use one Function to trigger button action in the right-click menu conditioned by the button selected on the custom right-click menu. The function that activates the right-click menu: Const MyString As String ="MyMenuName" Dim cbar As CommandBar Dim bt as CommandBarButton...

It is working now. Thanks :)