Search results

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...

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...

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...

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"...

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...