Search results

please :( anyone?

hi, thanks I tried do it something like u (with all the conditions) but it still doent work :( SELECT td2.* , tasks.name_task FROM (SELECT td1.machinenum, td1.ID_task, Min(td1.duedate_task) AS MinOfduedate_task FROM tasks_diary AS td1 WHERE (((td1.dodate_task) Is Null) AND...

hi I would like to show for each machinenum and for each ID_task the first (oldest) record by it's duedate_task I don't success do it please your help Ben SELECT tasks_diary.ID_task, first(tasks_diary.duedate_task), tasks.name_task, tasks_diary.machinenum FROM tasks INNER JOIN tasks_diary...

wow wow wow amazing say me please does it count also this sub? Ben

hi :) is there any way to achieve statistic about the vba con in vba editor like how much functions, how much code rows etc.. thanks Ben

indeed, I just asked your impression if it will make my db slow?

wow thanks u I guess it will make my database so slow right? Ben

hi :) I would like to know .. what is the best and creative way to add translation to other language (if the user chose it) to all database and its forms? I thought something like floating massage when u stand something with the mouse.. I would like hear more ideas thanks ") Ben

sorry I don't think it 's the solve in this case.. or more exactly, maybe I don't know to operate it I'll give u the full details : Private Sub mach_1_AfterUpdate() If Me.ex1.value = 99999 And Not Me.mach_1.Value = 0 Then If msgzeropro = 0 Then Me.mach_1.Value = 0 (***) from now...

I would get marriage with u with his response , first thanks u second ...with my English and little knowledge of access I would read it 10000 time I try do it :)

hi :) when I success you close the answer please follow it, in addition I do thanks for all who replied to me! about the number of the questions : I do one-time project I started fro, zero knowledge and in 1 month I built very complex software of course with contribution any one of you .. so...

hi :) I do have some event event 1 -> filter on condition #1 in addition to what already exists t_event1 -> cancel event 1, but stay the other filters event 2 -> filter on condition #2 in addition to what already exists t_event1 -> cancel event 2, but leave the other filter on subform I...

hi :) how can I get rib of this massage: "this object is locked. any changes you make will be discarded when the form is close" I know it.. I want it to be like this ... and I don't get this massage thanks Ben

hi :) I do have a table with technical parameters which defined by the admin Most of my dlookup functions are to this table and I wonder what is the best way to retrieve information for it (memory space and run time aspects) maybe to stay dlookup way like it's now, or to pass all this table...

hi , I have this sub: Private Sub mach_2_AfterUpdate() If Me.ex2 .value= 99999 And Not Me.mach_2.Value = 0 Then If msgzeropro = 0 Then Me.mach_2.Value = 0 Exit Sub Else Me.ex2.Value = msgzeropro End If End If Call colordec(2) End Sub when msgzeropro and colordec are functions this sub...

thanks u but question: this inputbox expects to accept long ... if the user type "hjhjhjh" - will the same error 13 jump up? I would like to alert the user he typed illegal type of variable

lol I hate my English please forgive me anyway now I discovered that.. yes I have to make format even if this select i'm really shocked why does it have to be so primitive? I wonder how this language still survives thanks u all

did u see my question on select sql statement? it's above I thought u answered to it

please be practice do u meant I need to covert even if it select sql? even without any edit?

thanks u so much last question please, do I need to covert to format yyyy/mm/dd also in this case: strSQL = "SELECT * FROM fault_diary WHERE [machinenum]=" & Me.Listmach.Value & " AND [date_start_fault]<=#" & currnow & "# AND ([date_repair_fault]IS NULL OR [date_repair_fault] >=#" &...