Recent content by Jordan76

  1. J

    Network Computer's holding printer resources?

    Is there a code snippet I can throw in to release the resources if I am just setting the printer using default settings, and using the specific printer settings for 2 different reports?
  2. J

    Network Computer's holding printer resources?

    Here is a screenshot of the error Here is a screenshot of the error I recieved. This error pops up everytime i open a new instance of the DB on another PC on the network. Even if you reset it on one by using Setup, and then move to a new PC to try it, you get the popup again. I tried with...
  3. J

    Network Computer's holding printer resources?

    Access recognizes the printer, even says in the error message that the default printer IS 'check printer' but it constantly says it is not available. I believe its holding the resources on a user which is connected simultaneously.
  4. J

    Network Computer's holding printer resources?

    I think I've discovered it. I have not created a workgroup for my database. Could this be affecting the printer resources if its used by multiple users?
  5. J

    Network Computer's holding printer resources?

    It should be noted that the problem is, that the printers are constantly being seen as not available on new machines, Any ideas? Thanks, Jordan
  6. J

    Network Computer's holding printer resources?

    I've been designing a database in access for monthes now. Being close to finished, I began rolling out to multiple workstations when I encountered a new problem I have never seen before. I will describe, and if possible can someone tell me if it is a problem with Access or Network issues...
  7. J

    (User-Defined Paper Size)

    Recently I developed a check printing DB for a travel agency. This worked wonderfully, providing I was able to set the paper size to (user defined Paper Size). This weekend I was setting the DB up on a new computer, with the EXACT same version of MS Access 2000. I don't think I did anything...
  8. J

    Error Trapping Novice

    Thanks Mile, Your the bestest!
  9. J

    Error Trapping Novice

    Thats Fantastic thank you, I just needed to know where to put it. Do I need to specifiy any error? like its generating a 2471, do i need to say 2471 anywhere?
  10. J

    Error Trapping Novice

    Hi there, Im using dlookup to search for values entered into 3 texts boxes. When one of the values isnt found, I get a 2471 Error and have to push end to move along with the data entry. What I want to do, but cant seem to do it is: I want the error to generate my own message box, then when...
  11. J

    Setting print area like in Excel

    Hmm, this could cause a problem. Is there a way to set a custom page up maybe? When choosing the page size, it only lets me use the ones in the drop down. Thanks In Advance Jordan
  12. J

    Setting print area like in Excel

    Do access reports, allow you to set a specific print area like in excel? I print cheques all time in Excel, and they stop right after the print area (that i manually set). However in access, the report forces the printer to scroll, therefor disrupting the check below the one being printed on...
  13. J

    Having a report not Scroll when printing is finished

    Is there a way to set the print area Is there a way to set the print area like in excel?
  14. J

    Having a report not Scroll when printing is finished

    Hey all, I am printing cheques, and I cant figure out how to have the printer not scroll into the check below. Its a tractor feed printer, and I need to only print the detail portion then stop, not scroll. Any ideas? I tried inserting page breaks but i think i did it wrong. Please help if...
  15. J

    Why would this work in 2002 and not 2000?

    Hmm Ive been reading on the differences between the two and cant figure it out. any ideas please?
Top Bottom