Search results

I'm not suggesting you try what was described. I'm suggesting that, since you are embarking on a new direction of development, there might be useful information available in that discussion regarding interactions with IoTs.

I'm sure that you can't create relationships on fields of different datatypes. I just successfully created a query joining two tables on a tinyint field and a smallint field, though. It made no sense logically in this test scenario, but SQL Server didn't object, since both as integers...

You might get some ideas from this YouTube video. It was a presentation on using and Azure IoT Hub with SQL Azure, but it has an extensive discussion of use of the IoT devices involved.

I won't share all of the details about why I know this to be a true statement, but it does involve a significant volume of curse words and keyboard practice while retyping those code changes.

Oh, in that case, I truly believe you are wasting time and effort to save some space that doesn't need to be saved. I can definitely see doing something like that in a green field database where you don't have to manage existing architecture and data and the motivation of saving spaces is...

I too am curious about the need to convert the datatypes of fields involved in Foreign Key Constraints.

Initiative: An organized effort by a group or groups to achieve a common goal. Trend: A prevailing tendency or inclination with no specified goals. What is actually happening with Access? Is it a trend or an organized initiative?

The situation has been greatly complicated by the recent censorship Online Safety Act laws in the UK.

Thank you. You have indeed proven something, even though you probably didn't intend to do so. Perhaps someone does have time and the inclination to replicate the line numbering function in one of the commercially available Access tools (MZ Tools, VBE_Extras, and perhaps others) for you.

And with that you just made my point :rolleyes:. You started out by asking other people to do the hard work of coming up with VBA code that replicates something already in existence. And you end by asking other people to do the hard work of trying to track done something that we suspect...

One last time. Show us the examples of your contributions, please. Links are fine.

Insulting other people is not the same as providing concrete examples to prove a point. This response falls under the same approach as the one which started this discussion: asking others to provide you with a way to create line numbers in VBA. You want the benefit of that tool, but expect...

A link to one such contribution you have uploaded here would easily prove your point.

Take a close look at Post #12, please.

Most of the people who participate in this forum are working professionals who have employers or clients to satisfy. Some of us are retired, though, and often look for time-filler projects to both contribute something to the Access community and to keep our skills as sharp as possible. Your...

Please clarify a bit. Why do you want to display the value from the control on the subform in another control on the main form? Is the value displayed in the control on the subform, txtScoreRating, a value which is calculated from other fields in the subform's recordsource? If the only thing...

I know you've mentioned this in previous posts referring to Navy regulations when you worked there. I too would like to know the specifics of those requirements, whether it referred to how long backups were to be retained, whether the regulation pertained to maintaining control over any existing...

My position is that experienced developers who understand how MVFs are designed and how to implement them are more likely to avoid them in favor of more robust approaches. Novices who don't understand normalization, much less the inner workings of MVFs, are more likely to use them and do so...

Simple enough. (y) But with a true Group, it would be: Me.GroupofControlsName.Visible = visibility and no need to poll all of the controls for the presence of the tag.

Same idea, but more code required I would expect.