My name is Colin Riddington and I am the owner of Mendip Data Systems based in the UK. I am also active on many online forums - usually with the user name isladogs.
This channel, Isladogs on Access, will be used for videos explaining features of various free example apps and code samples for Microsoft® Access® that I have created in recent years.
My other channel, Mendip Data Systems, will in future only be used for videos related to my commercial apps. It can be found at: ru-vid.comvideos
Why Isladogs? (pronounced Eye-la-dogs) Isla is my now elderly labrador dog shown in the photo. When we got her over 10 years ago, Isla was a fairly unusual name in the UK (though it has since become very popular due partly to Game Of Thrones). Someone thought the name came from the Isle of Dogs which is a region of London next to the Thames. The name Isladogs stuck and I have used it as my username on several Access forums for several years!
@@IsladogsOnAccess Hello, I want to explain to you clearly, I want you to teach us how to create a management dashboard with a sub-menu in Microsoft Access. You have very good videos, thank you very much.
@@HusnaSadat-fo4zt - I did a quick search. There are many examples of this already - See list of hits at www.bing.com/search?pglt=41&q=RU-vid+-+create+a+management+dashboard+with+a+sub-menu+in+Microsoft+Access&cvid=f2b864e28a6b49cbb550c362d20c1efa&gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIGCAEQRRhA0gEINTE4M2owajGoAgiwAgE&FORM=ANNTA1&adppc=EDGEDBB&PC=EDGEDBB
It is easy ..... when you know how! 😁 See these other related videos ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fp25Q17fajA.html, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8k7eKFpsUO4.html and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VXpDkiANNUU.html
Thank you very much for your tutorials! I found your work while searching on Access forums, and your Control Application Interface codes helped me on a project back in January this year! Glad to know we now have individual videos for each piece of code! I wonder if there is a way to apply some degree of transparency to objects on a form. I think it would be great to have a transparent background for the form window. I found a code where everything becomes transparent, but I would like to apply it just to specify objects such as a background canvas, trying to simulate something like the aero theme from Windows 7.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YlnCCPZBGEE.html The linked article & example app is at isladogs.co.uk/attention-seek/
Thanks John for the "Edit Linked Excel files" video. Just one question, do you know of any vba code that I can use to link to an excel NAMED RANGE via vba rather than the wizard?
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
@11:15 That's weird, I've been using the Application.CommandBars method (thank you, BTW) in the column headers of a subform and I do not get this runtime error when I'm using the subform in its main form. I'm using Access 365 v2406, Build 16.0.17726.20078 64-bit
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.
Hello sir! Please I need your helf about some settings in reports. I have a report with a subreport that contains records in multilines. I wanted to make the textbox shrink if the content is short. So set "can shrink" value as "yes". And it worked correctly. However the same report on other pc looks more taller without shrinking. I guess that this could be some settings about windows itself. What could be the problem?
In response to a 'challenge' by Karl Donaubauer, I've since added another short video showing how you can move both a popup form and the application window together!. See ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VXpDkiANNUU.html
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.
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
all thumbs up to the BEST CODER. This is what I need to protect my DB that I have searched the solution and found your video.Thank you for your other valuable tutorial. Already subscribed
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
Very interesting video, but for me the easiest way to access the data is to open another blank database and import the tables, or use Excel using powerquery. Any protection against this (password-protected database is not useful because in that case the user would not be able to use the database legitimately)
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
The second video is available now ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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
This is the second video in a 2-part series. The first video (Protect Data in Tables & Queries) is available at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6coPMh8My44.html
This is the first video in a 2-part series. The second video (LockDown Database Objects) is available at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PYbjtY3Q9w8.html
Hello Mr. Isladogs Please can you resolve a question that I have had for a long time and that as an access user I have not asked to resolve. This is about explaining to me how indentation works (located in the text format option). I have searched all over the internet and I can't get a valid result. Thank you very much, I'm sure I'm not the only one who has this question. I apologize for my English
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
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
Short blurb. I finally got around to using some of the code ideas on my personal project. If anywhere in your code you use the Left, Right, Top, or Bottom you may get a Expected Array Error after inserting the modMoveResizeForm module. I sure did! Not a big deal I learned something (will I recall when needed?) I traced it to the modMoveResizeForm Module. Change under Enum RESIZEDIRECTION Change Left to something like LeftDirection, Right to RightDirection, Top to TopDirection and you guessed it Bottom to BottomDirection. And then go though the code that uses the RESIZEDIRECTION of the Public Enum, and change the Left, Right, Top, Bottom to the new names.
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.
Sir, I needed a practical example, meaning if I have a specific item with more than one unit of measurement, each unit has a specific barcode, like supermarket programs. Please explain.
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/
Interesting video, still studying it. I use only one (generalized) continuous form in all applications. Adding functionality to columns becomes then very easy.
In response to a question by @gonefishing2006, I've just uploaded a follow-up video Move & Resize Borderless Form using Mouse Events: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fp25Q17fajA.html