Search results

it was my fault.... it works perfect thanks

Hi Mark, much pretty code, without repetitions but in Me.file_name = ID_films & tmp & Me.test & ".jpg" tmp is not added many thank's

that makes the trick thank's all for your time Private Sub type_media_AfterUpdate() If Not IsNull(Me!test) Then Me.test.Locked = True Me.file_name.Locked = True Else Me.test.Locked = False Me.file_name.Locked = False End If Select Case type_media Case Is = "Movies photo" Me.test =...

Dear Grumm, the function as it is called every "type_media after update" and the result is type_media test fil_dir Film photo 1 1_1.jpg Film photo 2 1_2.jpg Film photo 3 1_3.jpg Shooting photo 4 1_g4.jpg...

Hi al, I use this and I need to reset the number for every case. May be it's not the best code to do this but at least it works at a half :) Could you please help? type_media is short text, test is number Thank's in advance Private Sub type_media_AfterUpdate() Select Case type_media Case...

Hi, yes indeed. But there is not the only. In every query the special character "," dosen't work too. It must be replaced with ";" e.g. the usualy DateDiff("d",[date_in],[date_out]) doesn't work returning "... contains invalid syntax" It works as DateDiff("d";[date_in];[date_out]) And that...

Just a film critic, trying to make my life easier with ms access on keeping the total of Long and Short Greek Films...