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

Adding My Contact Details to Reports.

P: n/a
A fairly recent convert to Access I have succeeded in getting it to work
well on my current fairly simple requirements.

Can someone help me with another step?

I have three simple reports.

Income / Expenses and Car Business Usage.

These are mainly for the Tax office and I would like to add my name address
etc to the report header section.

I could add it as a label, but there is presumably a way of displaying the
one record of a table called My details.

Can anyone point me in the right direction?

I have not yet got to grips with VBA / SQL programming.
Thanks
Mike

www.mikethebass.moonfruit.com


Mar 5 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Use DLookup() to retrieve the value from the table and place it on the
report.

Let'a assume your MyDetails table has these 2 fields:
TheVariable Text (primary key)
TheValue Text

Enter records like this:
TheVariable TheValue
======== =======
OwnerName Acme Limited
OwnerAddress 99 Some Street, SomeTown

On your report, you can set the Control Source of a text box to:
=DLookup("TheValue", "MyDetails", "TheVariable='OnwerName'")

For more info on how to use DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Abbott" <mi*********@msn.com> wrote in message
news:du**********@news6.svr.pol.co.uk...
A fairly recent convert to Access I have succeeded in getting it to work
well on my current fairly simple requirements.

Can someone help me with another step?

I have three simple reports.

Income / Expenses and Car Business Usage.

These are mainly for the Tax office and I would like to add my name
address
etc to the report header section.

I could add it as a label, but there is presumably a way of displaying the
one record of a table called My details.

Can anyone point me in the right direction?

I have not yet got to grips with VBA / SQL programming.

Mar 5 '06 #2

P: n/a

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:44***********************@per-qv1-newsreader-01.iinet.net.au...
Use DLookup() to retrieve the value from the table and place it on the
report.

Let'a assume your MyDetails table has these 2 fields:
TheVariable Text (primary key)
TheValue Text

Enter records like this:
TheVariable TheValue
======== =======
OwnerName Acme Limited
OwnerAddress 99 Some Street, SomeTown

On your report, you can set the Control Source of a text box to:
=DLookup("TheValue", "MyDetails", "TheVariable='OnwerName'")

For more info on how to use DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Abbott" <mi*********@msn.com> wrote in message
news:du**********@news6.svr.pol.co.uk...
A fairly recent convert to Access I have succeeded in getting it to work
well on my current fairly simple requirements.

Can someone help me with another step?

I have three simple reports.

Income / Expenses and Car Business Usage.

These are mainly for the Tax office and I would like to add my name
address
etc to the report header section.

I could add it as a label, but there is presumably a way of displaying the one record of a table called My details.

Can anyone point me in the right direction?

I have not yet got to grips with VBA / SQL programming.

Thanks Allen,

that worked fine after some experimentation.

Mike Abbott.


Mar 5 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.