Search results for query: *

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...

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

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...

Well, while I have gone to a NUMBER of technical forums trying to get the answer to the Tractor Feed Label Problem, no one seemed to have the answer I was looking for. Many pointed to the OKIDATA ML591, others pointed to Access 2002 and in the end I still don’t have an answer. However, since I...

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...

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...

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?!?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...