How to import bmp images in Access

  • Thread starter Thread starter Guest
  • Start date Start date
Here is one way to get a .bmp into Access.

Storing bitmap or other object:
Create Table1. Create Field1 with type OLE Object. (allows you to store
objects in the table)

Inserting a bitmap or other object
Create Form1.
Draw a Bound Object Frame (from the Toolbox toolbar) called Control1
Create Button1 and this associated code for OnClick of the button

Private Sub Button1_Click()
Control1.SetFocus
DoCmd.RunCommand acCmdInsertObject
End Sub

When you click the button, you can choose the type of object to insert or
create a new one. If you choose to create from a file, you can browse to the
picture.

Once inserted, the table will display information about the object and the
bound object frame will actually show it.

Not sure if this helps.
 
Back
Top