Search results for query: *

Tried a different variation but your posting really helped. Thank you

I have a table that I have to export as a text file. One of the fields in the table is the account field. Some of the records display as 22 256 7894. The problem is that when I export the table the account value has to show as 222567894,no spaces. I can export the table just fine, but is there...

The following code work great, the QTRTAXES table which is in the working directory has an additional number added to the "Code" field. I recently copied the QTRTAXES table to a directory called :SU2003: and created an alias called SU2003. I want to be able to use the same method and...

Thanks for getting back to me. I managed to do a workaround to my problem. I created an undefined field in the form (newfield) and made the value, Var1, which is the longint return to that field. Then I formated the field so that it would have a leading zero using properites format. Finally I...

I created a library to pass 2 variables to a form. Var1 is an LongInt field and Var2 is a currency field. When I return the values to the form, I return the Var1 to an alpanumeric field called description. Var1 was originally formated to display 05532 but when it returns to the description field...

The following code which I have on a form works just fine. It draws information from a library and on Service Fee field I get the balance due for the previous invoice and on the description flied I get Balance on Invoice Number 05892. My problem come when I move to the next record and do the...

I have a form with Field1 and Field2. Is there a way that with a pushbutton I can store the value of field1 and the value of field2 in a library, and the with the push of another button get them to dispay in another field. Some sample code would really help. Thanks All

I have a billing form, Form(1) with a table on it. Can open another form, Form(2) with a fee table that has the service description of the service in one field and the fee of the service in another field, click a button on Form(2) and have the service description put on Form(1) service...

just changed to pdox10 from pdox9 and also changed to xp proffesional from win98. on the forms that I originally created on pdox9 there is a button that would print a report. this now works with pdox10 but after printing the report the printer prints a blank page. what strikes me as odd is that...

Try the newvalue method if Part.isBlank() then Name.font.color = Red else Name.Font.color = Blue endif endMethod hope this helps

Hope this works or at least points you in the right dirrection. method pushButton(var eventInfo Event) dodefault ContractNo.moveto() MenuAction(MenuFieldFilter) endMethod

I saved a data model file with 3 linked tables called Tax99.dm and I use it for my Tax form. In PDOX10 when the form is in the design mode I select from the menu Format Data Model, I then select Data Models, when I double click on the saved DM file it removes the existing file and then loads...

i have a form with a data model of 3 tables saved as taxes.dm can i have a button on the form that will change the data model to taxes1.dm? all my tables have aliases so they will work with the same form thanks all

I created a form with code. "Sales Tax" There are 3 tables on the form. A Data Model of Customer, Qtrtax, Taxitem. We entered the records for 2001 for all of our customers. Now I would like to enter records for 2002 in different tables. The customer table is always the same. Can I...

Wish I could tell you more "expression invalid in a calculated field" is what I get when I create a calculated field on a report where I want the currency as text. This works just fine on a form for me but I cannot do it on a report. getcurrencyastext(Number([CHECKS.Amount])) Does...

I can get a calculated field on a form to convert currency to text, simply by working with the experts and then creating the calculated field. I have tried to do the same on a report using the same steps with no success. I get the message "expression invalid in a calculated field". Can...

I can get a calculated field on a form to convert currency to text, simply by working with the experts and then creating the calculated field. I have tried to do the same on a report using the same steps with no success. I get the message "expression invalid in a calculated field". Can...

I have a report and I wish to have a graphic field that depending on the Month of the year , as in, December a Graphic field would display the desired graphic from a graphic table that I have, if the month is January another graphic from the same table will display on the same field. My table...

PDOX9 on a form I have a code such as if self.value = Active then TextBox.color = blue this works just fine, however when I want to use a custom color I use if self.value = Active then TextBox.color = "79,169,255" which happens to be the color when I go to the object explorer and...

I have a field on a report "CompanyName", the name of the company may be A & B, Inc. Is there a way that I can get this to show on my report as ABIN displaying the first 4 characters, no commas dashes or periods. PDOX9 WIN Thanks All!