Very cool. Thank you. I'm leaving for NY tomorrow, so I'll try it when I get back in town and have time to mess with it.
Lynn Bryant <--Georgia Peach headed north! Watch out NY! Ball Ground, GA --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
