Hi The following code indicates that Access cannot run the macro or calback function ribOpenForm Public Sub ribOpenForm(control As IRibbonControl) DoCmd.OpenForm (control. Tag) End Sub - I don't see what is wrong

Downloads still not working

This is INCREDIBLE! I am going to share this with my whole class!! You are my new hero no joke.

The links do not work?

Great video!

A nice approach to importing excel sheet data, but whether it can be imported with SQL command and ADODB if data in excel is stored in actual real formatted table (CTRL+T).

You are terrific.....absolutely fantastic.....thanks a hexarillion

Great videos! Could it be that the links to the XML code no longer work?

The link fo VBA in this video does't work. Will you be kind to fix it?

Theri is no code!

Thanks so much for this clear and thought through approach! Just to add my voice to the plea to make (again?) the code available on the indicated (broken?) link. Many thanks for the effort of producing this video!

Hi Access Jitsu. Is there a way to obtain the VBA code text in a file ? Or you could post the VBA code here. It is really hard to just type them up because the text is so small.

CAUTION !!! --- Hey, Access Jitsu, your a GREAT teacher and I am learning a lot from you! Maybe I missed it, but it might be possible that you simply forgot to tell people to be sure to have their Microsoft Office Library Objects turned on in order for some of this code to work!

GetFileFolder("file", "Choose the Access database holding your tables (the backend)") not work.

It didnt work for me! :( Private Sub form_Load() Me.TAB1.Value = 0 TAB1_change End Sub ---- Private Sub TAB1_change() Select Case Me.TAB1.Value Case 0 Me.SubCont.SourceObject = "00_Main-Menu" Case 1 Me.SubCont.SourceObject = "01_Project-List" Case 2 Me.SubCont.SourceObject = "02_Add-Project" Case 3 Me.SubCont.SourceObject = "03_Whiteboard" Case 4 Me.SubCont.SourceObject = "" Case 5 Me.SubCont.SourceObject = "" Case 6 Me.SubCont.SourceObject = "" Case 7 Me.SubCont.SourceObject = "" Case 8 Me.SubCont.SourceObject = "" End Select End Sub

I asked chatGPT to fix me up something like this but couldn't do it. Thanks

how to put subtotal on each group?

This is great tutorial. But if I use this method, when selecting object within SQL I cant use access query (eg. they named "qryOutstanding") it raised error pop up. actually it should a table or it possible I use access query? because: - if I use access query (eg. "qryOutstanding")= raised error: "expected parameter..bla bla" - If I use table as data source (eg. "tblCustomer") = no error solution?

Thank you, definitely learnt something.

Can somebody please direct me to the code as the link is not showing the code.

Hi I am not able to view the source code in you website. Please help.

Brilliant!!!!

I'm a bit late to the game but this tutorial looks invaluable to me. I have a fairly complex set of data in an Access database that I need to provide to colleagues that don't have access to the database in Excel format so that they can then build their reports and presentations. I do this alongside my 'day job' which is a maintenance engineer so this video is priceless.

there is no code!

Great. Can we use option group to open multiple sub forms like this?

Señor Jitsu, muchas gracias por su contenido y por su excelente explicación, Felicitaciones, estoy asombrado con sus amplios conocimientos.

Thank you

Thank you

Help! I want to import from access a query into a excel file, to a specific tab and cell

Awesome Series 👌 Can you explain how to use Macros with xml? For example On Open run this Macro from xml Can we let xml to Auto run Macro? Instead of clicking on?

hi. the download link doesn't work?

Only way ever feed Access been trying get Access into SQL but thinking bypass but want connection with Access my forms contain over hundreds field in on forms no my widgets are the sun moon planets asteroids the stars come talk with me set sky in motion my fascination with sky soon my ma ma name in sky be over head soon the Bull of Poniatowski on my puppy papers that fascination with sky hereditary

Pls can you show us Link to the VB code to relink backend

Just watching but its not clear zooming would be some kind of great amazing work

This is awesome, thank you for this video. May I ask, in a split DB scenario, is there an automated way to make changes to the back-end database? it does not happen often, but sometimes it is necessary to eg. add a column to an existing table, or even add a table to the backend DB. Is there a way to code this and roll out during an upgrade distribution?

The VBA in this video is located here: accessjitsu.com/2017/01/25/mic... was not available

Great Videos ! I tried to download the VBA code but there's no code on the given link.

Sir what an amazing videos you are definitely the best!

Thanks for a great series. I am working through it with Access 365 and Visual Studio 2022 and have run into two problems; 1) Trivial but annoying - all formatting is lost when I cut and paste the xml code into the form. 2) When I attempted to change the showFromScratch from false to true for the user ribbon, it was impossible to type correctly in the xml data field in Access. Could that have something to do with the fact that there is no longer a Memo type. I had to use Long Text instead. Thanks!

Sir, I have opened the link but I think there is no download link (for VBA)

can uplod file plz?

thanks

can uplod file plz?

The link to the VBA is not working.

Thanks for the information . But when i split data bases there come an error saying "cannot lock file as this is used by other program or user" i have got an excel power pivot running from my data base on network. I really need to split data base as we are moving to cloud - one drive - Could you pls help with this...

Can you update the link to the code?

Overall great video! Thanks!! One question, From your video, was able to go to files already exported but with the columns not being the width I want and I can now make them the right width. One Question, I often have one column that is date\time but it defaults to just showing dates, and I'd like to automate to show time. How could I make the whole column date\time format such as mm-dd-yyyy hh:mm Or something like that?

Amazing, please upload it Link not working

Great video, thanks 👍 Can you please send me the code The link is broken, have nothing in the Page Thank you

Great!!!! very simple and giving very core. Thank you so much..