I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

November Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Forms Topic

Including form usage, form coding issues, calculated fields, and the data model.
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Gary.L3
No Subject
53 months ago
Nothing New Since Your Last Visit
1064
Hits

Thread 24 of 25
Thread Starter  

Lothar.K
Corrupt Form... Now what?
Hello, I run Paradox 9 SP4 with Win 10. After some diagnostic errors that had me deeply concerned, I just discovered that problems I am having occur only when I try to modify a particular form. (Whew...) That form has nothing on it other than about a dozen buttons, and I have to occasionally tweak some of the button code. Starting earlier today, I found that whenever I clicked to save, or check syntax, for code on any of the buttons, Paradox would crash. Saving code on objects on other forms works just fine. So, that would seem to indicate that the form in question is somehow corrupted. I guess that I could create a new form, draw in those buttons, and cut & paste in their code. But is there a better approach to correcting the problem I am describing? Sincere thanks, Lothar
108 days ago
9 replies. Last post:

Lothar.K
Hi Steve, I had thought that the error might be spurious, but just discovered that it was not... In one of the Var-EndVar blocks, I had selectPrinter as a string. Removing that eliminated the error. As always, many thanks, Lothar
107 days ago
Nothing New Since Your Last Visit
189
Hits

Thread 23 of 25
Thread Starter  

rum
Application Control bar
Does anyone know which event(s) I would use to trap or capture a users mousclick on the applicaion menu. Specifically,  I want to know when the user clicks the X on the application window(not the open form).  I need to run some shutdown code before the active form starts the CLOSE event. Thanks Rum
4 months ago
2 replies. Last post:

Steven.G
add stuff to the CLOSE event on the form.. or, disable it completely with this on the MenuAction event on the form if eventinfo.id() = MenuControlClose then disabledefault return endif if you disable it completely, then they have to push your button, or select from your menu, etc
4 months ago
Nothing New Since Your Last Visit
126
Hits

Thread 22 of 25
Thread Starter  

Pete.D2
Editing on a form without keying F9
Is it possible not to have to press F9 to start editing fields on a form? The form I am working on ties the fields to a Paradox db table.
4 months ago
2 replies. Last post:

Pete.D
Wonderful. Thank you. TV.action(DataBeginEdit) works on Tableviews as well. Pete
4 months ago
Nothing New Since Your Last Visit
147
Hits

Thread 21 of 25
Thread Starter  

PeteD
Form opening a form and changing working directory
Is this tough to do? Presently we are launching forms from one form but then the orginal form closes. Also we are manually having to set the working directory for each form. Obviously we would like control to return to the menu after the launched form closes and the working directory set back to what it was before. I'm using Paradox 8.00.174.
7 months ago
13 replies. Last post:

Steven.G
no.. don't run paradox from within paradox
6 months ago
Nothing New Since Your Last Visit
296
Hits

Thread 20 of 25
Thread Starter  

Herbert Sitz
Possible to bind a blank form to a table?
I'm pretty new to Paradox, using Paradox 10., , I'm curious whether you have to use an expert to bind a form to table, or whether you can create a blank form and then modify the table property. , , The table property of a blank form has a little lock graphic by it, which I assume means it's locked or readonly. So is there any way to modify it? Or must I create a form with an expert?, , Oh, I also realize I can create the form using a Data Model and get a blank form bound to a table., , But what I'm curious about is whether I can change the data source in the properties menus directly. Seems like I should be able to. But I can't figure out how., , Thanks,, , Herb Sitz
16 years ago
Nothing New Since Your Last Visit
1266
Hits

Thread 19 of 25
Thread Starter  

KevinHart
CheckBox - How to suppress Return key
When using a CheckBox; Is there a way to suppress the Enter Key so it does not change the value? I tried using disabledefault in an IF checking for the FieldEnter action in the action method of the field but that stopped the cursor from moving to the next field but the Checkbox field value still changed.
12 years ago
Nothing New Since Your Last Visit
2015
Hits

Thread 18 of 25
Thread Starter  

gascottt
How do you declare a variable in Paradox SQL?
Hi,, , How do you declare a variable in Paradox SQL and how does the section look for example?
15 years ago
Nothing New Since Your Last Visit
1851
Hits

Thread 17 of 25
Thread Starter  

JFWconsult
Implementing a Reusable Progress Bar in Paradox
Mike, Re your "Implementing a Reusable Progress Bar in Paradox" form for download. I have downloaded it but am unable to open it. Paradox suggests that the form may be corrupt. Can you check please.
6 years ago
1 Reply:

mprestwood
Hi John, i downloaded the zip, extracted the file, and opened the form in design mode using Paradox 9. Worked just fine. Are you opening in design mode? Or, a later version of Paradox?
18 months ago
Nothing New Since Your Last Visit
1544
Hits

Thread 16 of 25
Thread Starter  

Allan.P
Form not saving
First time post here.  I have a form with a main table "contact", it works fine.  Has run fine for years. I recently added in another linked table "school", one to one.  I can make changes and edit, but none of the edits to any "school" fields will be saved.  Edits to the "contact" table are saved.  I have the same "contact" and "school" tables working on other forms just fine.  I have verified the tables as well. What do ya'll suggest I look at?
22 months ago
Nothing New Since Your Last Visit
644
Hits

Thread 15 of 25
Thread Starter  

Lynda.S
pick list and field info based on formula
{Too Long!}
23 months ago
18 replies. Last post:

stevecaple
{Too Long!}
23 months ago
Nothing New Since Your Last Visit
1342
Hits

Thread 14 of 25
Thread Starter  

Rabih.C
Customer-retail display screen communication
Hi. I wonder if anyone could help me write a code that allows control from Paradox onto the display screen that shows the price of the item entered throughyou. the bar code reader. Thank 
36 months ago
1 Reply:

mprestwood
Bar code readers are usually just keyboard wedges. Meaning, they emulate keyboard presses so no extra coding is needed. Let me know if you're doing something special; otherwise, no special coding needed.
36 months ago
Nothing New Since Your Last Visit
1531
Hits

Thread 13 of 25
Thread Starter  

Sam.S
Convert a V11 form back to 7.5????
Has anybody found a way to save a V11 form back to a version 7.5 form? I work in both platforms and inadvertantly saved something important as 11 that I need as 7.5. If anyone has an idea, I am all ears. Thanks
42 months ago
1 Reply:

Sam.S
I didn't have any luck converting back To 7.5 I ended up cutting and pasting from the v11 to an old copy of the v7.5, which worked ok. But, I had to copy each object separately. If I tried multiples, they would loose all the text labels.
42 months ago
Nothing New Since Your Last Visit
1154
Hits

Thread 12 of 25
Thread Starter  

Pat.S
Forgot how to change the time on TimeStamp field
Hi, Please any kind one tell me how to change the time on the time stamp field.  I forgot how to do it and could not find where in the system to read about it.  I need to change the time stamp field to coincide with the daylight saving time. Thank you kindly.
44 months ago
Nothing New Since Your Last Visit
980
Hits

Thread 11 of 25
Thread Starter  

Coder_182
Scroll Wheel Mouser Funtion in a form
I wonder if there is a function to operate the "scroll wheel" of the mouse in a form. In the design manner the scroll bar work's fine with the scroll wheel button. But when I run in the app. The scroll wheel of the mouse doesn't work. It's say I cant go to up or down using the scroll wheel.   Thanks in Advanced!
45 months ago
Nothing New Since Your Last Visit
856
Hits

Thread 10 of 25
Thread Starter  

Gary.L3
Paradox 8 Form file corrupted?
I use Paradox 8.00.302 I have a form that has been working fine for almost a year.  I periodically update the code, verify it's working, and then deliver it.  Last time I did this was on 1/10/2014.  This morning, I go to open the FSL version to look at the code, and I get the Error message, "Cannot interpret file. It could be corrupt."  The delivered form opens without a problem. I CANNOT lose this code.  Any help would be appreciated. Gary
46 months ago
2 replies. Last post:

Anonymous
Try making a copy of the file and give it a totally different name and see if that copy opens up properly. (Another) Dan --- Dan Ellingson
46 months ago
Nothing New Since Your Last Visit
3493
Hits

Thread 9 of 25
Thread Starter  

William.M2
Change Value
{Too Long!}
50 months ago
5 replies. Last post:

William.M2
Hello Dan, So sorry I did not explain the table naming convention.  The equipment inventory table is simply called equipment.db.  Then we have rentals.db and the customer is customer.db. Thank you once again and ever indebted to you for your help!  A true blessing thankyou! William
46 months ago
Nothing New Since Your Last Visit
1604
Hits

Thread 8 of 25
Thread Starter  

Cfolkes
Printer/font manager combination invalid
I am using 16bit Pdox 7, xp pro Sp2. I have been printing to an HP 750C Plus printer from my numerous Pdox applications for several years. Several days ago it started showing the error above whenever I try to print any report. The problem occurred overnight. It printed fine at 10 pm but the next morning it failed. Nothing was changed in the computer. I have done the following to try and correct the problem., 1. Removed and reinstalled the printer & driver., 2. Removed and reinstalled Pdox., 3. Created a simple application in PDox to test the printer., If I print from MS Word (or any other application) to the printer, it works just fine. When tne failure occurs, I exit Pdox and see a GP fault error. , I'm lost... I have no idea where to look for "Printer/Font Manager Combination Invalid"., Any suggestions?
10 years ago
4 replies. Last post:

Anonymous
--- Anonymous
49 months ago
Nothing New Since Your Last Visit
7584
Hits

Thread 7 of 25
Thread Starter  

joeroark
Creating User Logins
I am trying to create a User Login so certain fields in my inventory system can auto populate to save time.  I'm not sure where to start to accomplish this project.  Any help pointing my in the right direction is greatly appreciated! Thanks, Joe Roark
50 months ago
1 Reply:

Dan
Define in great detail what (not how) you want to accomplish with this user login.
50 months ago
Nothing New Since Your Last Visit
14508
Hits

Thread 6 of 25
Thread Starter  

William.M2
Multi Table Multi Record form
Greetings All, Sorry to bother everyone with what must be a super duper trivial question.  Our church mens group called k of c has a free medical equipment loan program.  I have been learning paradox here lately and building a database for the equipment we have and trying to keep track of the equipment as well.  I need some help. I have a customer/client table created. I have a inventory equipoment table created. Now what I need to build is a form that allows you to pick the client and then on the same form check out the equipment from the inventory table.  It needs to check in and out the equipment and then create a receipt.  This probably needs to be created in a seperate orders table. So sorry to bother you all but I dont know where to turn.  Thank you for any of your help William
50 months ago
1 Reply:

William.M2
After lots of playing and exploring, found out this was pretty simple.  The expert mode does make it pretty easy. William
50 months ago
Nothing New Since Your Last Visit
1288
Hits

Thread 5 of 25
Thread Starter  

Gary.L3
Custom method call in a calculated field
Can someone please help with this? In Corel Paradox 8, I have a custom method that returns a string that I want to display in the field value box.   However the only thing that displays is ERROR.   The help menus say that the method has to be in the "RSL runtime library." My method was attached at the form level.   Any help would be appreciated.
53 months ago
11 replies. Last post:

AIBreveleri
{Too Long!}
52 months ago
Nothing New Since Your Last Visit
2487
Hits

Thread 4 of 25
Thread Starter  

gcorvera
How can I use a Date variable in paradox SQL?
I'm trying to select records based on date; if I do the following it works Aux = "Citas"

dbTable =  ":Citas:" + Aux TempFile = ":Citas:##Temp" + Aux SQLVar = SQL SELECT * FROM ~dbTable WHERE

(FechaCita < '01/18/2013') endSQL

SQLVar.ExecuteSQL (PacData, TempFile) but if I try to use a variable for the date comparison it gives me an error (Type mismatch in expression):    FechaMaxS = "18/01/2013" SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < ~FechaMaxS ) endSQL I also tried the following but it gives the same error: SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < CAST(~FechaMaxS AS DATE) ) endSQL Could anyone tell me the correct syntax?  Thanks

58 months ago
2 replies. Last post:

Gonzalo.C
It still doesn't work. I tried:    FechaMaxD = Date(1, 18, 2013) SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < ~FechaMaxD ) endSQL And it still returns the same error
58 months ago
Nothing New Since Your Last Visit
2261
Hits

Thread 3 of 25
Thread Starter  

Greg MacKenzie
USING JOIN WITH executeQBE IN A FORM
{Too Long!}
5 years ago
6 replies. Last post:

SUBROMAN
Works! Thanks so much for the assist.
59 months ago
Nothing New Since Your Last Visit
2142
Hits

Thread 2 of 25
Thread Starter  

Sam.S
Auto email send from memo fields
I recently converted an app from 7.5 to paradox 11 and I am finding when entering Memo fields  with @ and . in them automatically do a mail.sendDLG() opening a new email message with the contents of the memo field as the TO: field. Does anyone know how to control this? Thanks
5 years ago
3 replies. Last post:

Sam.S
I think I have found a solution to the problem of paradox automatically trying to email when a field is selected that contains text "@" and a "." followed by text. In preferences, the general tab, there is a check box in the bottom right for "Disable Hyperlinks".  It is checked by default.  It seems like unchecking it resolves the objectional behavior.
5 years ago
Nothing New Since Your Last Visit
4599
Hits

Thread 1 of 25
Thread Starter  

Sam.S
Problem using Readprofilestring in calculated fld
{Too Long!}
5 years ago
Nothing New Since Your Last Visit
1573
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,264 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2017 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech