Search results

  1. E

    Access product catalogue website style

    Thanks. It seems the document wasn't set up correctly in your environment. This might be due to the Access version you're using, but I'm really curious to find out the exact cause. Could you download the attached file and see if you get the same behavior? If you still get the same behavior...
  2. E

    Access product catalogue website style

    You can use the browser control to show something like this: Doing that requires browser emulation set to IE11, which requires you to add a DWORD key with value 11001 to the path: HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION You could...
  3. E

    In stock or Not in stock

    Visiting a few products in that website, I see getElementsByName("Quantity") finds multiple elements and the first element is always the main product. The rest of the elements are related products. Therefore, getElementsByName("Quantity")(0) is always the main product. So why are you checking if...
  4. E

    Dynamic/reusable forms

    What sort of sub are you talking about? a sub routine, a sub form? What do you mean by item here? Also, I prefer to see how the metadata looks in your Access file, can you take a screenshot or paste here a few examples of the whole definition that will be processed by your code? It's really...
  5. E

    Problem Posting a table

    Testing a bookmarklet CityIDCityNameCountryID 1New York1 2Toronto2 3California1 cities It seems to work. You can use a bookmarklet to let you post your tables properly while the devs fix the parsing issue. Here's how to add the bookmarklet: 1. Add a bookmark to your browser 2. Name...
  6. E

    Problem Posting a table

    I edited the table markups from here Then I removed the header each cell's alignment markups, and And it shows correctly, but it takes the entire screen, I don't know if that's intentional.
  7. E

    Problem Posting a table

    Normal paste: task_status TaskStatusID Status 1 Status 1 2 Status 2 Only rows, no formatting: task_status TaskStatusID Status 1 Status 1 2 Status 2 Now without color markups task_status TaskStatusID Status 1 Status 1 2 Status 2 Now without font markups task_status...
  8. E

    Dynamic/reusable forms

    @Imb I think I understand what you're doing. Basically, your framework lets you write the control definitions to a table and after that everything is handled by the forms. So, what is the source object of the 20 subform controls? Is it the same form or different forms? How does the control...
  9. E

    Helpful Language Comparisons (maybe)

    Well, Access is not a language. VBA would be the point of comparison and these are a few of the things that should be evaluated for that document, I'll try with VBA. Popularity: - Bad reputation - Young developers avoid it - It's widely available because it comes with MS Office Community: -...
  10. E

    Dynamic/reusable forms

    @Imb I must confess I have no idea of what this thread is about, but based on the first few posts, it seems you're trying to get ideas or contributions that help you scale your currently 50MB+ code base. But instead of scaling your app, what scaled is the heat in this thread in terms of the...
  11. E

    Dynamic/reusable forms

    Install OBS, it's free. Run it. Add "display capture". Click "start recording". Show what you want to show. Click "stop recording". Go to youtube. Click upload. Choose the video you just recorded. By default, the video is in your videos folder. Done.
  12. E

    Slow downloads using ODBC driver to connect to Shopify

    You could continue troubleshooting this by using another computer and seeing if the same happens there while you get answers from both Shopify and the 3rd party app.
  13. 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...
  14. 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...
  15. 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...
  16. 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.
  17. 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...
  18. E

    Indenting and Spacing Revisited.

    Thanks for the appreciation. I hope that contributes to a better development experience for you and others.
  19. 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...
  20. 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...
Back
Top Bottom