Link to home
Start Free TrialLog in
Avatar of Cherylec
Cherylec

asked on

Ms Access Form Header Design

Can anyone please tell me how the form headers in the Northwinds Traders Database were created. I would like to polish up a database and I do like the way theirs looks, but can't find any info on how they created them.
In the properties form it just lists a basic color #C7C5BC, which is only the background color. I don't want to use the same colors, or the same pictures, but would like to know how the design was created, using the three different colors and the lines. I can't seem to click on anything in their header except for fields and pictures.
Thank You
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

i believe it was done using a template.
to see the form design definition as text file, you can save it as a text file with

application.saveastext acform, "home", currentproject.path & "\home.txt"

that will save the form's definition as a text file.

to make it simple, create a copy of the "Home" form and delete everything on it, save as "homex"

now run this


application.saveastext acform, "homex", currentproject.path & "\homex.txt"

open the the text file



Avatar of Cherylec
Cherylec

ASKER

thanks,
received "invalid outside procedure" acform
I am running this inside the database correct? or using the run cmd?
In design view. Header section, backcolor: click build button ... Then more colors...
Custom tab. Set individual color values- Red, Green and Blue.

Hnasr:
thanks for responding, do you know how they are getting the TWO different colors and the solid line? its some sort of design option that I don't see anywhere in the settings
<<I can't seem to click on anything in their header except for fields and pictures.>>

 Call up the property sheet for the form.  Everything on the format tab describes how the form looks (ie. Border Style, Picture, etc).

Jim.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've looked into this myself before and the headings are produced using an embedded image.  This is not produced by Access itsellf and so is not reproducable unless you have some means of extracting the image and saving it.
JDettman:
Thanks! you were mostly correct, but the properties I needed to set aren't in the header section properties, where I was concentrating my efforts. The entire form has to be selected then those format properties actually control the header as well when embedding an image.
After much experimenting, I do have it. I designed a banner in publisher saved as a picture and imbedded it in the form, then matched the settings with northwinds database.
thank you your comments made me take another look at the formatting for the entire form.
C
Peter57R wish I would have seen your post earlier!
It is a picture embedded, I was just assuming the formatting would take place in the header section properties!
I Created the same header design in publisher with a rectangle and a patterned fill, sized to the right size and saved as a png. and embedded it on the form.
thanks Everyone for your help!
would have been an A had it had instructions for creating the header I needed. but it did point me in the correct direction.