Пікірлер
@akokohjoel9854
@akokohjoel9854 Күн бұрын
Pls how can i pass BULK data from one table to another using VBA. thanks
@SixGraphics
@SixGraphics Күн бұрын
@akokohjoel9854 just use record set. I have the tutorial for building inventory management. Just go and stream, and you will learn more than that
@honbenbabumkuu9174
@honbenbabumkuu9174 22 күн бұрын
Mnataka tu views , bure Kaabisa
@TheChidonline
@TheChidonline Ай бұрын
naomba mawasiliano yako mkuu
@SixGraphics
@SixGraphics 23 күн бұрын
0786621442
@MarthaDanieljohn
@MarthaDanieljohn Ай бұрын
Naomba namba zako
@SumaOg4
@SumaOg4 3 ай бұрын
Mkuu nimeikubali io
@SixGraphics
@SixGraphics 3 ай бұрын
@@SumaOg4 pamoja sana Blood
@ShabeerYousafi-hz3fv
@ShabeerYousafi-hz3fv 4 ай бұрын
Sir, After 6 days, I still did not receive the answer to my question I hope, if you have time to answer my question.
@SixGraphics
@SixGraphics 4 ай бұрын
I have answered your question and I provided a link for solution go and watch it
@xcon971
@xcon971 4 ай бұрын
when is the next video???
@SixGraphics
@SixGraphics 4 ай бұрын
Data analysis
@diymixvideos1825
@diymixvideos1825 4 ай бұрын
how to make a reciept (like store or shopping malls receipt) can you assist us?
@SixGraphics
@SixGraphics 4 ай бұрын
Yes, I will make a tutorial for recept
@saqibiqbal8661
@saqibiqbal8661 4 ай бұрын
Is it workable on MS Access 2016? In the end please show the VBA Code Window in Zoom.
@SixGraphics
@SixGraphics 4 ай бұрын
Ok you can put your phone in portrait view
@saqibiqbal8661
@saqibiqbal8661 4 ай бұрын
Nice tutorial
@SixGraphics
@SixGraphics 4 ай бұрын
Thanks, help to share to others 🙏
@musisir1927
@musisir1927 5 ай бұрын
Great. Thanks
@SixGraphics
@SixGraphics 5 ай бұрын
You're welcome 🙏
@ShabeerYousafi-hz3fv
@ShabeerYousafi-hz3fv 5 ай бұрын
Your efforts are appreciated. good luck have you completed this project?
@SixGraphics
@SixGraphics 5 ай бұрын
No, there's some stuff like data analysis
@ShabeerYousafi-hz3fv
@ShabeerYousafi-hz3fv 5 ай бұрын
@@SixGraphics very good You plan to complete it?
@ShabeerYousafi-hz3fv
@ShabeerYousafi-hz3fv 5 ай бұрын
and one more issue In this database tutorial series, I can tell you that you didn't explain how to create an inventory form. I'm sorry for asking bro.
@alializadeh8195
@alializadeh8195 5 ай бұрын
Thanks
@SixGraphics
@SixGraphics 5 ай бұрын
Your welcome
@khalidjuma5530
@khalidjuma5530 5 ай бұрын
Wawooo!!!! Very interesting, I wish to see the second part of this design❤❤❤❤❤❤
@SixGraphics
@SixGraphics 5 ай бұрын
Thanks 👍 wait for it, soon will be Premiered.
@itsshahidu
@itsshahidu 5 ай бұрын
Hi Sir, I am following your tutorials. They are quite great and easy to understand, but unfortunately, I am facing some errors. I think the errors are caused because you may have skipped some steps related to the form functionalities at 16:30 upto 18:00 in this tutorial.
@itsshahidu
@itsshahidu 5 ай бұрын
Also if you provide the code in the description, then it will be helpful. Thanks!
@SixGraphics
@SixGraphics 5 ай бұрын
Thanks for your recommendation but I will check and reconcile.
@SixGraphics
@SixGraphics 5 ай бұрын
I haven't seen where I skipped but to change the txtbox to combobox just continue to watch the tutorial I have repeated some of the actions in some episodes
@xcon971
@xcon971 6 ай бұрын
sir in the Form SalesOrder we took the order date from table SalesOrder & now in the form FsubSalesLineReport we took the orderdate from the table SalesOrderDetail so where is the connection between the 2 date coz the orederdate is not appearing on the FsubSalesLineReport ??? explain please and very big thanks to u
@SixGraphics
@SixGraphics 6 ай бұрын
In yhe sales order form we have the query which includes 2 tables A customer table and sales order table then in FsubSalesLineReport we have a query with 3 tables if iam not mistaken a inventory table, sales order table and Sales order details table.
@jacob9060
@jacob9060 6 ай бұрын
*Promo sm* 😴
@SixGraphics
@SixGraphics 6 ай бұрын
Promo sm
@JessieAneslagon
@JessieAneslagon 6 ай бұрын
What app you use?
@SixGraphics
@SixGraphics 6 ай бұрын
Microsoft Access databases 2021
@xcon971
@xcon971 6 ай бұрын
sir i do have small problem the report SalesDetailReport always shows the date year 1900 i tried so many things but i couldnt solve it ???
@SixGraphics
@SixGraphics 6 ай бұрын
Follow what I have done to my tutorial don't add anything until you know what you're doing
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics i do sir all the dates are correct except when i add new sales order then i open the SalesDetailOrder so the order will not appear but hen i go to the table the date shows 1900???
@SixGraphics
@SixGraphics 6 ай бұрын
@@xcon971 I dont know Where you have mistaken send the database you made so as I can see it don't send code send accdb file to my email
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics i sent u the email and very big thanks in advanced
@aqantassoftware3792
@aqantassoftware3792 6 ай бұрын
Awesome video, very well explained. Must say your programming skills are upto the mark. Superb. Thanks for sharing.🙏
@SixGraphics
@SixGraphics 6 ай бұрын
Thanks much 🙏
@xcon971
@xcon971 6 ай бұрын
Status not changing only completed the other text r not showing
@SixGraphics
@SixGraphics 6 ай бұрын
I can ask why ? What is the properties of the status textbox?
@SixGraphics
@SixGraphics 6 ай бұрын
Remember the status is not a combo box it is a normal textbox linked to a word status not unbound
@xcon971
@xcon971 6 ай бұрын
sir i believe if we didnt do the navigation form all the codes will not be active so we cant test our work so kindly let us first do the navigation from
@SixGraphics
@SixGraphics 6 ай бұрын
Hahahaha 😁 ok we still have like ten modules bro relax we will test
@xcon971
@xcon971 6 ай бұрын
sir i am really confused when u open the Query for Form "FreportForSale" in the video time 15:20 it shows that u do the source query to report "SalesDetalViewQuery" can u explain please???
@SixGraphics
@SixGraphics 6 ай бұрын
Here the thing you must know is how to open data of that query by filtering the date entered in the form textbox, salesordersub is my table which preserve the saved orders. That's why when I want to get past sales ledger I use salesordersub and inventory. Just learn first and build the app for your interest.
@xcon971
@xcon971 6 ай бұрын
sir Auto_Header0 how did u make the code????? i tried to add the source from the control source but its failed
@SixGraphics
@SixGraphics 6 ай бұрын
Just check for previous tutorials I have explained that thing, you must have the table which contains names of the header you want
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics i created the table Businessinfo
@SixGraphics
@SixGraphics 6 ай бұрын
@@xcon971 yes fill the table with the headers you want
@Khuram_Shahzad
@Khuram_Shahzad 6 ай бұрын
Hi dear, will it be a complete application tutorial?
@SixGraphics
@SixGraphics 6 ай бұрын
Yes, just hit the bell icon so as you get a notification when I post new videos
@xcon971
@xcon971 6 ай бұрын
sir what about btn "Sales Edit", ''Drug Store'', ''Refresh'', ''Price List'', ''Supplier'' & ''SAVE'' u didnt add any codes?? explain please and many thanks
@SixGraphics
@SixGraphics 6 ай бұрын
Sale's edit I have explained it
@SixGraphics
@SixGraphics 6 ай бұрын
Sales edit is equal to form Sales customization, also the stock form still I haven't posted a video for it. So chills and wait ✋
@xcon971
@xcon971 6 ай бұрын
sir im just wondering why theres no VAT on sales or purchase orders?
@SixGraphics
@SixGraphics 6 ай бұрын
You can add it for you but here in my country, there is no VAT for such business especially Pharmaceuticals business
@xcon971
@xcon971 6 ай бұрын
sir did u built Form called frmDimmer ?????? can u explain Please and thank u in advanced
@SixGraphics
@SixGraphics 6 ай бұрын
Yes exactly
@xcon971
@xcon971 6 ай бұрын
thank u sir its solved now and working great
@SixGraphics
@SixGraphics 6 ай бұрын
So just be care with the space and syntax errors
@xcon971
@xcon971 6 ай бұрын
sir too many errors and u r not solving the errors u asked m to email u my data so u will fix it and its been more than 5 days and im still waiting and no reply i dont know hows the codes work with u perfect and with me not and im sure that i have no mistake coz i double checked the data more than 100 times. best regards for ur time and thanks for ur time at the begging of the work u were moving with us step by step so i share ur link to my friends and om my telegrarm group coz u were excellent but after that sorry to say that the data is ready and the tables ready and the forms ready u only show us the code i dont mind of that but nothing is working
@SixGraphics
@SixGraphics 6 ай бұрын
So you want it from the start, and sorry I have solved your error on the video just check the video for sql statement
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics which video???? i checked all the videos
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics sir u asked me to email you my data to fix the problem and i did
@xcon971
@xcon971 6 ай бұрын
yes yes i saw the video and the error solved thank u very much
@xcon971
@xcon971 6 ай бұрын
rsUser = Forms![NavigationForm]!txtUser.Value Error when i click save after adding new item
@xcon971
@xcon971 6 ай бұрын
you mean SubSalesOrderDetailsF not SubPurchaseOrderDetailsF correct i think u made a mistake on Salas Order when u click on save or you created a new Form?????? FsubPurchaseOrderLine??????? explain please
@SixGraphics
@SixGraphics 6 ай бұрын
Ok thanks 😊
@SixGraphics
@SixGraphics 6 ай бұрын
There are names of form and name of subform in sales order form I have the form named FsabsalesLine but in reference mean subform the name is FsubpurcharsedorderLine, I think I named different, that's why in the code we use FsubpurchasedOrderLine it's just a name for reference the mybsubform
@SixGraphics
@SixGraphics 6 ай бұрын
What you supposed to know is how to reference forms and subform name can vary according to the interest of a person and purposes
@xcon971
@xcon971 6 ай бұрын
Total items from where did u took the description count coz its showed me Error
@SixGraphics
@SixGraphics 6 ай бұрын
Remember you can't use count unless the form has the source table wit the field you want to count
@SixGraphics
@SixGraphics 6 ай бұрын
Here I use count Description because the form has the source from my inventory table, and if you get errors make sure you state what error, than saying error
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics got it i fixed it thank u very much
@sajtweek4066
@sajtweek4066 6 ай бұрын
Sir Login error ((FormattedMsgBox)) until now
@SixGraphics
@SixGraphics 6 ай бұрын
I have said don't use formattedMsgbox use nomal Msgbox, I think now I must write the code live instead of showing already written code remember the code you see to me is working perfectly
@SixGraphics
@SixGraphics 6 ай бұрын
Also I have given you an email address to send your project so as I can assist the SQL statement errors
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics ok thank u
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics i sent u email
@xcon971
@xcon971 6 ай бұрын
Did u get my email I'm waiting for Ur reply in my email so I will continue the work. Thanks I n advanced
@xcon971
@xcon971 6 ай бұрын
yes sir there is errors where i cant update the Inv_Qne always appears message Syntax error (missing operator) in query expression "inventoryT .inv_Qnt 2500where ItemCode=2 " and the inventory quantity is not changing on the inventoryT. i sent u message and im still waiting ur reply to solve the error check my message on video 7. very big regards and thank u in advanced
@SixGraphics
@SixGraphics 6 ай бұрын
I have replaced some of your comments and I sent a email so as you can send it I can help from that.
@SixGraphics
@SixGraphics 6 ай бұрын
Missing operator means you have forgotten one of the operator
@sajtweek4066
@sajtweek4066 6 ай бұрын
sir i believe that when u made the change price it will effect also the previous purchase order price so all the entire purchase order price will be wrong
@SixGraphics
@SixGraphics 6 ай бұрын
I have the intermediate table I will explain to the next tutorial
@SixGraphics
@SixGraphics 6 ай бұрын
When you change prices it changes only in inventory table I have created the table called salesordersub where it preserve the saved sales.
@sajtweek4066
@sajtweek4066 6 ай бұрын
hello sir i see that u created new table ((Inventory)) can u explain what did u added on this Table???
@SixGraphics
@SixGraphics 6 ай бұрын
Ok don't worry I will explain it on the next tutorial 👍👍
@sajtweek4066
@sajtweek4066 7 ай бұрын
dear sir i do have problem that the inventory is not updated a and always appear message Syntax error (missing operator) in query expression "inventoryT .inv_Qnt 33where Item_Code=2 " in both sales and purchase so i tried so many thing but i couldn't solve the problem . will u please tell me and guide me hat to do
@SixGraphics
@SixGraphics 6 ай бұрын
Yah this error is Sql error statement you, make sure you follow the syntax of SQL
@SixGraphics
@SixGraphics 6 ай бұрын
I will create the video to explain that concept
@xcon971
@xcon971 6 ай бұрын
@@SixGraphics im sure about the SQL i followed all ur steps 100% ??? sir i will keep waiting to solve my problem and best regards
@xcon971
@xcon971 7 ай бұрын
hello and thank u in advanced kindly r u going to continue or this is the last video??? best regards
@SixGraphics
@SixGraphics 7 ай бұрын
Still we continue brother we are not finished yet Still we have lot to learn, let me know if you encounter errors.
@xcon971
@xcon971 7 ай бұрын
@@SixGraphics yes sir there is errors where i cant update the Inv_Qne always appears message Syntax error (missing operator) in query expression "inventoryT .inv_Qnt 2500where ItemCode=2 " and the inventory quantity is not changing on the inventoryT. i sent u message and im still waiting ur reply to solve the error check my message on video 7. very big regards and thank u in advanced
@sajtweek4066
@sajtweek4066 7 ай бұрын
you are a great person, thank you very much
@SixGraphics
@SixGraphics 7 ай бұрын
Your welcome Help to share to others so, as we can support each other.
@ballaomer6738
@ballaomer6738 7 ай бұрын
Please make a video about how to send data from one access database into another access database in two different pcs with ip address and make sure too much fast like send 100 records in a few seconds ( without link tables)
@SixGraphics
@SixGraphics 7 ай бұрын
Okay don't worry I will make it
@sajtweek4066
@sajtweek4066 7 ай бұрын
hi how are you, and thank so much, dear sir i followed all ur steps but i still facing a problem with ((db.Execute SQL)) and if delete it the transaction completed but the Inve_Qnt will not changed??? where is the mistake??? best regards and thanks in advanced
@SixGraphics
@SixGraphics 7 ай бұрын
What error do you get mean state the error
@SixGraphics
@SixGraphics 7 ай бұрын
State the error I can help you
@xcon971
@xcon971 7 ай бұрын
@@SixGraphics as soon as i press on save (( Syntax error (missing operator) in query expression "inventoryT .inv_Qnt 2500where ItemCode=2 " . this the message and when i press on debug lead me to the visual basic ((db.Execute SQL)) with yellow color and if i delete it then no problem with saving but its not effected and the word Completed not appearing in the status
@xcon971
@xcon971 7 ай бұрын
@@SixGraphics ive checked so many times and im sure 100% that i followed all ur steps and the spelling
@xcon971
@xcon971 7 ай бұрын
the itmcode this is how i name u name it Item_Code so the name is correct on my data
@diymixvideos1825
@diymixvideos1825 7 ай бұрын
Great initiative. Wonderful. Keep it up
@SixGraphics
@SixGraphics 7 ай бұрын
thanks much
@diymixvideos1825
@diymixvideos1825 7 ай бұрын
hi. thanks for the tutorial keep it up. can you do the same on how you make for the print receipt for this program?
@SixGraphics
@SixGraphics 7 ай бұрын
yes,!! In the next tutorial, I will show you how to print the reports
@dharmendrapatil3336
@dharmendrapatil3336 7 ай бұрын
😂 are you teaching or showing stupid
@OscarMwakingwe-g4u
@OscarMwakingwe-g4u 8 ай бұрын
Hakuna njia nyingine mpk kushika sim yake,, manake hata password siiifahamu,, embu njia nyingine km ipo
@SixGraphics
@SixGraphics 8 ай бұрын
Jia nyingine haipo
@davidmwenya9100
@davidmwenya9100 8 ай бұрын
Mbona akuna njia igine bila kushika simu yake
@SixGraphics
@SixGraphics 8 ай бұрын
Ofcoz hakuna njia nyingine.
@flackvanderdutch3081
@flackvanderdutch3081 9 ай бұрын
Hi there, can you let us know the log in detais for admin and user please ?
@SixGraphics
@SixGraphics 9 ай бұрын
The main difference there is role type when you assign the user there is a combo which contains different roles we have Admin,user, guest when the employee is given the role for Adimin the will have full access to the system and remain have limited access it's either the owner described it's own role for user then you can customize the accessibility
@flackvanderdutch3081
@flackvanderdutch3081 9 ай бұрын
How do i give the staff the admin priviledges ? Thanks
@SixGraphics
@SixGraphics 9 ай бұрын
Wait we haven't reached there stick with me you will understand how the logic is done
@flackvanderdutch3081
@flackvanderdutch3081 9 ай бұрын
Alright,, many thanks for the calm reply, and sorry for the pressure. Exceptional work. Can i make some suggestion for the interface design and some funcionalities ?@@SixGraphics
@SixGraphics
@SixGraphics 9 ай бұрын
@@flackvanderdutch3081 your allowed bro just make them i'am listening 👂 👂
@hafeezsagar9309
@hafeezsagar9309 9 ай бұрын
I want 20 part and more
@SixGraphics
@SixGraphics 9 ай бұрын
It's coming soon just weit
@hafeezsagar9309
@hafeezsagar9309 9 ай бұрын
​@@SixGraphicshow long should i weit sir
@SixGraphics
@SixGraphics 9 ай бұрын
@@hafeezsagar9309 soon bro this week I will post