Recent content by mooneye

I have 2 worksheets. I need to map 2 columns of information contained in the 2nd worksheet into the 1st worksheet based on key fields contained in the 2nd worksheet. The 1st worksheet contains multiple instances of the key fields in the 2nd worksheet. I need to bring the additional information...

I tried conditional formatting but when I tried to drag it down the column it would not increment the formula.

I have put a function in a column to report if the values in the column next to it are invalid if they are greater than the corresponding values in another column. What I need to do is now highlight these invalid values as I must remove the function column that reports the Invalid values. Any...

Thanks Dale it did the trick.

Is there any quick way of deleting non-numeric data from fields, e.g. I want 12.5 to appear instead of 12.5 Kg. Any help would be greatly appreciated.

Is there anyway of deleting duplicate rows in an excel spreadsheet. I have a very large spreadsheet that would take too long to do manually.

Hi, I am having problems with hyperlinks to excel documents in Project. When I click on the hyperlink the excel documents open, but when I return to Project the project file I had open is after closing so I have to reopen the file after each time I use a hyperlink. Any help would be greatly...

I have a combobox which is used to indicate a records staus. I am trying to set a control on this combobox so that it may only have a status of 'closed' when a particular field has information in it.

Conditional Formatting as above, I was only thinking of Validation as a means of flagging the date using the red circle to show what has become overdue by 2 weeks.

I am trying to validate date fields. I need to flag a date if it is less than todays date by 14 days. Regards mooneye

You could also try running Wrkgadm.exe in File Run. You can create a new workgroup here and set Access to this workgroup which should free it for you to use again. Ed

I am trying to create a query that will select the current record on display in a form. Filter although it will do this for me is not an option. Thanks Ed

I am trying to create a command button that will send a mail with a report attached to it. My problem is that I am trying to get it to send a report only containing the current record. Is there any way of applying a filter to a mail. Ed

I need help creating a query that will only show the current record in a report.

I am trying to mail the current record in a report but I dont know how to filter the mail so that it will only send the current record and not all records.