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: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Lynn
Sent: Monday, November 14, 2005 12:11 PM
To: ms_access@yahoogroups.com
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 ms_access@yahoogroups.com, "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 --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/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/
