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

50 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  
9055
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
14075
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  
9162
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
23395
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
6914
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
15220
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
11667
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
4398
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
11627
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
5683
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
5338
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
17194
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
7191
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
5358
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
8321
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
6292
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
7105
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
5173
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
6128
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
5611
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
17423
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
5 years ago, and updated 47 months ago

Article
Nothing New Since Your Last Visit
9091
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
19321
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
5364
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
3679
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
4016
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
7462
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
8725
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
37 months ago

KB Post
Nothing New Since Your Last Visit
1373
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  
11902
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
53 months ago
(1 Comments , last by Anonymous )

FAQ
Nothing New Since Your Last Visit
8843
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
21754
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
6160
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
3721
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
11968
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
6448
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
4732
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
5369
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
4586
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
5039
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
5381
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)
20 months ago

Article
Nothing New Since Your Last Visit
1547
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
6614
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
6233
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
5773
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
10644
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
16352
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
55091
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
5421
Hits

DBA, Databases, & Data

Mike Prestwood
50. 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
6520
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]