Recent content by theDBguy

  1. theDBguy

    Access BE to Sharepoint List

    Hi. The basic idea is this. Let's say you have a parent table and child table as follows. tblParent ID ParentValue 11 ValueA 12 ValueB tblChild ID ParentID ChildValue 21 11 Child1 22 11 Child2 23 12 Child3 So then, after you have moved the...
  2. theDBguy

    How to Set Form Detail Height Through VBA

    Hi. Just a guess, have you tried using MoveSize?
  3. theDBguy

    Update ComboBox rowsource with Value List

    Hi. I finally had a chance to download your file. Please see the attached modified version of your db. The Gremlins/Zombies puzzle was applicable to your situation. Cheers!
  4. theDBguy

    Bound combo box value not displaying on continous form or datasheet

    Right. That's the typical approach. Cheers!
  5. theDBguy

    Update ComboBox rowsource with Value List

    Link fixed! Thanks! (y)
  6. theDBguy

    Bound combo box value not displaying on continous form or datasheet

    Glad to hear you got it sorted out. The problem should still be there, but maybe not so obvious now. Good luck with your project.
  7. theDBguy

    Update ComboBox rowsource with Value List

    Sorry, I can't download the attached file right now, but are you two maybe talking about this? https://thedbguy.blogspot.com/2016/02/combobox-gremlins.html?m=1 Sent from phone...
  8. theDBguy

    Solved File Copy

    Hi. I might try using a HTTPRequest Class to download a local copy of the file. Sent from phone...
  9. theDBguy

    Form based on query or table?

    Yes, in that context, I would agree with Google. As I said earlier, it depends on your requirements. So, if you require to filter out certain records from the form, then you can use a query. Of course, you also have the option to continue to use the table and simple apply the filter to the form...
  10. theDBguy

    Form based on query or table?

    Hi. When you create a bound Form, the Record Source can be based on a Table or a Query. Which one to use mostly depends on the requirements, but also sometimes based on your preference. I don't think there's a hard rule about it.
  11. theDBguy

    Form based on query or table?

    Hi. Welcome to AWF! So, what happens if you try to use a table instead? Normally, it doesn't matter if you use a table or a query, as long as the data source is from a single table only.
  12. theDBguy

    Need some advice for old DB develop

    Hi. I meant exactly what Micron said.
  13. theDBguy

    Need some advice for old DB develop

    Hi. First thing to check is if you have any missing references.
  14. theDBguy

    hey guys

    Hi. Welcome to AWF!
  15. theDBguy

    Hi everyone

    Hi. Welcome to AWF!
Top Bottom