Search results

  1. I

    Find a Date & Time using GetFileTime

    I've written a File Scanner in Access 97 that records File name, path, size etc and put all the information in a database. I've been trying to find the Date Last Modified but im not having anyluck. Does anyone have a decent example of how it is written as I am aware that there are a few API's...
  2. I

    Bug in API ftLastWriteTime As Filetime??

    I've realised that its the way the information is being passed, hopefully be able to get to the bottom of it now.
  3. I

    Bug in API ftLastWriteTime As Filetime??

    Hi, Im currently writing a db app that does a filesearch and then places the results in table for file compares. Its using multiple API's and im on the final two steps now but I can't seem to get it working.. My WIN32_FIND_DATA statement currently looks like this... Private Type...
  4. I

    FindFirstFile move through subfolders?

    I'm currently writing a file scanning program using the FindFirstFile and related API's to pull file info. How can I get findfirstfile to move through subfolders? is it possible?
  5. I

    Find file type i.e txt, xls in Access 97

    Hi, I am writing a file cataloge program that searchs a chosen drive and places all the data in a table. Im trying to get find a way that I can pull the actual filetype. Is there a way to do this in access 97? Im using the Application.Filesearch tool to do this, i've tried the .FileType but...
  6. I

    Best way to change a character in a string?

    Hi, Im trying to create subfolders based on a value in a table, the values in the table currently have a "/" in them so this will need to be changed to a "-", whats the best way to change a value in Access 97 as the Replace() function is not available?
  7. I

    Very Basic MSComm Problem

    I figured this out, my problem was that I was not calling the Scanner_Settings module so the MSComm control was never activated. Once I moved my Scanner settings into Form_Load it worked just as I wanted it to. Ian
  8. I

    Very Basic MSComm Problem

    Thanks for the link, I added the line of code but sadly it had no effect. Its annoying as im sure its something simple that im missing :o
  9. I

    Very Basic MSComm Problem

    Hi, Thanks for the reply, what you suggest above i have already tried with no luck.
  10. I

    Very Basic MSComm Problem

    Yes, barcode reader is on an RS232 serial port.
  11. I

    Very Basic MSComm Problem

    Hi, Im trying to get to grips with VBA in Access 97, im currently trying to write a small MSComm module that we can bolt on to various db's in house. The last time I touched access was well over 12 months ago and that was a very basic bit of code so im going into this blind. At the minute...
  12. I

    Access 97 DB Wont Run on Windows 2003

    Hi, thanks for the reply. We have a volume license (not sure of the correct terminology for Office licenses) for Office 97. I have managed to get this working fine, the problem was the server had Office 2003 installed on it as well (Standard edition though with no Access :confused: ) Once I...
  13. I

    Access 97 DB Wont Run on Windows 2003

    Hi, No error message, its just opens up access then closes straight away :( It happens when I try to run it from the actual terminal server machine and when logged on a terminal console. From the server it is back end on a Share (on actual machine), front end located on C: Drive. Also...
  14. I

    Access 97 DB Wont Run on Windows 2003

    Hi, Im currently implementing terminal server. I have an access 97 database which all my users will use, back end sits on the server share and is a mapped drive, front end is on the users local drive at present but will become a shared DB on the terminal server. I can get the DB running by...
  15. I

    Access Denied trying to Open COM1

    Im all but convinced now that its a group policy issue, if I log on to the machine locally then it works fine, with a network logon the permissions are incorrect and it fails Thanks for the help, hopefully I can track the policy problem down!
  16. I

    Access Denied trying to Open COM1

    Yes, We have a app called 'Barcode' this initializes the printer and sends the .BAS file to it.
  17. I

    Access Denied trying to Open COM1

    It works when we run it on NT4, we have put in some new XP machines which refuse to print on COM1 :rolleyes: From all the testing I have done so far it appears to be a group policy option I think
  18. I

    Access Denied trying to Open COM1

    Its the Open Command that its failed on, I have Open "COM1" for Output As #1 Problem is as soon as it hits the open it fails with access denied !
  19. I

    Access Denied trying to Open COM1

    I have a printer attached to COM1 which I print barcodes to, when I try to run the code I get a File/Access Denied Error 75 message. Is there anything in Access 97 that could be causing this? Ian
  20. I

    Printing to COM1

    Thanks for the help, Now seems though that it may be a more basic rights issue... When I am logged on locally to the PC (as a standard user with a local user accoun) I can print to the COM port no problem, when I log on with a domain account with Group Policies etc it fails due to a file...
Back
Top Bottom