ACG's Open, Save-As and Browse
for File Dialogs (OSDLG) is an Access code module or class that provides a simple "drop in" solution for developers who need quick,
convertible, lightweight and flexible common dialog functionality. Its easier to use than an Active X control, and provides more functionality as well. With
our Dialogs Class you can:
Have code
which works on all Windows 32 bit platforms.
Eliminate use of bulky or
changing Active X controls and eliminate worry about broken references on
distribution.
Make calls directly to the system dlls, and eliminate having to
change your code as you upgrade apps from one version of Access to another.
Have options like
multi-select capability, ability to return a short (DOS compatible) file name
and path, flexible file types.
What's Simple? Here's an example:
If you are most comfortable programming with functions you can use OSDLG's standard module calls that look like this:
Function GetDataMdb() as String GetDataMdb = atOpenFile(Me.hwnd, "Attach Tables from What Database?", 1, True, False) End Function
OSDLG
also provides a
VB class to use if you are using object programming, or simply want code that's as "easy" as an Active X control and costs less than the Office Developer's Edition. Using a class module makes OSDLG code easy to read and maintain; for example:
Function GetDataMdbFile() as String
Dim MyDlg as New DialogClass
Dim strReturnFile as String
With MyDlg
.Title = "Please select a Database File"
.TypeFile = 1 'Access mdbs.
.DialogType = "Open"
.Show
strReturnFile = .ReturnValue
End With
GetDataMdbFile = strReturnFile
End Function
