Microsoft Access 2003

T

teenster

How do you link a column from a table to show in a report. When I type the
expression it shows #name?. I don't know how to get it to show the date from
the column.
 
A

Arvin Meyer

Typically, all you need to do is type the field name into the controlsource
of the textbox that you want to display the data. The form or report must
have the table, or a query based on the table as the recordsource.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
E

Ernie

-----Original Message-----
Typically, all you need to do is type the field name into the controlsource
of the textbox that you want to display the data. The form or report must
have the table, or a query based on the table as the recordsource.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

report. When I type
the to show the date
from


.
Click to expand...
Also, if your column name has one or more spaces in it you
need to enclose it in square brackets [My Column Name]
 
A

Arvin Meyer

Also, if your column name has one or more spaces in it you
need to enclose it in square brackets [My Column Name]
Click to expand...

Actually, that's not necessary in the controlsource property, or in the QBE
query grid. It is necessary in code (unless you are using quotes) or when
fully qualifying a field in a form, report, or query. Square brackets are
also sometimes necessary, even with a single word, when identifying a field
which is a reserved word. (Like the a field named [Date]). Since I never use
reserved words as field names, I can't give you the specifics from
experience.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
A

Arvin Meyer

First you set the form's recordsource property to the query. Then you set
the text box's control source to: Hire Date
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

teenster said:
Thank you for your response. The record source is a query but the data I am
trying to have show up is from a table. Could that be the problem? Or maybe
what I have typed in the controlsource field is =
![Employee
Info]![Hire Date] is incorrect.

Thank you,

Arvin Meyer said:
Typically, all you need to do is type the field name into the controlsource
of the textbox that you want to display the data. The form or report must
have the table, or a query based on the table as the recordsource.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

type
the date
from
Click to expand...
Click to expand...
 
Top