Search results for query: *

That is a good idea - didn't even think about that. Thank you.

Hello! I have a question (not sure if even possible). I have a spreadsheet that I am seperating the types of data by colors. For example: Duplicate records are pink, records that do not need modification in peach, and updated records in yellow. Is there any way to sort the data by color...

I need help. Here is the situation. I have two spreadsheets, Location & Equipment. In both spreadsheets, I have an equipment field and location field. However I need to change the locations within the Locations spreadsheet. I want to change the locations within the Location spreadsheet, and...

I have a spreadsheet in Excel that contains company names and addresses. I need to find the companies that have the same address. I will also need to delete the company names if they are duplicated. Please help me with VB or please give some direction. I greatly appreciate anyones help...

Thanks Skip for all your help yesterday and today!!!! Again I greatly appreciate it!!!! Dana

Hello, Another situation I need help with, I'm needing to seperate the following into 3 seperate fields, as opposed to one. This is the current format-in one cell Mesa, AZ 85204-6632 Need the City, State, and Zip seperated. I have over 20,000 records to seperate and need a quick way to do...

Skip, Thank you for your help. I appricate your response. Dana

Thank you for your help. It worked great. I appricate your response.

Hello, I need help seperating data within a cell in Excel. I need to seperate the Code and the description. I would like the Code to be in one cell and the description to be another cell. For example: 2095ManufacturingCOFFEE EXTRACTS is combined in one cell. I need 2095Manufacturing to be in...

Thank you for your help on this. The acDataErrContinue worked great. Thanks again

I have written an event procedure for 'On Not In List' for a Combo Box - to bring up an error message that I wrote. However, once they click ok on my error message, Access brings up it's own error message right after mine. How can I stop it from doing this?? Any help would be greatly...

Chris, Thanks for your help also, it worked great. I am curious as to how to define in query parameter. Can you assist me with this for future reference. Thanks again to both you and Mike for your assistance.

This worked perfect!!! :) Thank you so much for your help on this -- you saved me from beating my head any further on the table.

I am adding a filter via VB directly into the 'Filter' under the 'Data tab'. It is working, however, I need to add 2 types of criteria but don't know how to set this up. The reason I am adding this filter in the report is because it is reading from a crosstab query - and does not recognize a...