Recent content by piet123

Hello, In Access 2000 : I have a custom search form with a ListBox. The ListBox gets it's records from a Query where the MainTable and RelatedTable is linked. On the DoubleClick event of the ListBox (ListInstruments) I have the following code: (This works perfectly as it should)...

Total Time I think I got it sorted in the meantime... I tried this in the Group Footer and it works: =Int(Sum([TimeOut]-[TimeIn])) & " day " & Format(Sum([Timeout]-[TimeIn]),"h"" hr ""n"" min ""s"" sec""") Thanks anyway.

Hello, (not sure if this post belongs in the Reports forum, sorry) From 2 Tables: In the Query I have these fields: LogID | UserID | TimeIn | TimeOut | with an additional column where I have this: TotalTime: Int([TimeOut]-[TimeIn]) & " day " & Format([Timeout]-[TimeIn],"h"" hr ""n""...

still having issues with this reply to unclejoe: thank you for the code(above). i tried that but still nothing. no error messages, and my forms still works perfectly, but the subforms still goes to 'record 1 of 4' (for example). (access2000 btw) and i want (no, the USER wants) it to default...

solved sorry, my mistake (stupid, stupid stupid mistake) . it happens sometimes at 2am. the qry was based upon another qry where i was counting a text field with a 'where' clause. problem is that i also had a 'group by' where i should have had a 'where' in another [date] field. fixed now...

in the qry design grid i have 2 columns: totfield1: (Nz([field1],0)) | totfield2: (Nz([field2],0)) then in a 3rd column i have grndtot: [totfield1]+[totfield2] all works okay except: if field1 value is 2 and field2 value is 3 i get grndtot as 23 instead of 5 ! i could do it before...

thank you reply to unclejoe: thank you for the reply. sorry for the delay, had meetings all day ! yes, the MAINfrm's Nxt,Prev buttons are my own (docmd....gotonext, etc) thanks for the code, i'll give it a go tonight. will keep you posted. piet.

keep focus on LAST sub record thanks again for the replies. sort order (of any field) is not really applicable here. adding new records is not the problem as such. continous forms- and datasheet views is not an option here. the problem i'm having is to KEEP focus on the LAST record of the...

let's try again reply to unclejoe : i already have docmd.runcommand accmdrecordsgotolast in the onclick event of the tab(of the tabcontrol). but it applies only for the first time you click the tab. once the user is viewing SUBreport3 (ie. the sub is already open/hasfocus), and then moves to...

thanks dennis, yes. the reason beiing: (fyi: each of the subforms contains ALOT of data) the mainform holds the patient's name, address, etc. subform1 is for (example) "observations" subform2 is for (example) "visits"(appointments) subform3 for xray examinations etc. etc. if the user looks at...

reply to Dennisk : Thank you for the reply. That is what I thought I should do. I know I want to do what YOU are suggesting but do not know how to do the following: On the MAINFORM's OnCurrent > DoCmd.RunCommand accmdRecordsGoToLast but for EACH and every subform and still remain focus on the...

Hello, I have searched the forums for help and got several references to what i think i need but i still just can't make it work. I think it's to do with recordset clone : On the MAINFORM is a Tabcontrol with 5 tabs. Each tab(page) has a subform. >Each subform's property is set to SINGLE FORM...

Thank you! That confirms my thought of a Msgbox to the user for "Are you sure..." but i was hoping that there was a more (elegant?) way of doing it. Thanks anyway.

Thank you for the (quick) reply. B ut if the user selected the wrong client by mistake (cbo_client), and have already entered data in the subform, how then can i let the user go back to cbo_client to change to another client ? Somehow I would like to prevent the subform data from beiing...

Hello, I HAVE searched the forums for many days but I could not find a solution. Maybe I'm not sure what to look for... The MAINFORM_1(single form view) is based on a Query and has a cbo named 'cbo_client'. This cbo is for a field named [client_id]. The AfterUpdate [event] of 'cbo_client' does...