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 Westi 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: *

  1. phillib5

    Automatically copy database from CD to Hard Drive

    I think I got it - %CD% in place of D:\ works.
  2. phillib5

    Automatically copy database from CD to Hard Drive

    Thanks guys. Carl, I was able to use your code in a batch file and it does just what I need. Now, I'm trying to find out how to refer to the current CD drive in use instead of D: when the database gets copied. Thanks again.
  3. phillib5

    Automatically copy database from CD to Hard Drive

    Does anyone know a way to automatically copy a database file from CD to a hard drive? And then have the database open up automatically from the HD? I understand a batch file could be used to do so, however I'm not sure on the commands. Any help is much appreciated, thank you! -Bryant
  4. phillib5

    Images in Access - any ideas?

    Does anyone know of any good ways to incorporate images into an Access Database? I've used a program called DBPix that works with Access, but I found that it has many kinks that have yet to be worked out. Any ideas would be greatly appreciated.
  5. phillib5

    Error Linking Tables through ODBC

    It appears in Control Panel. What would be a good way to test it?
  6. phillib5

    Error Linking Tables through ODBC

    Faircom 32Bit ODBC Driver
  7. phillib5

    Changing a field name in entire database

    Is that same field in different tables of your database? Or found on different forms, reports, etc.?
  8. phillib5

    Error Linking Tables through ODBC

    Hello, has anyone ever come across an 'Invalid Argument' error when trying to link tables through ODBC? I have 2 tables that are currently linked, but trying to re-create these links or linking to different data files generates this error. Any help would be greatly appreciated.
  9. phillib5

    Adjusting just the minutes of a date/time field

    Awesome, I used the latter solution and it worked like a charm. Both solutions were great, thank you.
  10. phillib5

    Adjusting just the minutes of a date/time field

    Does anyone know a way to adjust just the minute part of a time field. For example, I need to round the minutes off for certain time intervals. If the time was 5:01:00 AM, I would need it changed to 5:00:00 AM. Or 5:39:00 PM would need to be changed to 5:45:00 PM. This is the schema I go by...
  11. phillib5

    Form opens in read-only mode

    I'm working with an Access 97 database where there are several forms that open up and will not allow me to make any changes to the data unless I go to the next record, and then go back to the previous record. Then I am able to edit data. Has anyone else ever encountered this issue? Any help is...
  12. phillib5

    Comment field - Extracting Data

    Thanks Greg, I may be able to make a variation of that work. Here is a sample of the end of a memo field I am working with.... 2/3/05 lh will write and send coll assignment form to mr johnson…2/4/05 lh dicated letter to tape and to send coll assignement to mr stpieere to sign and setuo as 40%...
  13. phillib5

    Comment field - Extracting Data

    Hello, I am working with an Access 97 database where the creator decided to have a comment field for every record. In this comment field, users have been entering in data over time . Now they want the report they print out for these records to only show the last couple lines of the comment that...

Part and Inventory Search

Back
Top