Hi,
I have a form which is opened from a button on another form. The form is
used to display a list of records from a recordset in Continuous Mode. It
is sized vertically to display about 25 rows and has a vertical scrollbar.
This form has been working perfectly for weeks.
However, I must have done something recently because now the detail section
displays only one row at a time. That is, the form has shrunk vertically to
about 3
cm height. Property Can Grow is set to Yes, and Can Shrink to No.
In Design View, the form still displays full height. If I go from Design
View directly to Form View, it still retains full height and displays up to
25 rows. However, if I open the form via the button, it shrinks back to a
display height of one row. All the data is there, I just have to scroll a
row at a time to see it all.
The button on the other form generates a recordset (which is Public and
accessible from either form) and then does:
DoCmd.OpenForm "frmPersonList" , , , , acFormReadOnly
I cannot figure out what I might have done to screw this up, seeing as it
was working as designed weeks ago. Can anyone see the problem?
TIA for any help.
--
Cheers,
Lyn.
9  3984 
Lyn,
Have you tried to open the form in design view and *save* the form again ?
--
Hope this helps
Arno R
"Lyn" <lh******@ihug. com.au> schreef in bericht news:d2******** **@lust.ihug.co .nz... In Design View, the form still displays full height. If I go from Design
View directly to Form View, it still retains full height and displays up to
25 rows. However, if I open the form via the button, it shrinks back to a
display height of one row. All the data is there, I just have to scroll a
row at a time to see it all.
Thanks Arno. Yes, many times -- but no joy. Any other thoughts?
--
Cheers,
Lyn.
"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:42******** **************@ dreader2.news.t iscali.nl...
Lyn,
Have you tried to open the form in design view and *save* the form again ?
--
Hope this helps
Arno R
"Lyn" <lh******@ihug. com.au> schreef in bericht
news:d2******** **@lust.ihug.co .nz... In Design View, the form still displays full height. If I go from Design
View directly to Form View, it still retains full height and displays up
to
25 rows. However, if I open the form via the button, it shrinks back to a
display height of one row. All the data is there, I just have to scroll a
row at a time to see it all.
"Lyn" <lh******@ihug. com.au> wrote in message
news:d2******** **@lust.ihug.co .nz... Thanks Arno. Yes, many times -- but no joy. Any other thoughts?
That's what I was going to suggest as well. A continuous view form's height
should be established by setting the window height in design view. However; I
usually find that I have to make some other design change prior to saving to get
the size to "stick". I'll make a label one tick wider or move a hidden control
before saving.
How is the size if you open from the db window instead of from your button?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@ho tmail.com> wrote in message
news:GZ******** ********@newssv r30.news.prodig y.com... "Lyn" <lh******@ihug. com.au> wrote in message
news:d2******** **@lust.ihug.co .nz... Thanks Arno. Yes, many times -- but no joy. Any other thoughts?
That's what I was going to suggest as well. A continuous view form's
height should be established by setting the window height in design view.
However; I usually find that I have to make some other design change prior
to saving to get the size to "stick". I'll make a label one tick wider or
move a hidden control before saving.
How is the size if you open from the db window instead of from your
button?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Rick,
If I open from the DB window, I get the same small size. It is only if I
start in Design View and press the Form View button that the form opens full
size.
I must have done something recently that has caused this because the form
was working fine for weeks. But although I have tried backtracking to find
the cause, it still eludes me.
There seems to be no way to set the form height other than by dragging the
form vertically in Design View and saving it. Ie, no Height property
(except for the height of a single line in the Detail section). But for
some reason dragging vertically doesn't stick in Form View.
--
Cheers,
Lyn.
"Lyn" <lh******@ihug. com.au> wrote in message
news:d2******** **@lust.ihug.co .nz... Rick,
If I open from the DB window, I get the same small size. It is only if I
start in Design View and press the Form View button that the form opens full
size.
I must have done something recently that has caused this because the form was
working fine for weeks. But although I have tried backtracking to find the
cause, it still eludes me.
There seems to be no way to set the form height other than by dragging the
form vertically in Design View and saving it. Ie, no Height property (except
for the height of a single line in the Detail section). But for some reason
dragging vertically doesn't stick in Form View.
Is the form still in continuous mode (you can see more records after opening by
dragging the lower frame border down), or has it reverted to single view?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Lyn,
What version of Access is this ? Corruption here ?
If the problem persists I would create a new form, copy and paste the controles and just see how this form 'acts'.
If it's allright you can also copy the form's code.
Arno R If I open from the DB window, I get the same small size. It is only if I
start in Design View and press the Form View button that the form opens full
size.
I must have done something recently that has caused this because the form
was working fine for weeks. But although I have tried backtracking to find
the cause, it still eludes me.
Arno, Rick,
Firstly, to answer your questions: Access 2003, and the form remains in
Continuous Mode. Dragging the shrunken form vertically exposes all the
missing records.
Anyway, I have found the problem and have a workaround fix, although I am
not sure I understand what is going on.
I did what I should have done from the start -- I went back to a saved
version of the form from a time when it was working OK and did a comparison
of form properties, one by one. There had been a number of accumulated
changes, but the one which "caused" the problem was RecordSource. In the
newer "faulty" form, RecordSource was blank. Let me explain...
Originally the form listing was based on a query from a single table, and
the table name was set as the RecordSource. All worked OK. With further
development, the record source for the form became a union of queries from
two separate tables. This query is developed in the calling form and is
already available as a record set when the problem form is called. So when
I now open the latter form, I set the form's Recordset property to the
existing recordset. This saves exporting the query's rather complex SQL
from the calling form to the problem form (as OpenArgs?) to be set as its
RecordSource and, since the recordset is already in memory, saves
duplicating the query in the child form.
According to the Help file, setting the Recordset property of a form is
supposed to update the form's RecordSource property accordingly. So, it
seemed logical to delete the old RecordSource value from Design Mode (ie the
single table) as it was no longer valid. But doing so seems to be what
caused the shrinking problem. Anyway, my workaround for now is to restore
the old table name as the form's default RecordSource value, even though it
is not used.
Why would this cause the form to shrink? (BTW, I set the Recordset property
in the Open event -- also tried using Load event, no difference.)
Thanks again for your help.
--
Cheers,
Lyn.
"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:42******** **************@ dreader2.news.t iscali.nl...
Lyn,
What version of Access is this ? Corruption here ?
If the problem persists I would create a new form, copy and paste the
controles and just see how this form 'acts'.
If it's allright you can also copy the form's code.
Arno R If I open from the DB window, I get the same small size. It is only if I
start in Design View and press the Form View button that the form opens
full
size.
I must have done something recently that has caused this because the form
was working fine for weeks. But although I have tried backtracking to
find
the cause, it still eludes me.
"Lyn" <lh******@ihug. com.au> schreef in bericht news:d2******** **@lust.ihug.co .nz... According to the Help file, setting the Recordset property of a form is
supposed to update the form's RecordSource property accordingly. So, it
seemed logical to delete the old RecordSource value from Design Mode (ie the
single table) as it was no longer valid. But doing so seems to be what
caused the shrinking problem. Anyway, my workaround for now is to restore
the old table name as the form's default RecordSource value, even though it
is not used.
Why would this cause the form to shrink? (BTW, I set the Recordset property
in the Open event -- also tried using Load event, no difference.)
Just a guess: AllowAdditions false ?
If AllowAdditions =False then
Access is trying to be too 'helpful' here ... no records to show >> no detail
else
I don't have a clue also ...
end if
Anyway, glad you solved your case
Arno R
Allow Additions was False. Unfortunately changing it to True still required
a dummy value in RecordSource to work. Thanks for all the help though.
--
Cheers,
Lyn.
"Arno R" <ar************ ****@tiscali.nl > wrote in message
news:42******** **************@ dreader2.news.t iscali.nl...
"Lyn" <lh******@ihug. com.au> schreef in bericht
news:d2******** **@lust.ihug.co .nz... According to the Help file, setting the Recordset property of a form is
supposed to update the form's RecordSource property accordingly. So, it
seemed logical to delete the old RecordSource value from Design Mode (ie
the
single table) as it was no longer valid. But doing so seems to be what
caused the shrinking problem. Anyway, my workaround for now is to restore
the old table name as the form's default RecordSource value, even though
it
is not used.
Why would this cause the form to shrink? (BTW, I set the Recordset
property
in the Open event -- also tried using Load event, no difference.)
Just a guess: AllowAdditions false ?
If AllowAdditions =False then
Access is trying to be too 'helpful' here ... no records to show >> no
detail
else
I don't have a clue also ...
end if
Anyway, glad you solved your case
Arno R This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Scott M |
last post by:
Hi,
I am writing a small game that is using a form 800 * 600. The form
can be scrolled vertically up to a height of 1200 (basically the form
can be scrolled down one screen vertically).
The user controls a picturebox (my sprite) with the cursor keys
When the sprite hits the y value of 600 the screen scrolls down to
display the bottom part of the screen (by focusing on a hidden
|
by: Woof-Woof |
last post by:
Hi,
I have an application which displays a form with bar graph data on it.
What I need to do is string 30 of these bar graph forms vertically in
a picture box or some other container so I can scroll the 30 forms
vertically in sort of a "film clip" like method.
Can anyone give a little insight into what, if any, container is
capable of holding 30 different form objects each with its own data?
|
by: John Baker |
last post by:
Hi:
I have a form which contains the following entry ( one element on each line)
Name
Address line 1
Address line 2
city, state, zip
In many cases there is only ONE address line filled in (the other is for apartment numbers
|
by: Paul T. Rong |
last post by:
Hi everybody,
This time a very very difficult case:
I have a table "tblStudent", there are 50 students, I also made a form
"frmStudent" based on "tblStudent", now if I don't want to show all the
students in a classical (vertically, from top to bottom) way, but make them
"sitting" in 50 text boxes, 5 rows 10 columns, how to do it?
Thanks in advance.
|
by: Jozef |
last post by:
I have some old code that I use from the Access 95 Developers handbook. The
code works very well, with the exception that it doesn't seem to recognize
wide screens, and sizes tab controls so that they are too big and wind up
covering up some of the fields on the main form.
Is there any good code out there that works in a similar fashion that will
also either a) stretch the form width wise on widescreens or b), rely on
height rather than...
| | |
by: blah blah blah |
last post by:
I'm trying to make a form that can be sized vertically but not
horizontally. Any pointers?
First attempt was to
set the form's FormBorderStyle = Sizeable
set the form's MaximumSize.Width to the fixed width
Unfortunately, the users still sees these cursors, SizeNESW, SizeNWSE,
and SizeWE. Also, they can size the form vertically by grabbing one
|
by: gsb58 |
last post by:
Hi!
On a form I have a calendar. The form is rezised to 1024x768 (Don't
worry - this is a training case) when loaded.
Now I want to center the calendar on the form so that its edges are
equally far from the upper, right, left and bottom borders of the form.
I understand I must use the location property, am I right?
|
by: tdw |
last post by:
the View Orders form in my Access database has a Print button on it. It has other buttons too, like Edit etc. These buttons used to be at the bottom of the form laid out horizontally, but this was causing the form to be just long enough vertically that some people when viewing it on their screen would have to scroll up or down to see the top or bottom of the form.
So, my solution was to make the form wider and move the command button over to...
|
by: =?Utf-8?B?TWFyaw==?= |
last post by:
Hi...
We've been trying to migrate our asp.net apps off older, underpowered
hardware to newer, bigger boxes but when we do, we see our databases start to
melt.
When I started to look into it, I found that the older boxes all had bigger
EffectivePrivateBytesLimit values than the newer boxes, which seems very
counter-intuitive to me. And it seemed to me that a much smaller Cache would
be pushing more requests back to the databases.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
