![Isladogs On Access](/img/default-banner.jpg)
- Видео 64
- Просмотров 84 175
Isladogs On Access
Великобритания
Добавлен 6 ноя 2021
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: ruclips.net/user/MendipdatasystemsCoUkvideos
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!
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: ruclips.net/user/MendipdatasystemsCoUkvideos
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!
Move the Application Window AND Popup Form Using Code
This is a follow up to my earlier video about moving the application window using code: ruclips.net/video/8k7eKFpsUO4/видео.html
In that video, I explained that a popup form would not move as it is independent of the application window.
In this video, I demonstrate how the popup form can also be moved with the Access application window using code.
It was created in response to a challenge from Karl Donaubauer (MVP) on LinkedIn
The demo app and all code is available from isladogs.co.uk/move-app-window-popup
TIMES:
0:00 Intro
0:25 Example App
0:37 Standard Access form - use move down & mouse move events to drag Access application window together with the form.
0:47 Popup form doesn't move as inde...
In that video, I explained that a popup form would not move as it is independent of the application window.
In this video, I demonstrate how the popup form can also be moved with the Access application window using code.
It was created in response to a challenge from Karl Donaubauer (MVP) on LinkedIn
The demo app and all code is available from isladogs.co.uk/move-app-window-popup
TIMES:
0:00 Intro
0:25 Example App
0:37 Standard Access form - use move down & mouse move events to drag Access application window together with the form.
0:47 Popup form doesn't move as inde...
Просмотров: 211
Видео
Move the Access Application Window Using Code
Просмотров 3102 месяца назад
Here is another user interface 'trick'. This video shows how the entire Access application window can be moved using code. This can be useful e.g. to temporarily switch the currently visible application between Access and PowerPoint during a presentation. Thanks to Jesús Mansilla for bringing this code to my attention The demo app and all code is available from isladogs.co.uk/move-app-window TI...
Hide the Taskbar Icon
Просмотров 2612 месяца назад
This video demonstrates two solutions to a deceptively difficult task: hiding the taskbar icon for an Access application. For more details and the example apps with all code, go to isladogs.co.uk/hide-taskbar-icon TIMES: 0:00 Intro 0:34 Background Info - easy to explain / difficult to do / why do it / two solutions with application window visible or hidden 1:29 DEMO - using standard Access task...
BUG: Office & VBE Languages Different
Просмотров 2883 месяца назад
This video demonstrates a strange bug that occurs when English (UK) Office users change to another language such as Spanish and back again. On reverting to English (UK), the VBE language remains in Spanish. The video also describes three workarounds for the issue until it gets fixed. For more info, see my article: isladogs.co.uk/office-vbe-menu-lang-glitch Times: 0:00 Intro 0:37 Demo of issue 2...
Lock Down Database Objects
Просмотров 3653 месяца назад
This video is the second in a 2-part series. It demonstrates a simple method to prevent users accessing the tables, queries and macros to protect your data. This is designed to block knowledgeable users from meddling with your database. The ideas build on the approach used in the earlier article, isladogs.co.uk/protect-data-tables-queries and video: ruclips.net/video/6coPMh8My44/видео.html, in ...
Protect Data in Tables and Queries
Просмотров 4843 месяца назад
This video is the first in a 2-part series. It demonstrates a simple method of protecting your data by prevent users editing tables and queries. This is designed to block knowledgeable users from meddling with your database. In this example, tables & queries are made read only. This is made possible by the fact that tables & queries behave in many ways like datasheet forms with similar code use...
Gradient Background Fill in Forms
Просмотров 2444 месяца назад
This video demonstrates several ways of adding a gradient background fill to your forms to make these more visually interesting for your users The examples include 2 methods using code together with another two no-code approaches. For more info, see my articles: isladogs.co.uk/gradient-fill Times: 0:00 Intro 0:26 Outline of the different approaches 1:12 DEMO with 5 example forms 1:19 Code metho...
Highlight Sorted & Filtered Columns in Continuous Forms
Просмотров 4764 месяца назад
This video demonstrates how to highlight sorted & filtered columns in continuous forms For more info, see my articles: isladogs.co.uk/sort-continuous-forms and isladogs.co.uk/highlight-filtered-columns Times: 0:00 Intro 0:33 DEMO - Two very similar forms 0:44 Continuous form with sort buttons 1:41 Filter columns 2:28 Form with transparent buttons to mimic appearance of standard continuous form ...
Highlight Selected Control or Column in Continuous Forms
Просмотров 3374 месяца назад
This video demonstrates how to highlight the selected control or column in continuous forms using transparency and accessibility code For more info, see my article: isladogs.co.uk/highlight-selected-control-column/ Times: 0:00 Intro 0:22 DEMO - Highlight selected control & entire column 0:44 Deisgn view - controls have transparent background but were originally set as yellow,. 1:10 When clicked...
Rounded Corners in Forms
Просмотров 7714 месяца назад
This video demonstrates how you can easily add rounded corners to forms in any version of Access. The amount of rounding can be adjusted. The effect works best with borderless forms. For more info, see my article: isladogs.co.uk/rounded-corners Times: 0:00 Intro 0:35 DEMO - start with standard form in Access 365 / Windows 10 with square corners 1:17 Top corners rounded 1:35 Modify to round all ...
Move & Resize Borderless Form Using Mouse Events
Просмотров 3614 месяца назад
Most Access forms can be moved by dragging whilst holding down the mouse on the form title bar. This isn't possible for a borderless form. This video shows how a borderless form can be both moved and resized using a combination of mouse down and mouse move events. Doing this requires surprisingly little code and very few API calls. Related article with all code and example app: isladogs.co.uk/m...
Click Me and I Disappear (Hide Control With Focus)
Просмотров 4204 месяца назад
This short video shows how you can hide a control in one step without first setting the focus to another control. Related article with example app: isladogs.co.uk/hide-control-with-focus Times: 0:00 Intro 0:13 DEMO - disable / lock control with focus - both work with no errors 0:29 DEMO - attempt to hide control gives error 2165 - can't hide control with focus 1:05 To fix, usual solution is to ...
Highlight Entire Form (Dim Background)
Просмотров 6495 месяцев назад
This shows how you can dim or hide the background to focus user's attention on the current form Related articles with all code and example app: isladogs.co.uk/highlight-entire-form isladogs.co.uk/attention-seek isladogs.co.uk/move-resize-selected-columns-2 Times: 0:00 Intro 0:42 How the App Works 2:18 DEMO - using Move/Resize Selected Colums app with popup forms that open with the background di...
Freeze Columns in Continuous Forms
Просмотров 5785 месяцев назад
This video is part of a series on extending the functionality of continuous forms, using code to add features available in datasheet forms. The video demonstrates a simple method for freezing (and optionally locking) columns in a continuous form at runtime. These columns remain fixed in position when the form is scrolled using a horizontal scrollbar and when navigating the form using the tab or...
Hide & Restore Selected Columns in a Continuous Form
Просмотров 4775 месяцев назад
This video is part of a series on extending the functionality of continuous forms, using code to add features available in datasheet forms. The video demonstrates a simple method for selectively hiding / restoring columns in a continuous form at runtime. This is done by double clicking the column header label. All other columns are moved across leaving no gaps. The hidden columns are listed in ...
Paint Me Transparent (Selectively Hide Controls in a Continuous Form)
Просмотров 1,2 тыс.5 месяцев назад
Paint Me Transparent (Selectively Hide Controls in a Continuous Form)
Move Borderless Form Using Mouse Down Event
Просмотров 4435 месяцев назад
Move Borderless Form Using Mouse Down Event
Multiselect Filter in a Continuous Form
Просмотров 1,9 тыс.7 месяцев назад
Multiselect Filter in a Continuous Form
Highlight Current Control - NO CODE REQUIRED!
Просмотров 8509 месяцев назад
Highlight Current Control - NO CODE REQUIRED!
Access Database Analyzer Pro: 6 - Evaluation, Purchase & Activation
Просмотров 32211 месяцев назад
Access Database Analyzer Pro: 6 - Evaluation, Purchase & Activation
Access Database Analyzer Pro -5: Analysis History
Просмотров 13211 месяцев назад
Access Database Analyzer Pro -5: Analysis History
Access Database Analyzer Pro - 4: Analysis Reports
Просмотров 19411 месяцев назад
Access Database Analyzer Pro - 4: Analysis Reports
Access Database Analyzer Pro - 3: View Analysis Results
Просмотров 32011 месяцев назад
Access Database Analyzer Pro - 3: View Analysis Results
Access Database Analyzer Pro - 2: Options & Analysis
Просмотров 26711 месяцев назад
Access Database Analyzer Pro - 2: Options & Analysis
Access Database Analyzer Pro - 1: Introduction
Просмотров 47011 месяцев назад
Access Database Analyzer Pro - 1: Introduction
Change Query Views Using Command Bars Code
Просмотров 461Год назад
Change Query Views Using Command Bars Code
Making Automatic Form Resizing Work for You
Просмотров 3,3 тыс.Год назад
Making Automatic Form Resizing Work for You
Update on the Relationships Windows Bug - Part 2
Просмотров 200Год назад
Update on the Relationships Windows Bug - Part 2
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: ruclips.net/video/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.
@@IsladogsOnAccess That's right, if it's less to type and always works, that's the way to go.
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?
Nothing obvious springs to mind. Suggest you ask in an Access forum giving relevant details and screenshots of the report from both computers
Thanks for sharing. Awesome insight.
My pleasure! Glad you enjoyed it!
Amazing can you make video on how to make crosstab table in ms access
Hi. Assume you mean cross tab query. Use the wizard to do this and if necessary edit it manually
@@IsladogsOnAccess yes many thanks
Very interesting, thanks for sharing your insights on your tips and tricks series Sir. Hopefully more useful tips and tricks coming up.
More to come!
Thanks
You're welcome!
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 ruclips.net/video/VXpDkiANNUU/видео.html
Thanks so much, every time you coming back with great job.
My pleasure!
Nice work Colin!
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.
This is great news! Thanks so much for sharing it. Your video explained things very clearly. Again thank you.😊
You're very welcome. Its a very useful feature that has been hiding in plain sight for many years!
can we have the codes please. Nice video
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
Amazing work ❤
Many thanks
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
awesome
Thank you
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
Thanks so much, this is awesome.
Thanks
really inspiring indeed. I can't wait to watch the 2nd video. Quick question: will the 'timer' event not impact the global performance of the app ?
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👍
This is the second video in a 2-part series. The first video (Protect Data in Tables & Queries) is available at ruclips.net/video/6coPMh8My44/видео.html
This is the first video in a 2-part series. The second video (LockDown Database Objects) is available at ruclips.net/video/PYbjtY3Q9w8/видео.html
That is exactly what I was looking for. Thaaaaaaank you so much !!!!!!!! 👍👍👍👍👍👍👍👍👍👍👍👍👍👍
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
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
Great idea!
You're welcome
very good
Thanks
Colin, Thanks for the great job and explanation. It's very useful.
Thanks. Glad you found it useful
Excelent as always Mister!!. Best Regards.
Thank you
Excelent Sir!! always amazing!! Regards.
Thanks for the compliment. Glad you like it
The user prompt text is incredibly simple to implement and a major user experience upgrade. Thank you for sharing this.
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
Great video, thanks so much. I want to ask you about the numbers at the begin of the code line, what's that mean?
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.
Thanks
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.
The link I gave you includes an example database (not mine)
I was just thinking about his...
Good to know ....😁
thank you, pro
You're welcome
It is great, thanks so much.
Glad you like it!
Please, I want to know how to create a category with multiple barcodes and units of measurement
Various examples online e.g. see www.access-programmers.co.uk/forums/threads/code-128-generator-image-using-zxing-zebra-crossing-library.330588/
Please, I want to know how to create a category with multiple barcodes and units of measurement
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/
Create more than one barcode for one item using Access
Thank you for showing this one. I'm yet to use it ----- but it's going to happen.
You're welcome. Thanks for asking the question about resizing borderless forms!
Excellent !
Thank you
Interesting video, still studying it. I use only one (generalized) continuous form in all applications. Adding functionality to columns becomes then very easy.
Useful videos series and great job, thanks.
Glad you're enjoying the series. Still more to come!
In response to a question by @gonefishing2006, I've just uploaded a follow-up video Move & Resize Borderless Form using Mouse Events: ruclips.net/video/fp25Q17fajA/видео.html
So you replaced a 2 step process with yet another 2 step process. Fabulous!
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.
hi
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
Thanks. Encountered the same problem and looking up for a solution.
Not sure it was ever a 'problem' but this is certainly a simpler solution than the standard approach
Brilliant
Sometimes simple solutions are the best!