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.
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
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.
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.
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...
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...
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%...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.