Search results

anyone have any sort of idea or area which i could research?

i have approximately 100 users accessing a reporting system i have made in access which is linked to 5 databases. i am trying to record in a table the user ID of a person who has added a record to the reporting system. The users connect to the linked databases through ODBC when prompted. Any...

tried that. didnt work. got the solution now: =Int(CSng(([txtDateDel]-[txtdateRO])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")

i am trying to convert a time value that is currently in minutes to hours and minutes without luck so far. This is the calculation for the initial value in minutes: =DateDiff("n",[TxtDateRO],[TxtDateDel]) when i try to format into hh:nn i just get 00:00. The code i used is shown below...

Thanks for all your replies. I tried to do what you've shown 'the_doc_man' but without luck! im not really a good programmer so ive chosen to take advice from colinessex: Took your advice and have kept the date and time as one. =DateDiff("h",[TxtDateRO],[TxtdateDel]) it wont seem to work...

My Problem: I need to calculate the time in Hours/Minutes between 4 values. Field 1: Holds the Start Date Field 2: Holds the Start Time Field 3: Holds the End Date Field 4: Holds the End Time any suggestions on how to go about making this work. The End result needs to be in hours/minutes and...

thanks for your help. ive changed my list boxes to combo boxes and used the code you gave.

The combo box is cascaded and is only populated onced another combobox value has been selected. i want the first value of the 2nd combo box to be automatically shown.. Thanks

can anyone else verify this? if so, is it possible to show the first value of a combo box on load? instead of the blank combo?

I have a list box which is used as a record selection method [lstPlant]. The values for the list box are based on what the user selects from a combo box [cboPBL]. Does anyone know how to highlight the first value in the listbox once a selection has been made in the combo box? I need this to...