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 2 1242
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" <mi*********@ms n.com> wrote in message
news:du******** **@news6.svr.po l.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.
"Allen Browne" <Al*********@Se eSig.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("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" <mi*********@ms n.com> wrote in message news:du******** **@news6.svr.po l.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Guy Mahieu |
last post by:
All,
Is there a simple way to manipulate the details section of a Crystal Report
at runtime on a per-record basis?
The reason I want to do this is that my database table contains an image url
field, but in my report I have to show the image rather than its location.
I have looked for events that would be thrown when CR generates the...
|
by: Mike Turco |
last post by:
My phone directory project is moving along. Its a series of reports and
documents that all get imported into Word, via RTF files or whatever.
I need to create a couple of indexes. Is there a way to insert the index
marks within a database report, such that when I export the file to RTF,
word will recognize those indexes?
Thanks,
Mike
|
by: kosecki |
last post by:
Hi,
I'd like to do something like that:
I've a sql database which has a lot of email adresses, I've wonder if I
can export thems into Outlook 2003 Address Book because I need to
synchronize it.
Data from sql server is in dataset.
Greetings, Peter
|
by: kammaldeep |
last post by:
hi,
i m newbie 2 PHP & to b frank ... will alwaz be ... i dont think i will go into much details with PHP as my work doesnot include workin with PHP
bt i have a forum .. and i want to make a personal contact page in it .... and save all details in my new database....
i have website in the root folder
i get dis error
|
by: chutney |
last post by:
Dear all, please excuse the fact that this is not an explicit problem I have, but more of a general query.
I have an Access database (2003) with a load of contact details in it. Including various fields for each contact, such as services they offer, where they are, main contact name etc.
Some of these contact details will be out of date and...
| |
by: Gilles Ganault |
last post by:
Hello
I'd like to find a basic PHP+MySQL contact manager, so that we can
keep a list of our customers, and a contact history (ie. whenever they
call us for a problem, it'll be in the file). There may be other nice
features I should know about, but I don't want any of those enterprise
softwares like SugarCRM etc. that are just too...
|
by: rcollins |
last post by:
I have a report that gives me contact info for each client. We run these reports every month, ie, 4/1/2008-4/30/2008. As it is now we get the lients who have had contact for the month. What I would like to do is to have the clients with no contact listed too, or to have a list on the side who have no contact. I have made an find unmatched query,...
|
by: hedges98 |
last post by:
Sorry for the mouthful of a title!
Basically, I have a form with tabbed controls (Personal/Contact Details, Referral Information, Case Info/Status etc.) and I want to add a tabbed control form inside one of the existing tabs.
At the moment there are two tabs called Appointments and Group Appointments. What I want to do is add a tabbed...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |