Hello Theree
these is my first writing here with you guys I hope it will not be the last as i'm loving this website as I learned a lot from it. so I just have a question i'm a newbie actually and I need to complete an application with VB.NET (it will help me at work)
anyway i'll start with my config :
Visual Studio 2012
SQL Server 2012
quiet a fortune lol
as you can see in the excel document attached :
is's a material consumption
i need to enter evey travel information for any of my vehicules at work.
I'm working now as you can see in excel
and I have to copy and paste that table for every vehicule.
so what i need to do is : enter the veihicule information (a table reservec only for vehicule information)
(in excel from line 7 to line 11)
and now when i want to enter a trip info for some of those vehicules i want to select just the registration N) or whatever is associated whith that car in a combobox
then enter all other information in the table date, counter info .. etc and hit save
that now pretty much the input process
about the printing it's quiet complicated for me.
i want when i select a vehciule in a certain year (time interval) i want it to show me the input info from the SQL server database and put it into the designed report.
that report I can't figure out how to design it to fit my needs , as I want it to be splited into to A4 pages, the first will end at the 51'th line (excel) the "Refer to total"
and the rest will be printed in the second page.
i think it's all, and i'll appreciate for you help.
Thank You so much
excel file
David
Submit an article or tip