Search results for query: *

Remou. I would like to try your GotoControl method, whatever that is you mean. i tried what you said and i get a different error message. "object does not support the property or method". i can still hit the next button but the error message appears again. ps-i guess when we figure this...

Aceman: the above method gives me an error message. Compile error, Expected: = the Me!C1%StdTarget.SetFocus turns RED. the words StdTarget are highlighted in Blue. What did I break??

Aceman. i did what you said. i believe. in the subform sfrmProfit781Detail, i did the following in the ON Current part: Private Sub Form_Current() 'locks the field Me!C1%StdTarget.SetFocus End Sub ========================= the field name on the subform to lock is Named C1%StdTarget and the...

Hi belovedcei. i added your code but i get an error message as follows: "Compile error. Member or data member not found." what did i do wrong? the Next Button in the main form now has: Private Sub Command247_Click() On Error GoTo Err_Command247_Click DoCmd.GoToRecord , , acNext...

I have an unusual request from someone. I have a main and subform. The last field in the subform record is the only piece of data needing change per subform record. It is the "Profit" field that is input. On the Main form topside, I have the usual "hands" navigation buttons for "next...

I tried that. when i try to make a Form using this crosstab Qry, using the wizard, I see NO fields to choose for the Form. None show. I just tried a simplier 2nd crosstab with a different Qry. I CAN see the fields in the Form wizard. so now i am thinking that my first qry has something...

i just tried your approach but the xtab fields do not show in the report wizard. i can't remove the popup and modal. the user demands it. the data involves an appointment Date field which i was hoping to make a crosstab for a user selected week by customer. so of like a poor man's calendar...

I have a form button on my frmJunction. The purpose is to run a crosstab Qry. The Qry runs fine but it is Minimized on the tray below. i think it has to do with my Forms all using "YES" for Popup and Modal. how can i get the results to be maximized?? Private Sub APPOINTMENTS_Click()...

i will make this latter question #2 as a new request. so consider this one filled. knucklehead

I used the PHV method. it works wonders. Thanks so much to you fellows. i will donate a 2nd time today. that solves Question #1. Do you have any way to fix my 2nd problem. when i am in my frmJunction, i hit a button that runs the Qry that you just fixed. my code is noted in an earlier...

Remou. I see from that old thread that i had a similar question a few months ago. I now added the Parameters deal. At first, this Xtab Qry date range deal appeared to work. i was asked the question of begin and end dates. but then i tried a different range and i got the same answer every...

the following sql is my crosstab query. TRANSFORM Count(QryJobDetail.CusLocID) AS CountOfCusLocID SELECT QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress FROM QryJobDetail WHERE (((QryJobDetail.JobStatus)="appt")) GROUP BY QryJobDetail.LocFullName...

You are outstanding as usual. it woiks moe. It works better than I desired. I get a blank subform record at the top. I make my entry. I then hit my Save button (i realize that a save button is not necessary). I then see my new record at the top (i have it descending date order) AS WELL AS...

I have a main form which has a button, noted below, that creates a new blank screen for Main form top section input. it works fine. Private Sub cmd_ADD_Junction_SHEET_Click() DoCmd.GoToRecord , , acNewRec End Sub But now, i want to ADD a button on the Tab page to create a new record in the...

Based on all I learned today, here is 2 alternative calculations which derives the same answer. I wonder which of the 2 methods you all prefer ?? Stage1: Val(IIf(nz([StagingMH3],0)=0,0,Round(Nz([BatchQty],0)*Nz([StagingMH3],0),2))) Stage2: IIf(Val([StagingMH3] & "")=0,0,Round(Nz...

I guess i will live with the latter calc: StdQtyAct: Val(Round(Nz([SellQtyAct],0)*Nz([SellUnitAct],0)*Nz([StdConvFactorAct],0),2)) Each Detail Qry1 32,000 records are perfect to the 2nd decimal. But the Qry2, which sums up Qry1, has 10 of the 12 category summed records Accurately to the 2nd...

Hold the presses. i added something to the PHV method and got the proper 9.38 answer. so it works now for the first query. i added the VAL statement to the PHV statement. StdQtyAct: Val(Round(Nz([SellQtyAct],0)*Nz([SellUnitAct],0)*Nz([StdConvFactorAct],0),2)) i am so happy. now my next...

Hi - just got back. thanks so much to all of you for this help. I just tried the method by PHV, my favorite fellow. but it still does not work. here is an example. the sellqryact is 250, sellUnitAct is 1 and sellConvfactor is .0375. they all get multiplied: 250*1*.0375 which should equal...

Jeff- yes i know about the properties thing. my concern is not how the query shows. i did not want the many decimals to hang around for other calculations. i just want 2 decimals. the properties thing does not get rid of decimals over 2 decimals. the properties only fix the display, as you...

Following duane's lead, I changed the first Qry to: StdQtyAct: Val(Round(nz([SellQtyAct],2)*(nz([SellUnitAct],2)*nz([StdConvFactorAct],2)),2)) i get an answer of 919774.150000001 so still something odd getting more than 2 decimals?