About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Using MS Access - Access 2003: how to print table design info
Expert: Rob Henderson - 2/16/2005
Question That's my question to you, actually. How can I do this? I can try vba, but I don't know the code. That's the part I need help with. Thank you!
-------------------------
Followup To
Question -
Is there a way in Access 2003 to print what I visually can see on the screen in Table, Design Mode? Meaning, I'd like to have a printout that includes the fieldnames, data types, and descriptions. I know the documentor feature can print these items, but they come along with a bunch of other stuff I don't need (unless there is a way I don't know about to only print these 3 items I'd like). And if there is not a way to do this directly in Access, can it be done via Excel somehow (via a macro, perhaps)? Thanks very much for your time!
Answer -
Hi
You could do this in VBA but not a macro on it's own.
The simplest way would be to create a screenshot but wether that's any use I'm not sure.
Is VBA an option?
rob
Answer Hi
The reason I suggested VBA was because I didn't know your skill level.
I don't have a working example I can give you but would say you can achieve this quite easily by a combination of setting a DAO table def reference and then playing about with the particular properties you need.
Dim tbl As DAO.TableDef
Set tbl = CurrentDb.TableDefs("sometable")
Using the above syntax and intellisense you can suss out what information is available to you.
For example,
[tbl.Name] obviously represents the name of the object table.
There is an example which I think may fit your purposes quite well - The Access Developers Handbook - but it's not online so you'll have to purchase/ borrow a copy (it's more than well worth the money)
If you need some more assistance with the detail in the code when you have what you need (in terms of fields, etc) - give me a shout.
PS: If you're using Access2000+ remember to set a reference to the DAO library.
