sfrm_detailbareme.bas 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. Version =20
  2. VersionRequired =20
  3. Begin Form
  4. AllowFilters = NotDefault
  5. AutoResize = NotDefault
  6. RecordSelectors = NotDefault
  7. NavigationButtons = NotDefault
  8. AllowDeletions = NotDefault
  9. DividingLines = NotDefault
  10. AllowAdditions = NotDefault
  11. AllowEdits = NotDefault
  12. AllowDesignChanges = NotDefault
  13. ScrollBars =0
  14. PictureAlignment =2
  15. DatasheetGridlinesBehavior =3
  16. GridY =10
  17. Width =11515
  18. DatasheetFontHeight =11
  19. ItemSuffix =5
  20. Left =870
  21. Top =2910
  22. Right =12645
  23. Bottom =4245
  24. DatasheetGridlinesColor =14806254
  25. RecSrcDt = Begin
  26. 0x5af0c9bd35d1e440
  27. End
  28. RecordSource ="SELECT tbl_baremes.NomBareme, tbl_baremes.BorneInf, tbl_baremes.BorneSup, tbl_ba"
  29. "remes.UniteBornes, tbl_baremes.Valeur, tbl_baremes.UniteValeur, Max(tbl_PeriodeB"
  30. "areme.DateInf) AS MaxDeDateInf FROM tbl_PeriodeBareme INNER JOIN tbl_baremes ON "
  31. "(tbl_PeriodeBareme.CodePeriode = tbl_baremes.PeriodeValidite) AND (tbl_PeriodeBa"
  32. "reme.NomBareme = tbl_baremes.NomBareme) GROUP BY tbl_baremes.NomBareme, tbl_bare"
  33. "mes.BorneInf, tbl_baremes.BorneSup, tbl_baremes.UniteBornes, tbl_baremes.Valeur,"
  34. " tbl_baremes.UniteValeur ORDER BY tbl_baremes.BorneInf; "
  35. DatasheetFontName ="Calibri"
  36. FilterOnLoad =0
  37. ShowPageMargins =0
  38. DisplayOnSharePointSite =1
  39. DatasheetAlternateBackColor =15921906
  40. DatasheetGridlinesColor12 =0
  41. FitToScreen =1
  42. DatasheetBackThemeColorIndex =1
  43. BorderThemeColorIndex =3
  44. ThemeFontIndex =1
  45. ForeThemeColorIndex =0
  46. AlternateBackThemeColorIndex =1
  47. AlternateBackShade =95.0
  48. Begin
  49. Begin Label
  50. BackStyle =0
  51. FontSize =11
  52. FontName ="Calibri"
  53. ThemeFontIndex =1
  54. BackThemeColorIndex =1
  55. BorderThemeColorIndex =0
  56. BorderTint =50.0
  57. ForeThemeColorIndex =0
  58. ForeTint =50.0
  59. GridlineThemeColorIndex =1
  60. GridlineShade =65.0
  61. End
  62. Begin TextBox
  63. AddColon = NotDefault
  64. FELineBreak = NotDefault
  65. BorderLineStyle =0
  66. Width =1701
  67. LabelX =-1701
  68. FontSize =11
  69. FontName ="Calibri"
  70. AsianLineBreak =1
  71. BackThemeColorIndex =1
  72. BorderThemeColorIndex =1
  73. BorderShade =65.0
  74. ThemeFontIndex =1
  75. ForeThemeColorIndex =0
  76. ForeTint =75.0
  77. GridlineThemeColorIndex =1
  78. GridlineShade =65.0
  79. End
  80. Begin FormHeader
  81. Height =453
  82. BackColor =10855845
  83. Name ="EntêteFormulaire"
  84. AlternateBackThemeColorIndex =1
  85. AlternateBackShade =95.0
  86. Begin
  87. Begin TextBox
  88. OldBorderStyle =0
  89. OverlapFlags =85
  90. BackStyle =0
  91. IMESentenceMode =3
  92. Left =566
  93. Top =56
  94. Width =7476
  95. Height =315
  96. ColumnWidth =2790
  97. FontWeight =700
  98. BorderColor =8355711
  99. ForeColor =16777215
  100. Name ="NomBareme"
  101. ControlSource ="NomBareme"
  102. GridlineColor =10921638
  103. LayoutCachedLeft =566
  104. LayoutCachedTop =56
  105. LayoutCachedWidth =8042
  106. LayoutCachedHeight =371
  107. BorderThemeColorIndex =0
  108. BorderTint =50.0
  109. BorderShade =100.0
  110. ForeThemeColorIndex =1
  111. ForeTint =100.0
  112. End
  113. End
  114. End
  115. Begin Section
  116. CanGrow = NotDefault
  117. CanShrink = NotDefault
  118. Height =340
  119. BackColor =14277081
  120. Name ="Détail"
  121. AutoHeight =255
  122. AlternateBackColor =12566463
  123. AlternateBackThemeColorIndex =1
  124. AlternateBackShade =75.0
  125. BackThemeColorIndex =1
  126. BackShade =85.0
  127. Begin
  128. Begin TextBox
  129. OverlapFlags =93
  130. TextAlign =2
  131. BackStyle =0
  132. IMESentenceMode =3
  133. Left =3966
  134. Width =1416
  135. Height =315
  136. BorderColor =10921638
  137. Name ="BorneInf"
  138. ControlSource ="BorneInf"
  139. GridlineColor =10921638
  140. LayoutCachedLeft =3966
  141. LayoutCachedWidth =5382
  142. LayoutCachedHeight =315
  143. ForeTint =100.0
  144. End
  145. Begin TextBox
  146. OverlapFlags =93
  147. TextAlign =2
  148. BackStyle =0
  149. IMESentenceMode =3
  150. Left =5780
  151. Width =1476
  152. Height =315
  153. TabIndex =1
  154. BorderColor =10921638
  155. Name ="BorneSup"
  156. ControlSource ="BorneSup"
  157. GridlineColor =10921638
  158. LayoutCachedLeft =5780
  159. LayoutCachedWidth =7256
  160. LayoutCachedHeight =315
  161. ForeTint =100.0
  162. End
  163. Begin TextBox
  164. OverlapFlags =85
  165. BackStyle =0
  166. IMESentenceMode =3
  167. Left =7367
  168. Width =801
  169. Height =315
  170. TabIndex =2
  171. BorderColor =10921638
  172. Name ="UniteBornes"
  173. ControlSource ="UniteBornes"
  174. GridlineColor =10921638
  175. LayoutCachedLeft =7367
  176. LayoutCachedWidth =8168
  177. LayoutCachedHeight =315
  178. ForeTint =100.0
  179. End
  180. Begin TextBox
  181. OverlapFlags =85
  182. TextAlign =1
  183. BackStyle =0
  184. IMESentenceMode =3
  185. Left =623
  186. Width =1581
  187. Height =315
  188. TabIndex =3
  189. BorderColor =10921638
  190. Name ="Valeur"
  191. ControlSource ="Valeur"
  192. GridlineColor =10921638
  193. LayoutCachedLeft =623
  194. LayoutCachedWidth =2204
  195. LayoutCachedHeight =315
  196. ForeTint =100.0
  197. End
  198. Begin TextBox
  199. OverlapFlags =85
  200. BackStyle =0
  201. IMESentenceMode =3
  202. Left =2328
  203. Width =801
  204. Height =315
  205. TabIndex =4
  206. BorderColor =10921638
  207. Name ="UniteValeur"
  208. ControlSource ="UniteValeur"
  209. GridlineColor =10921638
  210. LayoutCachedLeft =2328
  211. LayoutCachedWidth =3129
  212. LayoutCachedHeight =315
  213. ForeTint =100.0
  214. End
  215. Begin Label
  216. OverlapFlags =85
  217. Left =5440
  218. Width =227
  219. Height =284
  220. FontWeight =700
  221. BorderColor =8355711
  222. Name ="A"
  223. Caption ="à"
  224. GridlineColor =10921638
  225. LayoutCachedLeft =5440
  226. LayoutCachedWidth =5667
  227. LayoutCachedHeight =284
  228. ForeTint =100.0
  229. End
  230. Begin Label
  231. OverlapFlags =247
  232. Left =3628
  233. Top =4
  234. Width =390
  235. Height =285
  236. FontWeight =700
  237. BorderColor =8355711
  238. Name ="De"
  239. Caption ="de:"
  240. GridlineColor =10921638
  241. LayoutCachedLeft =3628
  242. LayoutCachedTop =4
  243. LayoutCachedWidth =4018
  244. LayoutCachedHeight =289
  245. ForeTint =100.0
  246. End
  247. Begin Label
  248. Visible = NotDefault
  249. OverlapFlags =247
  250. Left =6859
  251. Width =390
  252. Height =285
  253. FontWeight =700
  254. BorderColor =8355711
  255. Name ="par"
  256. Caption ="par"
  257. GridlineColor =10921638
  258. LayoutCachedLeft =6859
  259. LayoutCachedWidth =7249
  260. LayoutCachedHeight =285
  261. ForeTint =100.0
  262. End
  263. End
  264. End
  265. Begin FormFooter
  266. Height =0
  267. BackColor =10855845
  268. Name ="PiedFormulaire"
  269. AlternateBackThemeColorIndex =1
  270. AlternateBackShade =95.0
  271. End
  272. End
  273. End
  274. CodeBehindForm
  275. Attribute VB_GlobalNameSpace = False
  276. Attribute VB_Creatable = True
  277. Attribute VB_PredeclaredId = True
  278. Attribute VB_Exposed = False
  279. Option Compare Database