Search results for query: *

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

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

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

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!

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!

subStr([TABLENAME.Field], 6, 1) the above code will give me the first value on the right of a number with 6 digits, as in 123456 - the value I will get will be the number 6 therefore I am gettin the first digit on the right of a six digit number. Is there a way to get the formula to read from...

PDOX 9 I am trying to get the code below to print more than one copy of the Garnish1 report, unfortunately it only prints 1 copy. There seems to be no syntax errors, what I my missing? Thank you! method pushButton(var eventInfo Event) Var R Report Q Query S String poi PrinterOptionInfo...

I have a form (Dialog Box) called "Print" , can someone tell me how to close the form using the escape key? thank you

method changeValue(var eventInfo ValueEvent) DoDefault If Deductions.Value<>&quot;&quot;and Self.Value<>&quot;&quot; Then Taxable.Value=Self.Value-Deductions.Value Tax_Due.Value=Taxable.Value*.06 Percent.Value=Deductions.Value/Self.Value endif endMethod Above is a method that I use on a form...