Recent content by theDBguy

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...

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

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!

Right. That's the typical approach. Cheers!

Link fixed! Thanks! (y)

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.

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...

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

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...

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.

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.

Hi. I meant exactly what Micron said.

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

Hi. Welcome to AWF!

Hi. Welcome to AWF!