Form for uploading Page headers

[buzzbait9]

Hello,

I built a form that will allow each page header to take the info needed depending on who is using the data base. I seem to be having a problem having the Logo uploaded so that it can be used. Since I am new to Access, my only example would be like a web page. use the location of the picture in the code and it pulls it up for each page associated.

I'm not understanding this process in Access 2010.

I guess this would be 2 questions. How do I add to my form the upload of the graphics and how do I get the reports and forms to pull that picture into the header every time.

Thanks

 

[arnelgp]

the concept is very complex.
first you need to have a table that will hold the username, formname and attachment that will hold the picture of each form.
then when the form opens you will search this table for the current username, and formname.
then you will have to save the attachment picture to a temporary location.
then you will load the picture to your image control.

 

[buzzbait9]

Thanks for the quick response.

The database is unique for each user. This is not a front end that is used by everyone, just a separate duplicate front end distributed to each user. Each user will fill out the Project form with the information, for there own project for the header and (hopefully) add an image for the logo. One time done. I can have the header fields grab the info for the project, I just need it to take the photo, that was uploaded on that form, and use it for their front end. A different user will have a separate front end that is not associated with any other user and will fill out their own project form with a logo.

Does that make sense?

Thanks

 

[arnelgp]

i dont understand.
here is an example, maybe you will find use to it.
the idea is to create a table in backend db and link it to the fe.

 

[buzzbait9]

Thank you so much for that Sample. It is not what I needed but I can see using that in the near future.

Let me Try once again.

This data base is a master database. it is sent "empty" to each user. Only that user will use it by adding their own records. It is not linked to any other user's accounts. When the user gets the database, they have to fill out a form that indicates their Project information and upload their Client logo.

The information and logo are for the headers for all reports and forms. No choices or changes are made by any other user.
It makes the DB no longer a master but tht projects database.
Does that sound easier?
No drop down, no if nothing statements. Only a module to tell the folder to use what the project requires.
Thank you again

 

[arnelgp]

can you upload your db, that i may take a look.