A form displays 10 fields.
I need to be able so select the fields that I want export so the user can personalize his report.
Any idea.
Novice
Windows XP 
Access 2003
A form displays 10 fields.
I need to be able so select the fields that I want export so the user can personalize his report.
Any idea.
VIP
Windows XP Access 2010 32bit
Export to where?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows XP Access 2003
At present I have a macro that export all form contain in excel format.
VIP
Windows XP Access 2010 32bit
I don't use macros, only VBA. I doubt a macro can accomplish what you want.
Do you want to export one record or a set of records? User wants to pick specific fields for export? Review this thread http://forums.aspfree.com/microsoft-...el-414974.html
An alternative might be to have Excel link to Access table.
Can't build Access report to accommodate the user?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote