You can email [email protected] - glad you're interested!

I have not tested that method, but I'm glad you found a workaround!

You should be able to find the appropriate reference for LibreOffice like pyexcel-ods that will enable you to read ods files.

Reply to my own comment, just realized access is 32bit & python 64. not sure I want to swap either so may look at alternatives.

I would suggest using a SQL query to get the sum directly instead of using VBA to loop through fields. In the query grid, you can just make a column: MySum: [Field1]+[Field2]+[Field3] etc Array sums are used when you're doing some kind of more complicated programming and you have values in memory (the array) and need to add for a particular purpose. Pretty cool that you got the example working! You will find more of a need for this as you make more complicated apps.

@seanmackenziedataengineering Thnx Sir. Shall abide by your advice. My question is I want write a sql statement referring only to that particular page of a columnar form. Suppose I have a columnnar form and in it's first page there is a field called "Board" . I have put navigation buttons and presently at a page where Board = 1. Therefore instead putting hardcover reference like "Where Board = 1", I want to put a text box which will refer to that particular page and bring the result by using ampersand as I have noticed in some of your illustrations. But I don't know the correct syntax. To make it understandable, in my columnnar form I am at page 1 where Board is 10 and I want to write a code like this: Select Field 1 + Field 2 from table 1 where Board = Me.Board. and it will display the result in the textbox where Board is 10 and ignore record of other pages where Board is not 10. I don't know whether I can do it. Regards.

Maybe this is possible with the shell execute function please help to understand the shell execute function

Make sure that your version of Windows has vbScript enabled. This is a new thing where it is not immediately available (by default).

Did you install the CUDA toolkit? You may need to install that separately.

@@seanmackenziedataengineering Yes, I installed it. I was trying to use the stable version 12.4, but it was giving me an error. However, today I managed to install it using version 12.6. Thank you.

Nice 🛠

Looks like you found it! For everyone else, there is an associated link to the video. If you are on mobile, it will be near the bottom of the screen. On desktop, it may be beside the video or something like that.

Thanks for the feedback! I appreciate it!

​@@seanmackenziedataengineering si, io ho creato una maschera invisibile in modo che quando l'amministratore mette in manutenzione l'applicazione un messaggio arriverà a tutti gli utenti che avranno l'applicazione aperta e dopo 5 minuti se non la hanno già chiusa li espellerà. Sono curioso di vedere come l'ha costruita lei,attendo la pubblicazione del suo video. Grazie ancora per la condivisione gratuita del suo sapere!

He has always responded to my questions and comments. Sean is awesome and doing a great job.

It is a problem that I have seen as well!

You probably need to install the ODBC driver for Access, which gets installed when you install the Access Runtime redistributable (you can google it)

It certainly is an amazing product! 🛠

It could be a spelling mistake. Or, if you use db.execute, it will not work; yo have to use DoCmd.RunSQL as it has access to expressions like you use.

Not that I know of.. anyone else heard of anything?

Yes that's true.. I guess in the older editor you can still write your SQL as I have done, without code assist and when you save it, Access will mangle it and change your spacing etc. I highly recommend using Notepad++ or something similar as I demonstrated in another episode to write more complicated queries. It allows you to use some limited code completion, spacing, indenting, and other goodies; plus it can act as a kind of clipboard on steroids (and a backup!). I showed it here: kzbin.info/www/bejne/n5C4dI1ras-Aptk

Happy New Year! Cheers

Many thanks!

¡No hay problema! ¡Gracias por mirar!

Glad you think so!

There are many different styles of installation. This is a basic installation to install and use PyTorch. Are you worried you'll install something you don't want to?

@@seanmackenziedataengineering no I figured it out I got it

Welcome 😊

It is a Python app already - I'm not sure how to get it onto iPhone or Android. Anyone else have a solution for that? *Also* you may want to consider Streamlit which will make it a web app that works for desktop, iPhone, etc

Glad it helped!

My pleasure! 😊

My pleasure! Glad it helped.

This solution works for a backend on a file share as well. If you get a read-only message, it is more likely a permissions issue on your file share. You need to give Full Control access to all users for best results. Read/write also works but will not release the lock file after the last user exits. You may need to talk to your IT department if it is a corporate network.

Thanks for asking! Still here :-) Took a little holiday so I have not posted much over the past weeks.

Awesome, nice work! 🛠

Glad you liked it!

In the video at 0:58

@@seanmackenziedataengineering Thank you Sir. Looking forward for your advice on another post where you wanted to know my requirements on building a SUM function. Regards.

For example, you can load an array in the Form code when the form opens. Maybe it is some kind of query lookup for when a user selects from a combo box. They select, then a complicated price lookup occurs via a query to the backend. It takes three minutes each time the user selects in the drop down. The user has the form open all day while they work. If you load an array or collection when the form loads, it is always available. Maybe a complicated price calculation now takes three seconds each time, instead of three minutes.

@@seanmackenziedataengineering Thank you Sir for your kind reply. But as I am a total beginner, it is too difficult for me. Since you are pre occupied with lot of assignments, cannot request you make an illustration on this which I could follow. Anyway I am trying to write a SQL code in the Got Focus event of the field of my form like "Select SUM(FieldName1, FieldName2) from Table1 where (FieldName3) = 1 (as the case may be). But it is not working with an error message "Function Not Defined". Probably my code is incorrect or in declaration of variables as writing module or function is not known to me. Anyway I sincerely express my gratitude for looking into my problem. Sir, sorry to bother you once more. I am trying to build a report with three fields like A1, A2 and A3. My question is can I group them under a single group and sort them corresponding to the number against each field i.e. If A3 is 10, A1 is 8 and A2 is 5 and the report may look like this: A3 10 A1 08 A1 05. Tried with grouping and sorting but as the fields are different, cannot do this. Sir, if time permits, kindly look into this. Thanks and regards.

Glad you enjoyed it! Cheers

As far as I know, it is only available in Office 365, in the "Current Version" release. If you're stuck on 2021 or earlier and still need a good editor, I would recommend the free Notepad++ which you can see I use in other videos for simple editing. Just set the language to SQL and it will do all the highlighting for you.

@seanmackenziedataengineering thank you!! I appreciate it🙏

Most welcome! Yes, Access reports are awesome. This is in part due to their powerful pagination, grouping, and printer-friendly features that are hard to find in other products. Reports also have some interactivity that you can experiment with, that you see when you open a report in Report view, not "Print Preview" mode. Lots of features become available when you open in this mode - especially when you start using some Modern Charts features as well. Very powerful!

That could mean that the record was not found - perhaps deleted since you created it, or you need to reload the clone as it cannot find the one you're looking for. Once you have clones, keeping everything in sync can get tricky!

@@seanmackenziedataengineering Sometimes I just think there's an invisible character in the VBA somewhere messing things up.

My pleasure!

You just need to install the latest version of Office 365 to get the new editor. I talk about the new editor and version at 0:49 in the video (you can see the minimum version that get the editor). Pretty nice addition, isn't it?

My pleasure!

You're welcome!

Interesting observation. I think you're right - it would be nice to be able to do that. Some things you can do are to load other objects like listboxes and combos on the fly. In the past, I did solutions where users did input on a subform in some kind of temp table. Then, they would need to click a button to commit the changes (basically append them to the production table). This is useful in some use cases. Thanks for sharing!

Thanks - that office I had a few years ago was right beside some train tracks. I usually had to pause recording while trains went by 😂