Search results

  1. E

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    Based on my experience, data macros do not respond to external changes, such as writing to a table through a Python script. The WebSocket approach was suggested because the Python script can trigger the updates via the WebSocket in real time and the browser control can react to those changes by...
  2. E

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    WebSockets respond to external stimuli. The legacy browser control supports them with IE11 emulation, and the Edge control should too. The process is as follows: Load web browser control with WebSocket listener. Python script writes to table via ODBC. Python script triggers the WebSocket. Web...
  3. E

    Solved CRUD in Excel

    If you really want to use Excel as a CRUD application. You have roughly three options, IMO: 1. Using data models and connections, which is the majority of the Data tab 2. Using list objects 3. Not using list objects With data models, you can import tables from external sources, make queries...
  4. E

    Mail merge from an Access control

    1. Create a Word template, adding you field names in the places where they need to be 2. Open a recordset with your query 3. For each record, open the Word template from Access 4. Run a Find and Replace routine to find your field names and replace them with their values according to your query...
  5. E

    Proper focusing of windows in MS Access (natively or by a code)

    Trigger the code from the popup form and you will get it correctly. I confirm those two events do not trigger.
  6. E

    insert a circle to a number

    Add an image control and load a PNG circle.
  7. E

    Proper focusing of windows in MS Access (natively or by a code)

    It seems that you've been struggling, but I doubt the only way to do it is sending a key combination. There must be something else going on, which is why I'm asking for your code, but a reproducible example would be best. I'm not sure what you mean I'm getting a different behavior than the one...
  8. E

    Proper focusing of windows in MS Access (natively or by a code)

    How are you opening your forms? Do you have code trying to set focus on something? If yes, how? if no, why not?
  9. E

    Proper focusing of windows in MS Access (natively or by a code)

    This line caught my attention, so I tried to reproduce that through this I did encounter an error when attempting to retrieve the active form name from the Immediate window while only the popup was open. However, when I added a button within the popup to query the active form, it correctly...
  10. E

    Access product catalogue website style

    I was copy-pasting from Google's OCR but it didn't read it correctly, when I typed it myself, it worked. OP translated database and it's attached. @Faoineag We're in post #42, the form design has been covered by now, I think you should focus on the database schema that works best for you, I...
  11. E

    Sub Forms

    The best thing that you can do is learn to use any control from the toolbox from scratch. Subform controls will only ask you for these 3 things: 1. Source Object: the form or report to display 2. Link Master Fields: the field(s) in the parent form that exists in the source object of the subform...
  12. E

    benefit of GPT

    Yes, many times I end up doing it myself, but it's a handy tool. In general, before I submit my prompt, I ask myself how can they use this prompt against me later?
  13. E

    Access product catalogue website style

    Something's wrong. I can see the name of the file, but it does not let me download it and that error message shows up. I suggest you use another service, like Google Drive or even Dropbox.
  14. E

    Access product catalogue website style

    I think the link doesn't work.
  15. E

    Access product catalogue website style

    Thank you for the compliment. I see that you're using the ActiveX browser control in your solution, I believe the same approach can be followed to add events to your sample, just give your tags some id attribute that is unique. For example, images could have the format "image_" & rs!id, ratings...
  16. E

    Access product catalogue website style

    I modified the file. This version does not require registry key changes. It is using the default browser, which is IE6, I think. That means the only thing we can hover over with CSS are links (but can be done with JS), we also can't scale or animate things (but can be done with JS). We don't...
  17. E

    Access product catalogue website style

    This is your link. https://limewire.com/d/792096ca-64f5-4a2a-959c-6291f5071363#YDG0valBnCTMUUe6p0nVKRYiFIPjwQH5jpL-QwBgG7o
  18. E

    Access product catalogue website style

    Attach a txt file with the link or post a screenshot.
  19. E

    Access product catalogue website style

    Thanks. Please read posts #12, #19 or #20 for context, where I'm writing that you need to enable IE11 emulation. The library allows it but the browser being used by your legacy browser control does not support that feature. You need to make the browser control emulate IE11 by modifying the...
  20. E

    Access product catalogue website style

    Just edit the link, for example, instead of google.com, you can write google dot com Internet browsers are really complex programs that must support old and new things and that is really hard to accomplish. Therefore, as most things, they have been evolving consistently and some things have...
Back
Top Bottom