Recent content by cliff7376

  1. C

    Limit Print output of group to number of pages

    I am creating a dispatch list for our manufacturing shop. I am Grouping the Report By Work Centers. Some Work Centers could have 1 page of data printing out daily and others could have up to 20 pages daily. Obviously they cannot do 20 Pages Worth of work in one day so it is a waste of paper...
  2. C

    Replace function in Access 2000

    in the query module? I must be missing something in my instalation then.
  3. C

    Replace function in Access 2000

    I found the problem. I guess the replace function will not work in a query but i found a way it can. You make a function in a module and use that. I did the following in a module and it worked great using the replaceq() function I created Function ReplaceQ (pString1 As String, pFind As...
  4. C

    Replace function in Access 2000

    I am trying to use the replace function in one of my queries and i get the error "Undefined function replace in expression". I was under the impression that access 2K had this capability. The replace function works in the form code. Is there some reference file I am missing or something? Any...
  5. C

    Print labels from data captured from form

    I am trying to create a PO Reciept Label that prints out once the data has been posted to my Sql Database. What I wanted to do is grab the data right after it has posted and print it out on a label using my default printer. Is there a print command where you can just print these variables out...
  6. C

    Keep first form on same record

    nevermind. I had a requery statement in my click event for some reason. It's all good now. Thanks
  7. C

    Keep first form on same record

    Those are good suggestions. I will fix those. The event is running in the before update of the control. The part number is a string becouse our part numbers use alpha numeric charachters. Do you know why it is going to record one once the new form closes?
  8. C

    Keep first form on same record

    I have a form that checked to see if a part number was entered into the DB. I Have made some code to check and if the part was not entered open up the part entry form for them to enter it in. The problem I am facing is that once they are done entering the new part in and close the form the...
  9. C

    Auto input new record or changed record date

    thank you
  10. C

    Auto input new record or changed record date

    I have a datasheet form and was wondering if anyone knew how to make a date automatically enter when a record has been changed.
  11. C

    hard code page size in report

    I have a program that uses continuous label stock. The width of the label stock is always the same but depending on certain variables the hieght of the stock varies from 1.5 inches high to 12 inches high. I need to be able to specify in code what size i want the page to be so I can have my...
  12. C

    Selecting Printers

    I am using this code exactly and Devices and Device are not showing as options to choose from. I get a user type not defined error. Is there some reference i need to include or something? Dim devs As devices Dim dev As device Sean
  13. C

    Hard coding the page layout for reports

    acctually sp1 for access 2k fixes the page formatting issue.
  14. C

    auto update fields from textbox input

    nevermind. I used dlookup. It worked exactly the way i wanted it to. Thanks Again Sean
  15. C

    auto update fields from textbox input

    Can I send you my database so you can help me out please. I have no idea why this is so hard for me but i am really confused. I tried using the query like you said but i can't get that to work either. thanks sean
See more
Back
Top Bottom