Видео

Glad you're finding them useful. I've been working on other projects for a while but have several videos planned for later this month. Anyway, yes you can add transparency! I covered this in a video from a couple of years ago related to my Attention Seeking database: ruclips.net/video/YlnCCPZBGEE/видео.html The linked article & example app is at isladogs.co.uk/attention-seek/

Actually my name is Colin! I've never tried linking to a named range in Excel but I expect it will work if you do this: SELECT XL.* FROM (SELECT * FROM [SheetName$NamedRange] AS xlData IN G:\MyFiles\ExampleDatabases\Excel\tblData.xlsx’ [Excel 12.0;HDR=yes;IMEX=0;ACCDB=Yes]) AS XL; Please can you try & let me know

Hi. Just rechecked in v2407 (Beta Channel). although both methods work in a continuous form, I still get the error using Application.CommandBars.ExecuteMso ("FiltersMenu") in either the Label_Click or FieldName_DblClick event of a continuous subform As DoCmd.RunCommand acCmdFilterMenu ALWAYS works and is less to type(!), I now always use that method.

@@IsladogsOnAccess That's right, if it's less to type and always works, that's the way to go.

Nothing obvious springs to mind. Suggest you ask in an Access forum giving relevant details and screenshots of the report from both computers

My pleasure! Glad you enjoyed it!

Hi. Assume you mean cross tab query. Use the wizard to do this and if necessary edit it manually

@@IsladogsOnAccess yes many thanks

More to come!

You're welcome!

My pleasure!

Glad you liked it

Let me buy you a beer, I'll be using this immediately...

Thanks. Can I drink it immediately? 😊 it’s a neat little feature which formed a small part of my Access DevCon presentation in April. Although I don’t often use it, the feature is invaluable for selectively hiding command buttons in a continuous form.

You're very welcome. Its a very useful feature that has been hiding in plain sight for many years!

Yes - as it says in the video details ...For further details and the example app, see my article isladogs.co.uk/control-help/. The app includes all code

Many thanks

Thanks @jojosmith342. Glad you found it useful. Do remember that whilst it should significantly reduce the chances of anyone meddling with your database, it isn't intended to be secure enough to prevent serious & determined hackers

Thank you

This is obviously not useful for the scenario you describe. If you are interested, I do have other articles on securing Access databases. For example: www.isladogs.co.uk/improve-security-2/index.html

Thanks

The second video is available now ruclips.net/video/PYbjtY3Q9w8/видео.html Surprisingly it seems to have little or no impact on performance. If the timer interval was reduced from 500 to 100 it might have more impact To reduce any possible impact, you could add a check to only run the code where the active datasheet had changed

@@IsladogsOnAccess thank you for the feedback Colin👍

You're welcome. Glad you like it. There are many more similar items available on my website. See www.isladogs.co.uk/add-features-forms

Hi Oscar. Not sure I understand what you are asking here. Auto Indent allows you to indent the first line of code by the specified number of spaces using the tab key. All subsequent lines will then start at that tab location For more details, see the MS Help article: for VBE Options - learn.microsoft.com/en-gb/office/vba/language/reference/user-interface-help/options-dialog-box. As this is off topic, if you need more help, please email me using the contact button on the related web article for this video

You're welcome

Thanks

Thanks. Glad you found it useful

Thank you

Thanks for the compliment. Glad you like it

Glad you found it useful. Of course, user prompt text only works well if the textbox is big enough for the prompt! Personally I prefer the caption method for most purposes

I assume you mean in the GetOrderBy function. Line numbering is a very useful feature available with the excellent MZ-Tools VBE add-in. I sometimes use line numbers to assist with trapping errors during development. In this case, I forgot to remove them before releasing the app. They have no effect on the code itself

Hi Jeff. I use code similar to this in many of my apps and have never experienced the problem you describe. In any case, only Top & Left are used in VBA. I've just tested and cannot replicate your error. However, your suggested changes clearly worked for you and I'll bear them in mind if I do experience them in the future. Thanks

Function HexToRGB(H As String) As Long Dim R As Long, G As Long, B As Long If Left(H, 1) = "#" Then H = Right(H, Len(H) - 1) R = CLng("&H" & Left(H, 2)) G = CLng("&H" & Mid(H, 3, 2)) B = CLng("&H" & Right(H, 2)) HexToRGB = RGB(R, G, B) End Function The Debug/Compile stopped dead in it's tracks on the If Left. Aren't LEFT, RIGHT, TOP, and BOTTOM technically reserved words? In any case I liked this video and the one regarding rounding corners and the circle.

@@gonefishing2006 I appreciate you trying to clarify the issue. However, I've rechecked my example app which compiles without error. The HexToRGB function isn't part of my app although I use almost identical code elsewhere. I imported my version of HexToRGB code into the app as a test and it still runs without error. Function HEXtoRGB(HEX As String) As String Dim R As Byte, G As Byte, B As Byte R = CByte("&H" & Left(HEX, 2)) G = CByte("&H" & Mid(HEX, 3, 2)) B = CByte("&H" & Mid(HEX, 5, 2)) HEXtoRGB = R & "," & G & "," & B End Function I suggest we continue this conversation by email - you can find my contact details on any page of my website. Perhaps you can send me an example which includes the compile error. Some questions for you - which version and bitness of Access do you have? In the VBE Options, what setting do you have for Error Trapping? I recommend Break on Unhandled Errors.

The link I gave you includes an example database (not mine)

Good to know ....😁

You're welcome

Glad you like it!

Various examples online e.g. see www.access-programmers.co.uk/forums/threads/code-128-generator-image-using-zxing-zebra-crossing-library.330588/

There are several examples by various authors in online Access forums. For example: www.access-programmers.co.uk/forums/threads/code-128-generator-image-using-zxing-zebra-crossing-library.330588/

You're welcome. Thanks for asking the question about resizing borderless forms!

Thank you

Glad you're enjoying the series. Still more to come!

LOL. A neater two step though!

@rtatt1 The idea is to hide a control even if there is no other control to set focus on in the form. Usually I added a transparent control on my form to pass the focus on. Thanks Colin for the trick 👍

@@nicor1501 You’re welcome. I first used it in a form with only one control.

Hello! Any other comment on the video? :~}

@@IsladogsOnAccess i loved it, i am very grateful. You asked to comment. That generally means type anything so the RUclips algorithm in theory makes it available to more people. I thought hi would meet that requirement

Well that's true but your longer answer was much more useful to me. Thanks for the comment!

What would help me is a key to devising two different tables that have relateds forms and explain why and jow the ghe data entry forms work togther, stating what objects dictate what the next line of code

Not sure it was ever a 'problem' but this is certainly a simpler solution than the standard approach

Sometimes simple solutions are the best!