Printing list of fields - Microsoft Access / VBA

This has got to be easy, I want a list of all the fields in a
database. Is that possible?

Nov 13 '05 #1

1232

Loop through the TableDefs collection.
For each one, loop through the Fields collection.

This example shows how to loop through the Fields of a table, showing the
field name, type, size, and description of each:
http://allenbrowne.com/func-06.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.

"Richard Hein" <Ri******@HeinComputing.com> wrote in message
news:of********************************@4ax.com...

This has got to be easy, I want a list of all the fields in a
database. Is that possible?

Nov 13 '05 #2

Ed Robichaud

In case you overlooked it, there is a built-in documenter wizard in Access,
available from the Tools-Analyze-Documenter menu
-Ed

"Richard Hein" <Ri******@HeinComputing.com> wrote in message
news:of********************************@4ax.com...

This has got to be easy, I want a list of all the fields in a
database. Is that possible?

Nov 13 '05 #3

Similar topics

Printing stl::list objects in gdb

by: Michael Jasn | last post by:

Hi all, I am trying to print the contents of a std::list<Point> in gdb (actually ddd). I have this function void BezierCurveEvaluator::evaluateCurve(const std::vector<Point>& ptvCtrlPts) ...

C / C++

Printing a Word doc from Access

by: Stefania Scott | last post by:

I am trying to print a word document from Access. The code I've written works well in my computer but does not in the one were it is needed. Here the piece of code: 'doc path strObjectPath =...

Microsoft Access / VBA

Printing report programatically while the report is still processing

by: Richard Hollenbeck | last post by:

I have a report that is dynamically naming the columns and rows, etc., but I have way more columns (at least 37 at this time) than will fit on the report comfortably. So I have ten columns on the...

Microsoft Access / VBA

C# .NET web application - printing the forms

by: Suzanka | last post by:

Hello, I have an application written in C# on visual studio .NET. It is a web aplication. The application consists of many different forms, that users occassionaly want to print out for filing....

C# / C Sharp

Printing problem with aspx...

by: Smitha Nataraj | last post by:

Hello, Please let me know if you have the solution for a similar kind of problem... Background: I have an aspx page which is used as a report i.e. will be used for printing some information....

ASP.NET

Printing Word documents with C#

by: Laurent Navarro | last post by:

Hi, I created a C# application which opens a Word document, fills some fields and sends the whole document to the printer. Everything is working great but I find the printing step very slow....

C# / C Sharp

Printing from the print preview screen

by: Brad Pears | last post by:

I have a vb.net 2005 application and am using the print preview screen. This screen has a printer icon on it that the user can use to print the document currently being viewed. It uses the default...

Visual Basic .NET

Question: How do I format printing in python

by: joemacbusiness | last post by:

Hi All, How do I format printed data in python? I could not find this in the Python Reference Manual: http://docs.python.org/ref/print.html Nor could I find it in Matloff's great tutorial:...

Python

Multiple page printing with nested loops

by: it0ny | last post by:

Hi guys, thanks I am fairly new to this forum so I hope I chose the right place to post this question. I try to make my program printout a deposit's report. I created a class to store the...

Visual Basic .NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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,...

General

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

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...

General