|
|
Okay, I've googled for this and only found one posting for this strange
behaviour in Access 2007 - and no solution.
I am running a 2003 db mode and when I occasionally make changes to various
forms -not even the popup forms!- and compile, make an mde, and re-open,
some of the popup forms open as a "sliver" about 1/4" by 1/2", and it is
really hard to even close them, let alone stretch them to a readable size.
This appears to happen randomly, sometimes not at all, sometimes to one or
two forms, and sometimes to only one form.
Two ?s:
1. Anyone else experience this? and
2. Any one have ideas on how to prevent this -maybe some code in the popup
forms, or???
Thanks in advance
Damon
|
|
Probably doesn't apply to your issue, but I had random form corruption
taking a db created from SourceSafe in Access 2003 and using it in Access
2007. The reliable solution was to open EVERY form in Access 2003 before
letting Access 2007 touch the db. I wrote a routine to automate the process
if you want to try it.
Dim frm As AccessObject 'Temporary form
Dim strFormName As String 'Name of the current form
'Open and close each form
For Each frm In CurrentProject.AllForms
strFormName = frm.Name
Select Case strFormName
Case "frmTableOfContents", "frmAbstractDialogModeDupSub"
'Don't open these forms because they generate errors when used
this way.
Case Else
DoCmd.OpenForm FormName:=strFormName, View:=acNormal,
WindowMode:=acWindowNormal
Call pjsWait(lngMilliSecs:=250) 'API code that waits 250 msec
DoCmd.Close acForm, strFormName
End Select
Next frm
"Damon Heron" <damon_327[ at ]hotmail.com> wrote in message
news:OvmGuAbUJHA.5284[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > Okay, I've googled for this and only found one posting for this strange
> behaviour in Access 2007 - and no solution.
> I am running a 2003 db mode and when I occasionally make changes to
> various forms -not even the popup forms!- and compile, make an mde, and
> re-open, some of the popup forms open as a "sliver" about 1/4" by 1/2",
> and it is really hard to even close them, let alone stretch them to a
> readable size. This appears to happen randomly, sometimes not at all,
> sometimes to one or two forms, and sometimes to only one form.
> Two ?s:
> 1. Anyone else experience this? and
> 2. Any one have ideas on how to prevent this -maybe some code in the popup
> forms, or???
|
|
Thanks for your input. I have decided for now to work on my laptop, which
has 2003 Access, and complete all coding changes, etc. there before I port
it to my PC (where 2007 resides). This solves the problem with the "sliver"
forms, so I know it is something in 2007 that is causing this.
I am one of those who is not a big fan of the 2007 interface, anyway, so
this will make it less stressful. I only use 2007 because of the one nice
feature--creating a runtime version for those who don't have Access
installed. This is worth the cost of the software, in my opinion.
Damon
"Paul Shapiro" <paul[ at ]hideme.broadwayData.com> wrote in message
news:O76IzxoUJHA.588[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > Probably doesn't apply to your issue, but I had random form corruption
> taking a db created from SourceSafe in Access 2003 and using it in Access
> 2007. The reliable solution was to open EVERY form in Access 2003 before
> letting Access 2007 touch the db. I wrote a routine to automate the
> process if you want to try it.
> Dim frm As AccessObject 'Temporary form
> Dim strFormName As String 'Name of the current form
>
> 'Open and close each form
> For Each frm In CurrentProject.AllForms
> strFormName = frm.Name
> Select Case strFormName
> Case "frmTableOfContents", "frmAbstractDialogModeDupSub"
> 'Don't open these forms because they generate errors when used
> this way.
> Case Else
> DoCmd.OpenForm FormName:=strFormName, View:=acNormal,
> WindowMode:=acWindowNormal
> Call pjsWait(lngMilliSecs:=250) 'API code that waits 250
> msec
> DoCmd.Close acForm, strFormName
> End Select
> Next frm
>
>
> "Damon Heron" <damon_327[ at ]hotmail.com> wrote in message
> news:OvmGuAbUJHA.5284[ at ]TK2MSFTNGP06.phx.gbl...
>> Okay, I've googled for this and only found one posting for this strange
>> behaviour in Access 2007 - and no solution.
>> I am running a 2003 db mode and when I occasionally make changes to
>> various forms -not even the popup forms!- and compile, make an mde, and
>> re-open, some of the popup forms open as a "sliver" about 1/4" by 1/2",
>> and it is really hard to even close them, let alone stretch them to a
>> readable size. This appears to happen randomly, sometimes not at all,
>> sometimes to one or two forms, and sometimes to only one form.
>> Two ?s:
>> 1. Anyone else experience this? and
>> 2. Any one have ideas on how to prevent this -maybe some code in the
>> popup forms, or???
>
|
|
|