Search results for query: *

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.

Easy question but where do I place the code for disabling the Shift Key. I have placed it in the startup forms 'on load' method but it does not disable the shortcut.

I am trying to disable and enable controls based on user security levels. I have created a table with users and their respective workgroups and based a userform on this table. My problem arises with the code [user]=CurrentUser() this only overwrites the first value in the user table though for...

I have a command button that prints the current record in access. When I insert a new record and then try to print it a blank report is printed, but then if I exit out of that form re-enter and then try to print the record the record will print correctly. Any help on fixing this bug would be...

I am trying to perform a check to see if the current user is a member of a custom user group that I set up in an access workgroup

I am trying to determine which group a user belongs to using code so that I can perform a condition.