Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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