Forms and subforms (1 Viewer)

Q

QueryStumped

Registered User.

Local time

Today, 02:40

Joined

Mar 22, 2017

Messages

60

• Jul 28, 2019

• #1

Two tables linked on employee number, one shows employee info the other employee picture. Employee information table is imported into the database, which is the main form. Pictures have been uploaded, this is the subform. As of now the sub form only shows the pic as bitmap image, when you click on it, picture comes up. How can the picture automatically show once the employee number is searched?

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 02:40

Joined

Apr 27, 2015

Messages

6,317

• Jul 28, 2019

• #2

Hello there, have you tried putting the image field in the main form?

 

Q

QueryStumped

Registered User.

Local time

Today, 02:40

Joined

Mar 22, 2017

Messages

60

• Jul 28, 2019

• #3

I have which I would have to append the two tables into one, correct, via macro? Didn’t know if there was a way around that.

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 02:40

Joined

Apr 27, 2015

Messages

6,317

• Jul 28, 2019

• #4

Base the form’s record set on a query that combined all the fields you need instead of the table.

 

Q

QueryStumped

Registered User.

Local time

Today, 02:40

Joined

Mar 22, 2017

Messages

60

• Jul 28, 2019

• #5

Sorry I haven’t done that yet, but was thinking of merging the two together after importing into dB, via macro and then redesign the form. Just didn’t know if there was a way around that, to show the pic without double clicking on what the sub form shows “bitmap image”

 

Q

QueryStumped

Registered User.

Local time

Today, 02:40

Joined

Mar 22, 2017

Messages

60

• Jul 28, 2019

• #6

Thank you I will try that when I return to the office. Appreciate your quick assistance.

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 23:40

Joined

Oct 29, 2018

Messages

21,447

• Jul 28, 2019

• #7

QueryStumped said:

Sorry I haven’t done that yet, but was thinking of merging the two together after importing into dB, via macro and then redesign the form. Just didn’t know if there was a way around that, to show the pic without double clicking on what the sub form shows “bitmap image”

Click to expand...

Hi. What is the data type of the field with the picture? You can either try an image or an OLE control to display it.

 

Q

QueryStumped

Registered User.

Local time

Today, 02:40

Joined

Mar 22, 2017

Messages

60

• Jul 30, 2019

• #8

NauticalGent said:

Base the form’s record set on a query that combined all the fields you need instead of the table.

Click to expand...

Thank you Thank you... it worked, appreciate your help!!

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 02:40

Joined

Apr 27, 2015

Messages

6,317

• Jul 30, 2019

• #9

QueryStumped said:

Thank you Thank you... it worked, appreciate your help!!

Click to expand...

Glad i could help. Best of luck going forward...