Et_FormHS_original.bas 41 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103
  1. Version =20
  2. VersionRequired =20
  3. Begin Report
  4. LayoutForPrint = NotDefault
  5. DividingLines = NotDefault
  6. AllowDesignChanges = NotDefault
  7. DateGrouping =1
  8. GrpKeepTogether =1
  9. PictureAlignment =2
  10. DatasheetGridlinesBehavior =3
  11. GridY =10
  12. Width =15825
  13. DatasheetFontHeight =11
  14. ItemSuffix =61
  15. DatasheetGridlinesColor =14806254
  16. Filter ="[Valide]=True AND [CodeAgent]='T20' AND [MoisRH]=9 AND [AnneeRH]=2013"
  17. RecSrcDt = Begin
  18. 0x531bfe97af4ae440
  19. End
  20. RecordSource ="SELECT tbl_FormHS.CodeAgent, tbl_FormHS.JourRH, tbl_FormHS.MoisRH, tbl_FormHS.An"
  21. "neeRH, r_Agents.Nom, r_Agents.Grade, r_Agents.Matricule, r_Agents.Catégorie, r_A"
  22. "gents.Groupe, tbl_FormHS.[HeureSup1<=14], tbl_FormHS.[HeureSup1>14], tbl_FormHS."
  23. "HeureSupNuit, tbl_FormHS.HeureSupDim, tbl_FormHS.Valide, Nz(DLookUp(\"[Itinerair"
  24. "e]\",\"[tbl_FormDep]\",\"[IDSuivi]=\" & [IDSuivi] & \" AND [JourRH]=\" & [JourRH"
  25. "]),\"\") AS Lieu FROM r_Agents INNER JOIN tbl_FormHS ON r_Agents.CodeAgent = tbl"
  26. "_FormHS.CodeAgent WHERE (((tbl_FormHS.Valide)=True)); "
  27. OnOpen ="[Event Procedure]"
  28. DatasheetFontName ="Calibri"
  29. PrtMip = Begin
  30. 0x6801000068010000680100006801000000000000d13d00001d01000001000000 ,
  31. 0x010000006801000000000000a10700000100000001000000
  32. End
  33. FilterOnLoad =0
  34. FitToPage =1
  35. DisplayOnSharePointSite =1
  36. DatasheetAlternateBackColor =15921906
  37. DatasheetGridlinesColor12 =0
  38. FitToScreen =1
  39. DatasheetBackThemeColorIndex =1
  40. BorderThemeColorIndex =3
  41. ThemeFontIndex =1
  42. ForeThemeColorIndex =0
  43. AlternateBackThemeColorIndex =1
  44. AlternateBackShade =95.0
  45. Begin
  46. Begin Label
  47. BackStyle =0
  48. FontSize =11
  49. FontName ="Calibri"
  50. ThemeFontIndex =1
  51. BackThemeColorIndex =1
  52. BorderThemeColorIndex =0
  53. BorderTint =50.0
  54. ForeThemeColorIndex =0
  55. ForeTint =50.0
  56. GridlineThemeColorIndex =1
  57. GridlineShade =65.0
  58. End
  59. Begin Image
  60. OldBorderStyle =0
  61. BorderLineStyle =0
  62. SizeMode =3
  63. PictureAlignment =2
  64. Width =1701
  65. Height =1701
  66. BorderColor =16777215
  67. GridlineColor =16777215
  68. BackThemeColorIndex =1
  69. BorderThemeColorIndex =1
  70. BorderShade =65.0
  71. GridlineThemeColorIndex =1
  72. GridlineShade =65.0
  73. End
  74. Begin TextBox
  75. AddColon = NotDefault
  76. FELineBreak = NotDefault
  77. BorderLineStyle =0
  78. Width =1701
  79. LabelX =-1701
  80. FontSize =11
  81. FontName ="Calibri"
  82. AsianLineBreak =1
  83. ShowDatePicker =0
  84. BackThemeColorIndex =1
  85. BorderThemeColorIndex =1
  86. BorderShade =65.0
  87. ThemeFontIndex =1
  88. ForeThemeColorIndex =0
  89. ForeTint =75.0
  90. GridlineThemeColorIndex =1
  91. GridlineShade =65.0
  92. End
  93. Begin FormHeader
  94. KeepTogether = NotDefault
  95. Height =1927
  96. Name ="EntêteÉtat"
  97. AlternateBackThemeColorIndex =1
  98. AlternateBackShade =95.0
  99. Begin
  100. Begin Label
  101. TextAlign =2
  102. Left =3685
  103. Top =283
  104. Width =8504
  105. Height =397
  106. FontSize =14
  107. FontWeight =700
  108. BorderColor =8355711
  109. Name ="Étiquette0"
  110. Caption ="ETAT MENSUEL DES HEURES SUPPLEMENTAIRES"
  111. GridlineColor =10921638
  112. LayoutCachedLeft =3685
  113. LayoutCachedTop =283
  114. LayoutCachedWidth =12189
  115. LayoutCachedHeight =680
  116. ForeTint =100.0
  117. End
  118. Begin TextBox
  119. OldBorderStyle =4
  120. TextAlign =2
  121. BorderLineStyle =3
  122. IMESentenceMode =3
  123. Left =2770
  124. Top =963
  125. Width =3246
  126. Height =315
  127. ColumnOrder =0
  128. BorderColor =10921638
  129. Name ="strEquipesLibelle"
  130. ControlSource ="Nom"
  131. StatusBarText ="Libelle de l'équipe"
  132. GridlineColor =10921638
  133. LayoutCachedLeft =2770
  134. LayoutCachedTop =963
  135. LayoutCachedWidth =6016
  136. LayoutCachedHeight =1278
  137. ForeTint =100.0
  138. Begin
  139. Begin Label
  140. Left =793
  141. Top =963
  142. Width =1605
  143. Height =315
  144. BorderColor =8355711
  145. Name ="Étiquette1"
  146. Caption ="NOM PRENOM:"
  147. GridlineColor =10921638
  148. LayoutCachedLeft =793
  149. LayoutCachedTop =963
  150. LayoutCachedWidth =2398
  151. LayoutCachedHeight =1278
  152. ForeTint =100.0
  153. End
  154. End
  155. End
  156. Begin TextBox
  157. OldBorderStyle =4
  158. TextAlign =2
  159. BorderLineStyle =3
  160. IMESentenceMode =3
  161. Left =2768
  162. Top =1416
  163. Width =3231
  164. Height =315
  165. ColumnOrder =2
  166. TabIndex =1
  167. BorderColor =10921638
  168. Name ="txt_MoisRH"
  169. ControlSource ="=UCase(MonthName([MoisRH])) & \" \" & [AnneeRH]"
  170. GridlineColor =10921638
  171. LayoutCachedLeft =2768
  172. LayoutCachedTop =1416
  173. LayoutCachedWidth =5999
  174. LayoutCachedHeight =1731
  175. ForeTint =100.0
  176. Begin
  177. Begin Label
  178. Left =793
  179. Top =1416
  180. Width =1890
  181. Height =315
  182. BorderColor =8355711
  183. Name ="Étiquette2"
  184. Caption ="Periode concernée:"
  185. GridlineColor =10921638
  186. LayoutCachedLeft =793
  187. LayoutCachedTop =1416
  188. LayoutCachedWidth =2683
  189. LayoutCachedHeight =1731
  190. ForeTint =100.0
  191. End
  192. End
  193. End
  194. Begin TextBox
  195. Visible = NotDefault
  196. OldBorderStyle =4
  197. TextAlign =1
  198. BorderLineStyle =3
  199. IMESentenceMode =3
  200. Left =623
  201. Top =1303
  202. Width =216
  203. Height =315
  204. ColumnOrder =3
  205. TabIndex =2
  206. BorderColor =10921638
  207. ForeColor =4210752
  208. Name ="AnneeRH"
  209. ControlSource ="AnneeRH"
  210. GridlineColor =10921638
  211. LayoutCachedLeft =623
  212. LayoutCachedTop =1303
  213. LayoutCachedWidth =839
  214. LayoutCachedHeight =1618
  215. End
  216. Begin TextBox
  217. OldBorderStyle =4
  218. BorderLineStyle =3
  219. IMESentenceMode =3
  220. Left =7371
  221. Top =963
  222. Width =2106
  223. Height =315
  224. ColumnOrder =4
  225. TabIndex =3
  226. BorderColor =10921638
  227. Name ="Texte22"
  228. ControlSource ="=\"DAERE\""
  229. GridlineColor =10921638
  230. LayoutCachedLeft =7371
  231. LayoutCachedTop =963
  232. LayoutCachedWidth =9477
  233. LayoutCachedHeight =1278
  234. ForeTint =100.0
  235. Begin
  236. Begin Label
  237. Left =6179
  238. Top =963
  239. Width =1095
  240. Height =315
  241. BorderColor =8355711
  242. Name ="Étiquette23"
  243. Caption ="DIRECTION"
  244. GridlineColor =10921638
  245. LayoutCachedLeft =6179
  246. LayoutCachedTop =963
  247. LayoutCachedWidth =7274
  248. LayoutCachedHeight =1278
  249. ForeTint =100.0
  250. End
  251. End
  252. End
  253. Begin TextBox
  254. OldBorderStyle =4
  255. BorderLineStyle =3
  256. IMESentenceMode =3
  257. Left =7371
  258. Top =1398
  259. Width =4311
  260. Height =315
  261. ColumnOrder =5
  262. TabIndex =4
  263. BorderColor =10921638
  264. Name ="Texte24"
  265. ControlSource ="Grade"
  266. GridlineColor =10921638
  267. LayoutCachedLeft =7371
  268. LayoutCachedTop =1398
  269. LayoutCachedWidth =11682
  270. LayoutCachedHeight =1713
  271. ForeTint =100.0
  272. Begin
  273. Begin Label
  274. Left =6179
  275. Top =1416
  276. Width =1095
  277. Height =315
  278. BorderColor =8355711
  279. Name ="Étiquette25"
  280. Caption ="GRADE"
  281. GridlineColor =10921638
  282. LayoutCachedLeft =6179
  283. LayoutCachedTop =1416
  284. LayoutCachedWidth =7274
  285. LayoutCachedHeight =1731
  286. ForeTint =100.0
  287. End
  288. End
  289. End
  290. Begin TextBox
  291. OldBorderStyle =4
  292. BorderLineStyle =3
  293. IMESentenceMode =3
  294. Left =10658
  295. Top =963
  296. Height =315
  297. ColumnOrder =6
  298. TabIndex =5
  299. BorderColor =10921638
  300. Name ="Texte26"
  301. ControlSource ="=\"Parc d'Erstein\""
  302. GridlineColor =10921638
  303. LayoutCachedLeft =10658
  304. LayoutCachedTop =963
  305. LayoutCachedWidth =12359
  306. LayoutCachedHeight =1278
  307. ForeTint =100.0
  308. Begin
  309. Begin Label
  310. Left =9694
  311. Top =963
  312. Width =840
  313. Height =315
  314. BorderColor =8355711
  315. Name ="Étiquette27"
  316. Caption ="SERVICE"
  317. GridlineColor =10921638
  318. LayoutCachedLeft =9694
  319. LayoutCachedTop =963
  320. LayoutCachedWidth =10534
  321. LayoutCachedHeight =1278
  322. ForeTint =100.0
  323. End
  324. End
  325. End
  326. Begin TextBox
  327. OldBorderStyle =4
  328. BorderLineStyle =3
  329. IMESentenceMode =3
  330. Left =13549
  331. Top =1398
  332. Height =315
  333. ColumnOrder =7
  334. TabIndex =6
  335. BorderColor =10921638
  336. Name ="Texte28"
  337. GridlineColor =10921638
  338. LayoutCachedLeft =13549
  339. LayoutCachedTop =1398
  340. LayoutCachedWidth =15250
  341. LayoutCachedHeight =1713
  342. ForeTint =100.0
  343. Begin
  344. Begin Label
  345. Left =11969
  346. Top =1403
  347. Width =1530
  348. Height =315
  349. BorderColor =8355711
  350. Name ="Étiquette29"
  351. Caption ="INDICE BRUT (*)"
  352. GridlineColor =10921638
  353. LayoutCachedLeft =11969
  354. LayoutCachedTop =1403
  355. LayoutCachedWidth =13499
  356. LayoutCachedHeight =1718
  357. ForeTint =100.0
  358. End
  359. End
  360. End
  361. Begin TextBox
  362. OldBorderStyle =4
  363. BorderLineStyle =3
  364. IMESentenceMode =3
  365. Left =13774
  366. Top =963
  367. Width =1476
  368. Height =315
  369. ColumnOrder =8
  370. TabIndex =7
  371. BorderColor =10921638
  372. Name ="Texte42"
  373. ControlSource ="Matricule"
  374. GridlineColor =10921638
  375. LayoutCachedLeft =13774
  376. LayoutCachedTop =963
  377. LayoutCachedWidth =15250
  378. LayoutCachedHeight =1278
  379. ForeTint =100.0
  380. Begin
  381. Begin Label
  382. Left =12529
  383. Top =963
  384. Width =1125
  385. Height =315
  386. BorderColor =8355711
  387. Name ="Étiquette43"
  388. Caption ="MATRICULE"
  389. GridlineColor =10921638
  390. LayoutCachedLeft =12529
  391. LayoutCachedTop =963
  392. LayoutCachedWidth =13654
  393. LayoutCachedHeight =1278
  394. ForeTint =100.0
  395. End
  396. End
  397. End
  398. Begin Label
  399. TextAlign =2
  400. Left =3685
  401. Top =56
  402. Width =8503
  403. Height =227
  404. FontSize =9
  405. BorderColor =8355711
  406. ForeColor =4210752
  407. Name ="Étiquette57"
  408. Caption ="Parc Départemental d'Erstein - Conseil Général du Bas-Rhin"
  409. GridlineColor =10921638
  410. LayoutCachedLeft =3685
  411. LayoutCachedTop =56
  412. LayoutCachedWidth =12188
  413. LayoutCachedHeight =283
  414. ForeTint =75.0
  415. End
  416. Begin Image
  417. BackStyle =0
  418. PictureType =1
  419. Left =283
  420. Top =56
  421. Width =2245
  422. Height =805
  423. BorderColor =10921638
  424. Name ="imgLogo"
  425. ControlTipText ="Auto_Logo0"
  426. GridlineColor =10921638
  427. LayoutCachedLeft =283
  428. LayoutCachedTop =56
  429. LayoutCachedWidth =2528
  430. LayoutCachedHeight =861
  431. TabIndex =8
  432. End
  433. End
  434. End
  435. Begin PageHeader
  436. Height =1474
  437. Name ="ZoneEntêtePage"
  438. AlternateBackThemeColorIndex =1
  439. AlternateBackShade =95.0
  440. BackThemeColorIndex =1
  441. Begin
  442. Begin Label
  443. OldBorderStyle =1
  444. TextAlign =2
  445. Left =793
  446. Top =964
  447. Width =1644
  448. Height =502
  449. FontSize =10
  450. BorderColor =8355711
  451. Name ="Étiquette4"
  452. Caption ="Date"
  453. GridlineColor =10921638
  454. LayoutCachedLeft =793
  455. LayoutCachedTop =964
  456. LayoutCachedWidth =2437
  457. LayoutCachedHeight =1466
  458. ForeTint =100.0
  459. End
  460. Begin Label
  461. OldBorderStyle =1
  462. TextAlign =2
  463. Left =2436
  464. Top =964
  465. Width =1644
  466. Height =502
  467. FontSize =10
  468. BorderColor =8355711
  469. Name ="Étiquette5"
  470. Caption ="Horaires Matinée"
  471. GridlineColor =10921638
  472. LayoutCachedLeft =2436
  473. LayoutCachedTop =964
  474. LayoutCachedWidth =4080
  475. LayoutCachedHeight =1466
  476. ForeTint =100.0
  477. End
  478. Begin Label
  479. OldBorderStyle =1
  480. TextAlign =2
  481. Left =4081
  482. Top =964
  483. Width =1644
  484. Height =502
  485. FontSize =10
  486. BorderColor =8355711
  487. Name ="Étiquette6"
  488. Caption ="Horaires Aprés-Midi"
  489. GridlineColor =10921638
  490. LayoutCachedLeft =4081
  491. LayoutCachedTop =964
  492. LayoutCachedWidth =5725
  493. LayoutCachedHeight =1466
  494. ForeTint =100.0
  495. End
  496. Begin Label
  497. OldBorderStyle =1
  498. TextAlign =2
  499. Left =5724
  500. Top =340
  501. Width =1635
  502. Height =1125
  503. FontSize =10
  504. BorderColor =8355711
  505. Name ="Étiquette7"
  506. Caption ="Nombre d'heures accomplies au cours d'un mois <=14H (**)"
  507. GridlineColor =10921638
  508. LayoutCachedLeft =5724
  509. LayoutCachedTop =340
  510. LayoutCachedWidth =7359
  511. LayoutCachedHeight =1465
  512. ForeTint =100.0
  513. End
  514. Begin Label
  515. OldBorderStyle =1
  516. TextAlign =2
  517. Left =7369
  518. Top =340
  519. Width =1650
  520. Height =1125
  521. FontSize =10
  522. BorderColor =8355711
  523. Name ="Étiquette8"
  524. Caption ="Nombre d'heures accomplies au cours d'un mois >14H (***)"
  525. GridlineColor =10921638
  526. LayoutCachedLeft =7369
  527. LayoutCachedTop =340
  528. LayoutCachedWidth =9019
  529. LayoutCachedHeight =1465
  530. ForeTint =100.0
  531. End
  532. Begin Label
  533. OldBorderStyle =1
  534. TextAlign =2
  535. Left =9014
  536. Top =340
  537. Width =1650
  538. Height =1125
  539. FontSize =10
  540. BorderColor =8355711
  541. Name ="Étiquette9"
  542. Caption ="Nombre d'heures Dimanche et jours de fête"
  543. GridlineColor =10921638
  544. LayoutCachedLeft =9014
  545. LayoutCachedTop =340
  546. LayoutCachedWidth =10664
  547. LayoutCachedHeight =1465
  548. ForeTint =100.0
  549. End
  550. Begin Label
  551. OldBorderStyle =1
  552. TextAlign =2
  553. Left =10657
  554. Top =340
  555. Width =1635
  556. Height =1125
  557. FontSize =10
  558. BorderColor =8355711
  559. Name ="Étiquette10"
  560. Caption ="Nombre d'heures accomplies de 22H à 7H (****)"
  561. GridlineColor =10921638
  562. LayoutCachedLeft =10657
  563. LayoutCachedTop =340
  564. LayoutCachedWidth =12292
  565. LayoutCachedHeight =1465
  566. ForeTint =100.0
  567. End
  568. Begin Label
  569. OldBorderStyle =1
  570. TextAlign =2
  571. Left =12302
  572. Top =963
  573. Width =2955
  574. Height =510
  575. FontSize =10
  576. BorderColor =8355711
  577. Name ="Étiquette11"
  578. Caption ="Observations"
  579. GridlineColor =10921638
  580. LayoutCachedLeft =12302
  581. LayoutCachedTop =963
  582. LayoutCachedWidth =15257
  583. LayoutCachedHeight =1473
  584. ForeTint =100.0
  585. End
  586. Begin Label
  587. OldBorderStyle =1
  588. TextAlign =2
  589. Left =5724
  590. Width =6576
  591. Height =340
  592. FontSize =10
  593. BorderColor =8355711
  594. Name ="Étiquette12"
  595. Caption ="DECOMPTE DES HEURES"
  596. GridlineColor =10921638
  597. LayoutCachedLeft =5724
  598. LayoutCachedWidth =12300
  599. LayoutCachedHeight =340
  600. ForeTint =100.0
  601. End
  602. Begin TextBox
  603. Visible = NotDefault
  604. FontItalic = NotDefault
  605. OldBorderStyle =0
  606. TextAlign =3
  607. BackStyle =0
  608. IMESentenceMode =3
  609. Left =12585
  610. Width =2670
  611. Height =315
  612. FontSize =9
  613. BorderColor =10921638
  614. ForeColor =4210752
  615. Name ="Texte55"
  616. ControlSource ="=\"Page \" & [Page] & \" sur \" & [Pages]"
  617. GridlineColor =10921638
  618. LayoutCachedLeft =12585
  619. LayoutCachedWidth =15255
  620. LayoutCachedHeight =315
  621. End
  622. End
  623. End
  624. Begin Section
  625. KeepTogether = NotDefault
  626. CanGrow = NotDefault
  627. Height =285
  628. Name ="Détail"
  629. AlternateBackColor =16777215
  630. BackThemeColorIndex =1
  631. Begin
  632. Begin TextBox
  633. TextAlign =2
  634. IMESentenceMode =3
  635. Left =793
  636. Width =1644
  637. Height =285
  638. FontSize =10
  639. ForeColor =4210752
  640. Name ="JourRH"
  641. ControlSource ="JourRH"
  642. GridlineColor =10921638
  643. LayoutCachedLeft =793
  644. LayoutCachedWidth =2437
  645. LayoutCachedHeight =285
  646. BorderThemeColorIndex =0
  647. BorderShade =100.0
  648. End
  649. Begin TextBox
  650. TextAlign =2
  651. IMESentenceMode =3
  652. Left =5725
  653. Width =1636
  654. Height =285
  655. FontSize =10
  656. TabIndex =1
  657. ForeColor =4210752
  658. Name ="HeureSup1"
  659. ControlSource ="HeureSup1<=14"
  660. Format ="Standard"
  661. ConditionalFormat = Begin
  662. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  663. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  664. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  665. 0x300000000000
  666. End
  667. GridlineColor =10921638
  668. LayoutCachedLeft =5725
  669. LayoutCachedWidth =7361
  670. LayoutCachedHeight =285
  671. BorderThemeColorIndex =0
  672. BorderShade =100.0
  673. ConditionalFormat14 = Begin
  674. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  675. 0x000000000000000000000000000000000000000000
  676. End
  677. End
  678. Begin TextBox
  679. DecimalPlaces =2
  680. TextAlign =2
  681. IMESentenceMode =3
  682. Left =10658
  683. Width =1636
  684. Height =285
  685. FontSize =10
  686. TabIndex =2
  687. ForeColor =4210752
  688. Name ="HeureSup2"
  689. ControlSource ="HeureSupNuit"
  690. Format ="Standard"
  691. ConditionalFormat = Begin
  692. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  693. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  694. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  695. 0x300000000000
  696. End
  697. GridlineColor =10921638
  698. LayoutCachedLeft =10658
  699. LayoutCachedWidth =12294
  700. LayoutCachedHeight =285
  701. BorderThemeColorIndex =0
  702. BorderShade =100.0
  703. ConditionalFormat14 = Begin
  704. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  705. 0x000000000000000000000000000000000000000000
  706. End
  707. End
  708. Begin TextBox
  709. DecimalPlaces =2
  710. TextAlign =2
  711. IMESentenceMode =3
  712. Left =9015
  713. Width =1650
  714. Height =285
  715. FontSize =10
  716. TabIndex =3
  717. ForeColor =4210752
  718. Name ="HeureSupDim"
  719. ControlSource ="HeureSupDim"
  720. Format ="Standard"
  721. ConditionalFormat = Begin
  722. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  723. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  724. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  725. 0x300000000000
  726. End
  727. GridlineColor =10921638
  728. LayoutCachedLeft =9015
  729. LayoutCachedWidth =10665
  730. LayoutCachedHeight =285
  731. BorderThemeColorIndex =0
  732. BorderShade =100.0
  733. ConditionalFormat14 = Begin
  734. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  735. 0x000000000000000000000000000000000000000000
  736. End
  737. End
  738. Begin TextBox
  739. TextAlign =2
  740. IMESentenceMode =3
  741. Left =2437
  742. Width =1644
  743. Height =285
  744. FontSize =10
  745. TabIndex =4
  746. ForeColor =4210752
  747. Name ="Texte17"
  748. GridlineColor =10921638
  749. LayoutCachedLeft =2437
  750. LayoutCachedWidth =4081
  751. LayoutCachedHeight =285
  752. BorderThemeColorIndex =0
  753. BorderShade =100.0
  754. End
  755. Begin TextBox
  756. TextAlign =2
  757. IMESentenceMode =3
  758. Left =4082
  759. Width =1644
  760. Height =285
  761. FontSize =10
  762. TabIndex =5
  763. ForeColor =4210752
  764. Name ="Texte19"
  765. GridlineColor =10921638
  766. LayoutCachedLeft =4082
  767. LayoutCachedWidth =5726
  768. LayoutCachedHeight =285
  769. BorderThemeColorIndex =0
  770. BorderShade =100.0
  771. End
  772. Begin TextBox
  773. TextAlign =2
  774. IMESentenceMode =3
  775. Left =7370
  776. Width =1650
  777. Height =285
  778. FontSize =10
  779. TabIndex =6
  780. ForeColor =4210752
  781. Name ="Texte20"
  782. ControlSource ="HeureSup1>14"
  783. Format ="Standard"
  784. ConditionalFormat = Begin
  785. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  786. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  787. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  788. 0x300000000000
  789. End
  790. GridlineColor =10921638
  791. LayoutCachedLeft =7370
  792. LayoutCachedWidth =9020
  793. LayoutCachedHeight =285
  794. BorderThemeColorIndex =0
  795. BorderShade =100.0
  796. ConditionalFormat14 = Begin
  797. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  798. 0x000000000000000000000000000000000000000000
  799. End
  800. End
  801. Begin TextBox
  802. IMESentenceMode =3
  803. Left =12302
  804. Width =2948
  805. Height =285
  806. FontSize =8
  807. TabIndex =7
  808. ForeColor =4210752
  809. Name ="Texte58"
  810. ControlSource ="Lieu"
  811. GridlineColor =10921638
  812. LayoutCachedLeft =12302
  813. LayoutCachedWidth =15250
  814. LayoutCachedHeight =285
  815. BorderThemeColorIndex =0
  816. BorderShade =100.0
  817. End
  818. End
  819. End
  820. Begin PageFooter
  821. Height =0
  822. Name ="ZonePiedPage"
  823. AlternateBackThemeColorIndex =1
  824. AlternateBackShade =95.0
  825. BackThemeColorIndex =1
  826. End
  827. Begin FormFooter
  828. KeepTogether = NotDefault
  829. CanGrow = NotDefault
  830. Height =1362
  831. Name ="PiedÉtat"
  832. AlternateBackThemeColorIndex =1
  833. AlternateBackShade =95.0
  834. BackThemeColorIndex =1
  835. Begin
  836. Begin Label
  837. Left =793
  838. Top =403
  839. Width =7080
  840. Height =270
  841. FontSize =8
  842. BorderColor =8355711
  843. Name ="Étiquette30"
  844. Caption ="(*) Indice brut < IB 381 pour paiement d'heures supplémentaires (cf décret n°200"
  845. "2-60 du 14/01/2002"
  846. GridlineColor =10921638
  847. LayoutCachedLeft =793
  848. LayoutCachedTop =403
  849. LayoutCachedWidth =7873
  850. LayoutCachedHeight =673
  851. ForeTint =100.0
  852. End
  853. Begin Label
  854. Left =8668
  855. Top =396
  856. Width =5490
  857. Height =270
  858. FontSize =8
  859. BorderColor =8355711
  860. Name ="Étiquette31"
  861. Caption ="(**) Indiquer les 14 premières heures au cours du mois (14 heures maximum)"
  862. GridlineColor =10921638
  863. LayoutCachedLeft =8668
  864. LayoutCachedTop =396
  865. LayoutCachedWidth =14158
  866. LayoutCachedHeight =666
  867. ForeTint =100.0
  868. End
  869. Begin Label
  870. Left =793
  871. Top =680
  872. Width =5490
  873. Height =270
  874. FontSize =8
  875. BorderColor =8355711
  876. Name ="Étiquette32"
  877. Caption ="(***) Indiquer les heures effectuées au cours du mois à partir de la 15e heure"
  878. GridlineColor =10921638
  879. LayoutCachedLeft =793
  880. LayoutCachedTop =680
  881. LayoutCachedWidth =6283
  882. LayoutCachedHeight =950
  883. ForeTint =100.0
  884. End
  885. Begin Label
  886. Left =8674
  887. Top =680
  888. Width =5490
  889. Height =270
  890. FontSize =8
  891. BorderColor =8355711
  892. Name ="Étiquette33"
  893. Caption ="(****) Heures de nuit entre 22h et 7h (décret n°2002-60 du 14/01/2002)"
  894. GridlineColor =10921638
  895. LayoutCachedLeft =8674
  896. LayoutCachedTop =680
  897. LayoutCachedWidth =14164
  898. LayoutCachedHeight =950
  899. ForeTint =100.0
  900. End
  901. Begin TextBox
  902. TextAlign =2
  903. IMESentenceMode =3
  904. Left =5725
  905. Width =1636
  906. Height =345
  907. FontSize =10
  908. ForeColor =4210752
  909. Name ="Texte45"
  910. ControlSource ="=Sum([HeureSup1<=14])"
  911. Format ="Standard"
  912. ConditionalFormat = Begin
  913. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  914. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  915. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  916. 0x300000000000
  917. End
  918. GridlineColor =10921638
  919. LayoutCachedLeft =5725
  920. LayoutCachedWidth =7361
  921. LayoutCachedHeight =345
  922. BorderThemeColorIndex =0
  923. BorderShade =100.0
  924. ConditionalFormat14 = Begin
  925. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  926. 0x000000000000000000000000000000000000000000
  927. End
  928. End
  929. Begin TextBox
  930. DecimalPlaces =2
  931. TextAlign =2
  932. IMESentenceMode =3
  933. Left =10658
  934. Width =1636
  935. Height =345
  936. FontSize =10
  937. TabIndex =1
  938. ForeColor =4210752
  939. Name ="Texte46"
  940. ControlSource ="=Sum([HeureSupNuit])"
  941. Format ="Standard"
  942. ConditionalFormat = Begin
  943. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  944. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  945. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  946. 0x300000000000
  947. End
  948. GridlineColor =10921638
  949. LayoutCachedLeft =10658
  950. LayoutCachedWidth =12294
  951. LayoutCachedHeight =345
  952. BorderThemeColorIndex =0
  953. BorderShade =100.0
  954. ConditionalFormat14 = Begin
  955. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  956. 0x000000000000000000000000000000000000000000
  957. End
  958. End
  959. Begin TextBox
  960. DecimalPlaces =2
  961. TextAlign =2
  962. IMESentenceMode =3
  963. Left =9015
  964. Width =1650
  965. Height =345
  966. FontSize =10
  967. TabIndex =2
  968. ForeColor =4210752
  969. Name ="Texte47"
  970. ControlSource ="=Sum([HeureSupDim])"
  971. Format ="Standard"
  972. ConditionalFormat = Begin
  973. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  974. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  975. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  976. 0x300000000000
  977. End
  978. GridlineColor =10921638
  979. LayoutCachedLeft =9015
  980. LayoutCachedWidth =10665
  981. LayoutCachedHeight =345
  982. BorderThemeColorIndex =0
  983. BorderShade =100.0
  984. ConditionalFormat14 = Begin
  985. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  986. 0x000000000000000000000000000000000000000000
  987. End
  988. End
  989. Begin TextBox
  990. TextAlign =2
  991. IMESentenceMode =3
  992. Left =7370
  993. Width =1650
  994. Height =345
  995. FontSize =10
  996. TabIndex =3
  997. ForeColor =4210752
  998. Name ="Texte50"
  999. ControlSource ="=Sum([HeureSup1>14])"
  1000. Format ="Standard"
  1001. ConditionalFormat = Begin
  1002. 0x0100000066000000010000000000000002000000000000000200000001000000 ,
  1003. 0xffffff00ffffff00000000000000000000000000000000000000000000000000 ,
  1004. 0x0000000000000000000000000000000000000000000000000000000000000000 ,
  1005. 0x300000000000
  1006. End
  1007. GridlineColor =10921638
  1008. LayoutCachedLeft =7370
  1009. LayoutCachedWidth =9020
  1010. LayoutCachedHeight =345
  1011. BorderThemeColorIndex =0
  1012. BorderShade =100.0
  1013. ConditionalFormat14 = Begin
  1014. 0x010001000000000000000200000001000000ffffff00ffffff00010000003000 ,
  1015. 0x000000000000000000000000000000000000000000
  1016. End
  1017. End
  1018. Begin Label
  1019. TextAlign =2
  1020. Left =793
  1021. Width =4932
  1022. Height =345
  1023. FontSize =12
  1024. BorderColor =8355711
  1025. Name ="Étiquette52"
  1026. Caption ="TOTAL"
  1027. GridlineColor =10921638
  1028. LayoutCachedLeft =793
  1029. LayoutCachedWidth =5725
  1030. LayoutCachedHeight =345
  1031. ForeTint =100.0
  1032. End
  1033. Begin Label
  1034. Left =9355
  1035. Top =1077
  1036. Width =4365
  1037. Height =285
  1038. FontSize =9
  1039. BorderColor =8355711
  1040. Name ="Étiquette53"
  1041. Caption ="Certifié exact: Le directeur / Le chef de service"
  1042. GridlineColor =10921638
  1043. LayoutCachedLeft =9355
  1044. LayoutCachedTop =1077
  1045. LayoutCachedWidth =13720
  1046. LayoutCachedHeight =1362
  1047. ForeTint =100.0
  1048. End
  1049. Begin TextBox
  1050. IMESentenceMode =3
  1051. Left =12302
  1052. Width =2948
  1053. Height =345
  1054. TabIndex =4
  1055. ForeColor =4210752
  1056. Name ="Texte60"
  1057. ControlSource ="=\"\""
  1058. GridlineColor =10921638
  1059. LayoutCachedLeft =12302
  1060. LayoutCachedWidth =15250
  1061. LayoutCachedHeight =345
  1062. BorderThemeColorIndex =0
  1063. BorderShade =100.0
  1064. End
  1065. End
  1066. End
  1067. End
  1068. End
  1069. CodeBehindForm
  1070. Attribute VB_GlobalNameSpace = False
  1071. Attribute VB_Creatable = True
  1072. Attribute VB_PredeclaredId = True
  1073. Attribute VB_Exposed = False
  1074. Option Compare Database
  1075. Private Sub Report_Open(Cancel As Integer)
  1076. Me.imgLogo.Picture = get_lien("logo_cd67")
  1077. Me.OrderBy = "[JourRH] ASC"
  1078. Me.OrderByOn = True
  1079. End Sub