how to enter image in access form

[jensonchandy]

hi friends

help needed in entering image into an access form.
plz tell me how to do it and to save it to the database

one more thing i need is i want to make my .mdb file to .mde
how to do that.
i'm using access2000
whenever i'm making the file to .mdb , it's showing an error that access cannot make the file an mde.....
reply needed

regards
jenson

 

[MarkK]

To make an .mde file you must compile your code first, and resolve any errors you encounter. Open a code window and go to Menu->Debug->Compile.

Someone else'll have to help you with the image.

 

[jensonchandy]

hi friend...

i need my database like an exe file
i have two .mdb files with me one my database and other contains forms and reports

when i open the .mdb file(reports&forms) the autoexec will come.
now what i want is when i close the mainform the entire .mdb should be closed.
how to do that

jenson

 

[MarkK]

Use this in your mainform...

Private Sub Form_Close()
Application.Quit
End Sub

 

[neileg]

help needed in entering image into an access form.
plz tell me how to do it and to save it to the database

With the form in design view go to Insert\Piture and browse for your image. You can drag it around and resize it.

Be careful as images can increase the size of the database file dramatically, much more than you would expect.

 

[jensonchandy]

when i'm entering the picture thru insert option only the file name is displaying on the object..the picture is not coming

 

[neileg]

Is the image type one that is supported by Access? Is it in a location that is accessible by the database? Try saving the image in the home folder for the database.