PrestwoodBoards: www.PrestwoodBoards.com

www.prestwoodboards.com

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  

EnigmaVariation
Error Msg : error occured when setting ..proerty
{Too Long!}
11/12/2020
3 replies. Last post:

Steven.G
let me see if I understand the context, first.. you're using a form to display a lookup table, instead of using the built-in lookup help, and move to the appropriate lookup record, as you move thru the main table.. yes?
11/13/2020
Nothing New Since Your Last Visit
40
Hits

Thread 24 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
1/8/2012
Nothing New Since Your Last Visit
5172
Hits

Thread 23 of 25
Thread Starter  

PS_3060
Setting Upper Case in a search field
I have a search firld on a form which works fine except I need to change all characters to upper case. This is the code. It used to work but something has changed. var, pn string, endvar doDefault pn = self.value, pn = pn.upper() PTMPTNO.setRange( pn, pn+"z" ) Cheers
10/4/2020
10 replies. Last post:

Steven.G
ok, an undefined field.. first, that little bit of code should work.. but second, you can still use real fields from dummy tables, in situations liek this, if pictures, lookup tables, etc. can help
10/9/2020
Nothing New Since Your Last Visit
65
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.
7/11/2017
Nothing New Since Your Last Visit
967
Hits

Thread 21 of 25
Thread Starter  

GaryG
Print form without user interaction
I would like to print the current form from a button. This can be done in objectPal by performing postaction(DataPrint) or action(DataPrint) When the postaction(or action) is performed, the printer dialog box pops up. I would like to perform this print action without the user having to click the Print button on the printer dialog box. I have tried using sendKeys with different options. Do you know of a way to print a form without any further using interaction other than clicking the button I have added on the form? Thanks
9/16/2020
1 Reply:

Steven.G
action(DataPrint) is the app equivalent for "File/Print" or hitting Ctrl-P I'm pretty sure there's a "current record capture" option buried in there somewhere, but can't think of it offhand
9/18/2020
Nothing New Since Your Last Visit
51
Hits

Thread 20 of 25
Thread Starter  

Ash.B2
Hiding the desktop
I read a short article that says in order to not see the desktop, and only my forms, I need to use app.hide() The problem is that when I try it, I get syntax errors.  I've searched through the boards and through the ObjectPal guide that I have, but I have not been able to find out exactly how to do this (what code and where) I also cannot seem to find where in the Object Explorer it is indicated whether a form is a child or a dialog.  I know this seems simple, but its very frustrating.  Thank you for your help.
1/20/2020
Nothing New Since Your Last Visit
165
Hits

Thread 19 of 25
Thread Starter  

GaryG
printerSetCurrent is hanging
Our entire user base is running 11.0.0.676 on Windows 10. I believe this is the latest version of Paradox. Today, there is 1 user whose Paradox app is hanging when executing  the command printerSetCurrent. Rebooting does not correct the issue. code snippet: stPrnName = "Win2PDF" if printerSetCurrent(stPrnInfo) then ; THIS LINE HANGS,      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "PDFFileName", pathstring , regKeyCurrentUser),      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "file options", 2, regKeyCurrentUser),      setRegistryValue("Software\\Dane Prairie Systems\\Win2PDF", "persistent", "0", regKeyCurrentUser), else,      errorShow("Failed to make Win2PDF the current printer"), endIf Has anyone run into similar issues with printerSetCurrent? Thanks, Gary
7/6/2020
7 replies. Last post:

josephpnorris
We've had this problem "forever" and haven't figured it out.  Windows 7.    It seems to come and go, but could be related to unusual status of one of your printers.   Try rebooting, etc.  Try removing unneeded printers.
8/3/2020
Nothing New Since Your Last Visit
145
Hits

Thread 18 of 25
Thread Starter  

juan@pcexperts.com
HowTo: Search for records not in another table
I need to create a query using the QBE that will list all records from table A not in table B. (A not-in query), , Thanks
3/20/2001
Nothing New Since Your Last Visit
2733
Hits

Thread 17 of 25
Thread Starter  

PS_2762
Opening A Form
I am absolutely brand new to programming in Paradox. I want to make a Main form. For ease of discussion, I just want to create a form which I have done that has one button. I want it to opne a form I already have linked to a table. I get a syntax error. I cannot find any build as you go coder. I have this and it gives me a syntax error: method action(var eventInfo ActionEvent), open("TestReview Form"), endMethod The form is in the same working folder as this Main form. Does anyone know what the syntax is to simply open a form? No parms passed, just open the form in data entry mode.
4/17/2020
9 replies. Last post:

Steven.G
first, that code should be on the pushbutton event.. I should have noticed that you put it somplace else second, what is your intended interaction with WP and or QP? third, any modern database platform will usually be SQL-based.. can't make any specific recommendations beyond that
4/20/2020
Nothing New Since Your Last Visit
82
Hits

Thread 16 of 25
Thread Starter  

rum
Order of Events
{Too Long!}
3/3/2020
Nothing New Since Your Last Visit
57
Hits

Thread 15 of 25
Thread Starter  

Ash.B2
Populating drop down from a table
{Too Long!}
1/23/2020
5 replies. Last post:

Ash.B2
Thanks so much, Rum! I took your code and refined it to my purposed.  No arrays for me, so I was able to simplify it, and in the end it wound up working better than I actually had planned!  (Was able to sort just by selecting the drop-down menu item, didn't need a separate button, like I thought I would) This worked very well, and I thank you. Ash
2/25/2020
Nothing New Since Your Last Visit
419
Hits

Thread 14 of 25
Thread Starter  

PS_1093
Error occurred while reading graphic file
Hi guys, In my form i inserted a graphic object. But when i right click and use the paste from graphic file and selected any graphic file it say, "Disk error occurred while reading file." "Error occurred while reading graphic file." Have you encountered the same error ? Any idea how to resolve this?, , Thank you in advance for your help., , -yuz
2/1/2020
1 Reply:

Steven.G
I have not used that funtion in many years.. my first guess is that it doesn't understand the file type.. remember, this is 25 year old technology, based on simple bmp logic
2/3/2020
Nothing New Since Your Last Visit
66
Hits

Thread 13 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/28/2011
8 replies. Last post:

Steven.G
it comes back.. it's possessed :-)
11/26/2019
Nothing New Since Your Last Visit
1544
Hits

Thread 12 of 25
Thread Starter  

Ash.B2
Bringing the Active record to a new form
{Too Long!}
10/24/2019
2 replies. Last post:

Ash.B2
Never mind. Tried for a few days, couldn't get libraries to work (maybe a windows 10 issue?), but I figured it out using a query to a temp table, and pulled the value from the temp table into the second form. Maybe not the most elegant, but it works.
10/27/2019
Nothing New Since Your Last Visit
170
Hits

Thread 11 of 25
Thread Starter  

Ash.B2
Form won't open
Inexperienced user here.  Self-taught, and smart enough to know that I don't know much. Paradox 10 running on Windows 10 I spent weeks developing a paradox form and application for a project I'm doing, then the form simply stopped loading. So I did it all again, spending weeks again. Then it stopped loading again. I can open all other forms in the same project, all tables, and all datamodels.  The form in question worked fine when I had it open last, designing and testing it.  Now it won't load.  All I get is the timer circle spinning, and it won't stop until I go to Task Manager and shut Paradox down.  No error message at all.
10/21/2019
15 replies. Last post:

Steven.G
{Too Long!}
10/23/2019
Nothing New Since Your Last Visit
207
Hits

Thread 10 of 25
Thread Starter  

rum
Forms Event Model Confusion
I have never found just the right combination of events for the following situation. In the following argument..... "C:\Program Files (x86)\Paradox\Programs\pdxwin32.exe" -c -q -pE:\OutsourceWork\V11\priv -wE:\OutsourceWork\V11 _stub.fsl Paradox will launch and display the _stub.fsl   form (no problem) When the form opens I want specific code to run AFTER the form is fully displayed. Two question 1.  How do I WAIT until the form is fully displayed 2. What event should I put the code in? My current problem is that there are 5-10 function calls that take place, each displaying results in a list on the screen.  And regardless of how many SLEEP() I put in the thing it will not display the form until about  halfway through the code execution. Sometimes only flickering onto the screen briefly before closing. Many thanks!
8/1/2019
5 replies. Last post:

Steven.G
geez, that was a long-shot.. no wonder it took so long to figure it out.. wow !!
8/2/2019
Nothing New Since Your Last Visit
179
Hits

Thread 9 of 25
Thread Starter  

PS_1600
Set Range/Pattern Match
I am working with a PDX8 program which uses Wahl2Wahl's table lookups which work very well. The table lookups do not function correctly on PDX10, the up/down arrows and tab do not work. I am trying to create something similar and combining  set range and locate pattern. I can get either to work but not together. Is there a way to code in such a way that the setRange is the default but the user can also type .. to enable the locate pattern logic? method keyPhysical(var eventInfo KeyEvent), , Var,   s  string, endVar,     doDefault,  ,      s = self.value,      ,      ;PART.setRange( self.value, self.value+"zzz" ),    ,       ignoreCaseInStringCompares(yes),       advancedWildcardsInLocate(Yes) ,       PART.locatePattern("DESC",s),   , endmethod Thanks. Steve
4/16/2019
19 replies. Last post:

Jeff.R3
I will take a stab at it, Unfortunately,I am on vacation this week. , send a a few sample records, as well as a rough count on how many records you will be searching. I will use that info to create something. Keep in mind, I have never done this, I only presume that I can do it, AND since I have a similar issue will give it a shot. , Jeff
4/25/2019
Nothing New Since Your Last Visit
446
Hits

Thread 8 of 25
Thread Starter  

lja
using alias to oracle, datamodel gives error
{Too Long!}
11/12/2008
10 replies. Last post:

John.O2
{Too Long!}
1/24/2019
Nothing New Since Your Last Visit
6248
Hits

Thread 7 of 25
Thread Starter  

GaryG
Navigation buttons disabled
I recently upgraded from Paradox 7 to Paradox 11.0.0.676. On one of the forms, the navigation buttons are disabled, yet I am able to scroll through the records using the wheel mouse. Any ideas on what may cause the navigation buttons to be disabled? P.S. I am new to Paradox. Thanks, Gary
11/28/2018
3 replies. Last post:

Steven.G
interesting.. two unrelated processes the last full version of paradox was v9 in 2000.. v10 in 2002 had a few minor additions.. v11 is v10 with the service packs added, and hasn't changed in 15 years
11/29/2018
Nothing New Since Your Last Visit
390
Hits

Thread 6 of 25
Thread Starter  

vinylsol
Unknown internal operating system error
I cut and paste images into an image field on a Paradox form and I've been doing this with no problems for years; yesterday I got a message saying 'Unknown internal operating system error' with a reference to the .MB file, when I tried to paste an image in. Paradox hung. After restarting, I verified and rebuilt the table and it imported the image ok but when I tried to do it with a new record the same thing happened. I'm using Paradox 10.0.0.663 running on a Lenovo laptop with Vista Home Premium and Service Pack 2. The database has 121,900 records in it but not all of them have images. Does anyone know what might be causing this? Any help would be appreciated, thanks.,
1/21/2010
38 replies. Last post:

philiptdotcom
Thanks!  I've used ChimneySweep before (probably have a license for it!), but I'd forgotten about it.  Thanks for the heads-up/reminder!  I'll check it out.  (As I recall, it was very useful in fixing things that the built-in "fixer" couldn't fix.  I'll try to dig it up & see what it can do with these memo fields!) Thanks again! Aloha, -pt
9/20/2018
Nothing New Since Your Last Visit
15661
Hits

Thread 5 of 25
Thread Starter  

Kathy D
Forms - Cursor Position Changed
Currently using Paradox 11.0.0.663 - Have an existing input form and have experienced a change this week for one user in the way the cursor is positioned when pressing F2 edit.  For all other users when F2 is pressed the cursor positions itself at the beginning of the field.  For this user upon pressing F2 the cursor is positioned at the end of the field.  I have been unable to find a solution to return the cursor to it's normal position (at beginning of field) upon edit.  I am sure it was a sequence of key strokes hit.  Closing out Paradox does not return cursor to correct position.
6/30/2011
Nothing New Since Your Last Visit
2334
Hits

Thread 4 of 25
Thread Starter  

Concordia
EDatabaseError in module +++++.exe at 00054b36....
I have been searching for a correction for this problem. Pls help, Here is the problem, "Exception EDatabaseError in module +++++.exe at 00054B36 Table +++++.db has no index for fields..." then is list all the fields in the table., Im not good at this program, nor did I create it, please help. Tony @ Concordia
2/8/2002
Nothing New Since Your Last Visit
5896
Hits

Thread 3 of 25
Thread Starter  

rum
Mouse WHEEL Movement
In PDOX 8,  the mouse wheel had no impact on the paradox environment,  It just didn't work. Now in PDOX 11,  the mouse wheel is allowing users to scroll off of the record they should be Adding/Editing.  The user is then focused on a blank screen. Is there a way to trap that event?  I dont see any clues in the help doicument when it comes to scrolling mouse wheels. Currently I use the KeyPhysical event to prevent users from using the arrow keys to move from record to record,  but does not prevent the MOUSE action
3/8/2018
10 replies. Last post:

Jeff.R3
Your situation will be different than mine,  On my form,  I have a parent child situation,  and it is the PARENT i am concerned with.   So  I haven't gone any deeper.
3/15/2018
Nothing New Since Your Last Visit
830
Hits

Thread 2 of 25
Thread Starter  

rum
Mouse WHEEL Movement
In PDOX 8,  the mouse wheel had no impact on the paradox environment,  It just didn't work. Now in PDOX 11,  the mouse wheel is allowing users to scroll off of the record they should be Adding/Editing.  The user is then focused on a blank screen. Is there a way to trap that event?  I dont see any clues in the help doicument when it comes to scrolling mouse wheels. Currently I use the KeyPhysical event to prevent users from using the arrow keys to move from record to record,  but does not prevent the MOUSE action
3/8/2018
Nothing New Since Your Last Visit
473
Hits

Thread 1 of 25
Thread Starter  

Dyskdata
Paradox reports, ole container
Can anyone help me I am new to paradox and need to add a tif file to a Paradox report and be able to change it at runtime. I thought of an OLE container but I can't find a way to change it on the fly through code. Any suggestions?
6/19/2001
Nothing New Since Your Last Visit
1921
Hits

New Thread
www.prestwoodboards.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 11/30/2020