Recent content by Manos39

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...