Search results

Thanks moke123, it worked perfectly! was driving me crazy, thx for ending my misery!

Hello all, I am trying to set focus to a specific field on my form every time that this particular tab is selected. I have tried putting the following code into the 'on click' event of that tab. Me.TabSalesOrders.Pages("SALES ORDER")!SearchSoNumber.SetFocus TabSalesOrders is the name of my...

Hello all, I am trying to set focus to a specific field on my form every time that this particular tab is selected. I have tried putting the following code into the 'on click' event of that tab. Me.TabSalesOrders.Pages("SALES ORDER")!SearchSoNumber.SetFocus TabSalesOrders is the name...

Hello, I am having trouble figuring out how to make a msgbox come up if my filter contains no records. I have the following code on the afterupdate event of a combobox that searches my forms recordset by customer name: Me.Filter = "[tblSalesOrders.Acct]=" &...

thanks ranman, however would you possibly be more specific in how to incorporate that into my vba? DoCmd.OpenForm "frmStandardCostNewer", acNormal, , "[ProductNum]='" & Me![ProductNum] & "'" thanks, BJF

Hello, I am wondering if anyone can help me out in opening up a form to a specific tab through vba. Ive got a form with a product field. When i double click that field, it opens up another form with product details. I use the following code on the field: Private Sub...

Thanks for the response AccessBlaster but I figured out that in order to get what I needed I just had to create another report with the information that I wanted and then add that report as a subreport to my main report design.

Hello, I don't understand how to get information from more than 1 record in my subform onto my report. I am using a report format to print out a packing list. The report draws information from a form and a subform. If the subform has 1 record only, then I get the information i need. How do i...

Hi, I haven't done an update query in quite some time and forgot how to do the following: Please see the attached snapshot of my query: The table on the left side (tblSalesOrdersDetails) has the field named 'LabelSaved' which contains numbers only(they are LabelId numbers from the...

Hello, I'm having a problem with my report that i print based on my form. Please help. I have a form with a subform. Based on the info entered into the form i designed a report to print out the info. The problem is that if I do not enter any info into the subform portion of the form, the...

Hi, I think I am having trouble with the syntax in my update query. Will someone please advise where I am making the error? I am trying to reference a form field and i need to reference a number that is in column 2 of that field. (the field is a combobox) The 'update to' field in my update...

Hi Paul- The if statement works however the code doesn't function as I need it to. Can you help me understand why? as I told you in an earlier post, I've got a controlled test set up with only three records. R001 R002 and R003 are my three records with R003 being a composite of the costs of...

Paul I replied but dont see it here so here it goes again... Thanks so much for all your help, I have to try the code in the morning becuase im away from my desk now, Im still familiarizing myself with addressing the query thru vba code as youve shown me Ill get back to you, thanks very much...

Hi Paul, thanks for all your help I think this may be what im looking for but im away from my desk until tomorrow I wll apply the code in the morning and get back to you Im still familiarizing myself with addressing the query in code as youve shown me. makes sense much more now. Thanks again BJF

also after putting the code in as you suggested, it did not change the records until I closed and reopened the form but thats OK for now. I just want to change all the data on records based on the condition if blendcheck = true I'm not sure where to put this condition.

Hi Paul, Thanks for all the replies. I think I understand what you are saying, but I did get the desired result after changing my original code to what you added rsQuery.Edit rsQuery!ResinCostWithFreight = Nz((R1.Column(2) * (PercentR1)), 0) + Nz((R2.Column(2) * (PercentR2)), 0) rsQuery.Update...

I'm not sure what the difference would be, isnt my form based on the recordset? I think i understand where you are getting confused with what i am doing: To clarify hopefully!.... The form will be used to input Resin data along with pricing Some records(Blends) will be conglomerates of other...

Paul, thanks so much for enlightening me to this: I understand what i need to do now and got some functionality going but how do I make the update conditional? I changed the code so far to: rsQuery.Edit rsQuery!ResinCostWithFreight = Nz((R1.Column(2) * (PercentR1)), 0) + Nz((R2.Column(2) *...

I'm definitely confused now- I sort of understand. I thought i needed to update my records through my form because the functionality i want to perform on all records as a global update is the same functionality that i can perform on any single record while in the form. Are you telling me that...

Paul thanks very much, that worked for me, however what i am trying to actually do is not working: i am needing to call an event which does some math and it doesnt seem to be happening: rsQuery.Edit Call CalculateStdCost_Click rsQuery.Update is there other syntax i need to use to use the...