ReportTest.bas 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376
  1. Version =20
  2. VersionRequired =20
  3. Begin Report
  4. LayoutForPrint = NotDefault
  5. DividingLines = NotDefault
  6. AllowDesignChanges = NotDefault
  7. DefaultView =0
  8. DateGrouping =1
  9. GrpKeepTogether =1
  10. PictureAlignment =2
  11. DatasheetGridlinesBehavior =3
  12. GridY =10
  13. Width =10890
  14. DatasheetFontHeight =11
  15. ItemSuffix =29
  16. DatasheetGridlinesColor =14806254
  17. RecSrcDt = Begin
  18. 0x18175c7013d9e440
  19. End
  20. RecordSource ="TableWithData"
  21. DatasheetFontName ="Calibri"
  22. PrtMip = Begin
  23. 0x68010000680100006801000068010000000000008a2a00005005000001000000 ,
  24. 0x010000006801000000000000a10700000100000001000000
  25. End
  26. FilterOnLoad =0
  27. FitToPage =1
  28. DisplayOnSharePointSite =1
  29. DatasheetAlternateBackColor =15921906
  30. DatasheetGridlinesColor12 =0
  31. FitToScreen =1
  32. DatasheetBackThemeColorIndex =1
  33. BorderThemeColorIndex =3
  34. ThemeFontIndex =1
  35. ForeThemeColorIndex =0
  36. AlternateBackThemeColorIndex =1
  37. AlternateBackShade =95.0
  38. Begin
  39. Begin Label
  40. BackStyle =0
  41. FontSize =11
  42. FontName ="Calibri"
  43. ThemeFontIndex =1
  44. BackThemeColorIndex =1
  45. BorderThemeColorIndex =0
  46. BorderTint =50.0
  47. ForeThemeColorIndex =0
  48. ForeTint =50.0
  49. GridlineThemeColorIndex =1
  50. GridlineShade =65.0
  51. End
  52. Begin CommandButton
  53. Width =1701
  54. Height =283
  55. FontSize =11
  56. FontWeight =400
  57. FontName ="Calibri"
  58. ForeThemeColorIndex =0
  59. ForeTint =75.0
  60. GridlineThemeColorIndex =1
  61. GridlineShade =65.0
  62. UseTheme =1
  63. Shape =1
  64. Gradient =12
  65. BackThemeColorIndex =4
  66. BackTint =60.0
  67. BorderLineStyle =0
  68. BorderColor =16777215
  69. BorderThemeColorIndex =4
  70. BorderTint =60.0
  71. ThemeFontIndex =1
  72. HoverThemeColorIndex =4
  73. HoverTint =40.0
  74. PressedThemeColorIndex =4
  75. PressedShade =75.0
  76. HoverForeThemeColorIndex =0
  77. HoverForeTint =75.0
  78. PressedForeThemeColorIndex =0
  79. PressedForeTint =75.0
  80. End
  81. Begin TextBox
  82. AddColon = NotDefault
  83. FELineBreak = NotDefault
  84. BorderLineStyle =0
  85. Width =1701
  86. LabelX =-1701
  87. FontSize =11
  88. FontName ="Calibri"
  89. AsianLineBreak =1
  90. ShowDatePicker =0
  91. BackThemeColorIndex =1
  92. BorderThemeColorIndex =1
  93. BorderShade =65.0
  94. ThemeFontIndex =1
  95. ForeThemeColorIndex =0
  96. ForeTint =75.0
  97. GridlineThemeColorIndex =1
  98. GridlineShade =65.0
  99. End
  100. Begin EmptyCell
  101. Height =240
  102. GridlineColor =12632256
  103. GridlineThemeColorIndex =1
  104. GridlineShade =65.0
  105. End
  106. Begin FormHeader
  107. KeepTogether = NotDefault
  108. Height =0
  109. BackColor =15849926
  110. Name ="EntêteÉtat"
  111. AlternateBackThemeColorIndex =1
  112. AlternateBackShade =95.0
  113. BackThemeColorIndex =2
  114. BackTint =20.0
  115. End
  116. Begin PageHeader
  117. Height =737
  118. Name ="ZoneEntêtePage"
  119. AlternateBackThemeColorIndex =1
  120. AlternateBackShade =95.0
  121. BackThemeColorIndex =1
  122. Begin
  123. Begin Label
  124. TextAlign =2
  125. Left =1133
  126. Top =113
  127. Width =4480
  128. Height =511
  129. FontSize =16
  130. FontWeight =700
  131. BorderColor =8355711
  132. ForeColor =9592887
  133. Name ="Étiquette2"
  134. Caption ="Formatted Title"
  135. FontName ="Verdana"
  136. GridlineColor =10921638
  137. LayoutCachedLeft =1133
  138. LayoutCachedTop =113
  139. LayoutCachedWidth =5613
  140. LayoutCachedHeight =624
  141. ThemeFontIndex =-1
  142. ForeThemeColorIndex =4
  143. ForeTint =100.0
  144. ForeShade =75.0
  145. End
  146. End
  147. End
  148. Begin Section
  149. KeepTogether = NotDefault
  150. Height =1360
  151. Name ="Détail"
  152. AlternateBackColor =15921906
  153. AlternateBackThemeColorIndex =1
  154. AlternateBackShade =95.0
  155. BackThemeColorIndex =1
  156. Begin
  157. Begin TextBox
  158. IMESentenceMode =3
  159. Left =3061
  160. Top =226
  161. Height =315
  162. ColumnWidth =1935
  163. BorderColor =10921638
  164. ForeColor =4210752
  165. Name ="param"
  166. ControlSource ="param"
  167. GridlineColor =10921638
  168. LayoutCachedLeft =3061
  169. LayoutCachedTop =226
  170. LayoutCachedWidth =4762
  171. LayoutCachedHeight =541
  172. Begin
  173. Begin Label
  174. Left =1360
  175. Top =226
  176. Width =660
  177. Height =315
  178. BorderColor =8355711
  179. ForeColor =8355711
  180. Name ="Étiquette3"
  181. Caption ="param"
  182. GridlineColor =10921638
  183. LayoutCachedLeft =1360
  184. LayoutCachedTop =226
  185. LayoutCachedWidth =2020
  186. LayoutCachedHeight =541
  187. End
  188. End
  189. End
  190. Begin TextBox
  191. IMESentenceMode =3
  192. Left =3061
  193. Top =623
  194. Height =315
  195. ColumnWidth =2835
  196. TabIndex =1
  197. BorderColor =10921638
  198. ForeColor =4210752
  199. Name ="key"
  200. ControlSource ="key"
  201. GridlineColor =10921638
  202. LayoutCachedLeft =3061
  203. LayoutCachedTop =623
  204. LayoutCachedWidth =4762
  205. LayoutCachedHeight =938
  206. Begin
  207. Begin Label
  208. Left =1360
  209. Top =623
  210. Width =390
  211. Height =315
  212. BorderColor =8355711
  213. ForeColor =8355711
  214. Name ="Étiquette4"
  215. Caption ="key"
  216. GridlineColor =10921638
  217. LayoutCachedLeft =1360
  218. LayoutCachedTop =623
  219. LayoutCachedWidth =1750
  220. LayoutCachedHeight =938
  221. End
  222. End
  223. End
  224. End
  225. End
  226. Begin PageFooter
  227. Height =1134
  228. Name ="ZonePiedPage"
  229. AutoHeight =255
  230. AlternateBackThemeColorIndex =1
  231. AlternateBackShade =95.0
  232. BackThemeColorIndex =1
  233. Begin
  234. Begin TextBox
  235. OldBorderStyle =0
  236. TextAlign =1
  237. BackStyle =0
  238. IMESentenceMode =3
  239. Left =283
  240. Width =3600
  241. Height =315
  242. BorderColor =10921638
  243. ForeColor =4210752
  244. Name ="Texte5"
  245. ControlSource ="=\"Page \" & [Page] & \" sur \" & [Pages]"
  246. GridlineColor =10921638
  247. LayoutCachedLeft =283
  248. LayoutCachedWidth =3883
  249. LayoutCachedHeight =315
  250. End
  251. End
  252. End
  253. Begin FormFooter
  254. KeepTogether = NotDefault
  255. Height =1134
  256. Name ="PiedÉtat"
  257. AutoHeight =1
  258. AlternateBackThemeColorIndex =1
  259. AlternateBackShade =95.0
  260. BackThemeColorIndex =1
  261. Begin
  262. Begin EmptyCell
  263. Left =225
  264. Top =60
  265. Width =690
  266. Height =690
  267. Name ="Auto_LogoCelluleVide"
  268. GroupTable =2
  269. GridlineColor =10921638
  270. LayoutCachedLeft =225
  271. LayoutCachedTop =60
  272. LayoutCachedWidth =915
  273. LayoutCachedHeight =750
  274. RowEnd =1
  275. LayoutGroup =1
  276. GroupTable =2
  277. End
  278. Begin EmptyCell
  279. Left =975
  280. Top =60
  281. Width =4650
  282. Height =690
  283. Name ="Auto_EnTeteCelluleVide"
  284. GroupTable =2
  285. GridlineColor =10921638
  286. HorizontalAnchor =2
  287. LayoutCachedLeft =975
  288. LayoutCachedTop =60
  289. LayoutCachedWidth =5625
  290. LayoutCachedHeight =750
  291. RowEnd =1
  292. ColumnStart =1
  293. ColumnEnd =1
  294. LayoutGroup =1
  295. GroupTable =2
  296. End
  297. Begin TextBox
  298. Enabled = NotDefault
  299. Locked = NotDefault
  300. OldBorderStyle =0
  301. TextAlign =3
  302. BackStyle =0
  303. IMESentenceMode =3
  304. Left =5685
  305. Top =60
  306. Width =5100
  307. Height =315
  308. BorderColor =10921638
  309. ForeColor =8210719
  310. Name ="Auto_Date"
  311. ControlSource ="=Date()"
  312. Format ="Medium Date"
  313. GroupTable =2
  314. GridlineColor =10921638
  315. LayoutCachedLeft =5685
  316. LayoutCachedTop =60
  317. LayoutCachedWidth =10785
  318. LayoutCachedHeight =375
  319. ColumnStart =2
  320. ColumnEnd =2
  321. LayoutGroup =1
  322. ForeThemeColorIndex =2
  323. ForeTint =100.0
  324. GroupTable =2
  325. End
  326. Begin TextBox
  327. Enabled = NotDefault
  328. Locked = NotDefault
  329. OldBorderStyle =0
  330. TextAlign =3
  331. BackStyle =0
  332. IMESentenceMode =3
  333. Left =5685
  334. Top =435
  335. Width =5100
  336. Height =315
  337. TabIndex =1
  338. BorderColor =10921638
  339. ForeColor =8210719
  340. Name ="Auto_Heure"
  341. ControlSource ="=Time()"
  342. Format ="Short Time"
  343. GroupTable =2
  344. GridlineColor =10921638
  345. LayoutCachedLeft =5685
  346. LayoutCachedTop =435
  347. LayoutCachedWidth =10785
  348. LayoutCachedHeight =750
  349. RowStart =1
  350. RowEnd =1
  351. ColumnStart =2
  352. ColumnEnd =2
  353. LayoutGroup =1
  354. ForeThemeColorIndex =2
  355. ForeTint =100.0
  356. GroupTable =2
  357. End
  358. End
  359. End
  360. End
  361. End
  362. CodeBehindForm
  363. Attribute VB_GlobalNameSpace = False
  364. Attribute VB_Creatable = True
  365. Attribute VB_PredeclaredId = True
  366. Attribute VB_Exposed = False
  367. Option Compare Database
  368. Private Sub Commande1_Click()
  369. MsgBox "salut"
  370. End Sub