Видео

This is a great question and helps to illustrate how this works. The answer is that you cannot use a subroutine for this purpose because it cannot be called in the same way. You are required to use = if you call some code directly from an event. You cannot call a sub using =. To make a public Sub for the same purpose, you can only call it from the form by also creating an Event Procedure with associated code-behind, then putting the subroutine as a single line in your new event procedure. So, you're creating a whole new code-behind and two lines of code, just to call a sub. For a context with 20 buttons using the same functionality, you now created 20x3 lines of code plus the code-behind when you could have just plugged the same function 20 times into form event properties.

Great to hear!

Glad you liked it - and thanks, I'll add that topic to my list! 🛠

Thanks for sharing - and happy to have you onboard. Cheers

You bet! mackenziemackenzie.com/downloads

@@seanmackenziedataengineering Thanks!

My pleasure!

Good idea for a video. Many of these tools like DropBox, Sync, and others have an app you install that allows you to designate a local folder to mirror the remote folder. So, you can use something like FileCopy ruclips.net/video/o8VMtHRW3w4/видео.html to just get the path and then copy files between folders on your computer or to pick a file to open. The synchronization with folders on the web will happen automatically. This is just one method, there are others too.

Glad you liked it!

Any time!

You're almost right - the (latest) official name I see on their download page is SQL Server 2022 Express, though that is a bit long and the product is simply known as SQL Express in the industry. Like people just say Access database or SQL Server database instead of SQL Server Enterprise Edition database or something.

You don't need to use vbScript to connect to MySQL, you can just download and install the MySQL ODBC Driver > Create an ODBC DSN in Windows for MySQL > Create Linked tables to MySQL > use tables like you use Access tables.

You don't need to use vbScript to connect to MySQL, you can just download and install the MySQL ODBC Driver > Create an ODBC DSN in Windows for MySQL > Create Linked tables to MySQL > use tables like you use Access tables.

Glad it was helpful!

Welcome!

Nice tips!

Glad it helped!

No, you will need to create a database or use an existing one.

I believe that track was called "Ripped" and was included with license as part of the Camtasia studio selections.. 2019 or 2020 version iirc. I thought it was groovy!

Thx!

Most welcome!

Pls can you show us vb script to MS access to MySQL

First, make sure all the users are using a db copy that has your new logic. If your app is a style that has a lot of modal pop-ups then they will interfere with the shut-down process, ie: Are you sure you want to close that form? That will stop the shut-down process. Design-wise, you want to convert that kind of behavior to use custom pop-ups that will still close on a shut-down command. Also, you may have an app where users can leave a form open (say a big data entry form) in an un-validated state. You will want to start modifying those forms so that they can exit gracefully unattended. Those kind of situations can cause issues but you can design for it.

Glad you like it!

Great suggestion! I'll add that to my list.

You can do it. Basically you can put the whole html+= block in the for loop in an if.. elif conditional statement, so it will only write a row if the row meets a criteria or something like that. Or, you can filter the dataset before you are writing the html, or you could conditionally format some elements. The possibilities are endless 🛠 for row in rst: if rst[1234] == 'Type A': html+= "other html" elif rst[1234] =='Type B': html+="red row here" else: html+="normal row html" Something like that!

It is possible that what you try to do after the delete gets an error. Perhaps you refer to the deleted record or something like that. What does your After Delete macro do?

@@seanmackenziedataengineering I want to store in the LOG table information about inserted/changed/deleted records from the DATA table. If I use the code Value = [DATA].[ID] in the After Insert or After Update event, it works, but if I use it in the After Delete event, then a new record is not created in the LOG table. No error will appear...

I want to write to the LOG table the insertion/change/deletion of a record from the DATA table. I use the expression Value = [DATA].[ID]. It works for both After Insert and After Update events, but not for After Delete. No record will be created, no error will appear...

@@vholas it is likely because you refer to a value that is already deleted when the macro runs. You might try Before Delete instead so you can use the value before it is deleted. Let’s see how it goes 🛠️

There is no CreateRecord action available for the Before Delete event. I also tried accessing the previous value in a field by using syntax [Old].[Field Name] , but this doesn't work either.

There's a challenge! I think you would probably need some kind of event in your app that would reset an inactive flag (maybe every time they hit OK or something like that). If they are inactive for x minutes/hours then gracefully shut down.

Awesome, welcome aboard! Yes you can use other ports by switching those during setup, and you can use more secure authentication (though the email will still be unencrypted)

You can try to classify the historical data using some measure: high, med, low or something like that. Try features or data-points that might also be in predicted models to train your models (temp, snow pack etc). Then try predicting based on what other models show. Something like that. Lots of dependencies but worth a try!

Cool project!

lol! 😀

You'll have to research that one. It seems to be related to previous or incomplete installations.

Thanks!

The account will be created when you make a snowflake account online. They will give you an address that you can go to access your Snowflake instance. It will be like abc12345.snowflakecomputing.com - your account is abc12345 in this example.

Many ways to do things indeed! If you need to replace something in text, you can use Replace ruclips.net/video/R5-gzNq7tgw/видео.html

You bet!

Happy to help!

I remember seeing this on another db back in the day when I first started, and was like, "you can do that??" lol

@@seanmackenziedataengineering Yeah haha. I wasn't aware either. But I frequently use the exact same trick on text boxes, so makes sense that it works on buttons as well!

You can see how to get it with this video: ruclips.net/video/rq_oqznypFo/видео.htmlsi=4SD5SNWkF3pmXX3W

Great idea - I'll add it to my list!

Si configura la propiedad RecordSource para ComboBox, guardará la elección. ¡Buena suerte!

Glad to hear!

BioBERT.. never heard of that one. I'll have to check it out! Specialized BERTs seem to be exploding on the scene - I'm looking at AeroBERT for aerospace and that looks cool too.

Possibly - I saw something about "Conversations" in the Twilio docs.

You bet! The trick is to get openstreetmap tiles working offline. It is all open so you can do it. A quick search will show the way.

This is a great question. The last version of Access with replication as a main feature was Access 2003. Replication was supported in Access 2007 and 2010 but then completely removed from Access 2013. This is unfortunately one of many brilliant technologies that Microsoft killed in favor of other alternatives. Not only that, but the 2003 version was even better than what I demonstrate in this video, because iirc it used a GUID instead of numeric ID among other things. If you really became skilled at implementing replication, it worked like a dream. I did several projects that were probably a decade or more ahead of their time - because of replication. Lots of developers took the time to learn it and reaped great rewards. However, iirc from what I read at the time, lots of developers did not achieve success with it and got themselves in trouble.. ..leading to a support nightmare for Microsoft.. so they removed it. This was similar to the removal of Access user security as part of the deprecation of the .mdb file format in favor of .accdb. It suggests that Microsoft wanted to "dumb down" Access and keep it as a desktop database tool. This would push serious developers to work with SQL Server/Express instead so they could access these kinds of features.

@@seanmackenziedataengineering Thanks for the insightful answer. I’m using the GUID auto number data type to implement my on replication schemes, but it’s an uphill battle.

You're very welcome! Good luck on your data engineering journey 🛠

If you numbered them like txtMyNumber0, txtMyNumber1, txtMyNumber2 etc then you can load them in one loop, something like: Dim intItem as Integer Dim arr(26) For intItem = 0 to 26 'say you have 27 text boxes arr(intItem) = Forms!MyForm("txtMyNumber" & intItem) Next Array is loaded! If you don't have a numbered design on your form then you can manually load: arr(0) = Forms!MyForm!txtThisField arr(1) = Forms!MyForm!txtThatField etc.

2nd option suits me I will try that out 1st option is cleaner and simpler if new this on designing stage Bravo 🫡

Will you kind enough to add to your “Download’ please Better to keep it in my collection 🤞

@@tuffley2175 added.

Will do!

Great question - you can also try: snowflake.connector.errors.ProgrammingError as e to refine your error trapping. Snowflake documentation also uses more general examples with: Exception as e If you're missing errors, I would try the first statement. You'll have to test and decide which will work best for your context. docs.snowflake.com/developer-guide/python-connector/python-connector-example#handling-errors