Search results

hi, I have this assignment: msgzeropro = Nz(InputBox(Message, Title), 0) if the user clicked on canceled , I got error type mismatch how can I avoid it? in addition I would like catch the knowledge if he clicked cancel for the last code. thanks Ben

so much thanks - it's what I need, to understand the rationale but now, how can I show in forms, subforms dates as dd/mm/yyyy ?! thanks! Ben

ok thanks I still believe it's not the main cause cause I used this database almost 2 month and I never met with this problem

thanks but see my first post, it's what I did

I don't cate about format but.... when I do DOA recordset it's show wrong data - and the calculate dateadd or diffate gives wrong! strSQL = "SELECT * FROM fault_diary WHERE [machinenum]=" & Me.Listmach.Value & " AND [date_start_fault]<=#" & currnow & "# AND ([date_repair_fault]IS NULL OR...

hi thanks there is not any other way to do it? this database uses by many users in any computer

hi :( I do have queries which add date in this format: ", #" & Format(Now, "dd/mm/yyyy hh:nn:ss") & "#," but in the tables I see it as mm/dd/yyyy hh:nn:ss i'm begging - how can I fix it and avoid it when use in any computer? thanks Ben

hi :) for unbound textboxes - how can I give user options to open calendar and chose date ... if I don't make mistake, it's automatic for bound textboxes thanks Ben

so how can it affects ? are there any specific situations ? thanks Ben

hi, please say me which is the best way to ensure there are specific record/s in the table by IF NOT ISNULL (DLOOKUP.......) or by IF DCOUNT(...)>0 what are the advantages and disadvantages for those? thanks u Ben

thanks u so much there is any thumb rule for it? Ben

hi :) I need all the columns of table1 and just one column of table 2 in any case, I need pass thought every record what is the best way (memory and time) to do dlookup for ever record to looking the value in table 2 or to do JOIN between the two tables from the start? thanks u Ben

hi :) I just want to clear it Does the function dateadd "understand" fractions ? for example: I need to write DateAdd("yyy", 0.5, curredate1) as DateAdd("m", 6, curredate1) or the first pattern is ok? thanks u Ben

thanks you I know it but... on close event ..how I can requery the parent (source-form) generally (without knowing the specific parent) or how can I following which was the parent -form ? thanks Ben

hi :) I'll do my best explain all my stages: 1. I made a query 2. I made a form (from1) based on this query when clicking on record, form2 opens. 3. I made from this form1 a same sub-form (subform1) for 2 different forms (from3, from4) 4. when exit from from2 I want to requery...

hi :) I understood I can't add controls to form during run time - unless in design view. So, I created a lot of hidden controls and during run time I make them to visible I feel its so naïve and not optimal - like I need reboot all those controls when the form loads and return them to hidden...

thanks u so much

Hi friends, I'm begging to solve it: how to write the part of the dlookup correctly thanks you!! Ben Me.Graph38.RowSource = "SELECT graph.[numoutt], Sum(graph.[quantity_pro]) AS SumOfquantity_pro, DLookup('yellow_range', 'machine', 'IDnum=' & [graph]![machinenum] & '') AS g " _ & " FROM...