Search results

Thanks, Drew. I finally worked through it last night. If you would like a copy of the code and to see how I did it I will be glad to forward it to you and provide answers to your questions. Believe me, my struggle was greatly simplified by the input of you and a couple of others. Fred

I think there a two questions you have here. Am I manipulating the data elsewhere? This is the command that creates rstDewPoint. I don't change it anywhere, but I do refer to it frequently in various parts of the code. Set RstDewPoint = WorkDB.OpenRecordset("SELECT * FROM qryFindDewPoint " & _...

Drew, I saw some mis-thinking I had done and noticed I told you something in error. The dpDegree is a String used to determine which field value to use. That part I corrected, however, I NEED to process the recordset in the order that I originally sorted them. The following gets the correct...

Having an ARRAY problem and data mismatch - one may be causing the other. This is my first venture into dealing with an array so I may have misinterpreted something in the things I've read. My goal is simple (I think). I have a query that contains all the info I need to produce some...

Actually, I did just the oppisite. I created the SQL first and that's how I got the proper syntax for the recordset. However, when I run the VB code I would like to do something that is the equivalent of Debug. Print to view the results as the code runs. The reason I think there may be a problem...

I use the following code to define a recordset: Set RstDewPoint = WorkDB.OpenRecordset("SELECT * FROM qryFindDewPoint ORDER BY [Zero Deg Point]", dbOpenDynaset) I am not getting any errors. However, after looking for a way to open the recordset so I can view the records within, I am still at a...

Hi, I am reviewing the following code and the last four lines of code are confusing to me. C(GasWork - 2) = C(GasWork - 2) + GasConc If LowestDew(GasWork - 2) > DewPointNum Then LowestDew(GasWork - 2) = DewPointNum End If If the Main Gas Symbol is "C6H14", "x" would equal "C6H" and Gas Work...

I'm reviewing some code by another programmer (again) and am trying to make sense of his intentions. Could someone tell me what this may mean? PressureTable.Move Record - 1 I am assuming it means go back one record. But surely he knew that he was already at the 1st record? Here's the source...

OK. I studied a bit more and have some more insight. Now I realize that he is passing the Boolean FALSE to the SUB. I follow the SUB and here's a section of code that doesn't make senseby passing FALSE to it: ' Get the form's mixture id number If fIsTable Then MixtureId =...

OK. I acknowledge that it's not a Function, but a Sub. Still, by using FindDewPoint FALSE what is the programmer saying? Does he want to run the Sub? Is he required to pass either a TRUE or FALSE parameter? Does it matter which parameter is passed since if the Sub runs it will create it's own...

Hi, I have a question involving a function that exists in a Module. (I am reviewing someone elses program) The Function is quite lengthy, but begins like such. ***************************** Sub FindDewPoint(fIsTable As Boolean) ***************************** Now, inside the form is the following...

Actually I got the answer from the MS newsgroup. Fields in Page Headers cannot grow because the Page header cannot grow. I moved it to the Report Header and all is fine. Thanks

Report is in a letter-like format. There is a memo field in the page header with the CAN GROW set to YES. There are several labels below this memo field - also in the page header. When the memo field contains more than 4 lines it overwrites the labels below. I was thinking that it should "push"...

I am at a loss for why the result of my control still ends up showing #Name. The subform works and the total is displayed. The field name for the total is [TotalConcPct]. On the Main form I entered into the text box controlsource: =[Component Gas subform].[Form]![TotalConcPct] The subform...

Yea, I know, why is it a text field in the first place? I didn't do it, but I must try to fix it. Here it is: A field (let's call it Weight %) is set to a TEXT type fields and allows the user to enter a value that could have as many as 4 decimal places. This value is entered into a subform of a...