TABLES

The UK's most regular instructor-led training courses.
Training information: 2000 access microsoft training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2003

8 posts

ReplyMon 26 Oct 2009, 13:46Delegate Felice said...

Felice has attended:
Excel Introduction course
Word Advanced course

TABLES

When my table is in design view, can I print off a list of headings (Field names)

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

336 posts

ReplyMon 26 Oct 2009, 15:19Trainer Anthony said...

RE: TABLES

Hi Felice, thanks for the query. You can't directly print off a list of the fields from table design view, but you can use the Documenter tool to do something very similar.

Save your table, and then select Tools - Analyze - Documenter. Select the table you want to analyze by ticking the relevant box, then choose Options. In there you can drill down to the information you want. Selecting just "Names, Data Types And Sizes" is fine. Click OK twice and the result will be a document you can print with breakdown information of your selected table in it.

Hope this helps,

Anthony

8 posts

ReplyTue 27 Oct 2009, 08:12Delegate Felice said...

RE: TABLES

Hi Anthony

I have tried the above but after I get to selecting just "Names, Data, Type and Sizes" and then click OK and OK again, I get
"No objects were selected".
Where am I going wrong.
Felice

· Why a Microsoft Access Course Could Change the Way You Do Business
· Microsoft Access 2007: New Features
· Microsoft Access: Unleash the True Potential Today
· Data validation in MS Access
· Supersizing your databases via Microsoft Access

Please browse our web site to find out more about
2000 access microsoft training and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###�s.

You could widen the column to make the date and time show, but sometimes this is not convenient: the column may already be exactly the width you want to accommodate all entries in cells further below. Maybe you don�t want to push any other columns any further to the right, because you won�t be able to see the column contents on one screen, or because it forces you to change the print settings.

The solution is to use the TEXT function to convert the value returned by NOW to text: text (as opposed to a value) stretches into the next column rather than returning ###�s. The TEXT function has two arguments: 1. the value to convert to text; 2. what format to show it in. Use custom number codes in double quote marks to specify the format. For example =TEXT(NOW(),�ddd dd/mm/yy hh:mm�) will return date and time using the format FRI 09/04/04 11:24.

View all Access hints and tips