Database Report field - Microsoft Access / VBA

timcos

OK...I am creatiung a report...much like a letter.

I have a text box. It is supposed to hold the LLC Name'

The database is "Client Info List"

The field is called "LLC NAME"

The text box has in it..."=[Client Info List]![LLC NAME]" no quotes of
course in the actual text box.

When I preview my report...this field and all fields return the result
"#Name?" again no quotes on report preview.

What is this...I obviously have something wrong.

Thansk in advance.

Nov 13 '05 #1

Subscribe Reply

1611

jimfortune

tim...@gmail.co m wrote:

OK...I am creatiung a report...much like a letter.

I have a text box. It is supposed to hold the LLC Name'

The database is "Client Info List"

The field is called "LLC NAME"

The text box has in it..."=[Client Info List]![LLC NAME]" no quotes of course in the actual text box.

When I preview my report...this field and all fields return the result "#Name?" again no quotes on report preview.

What is this...I obviously have something wrong.

Thansk in advance.

If I understand you correctly, you are trying to use an Access Report
to do something like a mail merge in Word. If "Client Info List" is
actually the name of the table in the database then you can assign it
to the report's Record Source. Then you can put =[LLC NAME] in for the
Control Source of the text box. If you want to limit the number of
records returned you can use a query based on that table as the
report's Record Source.

You're welskome,

James A. Fortune

Nov 13 '05 #2

fredg

On 14 Feb 2005 07:55:34 -0800, ti****@gmail.co m wrote:

OK...I am creatiung a report...much like a letter.

I have a text box. It is supposed to hold the LLC Name'

The database is "Client Info List"

The field is called "LLC NAME"

The text box has in it..."=[Client Info List]![LLC NAME]" no quotes of
course in the actual text box.

When I preview my report...this field and all fields return the result
"#Name?" again no quotes on report preview.

What is this...I obviously have something wrong.

Thansk in advance.

The name of the Database is "ClientnfoL ist" or the name of the table
in the database is "ClientInfoList "? Which?

I suspect you mean the name to the table used.

Is the [LLC Name] field included in the Report record source?
If so just use a text control BOUND to [LLC Name] (no = sign or table
name, just [LLC Name] as the control source).

If it is NOT part of the report's record source, then you need to use
a DLookUp().
=DLookUp("[LLC Name]","[ClientInfoList]","[SomeIDField] = " &
[AControlValueon Report)
The Criteria portion of this expression determines if you get the
correct value.
Make sure the name of this control is not the same as the name of any
field in it's control source expression.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Nov 13 '05 #3

Sean

Make sure the Name of the Text Box is not the same as the Name of the
Control for the Text Box.

Nov 13 '05 #4

Similar topics

13381

How can I store a PDF file in a SQL database?

by: Karen Grube | last post by:

Hi! Each week, we receive a two-page PDF file from UPS along with a separate flat file (a CSV) The PDF file contains the overview of our weekly invoice and the CSV contains the details of each shipment. I download the file from UPS and then use DTS to import the data into SQL. At that point, I have a Crystal report that prints what looks like a regular UPS invoice. The only problem is that I wind up with having to print two...

.NET Framework

2287

problem with updating database

by: Foxster | last post by:

in access i have two tables (tblplayer, tblpoints) in tblplayer i have field totalpoint (number) in tlbpoints i have field pointgame (number) the two files are related via idplayer now i made a query "qrybegan" and in that query i calculate a field sumpointgame which is the sum of all the field pointgame (option sum in the query) i have put in the query also the field totalpoint from the tblplayer now i want to put the sumpointgame in...

Microsoft Access / VBA

1363

Can A2002 Reports have multiple Groups on total database records???

by: Richard Holliingsworth | last post by:

Hello: I'm building a report to display statistics on the entire database. I have successfully built a report that groups the entire db on one field and gives me a count of db records for the categories in that field and a total record count for the db. Now, I need to add another "total database" grouping to get another set of record counts. I DO NOT want to nest this group, It MUST consider ALL database records.

Microsoft Access / VBA

1608

Efficient database construction help

by: Tony Williams | last post by:

I have two groups of companies each producing the same statistics, however one group produces them in £ sterling and the other group (much smaller only 5 companies) produces them in Euros. They send in the information in the same format but in different currencies. I need to produce reports of ALL the companies, with the euro figures converted to sterling, and also a separate report for the Euro companies in Euros. Which would be the most...

Microsoft Access / VBA

293

Database Report field

by: timcos | last post by:

OK...I am creating a report...much like a letter. I have a text box. It is supposed to hold the LLC Name' The database is "Client Info List" The field is called "LLC NAME" The text box has in it..."=!" no quotes of course in the actual text box.

Microsoft Access / VBA

4853

Database documentation

by: Ray | last post by:

I just completed a database and would like to prepare the documentation for it. As I have no experience to do so, can someone advise me the essential elements for the documentation and any example available for reference. Thanks, Ray

Microsoft Access / VBA

3563

Database design question

by: MP | last post by:

Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this one data field - but i'm not sure) :-) Background info:

Microsoft Access / VBA

1296

Check Box in Report Based on a Date in the Database

by: cfwillia | last post by:

Hi, I'm trying to make a Report that will show a check box as checked off if there is a date in a certain field for the given record (instead of the field in the database being yes/no, each field has a date). Also, sometimes the check box may have to be checked when a date is in one field or another field (or like 5 fields). When there is no date in the field or any of the fields, the check box should not be checked. Alternatively, would I...

Microsoft Access / VBA

2849

Export one record from database including a picture as an OLE object

by: davidwelli | last post by:

Hello, I have a Access 200 format database that contains contact details and a picture for each record. The contact details are held in one table and the images are held in another as OLE Objects. This database is used to produce passes. I want to export one record from the dartabase including the picture into a format that can be easily tansferred by email. I've created a query based on the two tables that will retreive all the...

Microsoft Access / VBA

8432

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8343

Changing the language in Windows 10

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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8856

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8633

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7365

AI Job Threat for Devs

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6185

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4179

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2762

transfer the data from one system to another through ip address

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

C# / C Sharp

1992

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP