Recent content by RaunLGoode

For the last 4 or 5 days I have been tracking emails from a support group. I would select the emails from the email list, right click the selection and copy the emails in the main list. Then I would select an Excel cell an Paste the values that would look something like this Yesterday, when...

I am using VLOOKUP to find a value in a named range(Range-A). I am using IFNA to trap values the Return "N/A" when no match is found. I then create a VLOOKUP to look in a different table (Range-B) for a match. =IF(ISNA(VLOOKUP(E2,Range-A,5,FALSE)), "", VLOOKUP(E2,Range-A,5,FALSE)) and...

I have a situation where Columns with date data require a specific format. I have to take client spreadsheets and clean up data of various data types. In this instance, the data type is date, but I wanted to create case statements, based on the data type of the range, to locate and resolve data...

Is it possible to return the data type for a range? In this case the range is a column. If possible, what would be the code to do so? I can see this would be problematic if there was more than one data type in the range. Thanks,

I have run across this a couple of times recently. I am copying a value from a single cell in a table generated in SQL or in another worksheet. When I paste the value to the destination cell, the value separates to multiple cells. Like I had selected "Text to Column" and used the "space...

jklo and SpentGeezer, Thanks! The 2 missing files were hidden and I think I understand how to edit the Access Macros. Again many thanks

Thanks for the reply. Let me clarify. My Experience is with Access 2003. The DBs I am migrating are in Access 2010. I have the Navigation pane open. but I can only see one Macro (ReloadData) in the Nav pane and I can't open / edit it unless I convert it to VBA. When I convert "ReloadData" to...

I have inherited several Access DBs that were on the personal hard drive of a developer who has left this company. We need to move the data bases to a secure server environment. There are several Macros associated with each of these DBs. I need to review the Macros to resolve any mapping issues...

Thanks Les, That worked like a charm RG

I am trying to automate some pivot tables. there are 5 Pivot Tables on 5 different worksheets that use a table on worksheet "Data". The column count will always be 7 (A-G) but the rows will change. How would I define the range of the data source? This is what I was trying [Code Starts] Dim...

I need to verify all the values in several columns are Long Integers. It would seem like this would be a fairly easy thing to do, but I haven't found anything after repeted attempts. I have tried using "Text to columns". but the example below works part of the time and doesn't other times...

This all came about because I am looking for a way to enable cascading deletions. Would a possible work-around be creating a deletion query for all records in the "child records"(all CorrectiveActionNumbers in tblCorrectiveActions matching the IncidentNumber) , then deleting the the parent...

I have inherited an Access 2007 database with two tables called “Incidents” and “CorrectiveActions”. tblIncidents IncidentID (Auto Numbered Primary Key) IncidentNumber Etc. tblCorrectiveActions IncidentNumber(Primary Key) CorrectiveAction(PrimaryKey) Etc. There...

I really like using the "Application.GetOpenFilename " method to allow users to navigate to files, but there are times when I would like to help out the users and have the browser start in a specific location. Is there a way, using Application.GetOpenFilename or something else, to open a...

Thank you for your help and prompt reply