Joao Livio { MIX ~ UP on USA}

 'To REQUEST a full functional sample please > Click

1. Insert a DialogBox ActiveX in your Form.

In Design View go INSERT - ActiveX CONTROL

2. Rename the control to "cdlg"

3. Paste the Code to a CLICK event of a Commad Button

CODE

    Dim strCaminho As String
    With Me.cdlg
            'Initial Directory
            .InitDir = "C:\"
            'Dialog Title
            .DialogTitle = "Localizar Arquivo"
            'Filter File Types
            .Filter = "Arquivos(*.txt)|*.txt|All Files (*.*)|*.*"
            .ShowOpen
            'Return File and Path to a Variable
            strCaminho = .FileName
    End With
    MsgBox "Path: " & strCaminho

SAMPLE

Me in TechDays 2005 (Portugal) Cool!

THECHDAYS 2005 (Portugal - Lisbon) - 7 to 10 November

Cool Event!, Great Organization! Congratulations Microsoft Portugal

Image management in Microsoft Access

Great Tool for IMAGE MANAGEMENT Microsoft Access (97 to 2003)

DBPix by Ammara Digital Image Solutions

DBPix is an Image Control for building database applications with picture handling capabilities, such as photo databases and other image management systems.

DOWNLOAD http://www.ammara.com/downloads.html

SAMPLES http://www.ammara.com/support/samples/index.html

MAJOR FEATURES

ActiveX™ data-binding - handle images like conventional data.

Optimize quality, compression, performance, bandwidth & storage.

Add digital camera & TWAIN scanner support.

Manage web or intranet image content.

Create 'purposed' images - thumbnail, detail, print, archive etc.

Storage inside database tables, as external files, or a mixture of both, to build scalable & manageable solutions.

Automate image processing and content management.

Work with all common databases and field types, eg Access, SQL Server, Oracle, MySQL and other databases with Blob, OLEObject, or equivalent long binary data types for storage of images embedded in the database table.

Use with Microsoft® Access, Visual Basic®, Internet Explorer, Visual C++®, VBScript, VBA, DAO, ADO, RDS and more.

Compressed bitmap image storage using industry-standard jpeg encoding or lossless png.

Outlook, can not see all messages in Inbox or Folder (Messages Missing)

Outlook, can not see all messages in Inbox or Folder (Messages Missing)

WORKAROUND

See Image Bellow