By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Insert company details in report

P: 2
Hi everybody. I would like to add my company details to a report so that my company details remain on the report always. For example all the other text boxes will be bound and changeable except my company details which I want to remain constant on every report. Can someone help me out?
Aug 22 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 184
All you need to do is do unbound controls on the design view of your Report.
Create labels, insert images, etc. Just don't put textboxes, combo boxes anumore, I normally just use Images and Labels, lines, and rectangles for this types of Report letterheads.
Aug 22 '08 #2

P: 2
OK thanks I'll give it a shot...
Aug 22 '08 #3

P: 69
Another thought here: it may be appropriate to have the company logo included in address details. In such a case an elegant solution is to create the logo and text in a graphics program, export it as a .gif or .jpg, which can be added to a table with one records and two fields. One field is a long integer ID, the other an OLE object. The table can be a bit more user friendly. I tend to add a field describing what is in the graphic for instance, because I frequently have more than one logo, or whatever. When the logo/address is needed in a form or a report, it can be used by having a bound object field with its data source a Dlookup and its format set to stretch or zoom. Doing it this way, when things change - telephone numbers, etc. - you only have to fix it in ne place

Like everything in Access, there are upsides and downsides. The upside is that the format of the address lines or whatever doesn't have to be set each time and you know that the relative positioning of the various elements will be unchanged. The downsides are that Access doesn't store graphics particularly efficiently, so if you go for high resolution of a big image you may end up with a large table. Using the table approach reduces this by not storing multiple images, one in each form, report. There will also be some time delay when the image is loaded. I've done this often - I put my trading logo on forms that I design for clients, for instance - and have never found the delay unacceptable.
Aug 23 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.