Salamat sa iyong tutorial Pre. Laking tulong ito lalano may ginagawa ako ngayon na program gamit ang access para sa Asset and Inventory System namin dito. Andito ako ngayon sa Canada bro.
Great ideas! I'd like to make a couple of suggestions. First, the sound quality. We can hear the hard consonants as your breath hits the microphone. And if you could increase the input volume that would be great, too. Second, I don't recommend the use of so many colors. Things tend to get too flashy. Other than that, good stuff!
Hello, is it possible to conditionally format the graph? for example when sales are below 2000 the bar is red and if it's above it then it's green? thank you
Nice question. Any way, in row source, click the 3 dots ... to open the query builder. Change the format of your date into numerical value. Let's say 1,2,3... and sort it to ascending. I will create a video for this tonight.
Nice po Sir, andme ko po natutunan sa inyo. Pde po ba ung kunware may comparison ang dalawang year? Kunware current year at last year. Tpos may magdidisplay na variance base sa encode na data sa table?
I am creating an employee management system, and want to create a dashboard form where i want to show active employees , how many on vacations etc, how to achieve this?
Mr. Edcelle i have to make one correction in the syntax =Nz(DSum("FinalAmt","SalesQ","Month='" & [MTD] & ","),0). because its not working. Als the first one : =Nz(DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#"),0)
you have an error. it should be =Nz(DSum("FinalAmt", "SalesQ", "Month='" & [MTD] & "'"), 0). For the today's code is =DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#")
Salamat sa iyong tutorial Pre. Laking tulong ito lalano may ginagawa ako ngayon na program gamit ang access para sa Asset and Inventory System namin dito. Andito ako ngayon sa Canada bro.
Maraming salamat sa panonood bro.
Great ideas! I'd like to make a couple of suggestions. First, the sound quality. We can hear the hard consonants as your breath hits the microphone. And if you could increase the input volume that would be great, too. Second, I don't recommend the use of so many colors. Things tend to get too flashy. Other than that, good stuff!
Thank you so much for your suggestions. It's highly appreciated.
And also thank you for watching.
Thanks so much for the effects bro. I really appreciate
Welcome. Thanks for watching
Hello, is it possible to conditionally format the graph? for example when sales are below 2000 the bar is red and if it's above it then it's green? thank you
This is wonderful ❤️
Thanks for watching
Good❤
Great and awesome video...I have been looking for such a tutorial.....
please can you share the file?
Nice
Good İdea
Thank you
Goood
Thanks
Nice instruction, What I see is that the months in the chart are in some random order. How do you order them from left to right or from right to left?
Here's the video: ruclips.net/video/N8bmOBuqVuc/видео.html
Thank you for an awesome tutorial!
How do I get the months in the Axis Category to filter into the correct order E.g. (Jan - Feb - March)?
Nice question.
Any way, in row source, click the 3 dots ... to open the query builder.
Change the format of your date into numerical value. Let's say 1,2,3...
and sort it to ascending.
I will create a video for this tonight.
Here's the link.
ruclips.net/video/N8bmOBuqVuc/видео.html
Sir can it be assigned a permanent color category in the pie chart? Thanks
Which video did you create the report in?
Nice po Sir, andme ko po natutunan sa inyo. Pde po ba ung kunware may comparison ang dalawang year? Kunware current year at last year. Tpos may magdidisplay na variance base sa encode na data sa table?
Pwede po. Instead na current year, last year yung ilagay sa criteria. Same concept pa rin.
Salamat pala sa panonood.
Do you have a tutorial to display images in a dashboard that will change like a slider?
Nice idea. On Timer Event Function.
I'll to create.
I am creating an employee management system, and want to create a dashboard form where i want to show active employees , how many on vacations etc, how to achieve this?
Just use the DCOUNT function.
Same process with dlookup and dsum.
please do a video on sale module
Yes sure. The POS side.
Mr. Edcelle i have to make one correction in the syntax =Nz(DSum("FinalAmt","SalesQ","Month='" & [MTD] & ","),0). because its not working. Als the first one : =Nz(DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#"),0)
you have an error. it should be =Nz(DSum("FinalAmt", "SalesQ", "Month='" & [MTD] & "'"), 0). For the today's code is =DSum("FinalAmt","SalesQ","SaleDate>=#" & Date() & "#")
Hi can i have file access? Thanks
can i have the file please
Sir magkaano pagawa nang program?
Depende po sa project sir. For more details, you can contact me in fb messenger ED PEREZ MATUGAS GULFAN
Salamat sa tanong
Ang bilis masyado, hinde masundan....
Pasensya. Pause mo nalang if medyo mabilis. Next time hinaan ko nalang ng konti. Thanks for watching.