Search results

I Arnel it is working perfectly!! Thank you so much!!

Arnel i did try all day, maybe if you saw my sample posted below you would figure out what is wrong To run one should change to system locale Greek in windows and from ypovolesfrm hit button planA3 or plan A4 after selecting year (has records for current year), month (all months) and a team. Please?

Arnel i tryed as you said still nothing appeared ( a report in the case) but, maybe it does but expected action needed after that -(opening a report)- is depended by this module Public Sub ReportQPlanSource(ByRef col As Collection) Dim sql As String, fld_name As String, i As Integer Dim p As...

How do i do that (to the backend)

Hello, i have very little knowledge of vba, still there should be a solution my DB was working everything good modules etc After splitting front end command which calls this module Public Function fncNextShift(ByVal dte2 As Variant, ByVal teamID As Long) As String Static rs As DAO.Recordset Dim...

Thanks arnelgp i ll give it a try... Is there a way for avoiding saving a query and beacause my listbox is working, to make that invisible and use the value with referencing that in my textbox? both are in same form I think that makes it more simple I was trying that before come with my...

Hello, please help me on refrase this working ok sql from my form's listbox to same form's textbox value (because the need of conditional formating and more) SELECT Count(hreomenoylikotbl.ylikoID) AS CountOfylikoID FROM ylikatbl INNER JOIN hreomenoylikotbl ON ylikatbl.ylikoID =...

Wrong i had same code on change Event, changed that too, now works as should with your advices!!

No Arnel it dropsdown anyway (even with no values)

Thanks i shall do that. I was good in basic Arnel. Back in school. Nowadays i would go back there if i could.. Had a commodore 64 :)

Yes, combobox cboOrario rowsource is SELECT DISTINCT orariatbl.orarioID, orariatbl.Orario FROM orariatbl, eidiyphresiontbl GROUP BY orariatbl.orarioID, orariatbl.Orario, eidiyphresiontbl.haraktirismosypiresiasID, eidiyphresiontbl.eidosypiresiasID HAVING (((orariatbl.orarioID) In (1,2,3,6,8)) AND...

I am trying to achieve that no luck with my coding

Hello, i was wondering if it is possible for a combobox which is coded to dropdown with an afterupdate event of a previous previous combobox, to not dropdown if it is empty..? That s what i need Thank you my code is Private Sub cboEidosypiresias_AfterUpdate() Me.cboOrario.Requery...

Its wonderfull!! many many THANK YOU Arnel!!!

I almost would let you in peace Arnel, all perfect but another problem sould be fixed, i noticed that report wrogly shows something. Someone who is placed on duty (eg like in screenshot) on Friday, 10th of November, while QrPlancross shows correct, 10nth working in that box, the Report...

This is after experiment, on your code working paint Sundays red, in past month as desired, but with current month (which is not finished yet) column headings arent the same i would like coumn headings produced same way as month 10 Arnel

Arnel almost perfect but a a little more help please! I would like Date Name left(format([date];"ddd"="S");1) at list included in that column head so having that, to show Sundays as Red i am trying in code to inlude it no luck here.. So S or M etc and Shift at least please

Thank you i shall try later. To explain, this on paper schedule is the one from which we place one to work according to his team s shift. So because there are five teams it is convinient to have the shifts written to see how to place someone on duty and decide how to place someone on duty in...

Arnel it is very good, i adopted it in mine, thank you for your work, one small favour and i will explain For passed months it is as should be, but if during a month like now 11th of 2022, column headings should be there even if no info down below against employee excist (like in crossatab...

I undreastand one sould change system locale to greek for that. What would you need to post istead as source for that report