Search results

  1. 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.
  2. 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...
  3. 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
  4. 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?
  5. 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...
  6. E

    Access Runtime

    Check @isladogs article: https://www.isladogs.co.uk/office-dual-install/index.html#RUN
  7. 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...
  8. 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"...
  9. 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).
  10. 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...
  11. 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.
  12. 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.
  13. E

    Solved Navigation tabs left side and top side controls

    You should have changed the navigation form that has both left and top buttons with one that has ONLY left buttons. Then, make another navigation form with ONLY top buttons for command1 and another navigation form with ONLY top buttons for command2 as well. Can you show a screenshot of what you...
  14. E

    Solved Navigation tabs left side and top side controls

    Yes, the setup that I described would have that effect, but with navigation forms. Can you show what you have or describe the problem that you're having?
  15. E

    Solved Navigation tabs left side and top side controls

    Opt for vertical left. Then: For the top button on the left, make another navigation form to appear, this time with horizontal tabs. For the 2nd button on the left side, make yet another navigation form to appear, also with horizontal tabs and completely different names. If some button on the...
  16. E

    CSV or Excel daily data

    Suggestion: Request both CSV and Excel files, then test them to determine which is easier to work with. Ideally, build the export mechanism yourself for better consistency, but if you can't, then test the two to make an informed decision. If the comparison calculations are the same each time...
  17. E

    Setting on click event of a control in VBA

    @ziad Creating controls on the fly will eventually render your form useless, I suggest you create a new thread for that because it's a very different topic. Moved by UG
  18. E

    Why is speech to text in Access slower than in Word?

    Let's suppose OP only has one input tag in the Edge Browser Control, then why not: MsgBox BrowserCtl.RetrieveJavascriptValue("document.getElementsByTagName('input')[0].value")
  19. E

    Why is speech to text in Access slower than in Word?

    Ah, sorry. I speed read the post.
  20. E

    Why is speech to text in Access slower than in Word?

    Something like this reads the content of a textbox with no issue from my computer. Private Sub MyButton_Click() CreateObject("sapi.spvoice").speak Me.MyTextbox End Sub Now, since you say you managed to make an HTML input read out loud its contents, I assume you're using...
Back
Top Bottom