IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE
   ► KBDesktop Data...   Print This     

DBA KB: Desktop Databases Topic

About Desktop Databases: Desktop databases allow you to develop relatively quickly because of very good GUI design tools, and high level integration of GUI design and data objects. All database tables, queries, forms, and reports are designed visually and you attach code where needed (coding is not visual though).

Topics

51 Articles Found in the Desktop Databases Topic  (or one of the sub-topics in bold above)

  KB Article    

Mike Prestwood
1. Access VBA Array (x = Array())

Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: Access & VBA
7 years ago

Code
Nothing New Since Your Last Visit  
7923
Hits

Microsoft Access

Mike Prestwood
2. Access VBA Empty String Check (Len(s&vbNullString))

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: Access & VBA
8 years ago

Code
Nothing New Since Your Last Visit
12426
Hits

Microsoft Access

Mike Prestwood
3. Access VBA Parameters (ByRef, ByVal)

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Posted to KB Topic: Access & VBA
9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit  
7993
Hits

Microsoft Access

Mike Prestwood
4. AOL FoxPro Resources http://users.aol.com/FoxProResources/index.htm
Posted to KB Topic: Visual FoxPro (VFP)
9 years ago
(1 Comments , last by Charl.e )

Link
Nothing New Since Your Last Visit
17145
Hits

Visual FoxPro

Wes Peterson
5. Application Manifests, Revisited for Vista Since the introducton of XP, Windows programs have benefitted from an application "Manifest." This was covered in an earlier article. This is an update to that information, pertaining to Windows Vista
9 years ago

KB Post
Nothing New Since Your Last Visit
6039
Hits

DBA, Databases, & Data

Wes Peterson
6. Application Virtualization: The Good, the Bad, the Ugly

Virtualization is a concept greatly expanded in Vista. This article discusses the impact of Application Virtualization on you development. It can have a huge impact on how the programs you write will behave when installed on Vista.

9 years ago, and updated 9 years ago

Article
Nothing New Since Your Last Visit
13403
Hits

DBA, Databases, & Data

Mike Prestwood
7. AxDistEx.exe Trojan Virus - Not

Some virus programs are reporting a virus in the 1998 file axdistex.exe:

File: \ Distrib\setup\axdistex.exe
Malware: Win32:CIH-C
Type: Virus/Worm
Posted to KB Topic: Paradox & ObjectPAL
8 years ago

Error
Nothing New Since Your Last Visit
10678
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
8. Borland Announces Paradox 7 for Windows 95 & Windows NT Database Power Made Easy for Users and Developers.
Posted to KB Topic: Paradox & ObjectPAL
10 years ago, and updated 10 years ago

News
Nothing New Since Your Last Visit
3861
Hits

Corel Paradox / ObjectPAL Coding

Fred Stevens
9. Building a DSN-less Connection: Listing available databases for a SQL Server

Using VFP and the Windows API to obtain and list the available databases for a selected server.

Posted to KB Topic: Visual FoxPro (VFP)
11 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
10067
Hits

Visual FoxPro

Mike Prestwood
10. Corel News Groups News://cnews.corel.com
Posted to KB Topic: Paradox & ObjectPAL
9 years ago, and updated 9 years ago

Link
Nothing New Since Your Last Visit
5040
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
11. Corel Ships Paradox 9 Developers Edition Corel ships Paradox 9 Developer's Edition. In every box is a copy of Mike Prestwood's Paradox 9 Power Programming book.
Posted to KB Topic: Paradox & ObjectPAL
10 years ago, and updated 10 years ago

News
Nothing New Since Your Last Visit
4763
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
12. Corel Ships Paradox with WordPerfect Office X3 Pro! Paradox 11 with SP2 already applied shipped as part of the WPO X3 Pro Edition.
Posted to KB Topic: Paradox & ObjectPAL
10 years ago, and updated 9 years ago

News
Nothing New Since Your Last Visit
15448
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
13. Corel WordPerfect X3 Pro Home Page http://www.corel.com/servlet/Satellite/us/en/Product/1152105039490
Posted to KB Topic: Paradox & ObjectPAL
10 years ago, and updated 9 years ago

Link
Nothing New Since Your Last Visit
6242
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
14. Crooit Software http://www.crooit.com/
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Link
Nothing New Since Your Last Visit
4753
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
15. dBforums Corel Paradox forum http://www.dbforums.com/forumdisplay.php?f=85
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Link
Nothing New Since Your Last Visit
7430
Hits

Corel Paradox / ObjectPAL Coding

Daniel Fought
16. DBMonster.com Paradox Topic http://www.dbmonster.com/Uwe/Forums.aspx/paradox/200805/1
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Link
Nothing New Since Your Last Visit
5580
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
17. DDE: Dynamic Data Exchange Introduction

Overview of DDE.

14 years ago, and updated 7 years ago

KB Post
Nothing New Since Your Last Visit
6356
Hits

DBA, Databases, & Data

Mike Prestwood
18. Diamond Software Group http://www.diamondsg.com/pdoxsales.htm
Posted to KB Topic: Paradox & ObjectPAL
9 years ago, and updated 9 years ago

Link
Nothing New Since Your Last Visit
4529
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
19. Felicia Keyboard Game This simple game demonstrates disabling keys, generatingsounds, and random numbers.
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Download
Nothing New Since Your Last Visit
5259
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
20. FoxTools.com http://www.foxtools.com/
Posted to KB Topic: Visual FoxPro (VFP)
9 years ago

Link
Nothing New Since Your Last Visit
5023
Hits

Visual FoxPro

Mike Prestwood
21. FreeWheel by Jim Barry
A cuddly tray icon which makes all your apps work with the IntelliMouse scrolling wheel. Two modes of operation are supported. Also, FreeWheel allows you to switch between documents by holding down the control and shift keys while moving the mouse wheel. FreeWheel is free, so dont delay - try it today. You might like it! Requires Microsoft IntelliMouse or equivalent.
Posted to KB Topic: Paradox & ObjectPAL
6 years ago

Download

Article
Nothing New Since Your Last Visit
14625
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
22. How To Save Time And Work When Creating A Paradox Report That Is Similar To Another

This is a simple discussion of a technique I use to create new Paradox reports quickly that are similiar to existing ones, yet functionally different in their purpose. Screen shots are included to illustrate the method I utilize.

Posted to KB Topic: Paradox & ObjectPAL
56 months ago, and updated 38 months ago

Article
Nothing New Since Your Last Visit
7998
Hits

Corel Paradox / ObjectPAL Coding

Wes Peterson
23. Icon plug-in for Photoshop and Paint Shop Pro http://www.aha-soft.com/products.htm
9 years ago

Link
Nothing New Since Your Last Visit
18597
Hits

DBA, Databases, & Data

Wes Peterson
24. MAPI - or Something Better Most development tools give us easy access to MAPI. Some offer MAPI as the ONLY easy way to send email. Still, is MAPI the best way to go?
10 years ago
(2 Comments )

KB Post
Nothing New Since Your Last Visit
4499
Hits

DBA, Databases, & Data

Mike Prestwood
25. Microsoft Access 2002 Released Microsoft launches Access 2002.
Posted to KB Topic: Access & VBA
9 years ago, and updated 9 years ago

News
Nothing New Since Your Last Visit
3281
Hits

Microsoft Access

Mike Prestwood
26. Microsoft Certifications http://www.microsoft.com/learning/mcp/default.asp
9 years ago, and updated 8 years ago

Link
Nothing New Since Your Last Visit
3609
Hits

DBA, Databases, & Data

Mike Prestwood
27. Mike Prestwood's Books

Lots to download here including support files, chapter PDFs, sample applications, and more.

Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Download
Nothing New Since Your Last Visit
6574
Hits

Corel Paradox / ObjectPAL Coding

Wes Peterson
28. MSI Installers: Whats Up with These? For a while, now, Windows has supported a new mechanism for installing applications: MSI. This is quite a bit different than the familiar setup.exe, and here we begin exploring the differences - and the significance of MIS installations.
9 years ago, and updated 9 years ago
(2 Comments , last by Wes )

Article
Nothing New Since Your Last Visit
7698
Hits

DBA, Databases, & Data

Laura Lage
29. MySQL Connectors and MSAccess Office 2007 Errors

Queries on a Microsoft Access database linked to MySQL tables failed with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing (Microsoft Access cannot find the field "fieldname" referred to in your expression).

Posted to KB Topic: Access & VBA
28 months ago

KB Post
Nothing New Since Your Last Visit
785
Hits

Microsoft Access

Mike Prestwood
30. ObjectPAL Array (Array[] type)

Arrays in ObjectPAL use a 1-based indice.

Use size() to get the number of elements. size() returns 0 if the array has no elements.

Posted to KB Topic: Paradox & ObjectPAL
7 years ago

Code

KB Post
Nothing New Since Your Last Visit  
10260
Hits

Corel Paradox / ObjectPAL Coding

paulh
31. ODBC - Intersolv v3.11 driver with Pdx9 installation disk

Currently using Pdx 11.0.0.302 on laptop with Win7 64 bit, no problems with essentially interactive use for year past. 

Now have need for access to Pdx tables by ODBC. Have installed drivers supplied on the Pdx 9 install disk but the drivers do not show up on the Drivers tab of the ODBC Administrator window.

In past, have successfully installed drivers ex Pdx 9 cd with same Pdx 11 set up on machines running Win XP. Except this time used a backup cd copy of the original installation disk. Made 2 attempts, first prompted for licence code, entered and it ran. The driver files have copied to the default location as prompted by the setup procedure. Also accepted default installation path for Pdx 11.

Posted to KB Topic: Paradox & ObjectPAL
44 months ago
(1 Comments , last by Anonymous )

FAQ
Nothing New Since Your Last Visit
8003
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
32. Paradox 9 Help & PDF Files

Paradox 9 ships with several very valuable help files. For convenience, you can also download them here.

Posted to KB Topic: Paradox & ObjectPAL
7 years ago
(3 Comments , last by David.J3 )

Download
Nothing New Since Your Last Visit
18343
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
33. Paradox Coding Convention: Paradox Edition The Paradox edition of our coding convention.
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Download
Nothing New Since Your Last Visit
5314
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
34. Paradox for Windows Ships Borland ships Paradox 1.0 for Windows
Posted to KB Topic: Paradox & ObjectPAL
10 years ago, and updated 10 years ago

News
Nothing New Since Your Last Visit
3240
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
35. Paradox:03:69e5: Unexpected Condition GP 0000 at Paradox:03:69e5:
Posted to KB Topic: Paradox & ObjectPAL
9 years ago, and updated 9 years ago
(1 Comments , last by greens )

Error
Nothing New Since Your Last Visit
9376
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
36. PrestoEdit Powerful text and source code editor that color codes ObjectPAL syntax. Great for times when you wish to edit ObjectPAL outside of Paradox.
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Download
Nothing New Since Your Last Visit
5620
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
37. RDA World Wide http://www.rdaworldwide.com/
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Link
Nothing New Since Your Last Visit
4154
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
38. Sedna: VFP is Now OpenSource! Kind of. Ongoing VFP enhancements likely to continue being an OpenSource effort.
Posted to KB Topic: Visual FoxPro (VFP)
9 years ago, and updated 9 years ago

News
Nothing New Since Your Last Visit
4925
Hits

Visual FoxPro

Mike Prestwood
39. Site of Bertil Isberg http://hem.bredband.net/bertilisberg/
Posted to KB Topic: Paradox & ObjectPAL
10 years ago

Link
Nothing New Since Your Last Visit
4155
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
40. TechTricks.com Paradox Articles http://www.techtricks.com/paradox/
Posted to KB Topic: Paradox & ObjectPAL
9 years ago, and updated 9 years ago

Link
Nothing New Since Your Last Visit
4392
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
41. The History of FoxPro http://www.foxprohistory.org/
Posted to KB Topic: Visual FoxPro (VFP)
9 years ago

Link
Nothing New Since Your Last Visit
4809
Hits

Visual FoxPro

Douglas.M
42. The Situation Dictates Whether Or Not Technology Is Obsolete

This article discusses a real life example of how I used so called "obsolete" technology to revive a Visual Foxpro manufacturing database that was comprised by viruses.

Posted to KB Topic: Visual FoxPro (VFP)
11 months ago

Article
Nothing New Since Your Last Visit
784
Hits

Visual FoxPro

Mike Prestwood
43. TheDBCommunity.com http://www.thedbcommunity.com
Posted to KB Topic: Paradox & ObjectPAL
9 years ago
(2 Comments , last by Anonymous )

Link
Nothing New Since Your Last Visit
5903
Hits

Corel Paradox / ObjectPAL Coding

Wes Peterson
44. Version Information Is there a right way to handle version information in our projects? Could we do a better job of it?
11 years ago, and updated 10 years ago
(2 Entries )

Blog
Nothing New Since Your Last Visit
5529
Hits

DBA, Databases, & Data

Mike Prestwood
45. Visual FoxPro 9.0 SP2 Help Download The help file for VFP 9.0 SP2 is now available for download. This is in addition to the online help documentation that was updated for SP2 last year.
Posted to KB Topic: Visual FoxPro (VFP)
9 years ago, and updated 9 years ago

News
Nothing New Since Your Last Visit
5151
Hits

Visual FoxPro

Fred Stevens
46. Win-32 API - Listing available local and network SQL Servers Demonstrates the use of the SQLBrowseConnect() Windows API call to generate a list of SQL Servers on a user’s network using VFP
Posted to KB Topic: Visual FoxPro (VFP)
12 years ago
(1 Comments , last by Anonymous )

KB Post
Nothing New Since Your Last Visit
9026
Hits

Visual FoxPro

Fred Stevens
47. Win-32 API - Listing ODBC Data Source Names Demonstrates the use of the SQLDataSources() Windows API call to generate a list of DSNs with VFP
Posted to KB Topic: Visual FoxPro (VFP)
13 years ago

KB Post
Nothing New Since Your Last Visit
14673
Hits

Visual FoxPro

Fred Stevens
48. Win-32 API: Determining the Unique Network Interface Card (NIC) ID Description of technique and sample code for using VFP to access the Win-32 API and return the MAC address of the Network Interface Card (NIC.
Posted to KB Topic: Visual FoxPro (VFP)
13 years ago, and updated 8 years ago
(1 Comments , last by darryl2 )

KB Post
Nothing New Since Your Last Visit
52993
Hits

Visual FoxPro

Mike Prestwood
49. Windows Virtualization http://www.microsoft.com/whdc/system/platform/virtual/default.mspx
9 years ago

Link
Nothing New Since Your Last Visit
4812
Hits

DBA, Databases, & Data

Mike Prestwood
50. WordPerfect Office X3 Service Pack 2 Service Pack 2 is now available for WordPerfect Office X3.
Posted to KB Topic: Paradox & ObjectPAL
9 years ago
(2 Comments , last by Anonymous )

News
Nothing New Since Your Last Visit
8445
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
51. Workbench for Paradox Add 50+ options to Paradox 7, 8, 9, and 10.
Posted to KB Topic: Paradox & ObjectPAL
9 years ago

Download
Nothing New Since Your Last Visit
5655
Hits

Corel Paradox / ObjectPAL Coding

Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New DBA, Databases, & Data Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  DBA, Databases, & Data Message Board
-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


Go ahead!   Use Us! Call: 916-726-5675 


©1995-2017 Prestwood IT Solutions.   [Security & Privacy]