Lynn- I don't think it's in the Running 2000 book. But you can download this from my website:
ftp://ftp.viescas.com/Download/Contacts2000.zip The code that uses the ComDlg class is in the CheckConnect function in modStartup. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lynn Sent: Thursday, November 17, 2005 12:41 PM To: [email protected] Subject: [ms_access] Re: msoFileDialogFilePicker - missing in 2000? Oh really? That's good news to be sure. I do have an Inside/Out book, but I'm sorry to say, it isn't yours. I have the 2002 one. If it's a matter of going out and picking up the 2000 one though, I could do that, no problem. Now, how would that work since I actually design in 2002? Just use the code you lay out in the example db's and then it should work for whoever of the users that use 2000? Thanks, Lynn Bryant Ball Ground, GA -- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Lynn- > > You can emulate the file picker in Access 2000 by using Windows API calls. > If you have any of the sample databases from my Inside Out or Building > books, all you need is the ComDlg class module and modify your code per the > examples. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Lynn > Sent: Thursday, November 17, 2005 11:21 AM > To: [email protected] > Subject: [ms_access] Re: msoFileDialogFilePicker - missing in 2000? > > Thanks, John...I 'opened' that version so that you wouldn't have to go > through a bunch of mess to see what you needed to see and thanks for looking > at it. Bad news on the FilePicker though :( but at least I have an answer. > Big thanks, as per usual, > > Lynn Bryant > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > > > Lynn- > > > > When I open your database, all I see is the Startup form - no > minimized DB > > window. I do, however, see the Properties window for all your > forms. You > > can fix that by running this bit of code: > > > > Sub FixAllowDesign() > > Dim objFrm As AccessObject, frm As Form > > ' Go through every form in the database > > For Each objFrm In CurrentProject.AllForms > > ' Open the form in Design view > > DoCmd.OpenForm FormName:=objFrm.Name, _ > > View:=acDesign > > ' Set the form object for efficiency > > Set frm = Forms(objFrm.Name) > > ' Check and reset the AllowDesignChanges property > > If frm.AllowDesignChanges = True Then > > frm.AllowDesignChanges = False > > ' Save the change > > DoCmd.RunCommand acCmdSave > > End If > > ' Close the form > > DoCmd.Close acForm, objFrm.Name > > ' Loop to the next form > > Next objFrm > > End Sub > > > > And finally, your database will not run in Access 2000 - the > picture code > > depends on the msoFileDialogPicker that is in the Office 10 > library, but > > it's not available in Office 9 (Access 2000). > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf > > Of Lynn > > Sent: Monday, November 14, 2005 12:11 PM > > To: [email protected] > > Subject: [ms_access] Re: msoFileDialogFilePicker - missing in 2000? > > > > Was anyone able to download my zipped db (in Files, AVDB.mdb) and > help me > > with the following? I've had others email me privately saying > they were > > having the same problem as I outlined below.....wondering if > anyone was able > > to figure out.... > > > > Thanks, > > > > Lynn Bryant > > Ball Ground, GA > > > > --- In [email protected], "Lynn" <[EMAIL PROTECTED]> wrote: > > > > > > The database that I designed for my friends has a glitch in the > > > picture addition section causing the Add/Edit Picture button not > > to > > > do anything at all when clicked. I'm being told that my problem > > is > > > as follows: > > > > > > You have a undefined variable: > > > msoFileDialogFilePicker in your code. Since Access uses VBA for > > > coding, I am not sure what the level is for coding versus regular > > VB > > > (VBA is scaled down). > > > > > > You would need to see where to declare the variable. Usually it > is > > > around the "Option Explicit" at the top. The lower level of > > access > > > VBA is not allowing the option explicit and is wanting it to be > > > declared separately. Unfortunately, after you fix this, you > might > > > bring up other code problems. > > > > > > > > > > > > I designed this DB in 2002, but the Default File Format is 2000 > > > (Tools/Options/Advanced). Can anyone help me here? I'll upload > a > > > zipped copy of the db to files, if I can. > > > > > > PS: Never was able to fix the Application Icon part...still > > brings > > > up a minimized DB window if anyone would care to fool with > that. > > I > > > know John asked me to upload the db last month, but I'm just now > > > getting to it. Big thanks to whoever can offer some assistance. > > > > > > Lynn Bryant > > > Ball Ground, GA > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor ------------------ -- > ~--> Get > > Bzzzy! (real tools to help you find a job). Welcome to the Sweet > Life. > > http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM > > ----------------------------------------------------------------- -- > -~-> > > > > > > Yahoo! Groups Links > > > > > > > > > ------------------------ Yahoo! Groups Sponsor -------------------- ~--> Get > fast access to your favorite Yahoo! Groups. Make Yahoo! your home page > http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM > ------------------------------------------------------------------- -~-> > > > Yahoo! Groups Links > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
