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

https://www.mikethebass.moonfruit.com

[Allen Browne]

Re: Adding My Contact Details to Reports.

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("TheVa lue", "MyDetails" , "TheVariable='O nwerName'")

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" <mikethebass@ms n.com> wrote in message
news:duebaq$1cb $1@news6.svr.po l.co.uk...[color=blue]
>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.[/color]

[Mike Abbott]

Re: Adding My Contact Details to Reports.


"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:440ab849$0 $23743$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
> 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("TheVa lue", "MyDetails" , "TheVariable='O nwerName'")
>
> 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" <mikethebass@ms n.com> wrote in message
> news:duebaq$1cb $1@news6.svr.po l.co.uk...[color=green]
> >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[/color][/color]
the[color=blue][color=green]
> > 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.[/color]
>[/color]
Thanks Allen,

that worked fine after some experimentation .

Mike Abbott.