Microsoft Access - What is a Table?
8:37
Microsoft Access An Admin Db Part 5
16:46
Microsoft Access An Admin Db Part 4
10:41
Microsoft Access An Admin Db Part 3
14:36
Microsoft Access An Admin Db Part 2
9:59
Microsoft Access An Admin Db Part 1
17:38
Microsoft Access - Using XML Files
12:34
Microsoft Access Split Databases
13:16
Microsoft Access - Get User Name
20:40
Recursion in Microsoft Access VBA
14:36
Пікірлер
@dab3963
@dab3963 9 күн бұрын
Fantastic videos, thanks a lot, that's all many helpful and very well explained
@markjohnson3786
@markjohnson3786 17 күн бұрын
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
@j.dasilva4567 Ай бұрын
I usualy do this with buttons, highlighting the button of the user option, but this seems to be a better idea. Thanks.
@salimtalal4696
@salimtalal4696 2 ай бұрын
This is absolutely amazing. Thank you soooo much Access Jitsu, you saved my day. God bless you abundantly. Thank you, thank you, thank you.😘
@kcerny43
@kcerny43 3 ай бұрын
You rock even in 2024. Nice!
@RichardMaitland-k7l
@RichardMaitland-k7l 6 ай бұрын
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
@jimmyitwv
@jimmyitwv 3 ай бұрын
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.
@RungeCarl
@RungeCarl 9 ай бұрын
Downloads still not working
@SusanSwanson-e6e
@SusanSwanson-e6e 9 ай бұрын
This is INCREDIBLE! I am going to share this with my whole class!! You are my new hero no joke.
@RungeCarl
@RungeCarl 10 ай бұрын
The links do not work?
@RungeCarl
@RungeCarl 10 ай бұрын
Great video!
@zoranstojanovski8407
@zoranstojanovski8407 10 ай бұрын
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
@salimtalal4696 Жыл бұрын
You are terrific.....absolutely fantastic.....thanks a hexarillion
@janserpieters568
@janserpieters568 Жыл бұрын
Great videos! Could it be that the links to the XML code no longer work?
@adnanvrazalica53
@adnanvrazalica53 Жыл бұрын
The link fo VBA in this video does't work. Will you be kind to fix it?
@adnanvrazalica53
@adnanvrazalica53 Жыл бұрын
Theri is no code!
@Bernard-lu6we
@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
@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
@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
@anupamdebnath6821 Жыл бұрын
GetFileFolder("file", "Choose the Access database holding your tables (the backend)") not work.
@BIM-Orbit
@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
@mikeygrey9855 Жыл бұрын
I asked chatGPT to fix me up something like this but couldn't do it. Thanks
@ristantosky
@ristantosky Жыл бұрын
how to put subtotal on each group?
@ristantosky
@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
@redwarrior260 Жыл бұрын
Thank you, definitely learnt something.
@FreeHappiness
@FreeHappiness 2 жыл бұрын
Can somebody please direct me to the code as the link is not showing the code.
@FreeHappiness
@FreeHappiness 2 жыл бұрын
Hi I am not able to view the source code in you website. Please help.
@RungeCarl
@RungeCarl 2 жыл бұрын
Brilliant!!!!
@kevinmould6979
@kevinmould6979 2 жыл бұрын
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.
@kolavithonduraski5031
@kolavithonduraski5031 2 жыл бұрын
same to me... everything you need to know for pulling data from access... 😊👍 its awesome
@adnangharbi8982
@adnangharbi8982 2 жыл бұрын
there is no code!
@Hamidali-mx8iv
@Hamidali-mx8iv 2 жыл бұрын
Great. Can we use option group to open multiple sub forms like this?
@luisfernandogaviriacaro3278
@luisfernandogaviriacaro3278 2 жыл бұрын
Señor Jitsu, muchas gracias por su contenido y por su excelente explicación, Felicitaciones, estoy asombrado con sus amplios conocimientos.
@KeffelewAssefa
@KeffelewAssefa 2 жыл бұрын
Thank you
@KeffelewAssefa
@KeffelewAssefa 2 жыл бұрын
Thank you
@gregorywilson3715
@gregorywilson3715 2 жыл бұрын
Help! I want to import from access a query into a excel file, to a specific tab and cell
@ssdusd
@ssdusd 2 жыл бұрын
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?
@lorenzogaruglieri7046
@lorenzogaruglieri7046 2 жыл бұрын
hi. the download link doesn't work?
@davsAlmanac
@davsAlmanac 2 жыл бұрын
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
@akokohjoel9854
@akokohjoel9854 2 жыл бұрын
Pls can you show us Link to the VB code to relink backend
@vincentchikobe649
@vincentchikobe649 2 жыл бұрын
Just watching but its not clear zooming would be some kind of great amazing work
@JWinAus
@JWinAus 2 жыл бұрын
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?
@anthonysykes589
@anthonysykes589 2 жыл бұрын
The VBA in this video is located here: accessjitsu.com/2017/01/25/mic... was not available
@sebastiantomaszewski1953
@sebastiantomaszewski1953 2 жыл бұрын
Great Videos ! I tried to download the VBA code but there's no code on the given link.
@jaironaranjo3654
@jaironaranjo3654 2 жыл бұрын
Sir what an amazing videos you are definitely the best!
@pakenhampastoralcharge6108
@pakenhampastoralcharge6108 2 жыл бұрын
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!
@ristantosky
@ristantosky 2 жыл бұрын
Sir, I have opened the link but I think there is no download link (for VBA)
@dbdata9836
@dbdata9836 2 жыл бұрын
can uplod file plz?
@dbdata9836
@dbdata9836 2 жыл бұрын
thanks
@dbdata9836
@dbdata9836 2 жыл бұрын
can uplod file plz?
@xm_tech
@xm_tech 2 жыл бұрын
The link to the VBA is not working.
@amjithat
@amjithat 2 жыл бұрын
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...