3 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for marcmanlin2

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.

Member Avatar for marcmanlin2
0
581
Member Avatar for satti

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 …

Member Avatar for AndreRet
0
167
Member Avatar for abu taher

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") …

0
93

The End.