Search results

Hi Fi & Rich, Thanks for both your help -- you guided me to the answer. The final working syntax to display the cost is: =[orderDetails].[Form]![OrderSubtotal]+([FreightCharge]+[PriceAdjustment]) One last question is, what is the command for setting this value to the main form's value...

Hi Fi, Thanks for the assistance, but I'm still getting an #Error The actual addition I want to do is in the [Orders3] form and I want to add: Sum([Price]) - from subform [OrderDetails] [FreightCharge]- from the same form [Orders3] [PriceAdjustment] - from the same form and have all those...

Harry, Worked great - thanks ever so much! Jon

Hello, I have a report that has a informal greeting in the header and in the 'detail' section of the report is the repeating list of items ordered. I was wanting these items to print out alphabetically sorted from the value [seriesTitle]. What is the best way to do this? Is there any easy...

Hi Jack, Thanks for the links. I've been reading over them, but I am having a problem getting started. I'm still having difficulty getting the syntax correct. I'm a beginner at this and I'm having problems even getting started with the subtotaler. If you could help me get started, I think I...

Hello, I'm trying to create a form that contains a subform to create the subtotal, shipping, and total cost in the main form. Could anybody direct me on how to do this - I keep getting #error! My values should be: Subtotal should be =Sum([price]) from the subform OrderDetails Total should...

DBL - Thanks very much -- both solutions worked beautifully! Jon

Thanks for those keywords -- I didn't know exactly where to start! Anyway, I did get the subforms, but it doesn't automatically update the address fields. I have to click forward and then back on the record to see the update Is there some script I can perform to: onUpdate of the CustomerID...

Hi Rich, Wow! Thanks for your prompt response. Sorry about the poor description. The value for [Sum of PaidInFull] is a true or false statement like a checkbox. The [Sum of Sampler1] value is actually a yes/no statement -- or a checkbox. I hope that clarifies things. I also realized...

Hello, I have an order form with a subform with order details. The orderform allows you to select the customer's name and then input all the order details in the subform. I would like to create fields that once I select the Customer's Name, it plugs all customer's query information into...

I modified it just slightly and it works beautifully! The final code was: ="Dear " & IIf(IsNull([NickName]),Trim(Left([CustomerName],InStr(1,[CustomerName]," ")-1)),[NickName]) & "," Thanks again for all your help -- I really appreciate it!

Hi Rich, Thanks for your input. I tried the coding you gave me, but it claims it has too many closing parenthsis. When I attempt to fix that it I get another syntax error for not putting text in quotes -- hmmm... I'm really bad at debugging -- could you take another look at it? Thanks in...

Hi Jack, I apologize for the extremely long delay in responding -- I've had my hands full with an unfortunate hard drive crash! Anyway ... Thanks for the recommendation on the FindAndReplace -- it work beautifully! I will certainly be purchasing that shareware software right away! Also the...

Hi DB, Thanks for your help. The sample code you gave me works well! Is there a simple code to cut just the first word of the name into the [name] slot. So it would be: ="Dear " & Iif (IsNull([Nickname]), [justTheFirstName], [Nickname])) Unfortunately, I've made some early bad mistakes on...

Hello, I was wanting to write a personalized report letter using customer data. I was wanting to do a header like: "Dear Joe," I have the entire customer name in one field and a seperate nickname field. So I would need a command that goes something like: write "dear" & IF [nickName] is...

I think I just found the answer .. it was not the Report Footer, but a ShipDateFooter than had an invisible entry in it that kept me printing an extra sheet of paper. Thanks for all your help on this matter DB! It is greatly appreciated!

Things are working great ... except it keeps on wanting to print an extra page at the end of the report. Ah.. sorry for flooding you with messages. For some reason my report insists on printing a seperate page at the end of the report. I thought perhaps it was some overlap outside the...

Actually right after I posted that message, I tried the command acPrint which does print automatically. Is there a way to assign a quickey to the button though? Thanks again!

GREAT! Its works great! Thanks for all your assistance. Is there a way to make the report print automatically instead of just a print preview? I also noticed the Northwind database had a quick key assigned to the button -- is this a simple task? Thanks again for all your prompt help!

Thanks for your fast response! It seems like it should work, but I'm getting an error: COMPILE ERROR: ARGUMENT NOT OPTIONAL I'm not sure what I'm doing wrong! My modified code from your suggestion is: Private Sub printReport_Click() DoCmd.OpenReport , "shipping_sheet_printout", acPreview...