[AccessD] tsGetFileFromUser()

Patti:

A little late to the thread and haven't been following it because I was away
for a few days.  But I use the common file open/save dialog box all the time
from code I cribbed from the ADH.  I could send it to you off line if that's
what you're looking for.  Or is there some other issue that this won't
satisfy?

HTH

Rocky


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, January 18, 2007 12:56 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.13/634 - Release Date: 1/17/2007
4:45 PM