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

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.

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

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.

I have created a command button to print the current record but it is only printing the first record in the table

I need to set a workgroup to be exclusive to just one database and not every access database I create.

I am trying to print the current record in a report in access. I have looked in the helpfiles but they are not clear on how you are applying the filter to isolate the current record.

I need to identify when the record on display in a form changes so that I can perform an if condition on the fields on display. Or else a way of identifying when the form goes into add mode.