Search results

Thanks for the help, I will try it that way.

OK, this is driving me nuts. I have a simple function I want to call from a VBA module. Below is the code: Public Sub CGDTest() Dim LowPct As Double, LowDeduct As Double LowPct = 15.9 LowDeduct = CalcLowDeduct(LowPct) End Sub Function CalcLowDeduct(LowPct As Double) LowDeduct...

I think I have these errors fixed. I ended up deleting and rebuilding the combo and text boxes for Product ID and Unit Price respectively. I think most of my errors have to do with the fact that I'm tweaking a template someone else built, not to mention my skill level at the beginner level...

That column reference starting at 0 rather than 1 doesn't make sense to me, but I supposed mine is not to question Microsoft! Thanks for letting me know about that.

Thanks Bob, sorry to be so daft, but is number of columns the same as ColumnCount? I already have that set correctly.

I checked on the RowSource query that drives the ProductID combo box. The query is as follows: SELECT DISTINCTROW Products.ProductID, Products.ProductName, Products.PackageSize, Products.WeightLbs, Products.DealerUnitCost, Products.UnitPrice, Products.InStock FROM Products ORDER BY ProductID...

OK, now I'm getting an error saying, "You can't assign a value to this object" after changing the statement to Me.UnitPrice = Me.ProductID.Column(6). The ControlSource property shows UnitPrice, which is the name of the text box. Does this need to be changed?

This is a dumb question, but how would I reference the rowsource of the combo since it's a select query? Also, the UnitPrice text box doesn't have a rowsource property. I can't get my head around this apparently . . .

Thanks so much, I'll give it a go!

I've uploaded a database which is giving me trouble. It was a template someone downloaded and asked me to tweak. The form named Order Details Subform has a combo box control named ProductID. (I would have named it cboProductID, but oh well . . . ) Anyhoo, when I run the main form or the...

OK, thanks, I'll try that.

Does it make a difference if my code is a procedure rather than a function? Thanks for the code.

Never mind, I figured it out.

OK, so I added another filter to the reporting sub: DoCmd.OpenReport ("AllSamplesReport"), acViewPreview, , "[pvmt_analysis_section_id] = " & Me.cboSectionNo " and [pvmt_sample_nmbr] = " & Me.cboSampleNo pvmt_analysis_section_id and pvmt_sample_nmbr are integers. I keep getting syntax...

That did it, thanks so much!

I have the following procedure to filter a report. Private Sub cmdCreateReport_Click() ' The section and sample numbers were chosen by the combo boxes DoCmd.OpenReport "SampleReport", acViewPreview, , [pvmt_analysis_section_id] = '& Me.cboSectionNo &' " End Sub The variable...

DCrake, that was it! The " & j & " was the last missing piece of my puzzle. I didn't find any explanation of that where I searched, so this is good info to have. I appreciate this so much!! Thanks to everyone for your input and helping me solve this.

Thanks, DCrake, I'll give that a try.

How do you run a VBA module from a macro? I tried the OpenModule action, but all it did was to open the module. I had thought this would run it since OpenQuery runs the query, not just opens it. Any help would be appreciated.

It's frustrating to me that this should be a simple task. I can do this task in Visual FoxPro in my sleep. Thanks for your help.