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 <*> 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/
