3 Solved Topics
Remove Filter | |
please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance. | |
Hello to Dear Friends, iam creating data reports ,but the problem is i cant find the way to make report in LANDSCAPE...i heard sp5 or sp6 vb can do that ..but i couldn't found any option like that. kindly guide me how to create reports in landscape format... ithink there … | |
in data environment I write code[CODE]SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS SumOfInAmount FROM AccountInfo where Date and Date between DTFr.value and DTTo.vlaue GROUP BY AccountInfo.incategory;[/CODE] in form I write code in a command button like:[CODE]Private Sub Command2_Click() Load DataEnvironment1 With DataEnvironment1 If .Command3.State <> 0 Then .Command3.Clos .Command3 Format(DTFr.Value, "dd/mm/yyyy"), Format(DTTo.Value, "dd/mm/yyyy") … |
The End.