Search results for query: *

All, OK, I have a major problem (or maybe not?). My wifehas been on my machine and amended all my services setting - i don't know why, she just did. Now, when I log in (after about 10 mins), I get no START bar so I can't get into the control panel to get back into the services. I created a...

I have a table which has several field headings. One of the fields is named 'Product'. I have run a query and created a report to display all the data (grouped) for the 'Product'types. What I need is a total of the number of Products, as opposed to having a complete list. ie. Software - 12...

I have several apps published via my server. I access them over the intranet. They used to work ok, but for some reason, when i click on the icon, they try to download a file name boilerplate.ica? any ideas it works fine for everyone else. Lamaar75@hotmail.com

I was prompted to download an applet ona particular website and lcick no. However, I now need this applet. Is there a way to make it prompt to download again? Thanks Lamaar75@hotmail.com

I have published an application via Citrix Metaframe (v1.8). I have given access to this application to a few people. However, only two of the people I gavce access to are able to access it. I checked NT group access and thee two people were members of another group, so I added everyone to...

I have two spreadsheets, one contains city ID's and country ID's (half of which are missing (over 6,000), amongst other things. My other spreadsheet just contains a list of all city ID's and their corresponding country ID's. I need a formula which will look at the column in the first...

I have a list of products in a table. I wish to display only the top 20 of the list, or maybe enter a number. what would be the best way to do this? thanks Lamaar75@hotmail.com

I have been sent a document in Word. When I click into the text, it highlights it all. The text also has a grey background. I can copy and paste the text into a new doc and it loses the formatting, but what is it? Thanks Lamaar75@hotmail.com

I have a spreadsheet which contains links to another one. When I open it, it says it has link and do i want to update them, I click Yes, save and then close. When I re-open it, it asks me again. It never used to do this, can anyone tell me why? Excel 2000. Lamaar75@hotmail.com

I primarily use Lotus notes as my email client, but being from an Outlook background I have configured this to read my Lotus email. However, it always looks at the copy of my mailfile on the server and is quite slow. Is there any way I can configure it to look at a local copy of my mailfile...

I primarily use Lotus notes as my email client, but being from an Outlook background I have configured this to read my Lotus email. However, it always looks at the copy of my mailfile on the server and is quite slow. Is there any way I can configure it to look at a local copy of my mailfile...

I have a row of data which is used for a pivot table. It was exported from an AS400 machine. It comes in two formats, numbers (012345) and letter and number (a12345). Some of the data is justified to the left and some to the right. The data to the right gets picked up by my pivot table. The...

I have a list of numbers generated from a database. They are formatted in Column A and can be any length in size. I need a formula to search through the numbers (they can be from 1 to 99,999) and pull out the duplicates and the number of occurances they are duplicated. I have tried using the...

OK, here goes. To simplify things, on one sheet, I have a row which contains the numbers "01" to "12" to represent the month of the year. Also on this sheet is other data which is relevant to a particular month. On my second sheet, I use a formula to look a the row which...

I wish to make all numbers entered in Excel be rounded up to the nearest 50. I can do it cell by cell, but have to enter a formula (round(cell, 50). Does anyone know of any VB code I can enter under 'Worksheet' 'Selection_change' which will do this for me? Thanks Lamaar75@hotmail.com

Hi all, I have a formula where by if a cell is more than 5 then it inserts teh date and time (using now) However, if the data in one cell changes, it changes the date and time in all cells which are referenced with NOW. I know this is a feature but I need to insert a static date and time. I...

If I have a field where the contents are numbers, 1-12, how can I group these on a report so that they show in quarters. Sorting and greouping does not work, neither does GroupOn. Thanks Lamaar75@hotmail.com

Any help would be grateful. Since I stopped using Access a year ago I have forgot how to do most things. I have Fields (Year, Products and Months). I need to create a query so that when I run a report, it displays the information by year and then splits the year into fours quarters (jan-mar)...

Does anyone know of any problem with the Freeze Pane option in Excel. I have two sheets in a workbook. I am able to Freeze the sheets on the first Sheet, columns A and B. However, when I attempt to do this on the second sheet, it only Freezes the pane from Row G. This even happens if I select...

Does anyone know if Microsoft have a viewer for MS Project? Thanks Lamaar75@hotmail.com