Graphics in Access Forms

[DenverDb]

I am curious to see the kinds of graphics that other people put in their forms and reports. Over the years I have put volcanoes, racetracks, gauges, and images of planets and the moon into my forms and reports.

One of my favorites is this gauge. The numbers are calculated using a five-level Likert scale. The code uses the .Visible method. The code is very simple.

The statements in the middle of the screenshot control the colors of the squares. The squares use conditional formatting.

I created the gauge in PowerPoint and pasted it into the Access form.

Two of the text boxes are multi-value fields. They are used to ensure consistency.

The checkboxes open forms that tell the user what the statements may mean to the business.

This form also reads the scores aloud. Many of my forms and reports use speech.

This was one of my earliest forms with a graphic so it is crude.

 

[arnelgp]

Home screen:

and Instructions screen on correct format of Excel file to import to the system:

I always use graphics on my Home screen:

also notice, i am always using a customized ribbon.
so app has familiar looks like in office, adobe, etc.

 

[The_Doc_Man]

The only graphics I was allowed to use for my big Navy project was a watermark background of the (then) SPAWAR logo for my main screen of my switchboard. And it was boring, but... the right way, the wrong way, and the Navy way.

 

[DenverDb]

Home screen:
View attachment 109300



and Instructions screen on correct format of Excel file to import to the system:
View attachment 109301

Thanks Arnelgp. Very nice.

I also have a cityscape in my application. I like yours as a switchboard.

 

[DenverDb]

The only graphics I was allowed to use for my big Navy project was a watermark background of the (then) SPAWAR logo for my main screen of my switchboard. And it was boring, but... the right way, the wrong way, and the Navy way.

Thanks, The_Doc_Man. The only graphics that I created when I was in the government were geochemical diagrams. I created so many that my friends gave me an award for them when I moved to a new duty station. Now you have an opportunity to go crazy. I love adding graphics to my applications.

 

[ebs17]

Access can also paint: Small project with the implementation of the LOGO programming language with own language definition

Codebeispiel - Access kann auch malen - MS-Office-Forum

Access kann auch malen Microsoft Access - Code Archiv

www.ms-office-forum.net

 

[lacampeona]

Hi Arnel
how you create that special ribbon?

 

[arnelgp]

you need to create a special table, usysRibbons and on the Option menu you set which Ribbon menu to show.
see this article: Create a custom ribbon in Access - Microsoft Support

 

[lacampeona]

ok thank you. So if I follow all the instructions I will be able to create that ribbon so nice like you made?

Do you have also some simple example to show?

thank you

 

[DenverDb]

Here's a form with a graphic that was created today.

The curve is a timeline.

The buttons on the right are command buttons that will open forms to the active proposal. All of those forms are main form/subform pairs with embedded graphics. Buttons on the forms open main report/subreport pairs with their own graphics.

The curve and thumbnails were created in PowerPoint and pasted into Access using Snip and Sketch. The thumbnails are screenshots and were resized to the same height and width. Clicking the Show Dates button will display dates for each record.

What do you think?