Search results

that helped but it returns numbers like 2, 4 , 5 etc

Thank you but it gives me error =DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID = '" & [atheltID] & "'")

tried this solution, dont work either =DLookUp([tmimaID]![Tbl_StelehosiTmimaton],[athletID]![Tbl_StelehosiTmimaton]=" & [tmimaID] & " And [AthletID]=[Forms]![Fr_Athlets]![atheltID])

I cant think better please help

Hello i would like your help.. need texbox to show value [tmimaID] on my form Fr_Athlets, based on value on table "Tbl_StelehosiTmimaton" and it seems i cant even though i ve tried...

Problem solved. Thanks bastanu and Shanemac51 and all you great guys for helping me. Was waiting for Shanemac51 but considering it came up to a good solution, there is no need to effort more... I am thinking of remaking my db so that only labels will be in my language and everything else...

Your solutions work great yet.. when taking everything you ve changed hopefully to work in my original db, i get this.. Maybe i miss something Shanemac51 Hope you could take a look in my DB as it is difficult to manage changes with my knowledge

I shall try your solutions and let you know soon. Thank you all. The problem isnt solved or i havent got any suggestion anywhere else. Thank you all

Yes i have crossposted since 10 years here and there https://www.pcreview.co.uk/threads/d...-help.4042851/ https://www.access-programmers.co.uk.../#post-1114013 and many more but i cant find a solution why so bad to help someone if he asked for help? 10 years i try to solve that

Thank you for your help ;) I have tested the updated file and the report opens for year 2022 and month January (1) populated (very good!) from the command button on the form as i wanted in the first place! But.. when i add some Saturdays that employees have worked in the next month...

Thank you i shall try soon

Maybe. but what might be the case here

Hello Having this problem over 10 years i need to ask again having simplyfied my database to a small sample if you would be kind to assist me on this: in a crosstab report called "RptsavvataepilogicrossA4" The report uses vba code to produse labels for dates (Saturdays) employees who have...

thank you it works!

actually it is a dynamic form

Hi i have a form which calls another form from depending on listbox selection fired by a command button problem is new form opens behind switchboard DoCmd.OpenForm "Fr_PromStoixeia", , , _ "promitheytesID = " & Me.lstSearch.Column(0)

Also another problem is : When form opens it is run behind switchboard code used DoCmd.OpenForm "Fr_PromStoixeia", , , _ "promitheytesID = " & Me.lstSearch.Column(0) do i need setfocus and how do i put it

Thank you very much ! it is solved now by your suggestion! DoCmd.OpenForm "Fr_PromStoixeia", , , _ "promitheytesID = " & Me.lstSearch.Column(0)

Thank you for your replies actually it is an autonumbered field! Where i have seen the code it indeed was referring to a text box... Thats getting me closer!