Search results

I have 8 different crosstab queries showing the sum of the "total" from the quert from which they were made. I then made one Query combining the 8 crosstabs into one query. I made a report of the Combined query. With a text box in the report footer showing the sum. All the calcs work fine unless...

Thanks, finally got it to work, I tried a 1 as well earlier, but no luck. I got rid of the combo box from the form, and used the lookup in the table properties for the drop-down list. And I based my form directly on the table, not a query of the table as I tried previously Thank-You very much...

Thanks Paul, you were right. So I created a new test table, and form with combo box, I no longer get errors, but the price is not showing in the Price field. The Combo box is called Combo6, having two columns: Item,Price. The Table has three field: ID, Item, Price. The form has the same as the...

Hi, I tried what you suggested. My combo box is named: Combo23, My Cost field is called: RentalFees, So in the afterupdate of the event section of the combo23 properties, I typed: Me.RentalFees = Me.Combo23.Column(1) I get an error as it cannot find the object Me. I attached an image of the...

In my table, which is used to produce cost estimates. The two fields that I'm concerned with are: [Item], [Cost]. I have a combo box for [Item] which get the data from another table called "inventory" having two columns, Item, Cost. Using a form based on the table, When making a selection from...

Your a Genius. I just changed it so it would preview the report. Works great. This sure saved me a lot of time from having to build a report from scratch off a new query, then try to figure out the calculations I need. Thanks ever so much! Can I add you to my friends list? Phil Killdozer

Hi again, I was able to get my report to reopen from my form, the one part of the script that I;m not sure about is: strCriteria = "[FieldInYourReportThatYouWantToFilterBy]= " & Me!controlWithSelectedItemToFilter I changed it to: strCriteria = "[TrialNO]= " & Me!TrialNO I renamed the field...

Re: Print Report Showing Current form info Ok, I will make a query wilth the calculations I can, and do a report from that. The db I messed up was my backup copy on my mem stick. My good copy is on my work computer. I will try to shrink my db down enought to attach to the forum. I will be...

What I have is a main form with just a few fields, like the [trial No], [Trial name], ect. This is shown in the Form view. Then I have four other forms inserted into the main form as subforms, these subforms show their data in the data sheet view, all are linked by the [Trial No] which is the...

My report is based on my form, basically I justed saved my form as a report. My form is based on 4 seperate queries. I did try placing the info in the criteria of the querry which makes up the main form in the [trial file no] field. The rest are sub forms, I then opened the form then the report...

Thanks Wiklendt I tried to get it to work today, using various ways and locations for the script. So for the button, are you referring to a command button on my form to open the report in print preview? I tried putting the command in the prosperities of the report so when it opens it would...

OK thanks, sounds complicated though, as I don't have any visual basic skils. Not sure how to bring up the "DoCMD". Is there a way under properities of the report under data source or someething like that to link my primary key from form to my report. or can I write a macro that would do the...

Hi, I created a report from a form with 3 subforms. The report works fine, but how to I get it print with the current infomation or current record that is showing on the form, beside forwarding to the next record once in the report. Not sure I explain this correctly, basically when I open the...

Thanks alot Paul, I think I got it, I will continue tomorrow Phil

That was it, it now works. So my next questions is, this form will be one of 3 subforms on the main Form. So on the main form, can I put in a calculation to total all the subforms totals.

Thanks pbaldy, that works, if I only had those two fields, but my actual calculation on my textbox is: =([Todate]-[Fromdate]+1)*[Rental Fees]*[Quanity] I tried this expression: =sum(([Todate]-[Fromdate]+1)*[Rental Fees]*[Quanity]) The problem is with the date calculation, as I tried that alone...

Sorry Lagbolt, for not making myself clear, and for taking so long to get back to you. But my problem is to get the sum from my text box with the calculation expression. For ex if textbox1=[Qty]*[Price], and I have several line items. I want to use another textbox to show the sum of texbox1...

My form has several text boxes with calculations, they work fine, but how do I calculate the total or sum of all my text boxes? Killdozer:(

Yes it shows in a subform, I will try what you said, and let you know how it works. Just to clarify to I type: MySubform, or the actual name of my subform Thanks

Yes that works, how ever I noticed that I had to close the form and reopen or else I would get the same results regardless of the search word. Thanks a bunch Killdozer