Search results

  1. E

    How Sql Server can interact with Microsoft Access (or other application) ?

    Think of it like a group chat. PC1 says hello, PC2 and PC3 see it because they are connected to the same chat window. A chat service is a Websocket too. The 3 workstations must have a web browser control connected to the same websocket. And on message, all workstations react at the same time...
  2. E

    Close worbook vba not working.

    Not sure Application.Quit will run after you've chosen to close the workbook, so simply quit the application, I think you've already chosen to ignore changes by using the Saved=True property. Sub QuitExcelNow() If Application.Workbooks.Count > 1 Then ThisWorkbook.Saved = True...
  3. E

    How Sql Server can interact with Microsoft Access (or other application) ?

    Indeed, it's not the same if the record was affected from access, a terminal command, or external client. Identifying the source of the modification is the first step, and it's there where you have to add the code to do additional stuff, if such environment allows it.
  4. E

    Edge browser open external window

    Logging into a website from an external browser won't log you in from the edge browser window, they're both different browsers. Opening the default external browser could be done with this: FollowHyperlink "https://www.wikipedia.org" Opening a particular browser, like Edge, to a website could...
  5. E

    How Sql Server can interact with Microsoft Access (or other application) ?

    Just remember that web browser controls can send notifications through websockets. If the client used to update the record is Access, you can set it up so that this instance of Access sends a message to other clients once the record is updated. Any other Access clients connected to the same...
  6. E

    Currency from US$ to GBP

    Traversing all objects is easy, but what you want to do with that is tricky. For example, you can use Application.CurrentProject, then... If it's forms, use AllForms: Sub TraverseForms() Dim f As Object For Each f In Application.CurrentProject.AllForms 'do something with the...
  7. E

    How to always set focus on the control on parent form after entering data in the subform

    I made a few extra tests and I see that directly executing the query shows the same behavior and I think it's because of the requery method in the context of the after update event. I've never worked with barcode scanners, but I think you'd be much better using the change event + the .text...
  8. E

    How to always set focus on the control on parent form after entering data in the subform

    I suggest you simply set focus to another control from the main form before you set focus to txtProductCode. Me.sfrmPosLineDetails_Subform.Requery Me.SomeOtherControl.SetFocus ' change the name Me.txtProductCode = Null Me.txtProductCode.SetFocus This might be one of those cases...
  9. E

    Pat Hartman has left the building

    Although I've been around for a much shorter time than most of you in more than one way, my interactions with Pat Hartman were always somewhat complicated, even in threads where she was seeking advice. A number of new users expressed similar frustrations, and some even stopped posting, possibly...
  10. E

    Microsoft Access: Edge Browser Control is finally here :)

    No, I meant actually developing for the web browser control making the contents of the control interact with the application.
  11. E

    Microsoft Access: Edge Browser Control is finally here :)

    You can find the legacy web browser controls even in the newest versions of Access. However, web technologies have moved on and IE couldn't keep up. Then, Google developed Chromium and a lot of folks forked it or worked on top of it, Microsoft included, and now a lot of browsers are based on...
  12. E

    Click Farms

    I have reported this whole thing. Greetings.
  13. E

    Webbrowser in Form without Control !!!! Years to late....

    I couldn't make it work, but does it give you an object model to manipulate the application or is this just for the amusement of opening an application from an Access form?
  14. E

    Seeking a Moderator for the Moderators

    How about a LLM moderating mods?
  15. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    You check the IP and if it's from UK, you get limited access or no access at all. Holy Sith, 99% of the Watercooler then?
  16. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    Can anybody please explain what that pesky legislation is flagging? How is this site harmful to children exactly? Is it the utteraccess owner thread, that's the only thing that comes close, right? Something else? Perhaps the war happy propaganda? Is it the mods wishing to bomb civilians? What is...
  17. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    That's a LLM you're replying to. Either that or LLMs write exactly like Jason does. Anyways, so the current situation is: 1. AWF relies on threads about politics to subsist 2. Threads about politics hurt ad revenue 3. UK legislation is the source of the problem 4. UK legislation applies if the...
  18. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    According to a basic whois search, the servers are already in the US, but Jon could probably make the .co.uk domain point to a .com or whatever else
  19. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    @Pat Hartman Because the Watercooler belongs to this Access forum. Access is not politics, it's software.
  20. E

    UK Online Safety Laws - I, and therefore the site, are at risk

    Come to think of it, The Watercooler seems to be a contention board, and that toxicity has clearly taken its toll.
Back
Top Bottom