Crud VB6

Simple CRUD made with VB6, Crystal Reports 8.5 and SQLite.

Overview

This project consists of a small CRUD (create, read, update, delete) system made in Visual Basic 6 that uses SQLite as a local database engine. It also uses Crystal Reports for reports and allows export to other formats.

The project consists of 3 modules:

• Articles module with create/update/delete and search operations.
• Categories module with create/delete operations.
• Reports module with function to export to .pdf, .doc, and .xls formats.

It is not necessary to install the SQLite ODBC to run the application since it has a special class module for this that makes use of the internal functions of sqlite.dll (included in the repository)

Also included is the script to create the installer using InnoSetup

How to use this?

In order to modify the project, you only need to have Crystal Reports 8.5 installed (it automatically installs the .OCX libraries used in the application) and then open the crud_vb6.vbp project since Microsoft Visual Basic 6.0. It is not recommended to modify the cSQLiteConnection.cls file as it contains the functions necessary to interact with the SQLite database

Then, to test your modified version (test the .exe) with an installer you only need to do the following:

1. Run the build.bat file from a terminal as administrator, this will create a crud_vb6.exe in the root folder
2. Open the install.iss file with InnoSetup and option Build > Compile. This will create the installer in the InnoSetup_Installer folder

And voila, you now have your own customized version of the CRUD_VB6 system with its standalone installer.

Development environment

• Microsoft Visual Basic 6.0 (VB6)
• Crystal Reports 8.5
• InnoSetup 6.3.3
• Greenshot 1.2.10 (for screenshots)

and the classics... Sublime Text, Notepad++, VS Code, etc.

Platforms

Windows 7 or latter

Screenshots

Installer

Main menu

Articles module

Reports module

Errors with Crystal Reports

This is a list of some errors I encountered when working with Crystal Reports 8.5 and wanting to deploy the application to a clean machine. I hope it helps you.

LIBRARY	ERROR IF NOT FOUND
crviewer.dll	Runtime-Error '339' Component crviewer.dll or one of its dependences not correctly registered: a file is missing or invalid
craxdrt.dll	Runtime-Error '-2147024770 (8007007e)': Automation error
P2smon.dll*	Physical database not found.
crxf_pdf.dll	Runtime-Error '-2147190548 (800478ec)': Missing or out-of-date expor DLL.
crtslv.dll	Runtime-Error '-2147190908 (80047784)': Failed to export the report.
EXPMOD.dll	Runtime-Error '-2147190908 (80047784)': Failed to export the report.
u2ddisk.dll	Runtime-Error '-2147190548 (800478ec)': Missing or out-of-date export DLL.
u2fwordw.dll	Runtime-Error '-2147190548 (800478ec)': Missing or out-of-date export DLL.
u2fxls.dll	Runtime-Error '-2147190548 (800478ec)': Missing or out-of-date export DLL.

luckily and thank God all these errors are resolved simply by registering these libraries. View the file dependencies.bat

(*) It may not be necessary

References

• Report no showing data
• Export report to PDF
• Error: 'Pyhsical database not found'
• Error: cr8.5 Export to PDF
• Error: cr8.5 export to PDF (bendito seas)
• Working with Crystal Reports 8.5 and .ttx files
• Trust Center locked word file
• Use of Dictionary in VB6
• Use of dictionary in VBA/VB6
• ListView column click order
• Sort ListView column click
• Embebed manifest into exe (vb6)
• vb6 icons free
• Permission Windows
• VB6 Common Controls
• emule hyperlink on VB6