Recent content by rodneyb

Hey thanks guys this is a big help. I will give it a try and let you know how I get on. Cheers.

Hi, I have a database file which is located on the C drive, and I have a process which when executed takes a copy of some files I've been working on and archives them on the work LAN. This currently works fine but there is an issue I need to take care of if the LAN goes down. Ie I need to be...

ah but users can work on the application while it is being zipped - users can't work on the app when the db files are 'copied', but they can work on the app when winzip is called to zip a file. This is the whole dilema - because winzip is still trying to zip the copied files whilst the...

thanks guys for your help. I tried appactivate but could not get this to work correctly therefore I implemented Cables code which works great. The only thing I would like to modify is instead of the dos window displaying on top of the access app in order to run pkzip - I would rather have it...

Hi, I currently use the following code for an Access97 application to backup the frontend and backend files: 'copy database to predefined directory Dim fso As Object Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile dbCopyLoc & "\*.mdb", archivePath, True Set fso = Nothing...

Hi, I have currently got some code within an Access97 app which is used to zip some files to a specified directory. I am achieving this using pkzip: Call Shell("pkzip25.exe" & " -add -move " & archivePath & "\" & filename & " " & archivePath & "\*.mdb", vbHide) This works fine when the code...

Hi, Is it possible to store a pdf file onto an Access97 database? I have a client who wants to be able to use their Access97 application to import pdf documents using an access form as the interface (ie click a button to import a doc and click another button to view the imported doc). I found...

Thanks OldSoftBoss, the code you provided was spot on - it was just what I needed. Thank you so much.

Thanks for the reply OldSoftBoss. I have had a look at the Northwind db but don't know where to look exactly for this piece of code - can you please help me out by telling me specifically where to look - or just paste the code here. Much appreciated.

I have a client who has a front end (access 97) and a backend file which is linked via the linked table manager. He now wants (for various reasons) multiple backend files that he can dynamically link to from the same front end, say using a command button from the front end interface, to display...

Aha - got it going using this code: Dim checkFile checkFile = Dir(archivePath & "\*.zip", vbDirectory) ' Retrieve the first entry. Do While checkFile <> "" ' Start the loop. If (Now - FileDateTime(archivePath & "\" & checkFile)) > 20 Then Kill archivePath & "\" & checkFile...

Hi, I have some vba code which copies the current database to an archive directory and zips it up and renames it with a date/time stamp. This archiving code is initiated on a daily basis therefore as you can imagine the number of archive files will soon add up. I want to be able to add code...

Thanks Wayne, how do I create "xx"? do I need to specify "xx" somewhere via menu options? if so how?

Thanks guys - but how do I get access the import specs options as I am importing from this piece of code within a module: DoCmd.TransferText acImportDelim, , "loadtmptransac", importloc & MyFile, False

Thanks Wayne I've managed to fix it - the problem was I had two full stops in the file name to be loaded which was causing the error. However I noticed that when the file loads it's formatting big fields that have numbers in them to the text format "1.326655E+16" etc. how do I stop this from...