Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MikeKohler
  • Order by date
  1. MikeKohler

    Symantec and Disk Space

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

    Symantec and Disk Space

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

    Query with Linked Tables not working with ComboBox

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

    Query with Linked Tables not working with ComboBox

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

    Create Date from 3 Fields

    Thank you, that worked great.
  6. MikeKohler

    Create Date from 3 Fields

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

    Concatenate Results in Error

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

    Concatenate Results in Error

    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?
  9. MikeKohler

    Concatenate Results in Error

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

    Divide time Column

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

    Divide time Column

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

    Divide time Column

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

    Divide time Column

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

    Limit Find/Replace to One Colum

    Thank you, that saved me a lot of time.
  15. MikeKohler

    Limit Find/Replace to One Colum

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

    Access 2003

    Thanks, I think I will keep it in 2000 format. There are people I need to distribute it to, and I'm sure they don't have 2003.
  17. MikeKohler

    Access 2003

    Hi, I have a question about versions. Right now I am using Acess 2003, and am storing my database so that its using the Access 2000 file format. Is there any advantages to saving it as a 2003 file, are there new features not availabe in the 2000 format? Thank you, Michael Kohler
  18. MikeKohler

    Upload - Limited to 12 files

    Hi, thanks for your help. I figured it out. When I upload, it calls a function that deals with the file. Since I have multiple folders, each folder has a seperate function. I called the wrong function, and the uploaded file was being sent to the wrong folder. I didn't notice it before...
  19. MikeKohler

    Upload - Limited to 12 files

    No, I checked and that is not happening.
  20. MikeKohler

    Upload - Limited to 12 files

    This is the code that I use to upload the files: <?php //Script 11.4 - upload_file.php // Address error handling. ini_set ('display_errors', 1); error_reporting (E_ALL & ~E_NOTICE); if (isset ($_POST['submit'])) { //Handle form. // Try to move uploaded form. if (move_uploaded_file...

Part and Inventory Search

Back
Top