Foreword:
Boys started learning VB6.0 by use of the previously used 3 years practical learning program,
Step by step, from the EXCEL spreadsheet formula - & gt; EXCEL VBA program - & gt; ACCESS - VBA program - & gt; MS_SQL + ACCESS - VBA program,
At present, there have been multiple small software in the actual operation of unit, mainly include: work plans, log management, object management, financial management,
Are based on the background - MS SQL server + front ACCESS program,

Program to upgrade to the VB6.0 by use of reason, I have been to the program must rely on OFFICE2003 software,,
Because, OFFICE2003 gradually behind the elimination, the difference is too big, an architecture in an basic to rewrite my software,
So kick open OFFICE, using VB to write,
Consider using VB2010 originally, but the feeling is so different with VBA syntax!
Had to temporarily use VB6.0 by use first, at least, a lot of code can be directly copied,

Software architecture:
Well! Directly hold a piece of software that our unit!
1, the background data using SQL server storage,
2, the front desk a main window, in which each functional module of the forms show, free open, switch, closed,
3, all sorts of function modules, ready to make a DLL, real-time running from the server to download,


Steps:
1, the main program - functions:
A, connect to SQL server, complete the
B, read the local configuration file content, complete,
C, the login window, read the list of users, permissions, completed authentication codes,
D, the program icon, study...
E, the main window plan...

CodePudding user response:

Can consult everybody the teacher, EXE program on the same DLL at runtime:, downloaded to a local call, exit closes, delete the DLL file?

Well! I'm going to the terminal, there is only one of the main program EXE file, a CFG configuration files, terminal is not save DLL files, need from the server to download, run after the completion of the deleted,
Because of considering, DLL file on the server can be upgraded at any time, every time to open the can real-time using the latest version,

CodePudding user response:

Icon fix: pentagram

CodePudding user response:

Can, of course, the question a lot, specific can oneself slowly to baidu

CodePudding user response:

Can, but need to dynamic load DLLS, seems to have some difficulty in implementation

CodePudding user response:

This is a typical plug-in architecture, increase the function you just need to download the DLL module, do not need to function can also be dynamic unloading,

CodePudding user response:

reference 5 floor ok999ok reply:

this is a typical plug-in architecture, adding features you just need to download the DLL module, do not need to function can also be dynamic unloading,

Consult with an example of implementation?

CodePudding user response:

Well! Get rid of the main window basic today!
Add the menu, the status bar, to the status bar to add a progress bar! ,
Found that there is a problem, if the MDI window, the progress bar should not set length, if the move to the status bar, to cover up the whole status bar!


MDIForm

CodePudding user response:

It's so trouble
I suggest or local good DLL call
A version control server do
Local reads from the server version
Versions have change to download new files
This relatively easier to control

CodePudding user response:

Well! On software plug-in architecture, originally not difficult!

Idea:
1, will be the main program and the plug-in into EXE,
2, the main program according to the need to run the plug-in, and forms to grab it to their own form of as a child form,

Difficult points:
1, avoid plug-ins run repeatedly,
2, the communication between the main program and subroutines, call and deliver results,

O give directions!

CodePudding user response:

refer to the eighth floor aspower_ response:

this very troublesome
I suggest or local good DLL call
A version control server do
Local reads from the server version
Versions have change to download new files
Such relatively good control much

Well! Because in the local area network (LAN), bandwidth, storage space, what are not problems,
Runtime directly download the EXE file, no effect,

CodePudding user response:

Download an API help, learn to see!

CodePudding user response:

references to the tenth floor qq_16443837 response:

Quote: refer to the eighth floor aspower_ response:

It's so trouble
I suggest or local good DLL call
A version control server do
Local reads from the server version
Versions have change to download new files
Such relatively good control much

Well! Because in the local area network (LAN), bandwidth, storage space, what are not problems,
Runtime directly download the EXE file, no impact,

The original poster with very fierce, I am also excel formula SQL access turns is the fate

CodePudding user response:

The

refer to 12 floor VJKHJMBMNB reply:

Quote: reference to the tenth floor qq_16443837 response:

Quote: refer to the eighth floor aspower_ response:

It's so trouble
I suggest or local good DLL call
A version control server do
Local reads from the server version
Versions have change to download new files
Such relatively good control much

Well! Because in the local area network (LAN), bandwidth, storage space, what are not problems,
Runtime directly download the EXE file, no impact,

The original poster with very fierce, I am also excel formula SQL access turns is really the fate

Common learning progress together!

CodePudding user response:

references to the tenth floor qq_16443837 response:

Quote: refer to the eighth floor aspower_ response:

It's so trouble
I suggest or local good DLL call
A version control server do
Local reads from the server version
Versions have change to download new files
Such relatively good control much

Well! Because in the local area network (LAN), bandwidth, storage space, what are not problems,
Runtime directly download the EXE file, no impact,

Not about what bandwidth and space
Are their coding is simple, without special requirements for
Or better to reduce unnecessary business code.

CodePudding user response:

I'm dizzy!
Spent one day to rewrite module of class a reading configuration files, finished just detection, the Win would have had to read and write configuration file system function,
Here is an example:


'in the form, please put 3 TextBox, a CommandBox
Private Declare FunctionGetPrivateProfileString Lib "kernel32" _
Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, _
ByVal lpKeyName As Any, ByVal lpDefault As String, _
ByVal lpReturnedString As String, ByVal nSize As Long, _
ByVal lpFileName As Long As String)
Private Declare Function WritePrivateProfileStringLib "kernel32" _
Alias "WritePrivateProfileStringA" (ByVal lpApplicationName AsString, _
ByVal lpKeyName As Any, ByVal lpString As Any, _
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull