Search results

  1. E

    Slow downloads using ODBC driver to connect to Shopify

    Yes, the Shopify guys are the ones to know if your IP is listed somewhere. You really want to discard that. If they're not to blame, then it's good to check what the developers of the 3rd party app know about that issue. I suppose you've already conducted a few Google searches about that. If you...
  2. E

    Slow downloads using ODBC driver to connect to Shopify

    Their support team has helped me a lot in the past, but they can't do anything if it's a third party app. If so, then try asking the developers of that third party app. Those delays sounds like the delays I experienced. First it was nice, then it was slow and then I just couldn't connect...
  3. E

    Slow downloads using ODBC driver to connect to Shopify

    I experienced this with a few hosting providers, it turned out they were blacklisting the IP of the computers on and off because they were receiving random requests on multiple ports of them. Those computers were part of a botnet. You might want to ask Shopify why your queries are taking so...
  4. E

    Indenting and Spacing Revisited.

    Absolutely, comments are an extra thing to maintain and I despise them because of that and their huge size The entire Access community seems to trust similar blessings as far as my experience goes, it's why I tend to look at the debugger more than it is adviced too.
  5. E

    Indenting and Spacing Revisited.

    I agree with that, since "what" and "how" is the code itself. I think I spend a shameful amount of time naming things just to avoid dealing with the addition of comments. They make the code much longer than it should be (I hate long code), but if someone else has to read it, I might add a few...
  6. E

    Indenting and Spacing Revisited.

    Thanks for the appreciation. I hope that contributes to a better development experience for you and others.
  7. E

    Indenting and Spacing Revisited.

    In general, I like to separate the ideas within code, so these are a few considerations: If the variable won't be used yet, I don't want to deal with it. If I change the code later and I don't need that variable anymore, I don't want to check whether the variable is orphaned some other place. If...
  8. E

    Indenting and Spacing Revisited.

    Without modifying the code, this is how I would approach indenting and spacing: Private Sub Form_Click() Me.txtHighlight.Requery Dim Rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant pubProjectID = Me.txtSourceID pubEntityID = pubProjectID...
  9. E

    Solved Continuous Sub-Form

    I suggest you post a sample database or at least a few screenshots of the database schema and the continuous form you created. Assuming things are correctly setup, you would link main and continuous form via master/child links, which is a setting found in the Data tab of your subform control.
  10. E

    Synching subforms after query

    Clicking a navigation button will close the current form in the navigation subform and open the target form associated with the button clicked. Navigation buttons have a Where clause too. Keep that in mind. You have a textbox holding the current record in your main form. You also have a...
  11. E

    Solved Getting the key and value from Json collection with VBA Microsoft Access

    If you visualize the JSON, you'll see that both weather and coord come from the root object. It should be: Json("weather")(0)("main") Similarly, if you want to get description, it has to be: Json("weather")(0)("description") Here's a view of your object: asd
  12. E

    Tooltip with textbox when hovering over label

    That's unfortunate indeed, but hey, it's good news that it works. What happens if you tweak the delays? any sweet spot?
  13. E

    Tooltip with textbox when hovering over label

    I haven't posted in a while... this is an unpolished proof of concept I had fun with for a moment. It works like this: 1. A function is assigned to the mouse move event of each control when the form loads 2. The function starts a timer and a flag to show the tooltip 3. On timer, another timer...
  14. E

    Access Runtime

    Check @isladogs article: https://www.isladogs.co.uk/office-dual-install/index.html#RUN
  15. E

    code to close my current form on pressing the button to open my Main Menu

    Hi @John Lee, You can simplify handling the opening and closing of forms using the following snippet: Private Sub cmdOpenfrmFrontEnd_Click() DoCmd.BrowseTo acBrowseToForm, "frmFrontEnd" End Sub The BrowseTo command also supports a Where clause, which is useful if you need to specify the...
  16. E

    Solved Navigation tabs left side and top side controls

    There’s no need to hide or disable the first button or get the form to open on the second tab. Tweak the first button's top padding to get the appearance you want (as shown in the sample file of post #14) If you still want to get the form to open on the "second tab", which is "frmInputForms"...
  17. E

    Solved Navigation tabs left side and top side controls

    Click button 1 on the left, show its properties pane and go to the Data tab. You can see there what it loads (it loads another navigation form).
  18. E

    Solved Navigation tabs left side and top side controls

    I suggest you open the file in design mode to take it apart, then either put it back together or improve it. There’s really no trick to it, just select, tweak the settings, and adjust until it looks the way you want. This particular design is called "flat," which has minimal gaps and almost no...
  19. E

    Solved Navigation tabs left side and top side controls

    I guess it would be easier if you see it yourself. Just check this sample.
  20. E

    Solved Navigation tabs left side and top side controls

    As you wish, but that sounds harder to pull off and maintain. The suggestion wouldn't require code.
Back
Top Bottom