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

May 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  

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.
30 days ago
13 replies. Last post:

Steven.G
no.. don't run paradox from within paradox
9 days ago
Nothing New Since Your Last Visit
108
Hits

Thread 24 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
1119
Hits

Thread 23 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
1860
Hits

Thread 22 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
1705
Hits

Thread 21 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?
12 months ago
Nothing New Since Your Last Visit
1544
Hits

Thread 20 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?
16 months ago
Nothing New Since Your Last Visit
529
Hits

Thread 19 of 25
Thread Starter  

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

stevecaple
{Too Long!}
17 months ago
Nothing New Since Your Last Visit
975
Hits

Thread 18 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 
30 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.
30 months ago
Nothing New Since Your Last Visit
1315
Hits

Thread 17 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
36 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.
36 months ago
Nothing New Since Your Last Visit
1029
Hits

Thread 16 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.
38 months ago
Nothing New Since Your Last Visit
855
Hits

Thread 15 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!
39 months ago
Nothing New Since Your Last Visit
740
Hits

Thread 14 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
40 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
40 months ago
Nothing New Since Your Last Visit
3382
Hits

Thread 13 of 25
Thread Starter  

William.M2
Change Value
{Too Long!}
44 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
40 months ago
Nothing New Since Your Last Visit
1438
Hits

Thread 12 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
43 months ago
Nothing New Since Your Last Visit
7343
Hits

Thread 11 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
44 months ago
1 Reply:

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

Thread 10 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
44 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
44 months ago
Nothing New Since Your Last Visit
1171
Hits

Thread 9 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.
47 months ago
11 replies. Last post:

AIBreveleri
{Too Long!}
46 months ago
Nothing New Since Your Last Visit
2235
Hits

Thread 8 of 25
Thread Starter  

Gary.L3
No Subject
47 months ago
Nothing New Since Your Last Visit
907
Hits

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

52 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
52 months ago
Nothing New Since Your Last Visit
2042
Hits

Thread 6 of 25
Thread Starter  

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

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

Thread 5 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.
56 months ago
Nothing New Since Your Last Visit
4438
Hits

Thread 4 of 25
Thread Starter  

Sam.S
Problem using Readprofilestring in calculated fld
{Too Long!}
56 months ago
Nothing New Since Your Last Visit
1463
Hits

Thread 3 of 25
Thread Starter  

Caosity
Custom Lookup Dialog Box
{Too Long!}
58 months ago
Nothing New Since Your Last Visit
1663
Hits

Thread 2 of 25
Thread Starter  

davidc
Code in a Form question
I've done a good bit of ObjectPAL programming and quite a bit of work on Forms - but I've never mixed the two! The database (myData.db) I'm working with has this structure: mdPerson (A8); mdEvent (A4); mdYear (SmallInt); mdMonth (SmallInt) I have a form based on that database which is primarily a crosstab of mdMonth (column) by mdEvent (row) with the content of the cells being Count(myData.mdPerson) [Thus it gives me a count of how many of each event type occurred in each month.] What I have been doing is manually setting a Filter (from the Format menu) something like mdYear > 1999 What I would like to have is a form where I can do that in the form itself. So I've added to the form these fields: myYear (SmallInt);  myFilter (Radio Button: "No Filter", "Year Only", "> Year", and "< Year")  So I think I would use the PushButton method on the Radio Buttons, but how do I reference the value in myYear and how would I set the Filter on myData? Thanks!!!
59 months ago
3 replies. Last post:

Dan
The ValueChanged method does not occur until you depart from the field.  Try the mouseClick event.
58 months ago
Nothing New Since Your Last Visit
2531
Hits

Thread 1 of 25
Thread Starter  

ansuiya.s
Forms Jumping for user
HI Guys, I am pretty new to programming as such. Recently I undertook a project where I had to change the current forms to show an edit form before records get posted to the server table for good. However, one of the users is complaining that when he tries to enter data, the form seems to jump such that the line he was editing is not the line he should be.  Of all the users he seems to be the only one having this problem.  One other has said that it happens to her sometimes. I have looked at all the code, stripped all the unwanted code and cannot seem to see any reason why the form would be jumping for only one user. Can you help..it'll be well appreciated. Many Thanks, Ansuiya
59 months ago
Nothing New Since Your Last Visit
1562
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!

1,764 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