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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mchester

  1. mchester

    Count the button clicks + Display the count

    ZmrAbdulla I found my error on your first suggestion and the button is working perfectly. Not knowing nothing about programming, trial and error can be frustrating. Thanks I will try suggestion #2 now Mike
  2. mchester

    Count the button clicks + Display the count

    Thanks for the information. I really do not understand where to insert the code. I tryed putting it in the control properties in On Click. I get an error Form 2 does not exist. Do you know what I am doing wrong
  3. mchester

    Count the button clicks + Display the count

    I am trying to add a button to a form. When the button is clicked the number 1 is displayed, clicked again 2 is displayed and so on. I need the displayed number to be able to be saved. The whole process start over at O (zero). I have looked all over the web and this site. Thanks mike
  4. mchester

    Dlookup in a form

    jrbarnett thanks for the help I have been trying since my last post this is what I finally got to work. =DLookUp("[CIMPROV<1200]","[CALCSTANDARD]","[CGRADE]=[GRADE]") I would never get through all this with out all of the help I get from this site. Tek-Tip and its members is my genie in the...
  5. mchester

    NEED TO TRANSPOSE A TABLE IN ACCESS

    When I used the sql it said * not in a crosstab query.
  6. mchester

    Dlookup in a form

    I used the funcion: =DLookUp("[CIMPROV<1200]","[CALCSTANDARD]","[GRADE]=" & [Form]!APPRAISERPRODUCTION!GRADE2) I change the name of the table calculatedstandard to the above table and change the function also. I still receive a #name error. My grade field is a number and a text box on my form...
  7. mchester

    Dlookup in a form

    I need to look up a record in a table called caculatedstandard and use a control in a form. I tried this dlookup statement: =DLookUp([CIMPROV<1200],[CACULATEDSTANDARD],[GRADE]=[Form]!APPRAISERPRODUCTION!GRADE2) I get a #name error thanks mike
  8. mchester

    NEED TO TRANSPOSE A TABLE IN ACCESS

    Here is my SQL TRANSFORM Var(INDIVPRODUCTION.DATE) AS VarOfDATE SELECT INDIVPRODUCTION.[IMPROV<1200] FROM INDIVPRODUCTION, PRODUCTIONMAIN GROUP BY INDIVPRODUCTION.[IMPROV<1200] PIVOT INDIVPRODUCTION.DATE; I need all the Improv fields not just the one. I needed a feild named Task with all the...
  9. mchester

    Add a label to the left side muliple column report

    I have a five column report. I to label the rows down the left side. When I do it access puts the label in every column. I need one label and five colums of rows. Thanks mike
  10. mchester

    NEED TO TRANSPOSE A TABLE IN ACCESS

    My table looks like this Appraiser,Date,Improv<1200,Improv>1200,Improv12001-400,..... The crosstab query I made,I used Date as my column headings and needed the Improv fields as my row headings. So dates across the top and the Improvement discriptions down the side for each appraiser...
  11. mchester

    NEED TO TRANSPOSE A TABLE IN ACCESS

    YES A CROSS TAB QUERY WONT WORK FOR WHAT I AM DOING, I NEED TO END UP WITH A REPORT FROM THE NEW TABLE. i TRIED A CROSS TAB AND THE RESULTS WERENT WHAT I WAS LOOKING FOR. THANKS FOR YOUR RESPONSE.
  12. mchester

    NEED TO TRANSPOSE A TABLE IN ACCESS

    MY TABEL NAME IS: INDIVPRODUCTION HAS 29 COLUMNS I HAVE VERY LIMITED KNOWLEDGE OF VB THANKS MIKE
  13. mchester

    Need a verticle header on a multiple column peport no crosstab

    My data in the tabe is not set up for using a cross tab report. I need to put a permanent Headear/Label on the left side of a 6 column report. I have searched the web for 2 days. I saw a code example of something called a "twipt"(maybe). The cross tab layout is wondrful but the 1st column of...
See more

Part and Inventory Search

Back
Top