Search results

I am using the formula as per above but when the seconds equal over 24 hours a day is dropped. How can i get this field to show the tot HH:MM:SS and not just the HH:MM:SS of the "current day". I.e 86412 Seconds should equal 24:00:12 but shows as 00:00:12. All help appreciated.

I have had a quick llok at the instr() function but don't understand how i incorporate it. Could you explain further. Cheers

I have written some VBA code to import a file with a click of a button from a CD. The file is not always the same name but always follows the following: D:\????f3??.vp Here is the code. DoCmd.TransferText acImportDelim, "550 Invoice Records Import Specification", "Tab 550 Current Month"...

Triffic. Many Thanks for your help.

I would like to view all of my query names from within a form using a combo box. Is this possible. I would like to do this so the user can select what query to run or delete. I cannot reference the query via a button etc... as the user can make new queries and name it as whatever they want...

Thanks for all your help guys. That is great!!!!

I have a field in a report which displays a value by total seconds ie 1827 seconds. I would like to convert this value into a new field shown as HH:MM:SS. Does anyone have any ideas on how i can achieve this. All help appreciated. Cheers Arry:D

Any other suggestions anyone?? Is there an easier way?

Many Thanks I will give it a go! Arry

Try holding the Shift key when you open the database.

Hello all, Hope you can help. Does anyone know a way to export data from an Access table/query into an excel file?? Sounds straight forward but what if the table/query is over 65,536 lines. Is there an easy way to split the records and paste into different excel sheets.:eek: For example...