Search results

Just a little heads up, I do not have that browser control but I went to the website of your image and I can see that the menu that you are showing is a custom UI of the component. Pasting with the UI of said component does not work on my everyday browser, which means that the same message...

Maybe it's one of those policies where you can not do something that wasn't triggered by a human and therefore it needs direct access to chromium's API for that to work. Have you tried not using the clipboard and instead dumping the data in a variable? Have you tried using the...

I created a table with the most common data types and named its columns according to its type, the result of checking for DecimalPlaces was the following: ByteNumberField Field Type: 2 Prop Value: 255 IntegerNumberField Field Type: 3 Prop...

@Pat Hartman All number types load with a DecimalPlaces property, I don't know why, they just do. The GUI of the table designer also shows the decimal places field. I'm not saying it should be specified, I just mention that if you check for that property from VBA, it will let you access it...

In html, you would use <br> In vba, you could use vbcr or vbcrlf What are you using

That's my favorite place to find what's the default member, I tried to find the list of field types but I could not, I know I've seen it somewhere.

I did a bunch of edits to my answers, sorry about that. I promise they'll stay as they are from now on.

You may find a few extra issues when you try to anticipate the properties of certain types. I found that an autonumber is type 4, just like a long type. However, the autonumber has no DecimalPlaces property while the Long type does, for some reason. But there are still possibilities we can test...

That's a great question. Before that, in order to inspect your variable you enter debug mode, just make sure your Locals window is open. This is how I did it for your case, just a simple Stop after initializing the rst variable puts it in the Locals window and I can expand it with the plus sign...

Or if you prefer fld.Properties!DecimalPlaces This and much more can be found if you inspect your fld variable

Did you try .Fields(field).Properties("DecimalPlaces").Value In your case, perhaps DecimalPlacesHold = fld.Properties("DecimalPlaces").Value edit: fixed typos and errors

Yeah, it's different from splitting an accdb and putting the BE on a LAN, which is extremely easy to do. But since such a simple method for web accessibility does not exist, alternatives must be used. I assume Microsoft's alternative is to make us migrate to Azure or their other products in...

You're all welcome, I'm happy to help. (y)

I'm sorry about the lack of explanation. What you saw was me with your Excel file open on the left side of the screen and to the right you can see the VBA window with a code snippet and a few hand drawn remarks over the locals window. What I meant to show is that by inserting a module from the...

I'm sorry, George, I've been doing some plumbing this weekend, so I can't really watch the entire video. I did watch some snippets, but if what I said in conjunction to what you said aligns with what's covered in the video then I'm afraid it's that trivial. No fancy stuff, just basic REST API...

Your worksheet object has a collection to all hyperlinks. You can use it to import it into your access database.

Well, I'll see what I can come up with in this format, most part of the thread should be about how the REST API of Firebase expects you to make our HTTP requests. The whole strategy is 1. Make HTTP Requests, like "create http object, send request, receive response", that's like three lines of...

@KitaYama Thanks for the advice. I appreciate you took the time to check the sample and I'm glad you found it useful. Your IT department knows about their constraints and that's a good thing, but I would like to point out that Access is guilty of a lot of these: Even though I've used the free...

@KitaYama Reflecting on that, it did look like an angry response. I edited it. Unfortunately, I'm not affiliated to Firebase, so I can only speak by the number of developers that use the service and it's going up because database as a service is currently a trend and many employeers are...

Yeah, I absolutely agree, Doc. Navy operations are a matter of national security, a good candidate for the extreme of the line. You don't want to use software nobody will be responsible for in such a case. There are so many other companies across the globe that can't afford to have such a high...