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!

Register Log in
  • Congratulations derfloh 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. Pampas58

    Creating a New Directory / Folder using Access

    Greetings to all who chose to read this question: I have a very simple application, it tracks the test reports for the engineering group. We create an E-File number, then we manually create a folder by that name and then we stuff the reports there manually. Question; who can I have Access...
  2. Pampas58

    Update Query - Approval Message - How to stop it

    PHV - Thanks you TheAceMan1 - You ROCK!!! Thank you both for the help Thanks for your help, the ignorace you jusst cured... is mine Tempus Fugit, ergo carpe diem
  3. Pampas58

    Update Query - Approval Message - How to stop it

    I'm creating a new application for our repair department to send out quote letters to our customers rather than make the 1000 phone calls it takes to make contact with them. I want the clerk to have two options "Print NOW" which is done and works fine, or "Batch Print". I set the status when...
  4. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    ...iNumberOfPages = Int((iTotalLabels / 6) + (5 / 6)) 'print the pages For iPage = 1 To iNumberOfPages iLastLabel = iPage * 6 ' Define the last label on the page iFirstLabel = iLastLabel - 6 ' subtract 6 to find the first label stCriteria = "[Label Number]...
  5. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    dhookom, Thank you for your response. I’m listing the answers below. - set the Height of your detail section to the height of your label [Pampas58] - The height of the detail section is 1.5 inches - set the top and bottom margins to 0 [Pampas58] - That’s the rub, Access won’t Allow...
  6. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    genomon; Just to let you know, I did start from scratch one more time and I still get the feed. This time it was only 1.25 inches which happens to be exactly 2x the Top Margin default for the letter size. At any rate, I'm trying to feed the following information into the Okidata (based on...
  7. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    genomon, Great suggestion and I tried it. I get a 3.375 feed after each label rather than after the full page. So I end up with 6 lables with 6 pieces with 6 3.375 feeds in between. ahhh, the joy of programming, no?!?
  8. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    genomon, Yes, twice just to make sure I had it right. I get a 3.375 automatic advance at the end of what would be a 8-1/2 x 11 letter size page. When I try to change from letter to legal, then the skip takes place at the end of the legal size page. So I go looking for a longer page, and the...
  9. Pampas58

    Runtime error defining parameters

    This may be a sophomoric answer, but last night working on a project I received the same error message. I looked for a while and found that I had a misspelled "Repalcment" in the table definition, but I spelled it correctly "Replacement" in the code. When it went looking for it in the...
  10. Pampas58

    Tractor Fed Part II - How to Define My Own Paper Size?

    Well, I'm trying another approach to this question. I found where I could define the Printer.TopMargin = 0 but the form feed, or perforation skip (which are both set to NO on the printer - a 24 pin Dot Matrix Impact printer) continues to happen; which points to my Access 2002 report. So, I...
  11. Pampas58

    Tractor Fed Continous Label gets a page break feed; how do I stop it?

    Folks, THANK YOU FOR TOSSING ME A LINE HERE: Answers: genomon; I do go into the preview and change the margins to zero (0) and then it just repopulates with whatever the minimums. Grrr!!! but it is what it is, an that's what I want to change. dhookom; yes, I defined the page size to the...
  12. Pampas58

    Tractor Fed Continous Label gets a page break feed; how do I stop it?

    genomon, Exactly why I am puzzled. The Okidata is dot matrix printer and should simply roll right through the perforations. However, it gives me a top margin inside of Access and it's driving me crazy (well, for me it's just a short walk) that I cannot figure out how to override it. I was on...
  13. Pampas58

    Tractor Fed Continous Label gets a page break feed; how do I stop it?

    genoman, THANK YOU for the quick replay... I just rechecked to make sure: Column Spacing = 0 and is grayed out (only 1 column) Row Spacing = 0 CORRECTION: When I said Page Break, I meant the old "Perforation Skip spacing" and I looked in the printer itself and I find that Perferation Skip is...
  14. Pampas58

    Tractor Fed Continous Label gets a page break feed; how do I stop it?

    Once again I begin what seems like a simple project and reality hits me with a two by four on the back of the head. THE ISSUE: Continuous form, custom product and serial number label for our products that feeds a Page Break at the end of the page in letter size page. I’ve used the Label Wizard...
  15. Pampas58

    e-mail error from Access2000 to Outlook2003 sp3

    I get the following error when the code below tries to fire off Outlook2003 to send an e-mail to the approver. The worse part of it is, that it only happens on some machines. I've talked to the IT folks and they have not seen anything that gives them a clue as to why some machines are...
  16. Pampas58

    How to transfer specific records from Table_1 to Table_2?

    ck199 OK, third time reading what you were suggesting and I think it hit me; finally! Is what you're suggesting that once I have the record found - the match from the first Do While Not.eof that finds the record I'm looking, then caputre the record number and go right back to it? Or am I...
  17. Pampas58

    How do I blank a date field ina bound form?

    Pampers, Thanks but after trying various different approaches with the statment, it appears that I cannot set the field back to Null that way... but I'm going to keep trying. PHV, Thanks too, but it too did not work. ck1999, Thanks for the offer, I did find something that sort of worked with...
  18. Pampas58

    How do I blank a date field ina bound form?

    CaptainD, Thanks, but I get the error "Compile Error, Expect end of statement" When I put in the following code: Dim vResponse As Variant Dim iID As Integer iID = [ID] ' this is the current record number 'Warn the user that there is a Date stored without a serial...
  19. Pampas58

    How do I blank a date field ina bound form?

    The Question: How do I blank a date field in a bound form? I’m not good enough yet to create and work with unbound forms and get anything done. The Why of the Question: I’ve created an order, repair, and ship database where the repairs are matched to the initial repair order. The part...
  20. Pampas58

    How to transfer specific records from Table_1 to Table_2?

    Since I posted the question I found what I was doing wrong with the DAO statements, but still this just "Sort of" works... Private Sub cmdIssueWorkOrder_Click() On Error GoTo Err_cmdIssueWorkOrder_Click 'This module transfers information from the tblOrderStatus to 'the table Repair Log...

Part and Inventory Search

Back
Top