Recent content by MikeKohler

I found the solution to this problem on the Symantec website at the following link: http://service1.symantec.com/SUPPORT/ent-security.nsf/0/d4e9dfc5ec676063c1256aa7002788fd?OpenDocument It tuns out the folder can be deleted.

Hi, as part of a network we have Symantec Antivirus Corporate Edition. My local hard drive is near full, and most of the files are located at: C:\Documents and Settings\All Users\Application Data\Symantec\Norton AntiVirus Corporate Edition\7.5\I2_LDVP.TMP\dec In this folder, there are files...

You're right, I had to change my table structure. I'm creting a whale monitoring database, and I had split the data based on sex, so I had females in a different table linked to the main table containing males. I combined the data into one table and using different queries, I can now have the...

Hi, I have a switchboard that when a combo box is used a report opens in preview view with the selected record. To get this result I use the criteria Forms!Switchboard!cmboName in the underlying query. This works fine when the query consits of one table. But when there are multiple tables...

Thank you, that worked great.

Hi, I have 3 columns, Day, Month and Year. What I want to do is to combine the 3 columns into one, and then import the spreadsheet into Access. The problem is that Access won't recognize the combined Date column as a date, it sees it as text. What format should the Day, Month and Year columns...

An update, I read this in a different forum and it worked. I saved the file as csv file, closed it and reopened the file in Excel, and the formular =B241&"/"&C241&"/E2 word fine.

I have columns Day Month Year 1 7 1975 16 8 1974 I want to then combine the fields into one that shows this as 1/17/1975. What format should these columns be in?

Hi, I'm trying to merge 2 columns, each is general format. When I enter the formular =B1&C2 I get the result #VALUE. I'm using Excel 2003. Thanks, Michael Kohler

One addition, the method I use makes sense for the feet column but not for the inches. So what I ended up doing was K6-(M6*12) K6 is the original column in inches - the feet column (INT(Cell_Ref)*12. That way you get the inches.

Thanks Skip, but what happens when the data has already been entered into a spreadsheet? I am creating a new acccess database that is used to monitor the beluga whale. Old data is in an Excel spreadsheet, and various measurement columns are in inches. I divided each colum by 12 to get feet...

Thanks for the reply. I was using faulty logic, what I am actually tring to do is split a column containing inches into 2 that contain feet and inches. I read a post about displying a number in the time format, and didn't think it through, the date had nothing to do with what I wanted, except...

Hi, I have a column that contains numbers in the format mm:ss. Is it possible to split the column based on the : so that mm is in one column and ss is in another? Thank you, Michael Kohler

Thank you, that saved me a lot of time.

Hi, is it possible to limit Find/Replace to 1 column in Excel? I have a column for color with W and G for white and grey, but I also have a column for geographic location which contains West. Can I change the colour column without changing the location column? Thank you, Michael Kohler