On Feb 14, 11:51 pm, "Rex" <rakesh...@gmail.com> wrote:
> Hi
>
> I am using Access as a front end for my SQL Server 2000 database. I
> want to store images straight in the database. I want to write a VBA
> code inorder to do the following:
>
> 1. Upload an image in the database
> 2. See the image on my form when I navigate through each records of
> images.
>
> I am not a good VBA programmer and so I am not able to figure out how
> to do this..
>
> Any help would be appreciated...
>
> Thank you
> Rex

On Feb 16, 12:20 am, "raibeart" <raibe...@gmail.com> wrote:
> Rex,
>
> You do not want to store in the database with Access. Access will
> also store the program to open the image with it. Very big bloat.
>
> Put your images in a directory.
> Store the full path to the image, including the name of the image in
> the database.
> Use the image control on your form.
> Write the code to requery the image control with the new image
> location as you change records.
> Put the code in the OnCurrent event of the form.
>
> Robert
>
> On Feb 14, 11:51 pm, "Rex" <rakesh...@gmail.com> wrote:
>
>
>
> > Hi
>
> > I am using Access as a front end for my SQL Server 2000 database. I
> > want to store images straight in the database. I want to write a VBA
> > code inorder to do the following:
>
> > 1. Upload an image in the database
> > 2. See the image on my form when I navigate through each records of
> > images.
>
> > I am not a good VBA programmer and so I am not able to figure out how
> > to do this..
>
> > Any help would be appreciated...
>
> > Thank you
> > Rex- Hide quoted text -
>
> - Show quoted text -