Glad you found it , Victor! 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 2:56 PM Subject: [RBASE-L] - Re: -Error- 2161
> 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 > > --- 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. ================================================
