PC Review


Reply
Thread Tools Rate Thread

Access 2007 Problem

 
 
John M
Guest
Posts: n/a
 
      14th Apr 2009
I just recently updated from 2002 to 2007. Now i find some of my forms when
opened are just a small square in the top left corner of the screen. i have
tried resizing them and they work fine till i close the program and then
reopen it, when they go back to the small square again. Also, in the process
of expanding the forms, sometimes Access crashes and comes up with an error
message to send to microsoft. This is extremely tiresome and sometimes makes
the program nearly unusable. This never happened at all in 2002
As i use it for my business any help on this matter would be greatly
appreciated.

John M
 
Reply With Quote
 
 
 
 
Danny J. Lesandrini
Guest
Posts: n/a
 
      14th Apr 2009
What happens if you put this code in the Open event?

DoCmd.Maximize
or
DoCmd.Restore

Also try adding & playing with this.
DoCmd.MoveSize 0,0,4000,4000


Alternatively, if any of these exist, try commenting them out and see if that helps.

Also, check to see if there is any code on the Form_Resize()event.
--
Danny J. Lesandrini
(E-Mail Removed)
www.amazecreations.com


"John M" <(E-Mail Removed)> wrote ...
>I just recently updated from 2002 to 2007. Now i find some of my forms when
> opened are just a small square in the top left corner of the screen. i have
> tried resizing them and they work fine till i close the program and then
> reopen it, when they go back to the small square again. Also, in the process
> of expanding the forms, sometimes Access crashes and comes up with an error
> message to send to microsoft. This is extremely tiresome and sometimes makes
> the program nearly unusable. This never happened at all in 2002
> As i use it for my business any help on this matter would be greatly
> appreciated.
>
> John M



 
Reply With Quote
 
Damon Heron
Guest
Posts: n/a
 
      14th Apr 2009
I struggled with the same problem when I switched to 2007. I called them
"sliver forms". Eventually, I ended up setting the width and height of all
my forms in the form resize event:

DoCmd.MoveSize , , 6040, 5040 '(thats right, down, width, height)

and I also set auto resize property to no, although don't know if this was
necessary.

Damon


"John M" <(E-Mail Removed)> wrote in message
news:B1303E03-7D76-487D-848B-(E-Mail Removed)...
>I just recently updated from 2002 to 2007. Now i find some of my forms when
> opened are just a small square in the top left corner of the screen. i
> have
> tried resizing them and they work fine till i close the program and then
> reopen it, when they go back to the small square again. Also, in the
> process
> of expanding the forms, sometimes Access crashes and comes up with an
> error
> message to send to microsoft. This is extremely tiresome and sometimes
> makes
> the program nearly unusable. This never happened at all in 2002
> As i use it for my business any help on this matter would be greatly
> appreciated.
>
> John M



 
Reply With Quote
 
Mark Andrews
Guest
Posts: n/a
 
      14th Apr 2009
I've seen the small square. I just resized the screen and pressed save and
it seemed to take from then on.

Not sure on the crashing, do you have SP1.
Try Allen brownes site for tips on crashing.

Mark
RPT Software
http://www.rptsoftware.com

"John M" <(E-Mail Removed)> wrote in message
news:B1303E03-7D76-487D-848B-(E-Mail Removed)...
>I just recently updated from 2002 to 2007. Now i find some of my forms when
> opened are just a small square in the top left corner of the screen. i
> have
> tried resizing them and they work fine till i close the program and then
> reopen it, when they go back to the small square again. Also, in the
> process
> of expanding the forms, sometimes Access crashes and comes up with an
> error
> message to send to microsoft. This is extremely tiresome and sometimes
> makes
> the program nearly unusable. This never happened at all in 2002
> As i use it for my business any help on this matter would be greatly
> appreciated.
>
> John M



 
Reply With Quote
 
John M
Guest
Posts: n/a
 
      25th Apr 2009
Sorry for so long to reply
The DoCmd.Restore wouldnt work consistantly. I have found using the Movesize
command is the only one that totally fixes the problem. It has meant i have
had to go through all my forms and set the size in the 'on load' event. But
at least it now works.
Thank you very much, and the others that replied as well, for your help.

John M.

"Danny J. Lesandrini" wrote:

> What happens if you put this code in the Open event?
>
> DoCmd.Maximize
> or
> DoCmd.Restore
>
> Also try adding & playing with this.
> DoCmd.MoveSize 0,0,4000,4000
>
>
> Alternatively, if any of these exist, try commenting them out and see if that helps.
>
> Also, check to see if there is any code on the Form_Resize()event.
> --
> Danny J. Lesandrini
> (E-Mail Removed)
> www.amazecreations.com
>
>
> "John M" <(E-Mail Removed)> wrote ...
> >I just recently updated from 2002 to 2007. Now i find some of my forms when
> > opened are just a small square in the top left corner of the screen. i have
> > tried resizing them and they work fine till i close the program and then
> > reopen it, when they go back to the small square again. Also, in the process
> > of expanding the forms, sometimes Access crashes and comes up with an error
> > message to send to microsoft. This is extremely tiresome and sometimes makes
> > the program nearly unusable. This never happened at all in 2002
> > As i use it for my business any help on this matter would be greatly
> > appreciated.
> >
> > John M

>
>
>

 
Reply With Quote
 
BATISTA RIBEIRO JOAO SAMUEL JOAO SAMUEL BATISTA RI
Guest
Posts: n/a
 
      26th Apr 2009

"John M" <(E-Mail Removed)> a écrit dans le message de
news:12DC3E67-1BC1-4A1A-80B6-(E-Mail Removed)...
> Sorry for so long to reply
> The DoCmd.Restore wouldnt work consistantly. I have found using the
> Movesize
> command is the only one that totally fixes the problem. It has meant i
> have
> had to go through all my forms and set the size in the 'on load' event.
> But
> at least it now works.
> Thank you very much, and the others that replied as well, for your help.
>
> John M.
>
> "Danny J. Lesandrini" wrote:
>
>> What happens if you put this code in the Open event?
>>
>> DoCmd.Maximize
>> or
>> DoCmd.Restore
>>
>> Also try adding & playing with this.
>> DoCmd.MoveSize 0,0,4000,4000
>>
>>
>> Alternatively, if any of these exist, try commenting them out and see if
>> that helps.
>>
>> Also, check to see if there is any code on the Form_Resize()event.
>> --
>> Danny J. Lesandrini
>> (E-Mail Removed)
>> www.amazecreations.com
>>
>>
>> "John M" <(E-Mail Removed)> wrote ...
>> >I just recently updated from 2002 to 2007. Now i find some of my forms
>> >when
>> > opened are just a small square in the top left corner of the screen. i
>> > have
>> > tried resizing them and they work fine till i close the program and
>> > then
>> > reopen it, when they go back to the small square again. Also, in the
>> > process
>> > of expanding the forms, sometimes Access crashes and comes up with an
>> > error
>> > message to send to microsoft. This is extremely tiresome and sometimes
>> > makes
>> > the program nearly unusable. This never happened at all in 2002
>> > As i use it for my business any help on this matter would be greatly
>> > appreciated.
>> >
>> > John M

>>
>>
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Access 2003 User Security DB opening with Access 2007 Donna Microsoft Access Security 4 20th May 2010 05:58 PM
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Microsoft Excel Misc 0 4th Dec 2008 05:57 PM
Access 97 Upgraded to Access 2007 User level security problem Derek Curtis Microsoft Access Security 3 6th Sep 2008 05:50 AM
Problem with subform in Access 2007 - works fine in Access 2003 CinBar Microsoft Access Forms 5 4th Jan 2008 03:51 PM
[Access 2007] Problem to disable the Close Button (X) on the Access Application Window David Berthemet Microsoft Access 0 28th Feb 2007 11:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:54 PM.