Fantastic videos, thanks a lot, that's all many helpful and very well explained
@markjohnson378617 күн бұрын
This is a great series of tutorials. A potential time-saving option would be to write to a preconfigured/formatted Excel workbook that is of the type Template as a re-usable solution.
@j.dasilva4567Ай бұрын
I usualy do this with buttons, highlighting the button of the user option, but this seems to be a better idea. Thanks.
@salimtalal46962 ай бұрын
This is absolutely amazing. Thank you soooo much Access Jitsu, you saved my day. God bless you abundantly. Thank you, thank you, thank you.😘
@kcerny433 ай бұрын
You rock even in 2024. Nice!
@RichardMaitland-k7l6 ай бұрын
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
@jimmyitwv3 ай бұрын
I have the same error and my database used to work. I have changed versions of office. I'm wondering if this only works for 32bit installations.
@RungeCarl9 ай бұрын
Downloads still not working
@SusanSwanson-e6e9 ай бұрын
This is INCREDIBLE! I am going to share this with my whole class!! You are my new hero no joke.
@RungeCarl10 ай бұрын
The links do not work?
@RungeCarl10 ай бұрын
Great video!
@zoranstojanovski840710 ай бұрын
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).
@salimtalal4696 Жыл бұрын
You are terrific.....absolutely fantastic.....thanks a hexarillion
@janserpieters568 Жыл бұрын
Great videos! Could it be that the links to the XML code no longer work?
@adnanvrazalica53 Жыл бұрын
The link fo VBA in this video does't work. Will you be kind to fix it?
@adnanvrazalica53 Жыл бұрын
Theri is no code!
@Bernard-lu6we Жыл бұрын
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!
@rangiroa100 Жыл бұрын
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.
@PathwaytoAccessibility Жыл бұрын
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!
@anupamdebnath6821 Жыл бұрын
GetFileFolder("file", "Choose the Access database holding your tables (the backend)") not work.
@BIM-Orbit Жыл бұрын
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
@mikeygrey9855 Жыл бұрын
I asked chatGPT to fix me up something like this but couldn't do it. Thanks
@ristantosky Жыл бұрын
how to put subtotal on each group?
@ristantosky Жыл бұрын
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?
@redwarrior260 Жыл бұрын
Thank you, definitely learnt something.
@FreeHappiness2 жыл бұрын
Can somebody please direct me to the code as the link is not showing the code.
@FreeHappiness2 жыл бұрын
Hi I am not able to view the source code in you website. Please help.
@RungeCarl2 жыл бұрын
Brilliant!!!!
@kevinmould69792 жыл бұрын
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.
@kolavithonduraski50312 жыл бұрын
same to me... everything you need to know for pulling data from access... 😊👍 its awesome
@adnangharbi89822 жыл бұрын
there is no code!
@Hamidali-mx8iv2 жыл бұрын
Great. Can we use option group to open multiple sub forms like this?
@luisfernandogaviriacaro32782 жыл бұрын
Señor Jitsu, muchas gracias por su contenido y por su excelente explicación, Felicitaciones, estoy asombrado con sus amplios conocimientos.
@KeffelewAssefa2 жыл бұрын
Thank you
@KeffelewAssefa2 жыл бұрын
Thank you
@gregorywilson37152 жыл бұрын
Help! I want to import from access a query into a excel file, to a specific tab and cell
@ssdusd2 жыл бұрын
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?
@lorenzogaruglieri70462 жыл бұрын
hi. the download link doesn't work?
@davsAlmanac2 жыл бұрын
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
@akokohjoel98542 жыл бұрын
Pls can you show us Link to the VB code to relink backend
@vincentchikobe6492 жыл бұрын
Just watching but its not clear zooming would be some kind of great amazing work
@JWinAus2 жыл бұрын
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?
@anthonysykes5892 жыл бұрын
The VBA in this video is located here: accessjitsu.com/2017/01/25/mic... was not available
@sebastiantomaszewski19532 жыл бұрын
Great Videos ! I tried to download the VBA code but there's no code on the given link.
@jaironaranjo36542 жыл бұрын
Sir what an amazing videos you are definitely the best!
@pakenhampastoralcharge61082 жыл бұрын
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!
@ristantosky2 жыл бұрын
Sir, I have opened the link but I think there is no download link (for VBA)
@dbdata98362 жыл бұрын
can uplod file plz?
@dbdata98362 жыл бұрын
thanks
@dbdata98362 жыл бұрын
can uplod file plz?
@xm_tech2 жыл бұрын
The link to the VBA is not working.
@amjithat2 жыл бұрын
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...