[AccessD] tsGetFileFromUser()

Hi Patricia

This code seems to use the open file dialogue of Access, not that (the common) of Windows:

Declare Function adh_accOfficeGetFileName Lib "msaccess.exe" _
 Alias "#56" (gfni As adh_accOfficeGetFileNameInfo, ByVal fOpen As Integer) As Long

However, as you can read from the message, this won't work for A2003 and probably neither for A2007. The internal function "#56# has changed to something else but who knows what?

Arthur: Patti wish to open the file dialogue box with the view "Details" selected as default.

/gustav

>>> Patricia.O'Connor at otda.state.ny.us 17-01-2007 22:51 >>>
Thanks Art Gustav
You would think MS would have it documented somewhere.  I searched through Google didn't find very much. Here

http://p2p.wrox.com/topic.asp?TOPIC_ID=6064 

I found some code but not sure where to exactly put things.  Tried to modify mine a little but it kept erroring so I kept the original


Thanks 
Patti