Search results for query: *

The hours are stored in date/time format.

If I wish to sum up a column of hours on a form, how can I format a text box to show the result in days, hours and minutes (if in fact I can)? Thanks

I know about conditional formatting, but is there an alternative way in which you are able to count cells that have certain colour formatting? e.g. count all the cells in a column that have green text. Thanks

That was just what I was after, thanks very much!!

I have a table, which allows a client name to be entered, and 4 check box fields to be assigned. Each check box needs to carry (somehow) a numeric value, in order to accumulate a total figure. E.g. Field name Name box 1 box 2 box 3 box 4 Record J Smith v v...

Can anyone give me an idea why my 128mb usb storage pen thinks it is a floppy disk. Consequently I am unable to copy anything more than 1.44mb on to it. I am using Windows 2000 plus I have also try XP and come across the same problem.

Is it possible to have three fields on a form with the content of field 3 based on the input of fields 1 and 2. For example if field 1=a and field 2=b, is it possible for field to equal 'a b'

Does anyone know what if formula would change the background colour of a cell depending on the condition being tested for? ie if a2>b2 then c2 turns blue. Any clues would be helpful, thanks!

Thanks for that!

Is it possible to create a formula that counts the number of characters in a cell? Any pointers would be appreciated. Thank you!

Do you happen to know whether it is possible in Outlook to do the following:- When receiving an email from a new contact to have Outlook automatically add their details to the contacts folder. I know you can select their name and right click and add to Contacts, but is there anyway this can...

Thanks for your assistance!!!

I have been asked if it is possible to add a list of values in a column but to only add every alternate value. Therefore if I have a column with 50 values I only want to accumulate 25 of the 50.

Thank you for your prompt reply, most grateful!!!

I have a spreadsheet whereby number of hours worked is entered on a row e.g. 8:30 7:00 11:00 The total hours worked figure however displays 2:30 instead of 26:30 and all of the cells are formated to Custom hh:mm. What must I do to display my totals correctly?

Is it possible when using the subtotals feature to make the the vales appear in the column opposite instead of appearing directly below the values you are adding?

Is it possible when using the subtotals feature to make the the vales appear in the column opposite instead of appearing directly below the values you are adding?

I have some fields in a table that contain email addresses (in data type text, perhaps I should have used hyperlink?). I want to be able to pull out of the table via a query these addresses in order to compose an email. If I do this will I be able to do a straightforward copy and paste into the...

Yesterday evening I tried to help a friend of mine set up internet access on his lap top. I set this up manually but when it came to connecting I got the message "Access was denied because the username and / or password was invalid on the domain" I have checked everything over and...

I have a button on my form and I want it to act like a combo box does. ie to click it and a list appears displaying the contents of one of the columns of my table, then selecting a record from that list, it populates it to a text box.