Adding My Contact Details to Reports.

[Mike Abbott]

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

[Allen Browne]

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.

[Mike Abbott]

"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.