Thank you Sami and David The problem was vJambDate = .vJambDate Instead of vJambDate = JambDate in the forms vars I have been looking at this for 1.5 days. Sometimes it the simple problems that give us the most problems
On 18 Feb 2005 at 11:32, Victor Timmons wrote: > There are NO popups on the from. unless there is something under something > else > > > On 18 Feb 2005 at 12:44, Sami Aaron wrote: > > > Victor - > > > > The missing global variable could also be used in a WHERE clause in a > > pop-up. > > > > Sami > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Sami Aaron > > Software Management Specialists > > 913-915-1971 > > [EMAIL PROTECTED] > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Victor > > Timmons > > Sent: Friday, February 18, 2005 12:29 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: -Error- 2161 > > > > Thank you David. This form has no list box, or combo boxes. This is also > a > > 6.5++ for windows database. I will look at everthing else on the form. > > > > On 18 Feb 2005 at 12:27, David M. Blocker wrote: > > > > > Victor > > > > > > There could be an error in one of the controls, such as a list box or > > combo > > > box with a WHERE clause. Do all the controls on the form work > > correctly? > > > For starters, look for one that ISN'T and then look at its properties > > > > > > David Blocker > > > [EMAIL PROTECTED] > > > 781-784-1919 > > > Fax: 781-784-1860 > > > Cell: 339-206-0261 > > > ----- Original Message ----- > > > From: "Victor Timmons" <[EMAIL PROTECTED]> > > > To: "RBASE-L Mailing List" <[email protected]> > > > Sent: Friday, February 18, 2005 12:51 PM > > > Subject: [RBASE-L] - -Error- 2161 > > > > > > > > > > I get an error that reads > > > > > > > > -ERROR- Unrecongnized Global Variable in Expression. [2161] > > > > > > > > All I have to do to get this error is to open the form and save it, > no > > > > changes. > > > > > > > > EDIT USING WorkOrderPick4 + > > > > WHERE EstimateNumber IN + > > > > (SELECT EstimateNumber FROM EstimateHeader WHERE OrderShipped <> > > 'S') + > > > > ORDER BY BoFlag ,ShippingDate,EstimateNumber,ShippingID NOHEADER > > > > > > > > IF I run the same form from the R> and use the same code it runs > just > > > > fine. If I go back to backup of the form and run it from the RMD > file > > it > > > > runs just fine. If I open the form in design mode and save with no > > changes > > > > being done to it. I get the error. > > > > > > > > I have tried to reload the database it reload just fine with no > > errors. I > > > > see no errors in the Expression List for the form. Not sure what > else > > I > > > > should be looking for. > > > > > > > > Thanks for the Help > > > > > > > > > > > > > > > > > > > > > > > > Victor Timmons > > > > Tiz's Door Sales, Inc > > > > 425-258-2391 > > > > > > > > --- RBASE-L > > > > ================================================ > > > > TO POST A MESSAGE TO ALL MEMBERS: > > > > Send a plain text email to [email protected] > > > > > > > > (Don't use any of these words as your Subject: > > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > > ================================================ > > > > TO SEE MESSAGE POSTING GUIDELINES: > > > > Send a plain text email to [email protected] > > > > In the message SUBJECT, put just one word: INTRO > > > > ================================================ > > > > TO UNSUBSCRIBE: > > > > Send a plain text email to [email protected] > > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > > ================================================ > > > > TO SEARCH ARCHIVES: > > > > Send a plain text email to [email protected] > > > > In the message SUBJECT, put just one word: SEARCH-n > > > > (where n is the number of days). In the message body, > > > > place any > > > > text to search for. > > > > ================================================ > > > > > > > > > > > > > > > > > > > > > > Victor Timmons > > Tiz's Door Sales, Inc > > 425-258-2391 > > > > > > > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
