Search results for query: *

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

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!

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...

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.

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.

I wonder if someone could kindly assist me with a query I am trying to build. I have a variety of queries that when run produce totals based on tick boxes in a form. My problem is that I want to calculate the overall total of all of these queries added together. I have discovered that if just...

I wonder if someone could be kind enough to explain how I achieve the following on a form. 1) If I enter data say into the 1st field on my form, how can I make it jump to the 3rd field and leave the 2nd blank? 2) If I entered numeric data into the 2nd field, how can I place a tick in the 4th...

Is it possible to print off emails without the - sometimes - very long list of recipients being printed too. Can anyone tell me how to do this?

I was recently asked a question that I could not answer concerning XP. A colleague claims that his computer boots up when he lifts up his telephone. Does anybody know why?

1) When I have reopened my archive file why am I still unable to search and find categories? 2) Is it possible to have one calendar view open that incorporates an overview of my colleagues’ diaries? 3) What are macros ever used in Outlook for? Has anyone found a possible use for them?