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 BoardParadox Third Party Books & Documentation Topic   Print This     

New Paradox User

New Paradox User in Paradox Third Party Books & Documentation topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   New Paradox   New Paradox User  
FlaglerMuseum

Help!!!  I am a new Paradox user and I am not a programmer or a techie.  I've been working here for 6 months and have been able to figure out how to create basic forms and reports but I'm trying to find training or manuals that will get me to the next level.  Any suggestions?  Thanks.

 Posted 12 years ago (Thread Starter)
Comment Quote
About FlaglerMuseum -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11909, 9 reply
Thread Started 6/20/2007 3:41:34 PM
View Counter=19082
Last Reply Posted 7/9/2014 6:16:58 PM)
Location= 
Joined=12 years ago   MB Posts=24  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
Also, make sure you join our Paradox group and subscribe to our monthly eMagazine. Each month we'll send you our Paradox question of the month, a tip, a Paradox definition, etc. Our eMagazine is custom tailored based on the groups you join.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #11931 (Level 1.1)  Reply to 11909
Thread Started 6/26/2007 12:17:07 AM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=75   BLOG, Topics=4  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Hi Teresa,

It's been a while so I wanted to ask how it's going? Are you still maintaining the Paradox application?

--
Mike Prestwood
Prestwood IT Solutions

 Posted 9 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #13897 (Level 1.2)  Reply to 11909
Reply Posted 1/30/2010 3:11:55 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=75   BLOG, Topics=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
Get your hands on Mike's book on programing for paradox 9.  It's an excellant starting point.  Check out the prestwood store, there is usuall a copy for sale out there.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #11910 (Level 1.3)  Reply to 11909
Reply Posted 6/20/2007 5:13:30 PM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
If you have a specific question on how to do something in paradox you can always post your question to this Board and one of use is sure to have tackled something similar in the past.  At least we can point you to several possible solutions.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #11936 (Level 1.4)  Reply to 11909
Reply Posted 6/26/2007 1:58:18 PM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Without looking at the data this is somewhat difficult, but we can possibly talk through this.  First, I am going to assume that you have one table containing all your data.  Each record has an name field to identify the member/contributer.  The table also contains a membership date field and a renewal date field.  It sounds like the distinction between a member and a contributer is possibly a little indistinct.  Is there a field that designates a member and a seperat field that designates the individual as a contributer?

I cant be sure but it seems to me that possible this table should be split into at least two tables.  One for the member/contributer identifing information and a second to contain the contribution history.

Quit a bit of what you are looking for can be accomplished in a fairly simple report using filters and group bands.  This would be fairly inflexable but quick.

So, before I make any more guesses.  How do you distinguish a member from a contributer?  How do you distinguish the levels fo membership and levels of contributers?

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #11943 (Level 1.5)  Reply to 11909
Reply Posted 6/26/2007 3:28:19 PM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Probably the best way to send a report would be to email it to me.  However without the datatables the report would not work.  Perhaps a screen shot of the report would work?

The correct way to design a database is to have each table handle the data for the different objects in your application.  So in your case you should probably have table for data identifing an individual.  I would assume that an individual can have only one membership level so that could be included in this table.  It sounds like an individual can be multiple types of contributors, so this would probably be best put into another table and linked back to the individual table.  The contributions should be contained in a third table and linked to the contributor table.   This would allow you to track contributions over time

 Have you been able to locate a copy of Mike's "Power programming for Paradox 9"  It is really a great text for someone just picking up Paradox and it is appropriate for all versions that followed 9. 

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 12 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #11967 (Level 1.6)  Reply to 11909
Reply Posted 7/11/2007 10:17:52 AM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
FlaglerMuseum

Thanks for all your suggestions.  We have a database with membership information and I want to be able to pull up reports on a members giving history and their membership history.  Short term I am looking for reports that will pull everyone that renewed or became a new member in the last month as well as gave a contribution.  The funky part is where I want the report to separate the members from the contributors, them separate the levels of membership as well as levels of contributions and then still sort them in alphabetical order.  I think I have figured out a way if I add a columns putting in a grouping code for each level of membership and use the grouping feature (because our membership levels are not in alphabetical order), but that's a lot of data entry that I don't want to do if it's not necessary.

 I keep seeing web sites where people give answers in code but I don't even know where to put the code for a report or where to begin.  Is there help for me?  I would love to take a local class but I cannot find any nearby, or even in the Continental US for that matter.  Should I just try to learn SQL?  will that help?  Any suggestions are appreciated.

 

Thanks

 Posted 12 years ago (Thread Starter)
Comment Quote
About FlaglerMuseum -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11938 (Level 1.7)  Reply to 11909
Reply Posted 6/26/2007 2:18:04 PM
Location= 
Joined=12 years ago   MB Posts=24  
FlaglerMuseum

Our table probably should be divided into several tables but we are so far behind the curve.  We didn't even have a form for data entry until about two months ago, and we have had Paradox for about 12 years, prior to that we were just entering the data into the raw database.  The columns we would use in the report are as follows.

Title, First Name, Middle Name, Last Name, Jr., Sr., etc.,

then:

Current Membership Level (There are two different types of Memberships, Individual, which comprises 7 (seven) different levels and Corporate, which comprises four different levels, all of which would need to be divided in the report but are all notated in the same column.

then:

We have fields that mark who is a Contributor, Individual Contributor, Corporate Contributor or Foundation Contributor.  This particular field is only marked with an X.  the amount of the contribution is indicated in a field labled Contribution Amount and Contribution Date

 

One of the main problems is that all information is on one line.  I may have a record of a person who became a member but also gave a contribution.  Or they are  a member but their Foundation gave a contribution (oh by the way there is another column for Foundation Name).  Usually in the same month that may not be a problem, but down the line I need to expand the dates of the report to the entire year and I'm not sure if that would create some conflicts.

 Currently we compile all of this information manually in WordPerfect.

 Thanks for your help, you are a trooper!! Smile

 Is it possible for me to attach a sample of a report, I tried to paste one into this page but it came out pretty distorted.

 Thanks a bunch,

 Teresa

 

 Posted 12 years ago (Thread Starter)
Comment Quote
About FlaglerMuseum -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #11946 (Level 1.8)  Reply to 11909
Reply Posted 6/26/2007 4:10:36 PM
Location= 
Joined=12 years ago   MB Posts=24  
Most Recent Post
Sam.S
North Hartland, VT USA

I found the manual for Borland's paradox 7.5 (win 95) to be a great reference. Maybe you can find it on eBay.

You want coffee?  I could write a paradox app for that...

 Posted 58 months ago
Comment Quote
About Sam.S -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Sam.S

You want coffee?  I could write a paradox app for that...


Post ID #15162 (Level 2) and Parent is 11909
Reply Posted 7/9/2014 6:06:48 PM
Location=North Hartland, VT USA 
Joined=9 years ago   MB Posts=40  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1261A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11909 Counter
19082
Since 4/2/2008
Follow PrestwoodBoards on: 


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