By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

continuous forms on popup only displaying one record unless I expand the window

P: 2
Hello

I am fairly new to Access and am having a problem for which I am trying everything without success. It is access 2003.

I have a main form. When the user presses a button a modal popup comes up with a continuous form based on a database table. I am manually linking the table to the main form table rather than as a subform, but either way I get this problem. When the popup comes up, even though there are 3 records, I only see one. If I expand the popup downwards I see the other records. I want them to be shown from the start.

Properties for the popup form are:

Default View: Continuous forms
Allow Form View: Yes
Scroll Bars: Vertical Only
Record Selectors: Yes
Navigation Buttons: Yes
Dividing Lines: Yes
Auto Resize: No
Auto Center: No

the detail section of the popup form has:

Force New Page: None
New Row or Col: None
Keep Together: yes
Visible: yes
Display When: Always
Can Grow: Yes
Can Shrink: yes

I have tried every combination I can think of as well as enlarging the detail section but that just makes more space for each record in the popup. Any help would be appreciated.
Nov 19 '07 #1
Share this Question
Share on Google+
5 Replies


P: 2
It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.

Anyway, I truied undoing anything I had done and it still works, justa s before nothing I did could make it work. Since I am not learning from my mistakes, I am doomed to repeat them, unless someone can shed light on this.

Thanks!
Nov 19 '07 #2

NeoPa
Expert Mod 15k+
P: 31,307
You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.
Nov 19 '07 #3

Jim Doherty
Expert 100+
P: 897
It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.

Anyway, I truied undoing anything I had done and it still works, justa s before nothing I did could make it work. Since I am not learning from my mistakes, I am doomed to repeat them, unless someone can shed light on this.

Thanks!

Hi Kenneth,

As a workaround use this

Create a standard module and paste this below the Option Compare Database line

Expand|Select|Wrap|Line Numbers
  1.  
  2. Declare Function GetDesktopWindow Lib "user32" () As Long
  3. Declare Function GetWindowRect Lib "user32" (ByVal hWnd As Long, rectangle As RECT) As Long
  4.  
  5. Function getScreenResolution() As String
  6.     Dim r As RECT
  7.     Dim hWnd As Long
  8.     Dim retval As Long
  9.     hWnd = GetDesktopWindow()
  10.     retval = GetWindowRect(hWnd, r)
  11.     getScreenResolution = (r.x2 - r.x1) & "x" & (r.y2 - r.y1)
  12. End Function
  13.  
  14.  

Now for 'pop ups' and windows such as those I personally place them wherever I want dynamically but for 'starters' if you want to try this one you'll see what I mean.... it will place your popup top left of screen each time (out of the way so to speak and size the length to fit the resolution either 800x600 or 1024x768:

In the On Open event of the form place the following code

Expand|Select|Wrap|Line Numbers
  1. On Error Resume Next
  2. If getScreenResolution() = "1024x768" Then
  3. DoCmd.MoveSize 0, 0, , 10980
  4. Else
  5. DoCmd.MoveSize 0, 0, , 8500
  6. End If
Bit rough and ready but it ought to facilitate you for what you need

Regards

Jim :)
Nov 19 '07 #4

NeoPa
Expert Mod 15k+
P: 31,307
Unfortunately, as we have no accurate log of all the changes you made, and in which order, there is little to go on to determine what caused it to start working I'm afraid.
I'm sorry to be unable to help as you've provided a lot of relevant info and laid it out carefully too.
Maybe someone else will see something I missed.
Nov 19 '07 #5

missinglinq
Expert 2.5K+
P: 3,532
I think this is what's happened:

a modal popup comes up with a continuous form... When the popup comes up, even though there are 3 records, I only see one. If I expand the popup downwards I see the other records.
The form at this point was continuous, and in Design View, the OP had way too much empty space between the bottom of the text boxes and the bottom of the form, which meant that there was a lot of "white space" between each row of data, forcing the OP to expand the form to see all three records.

It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.
When the form was made into a subform again, the form was no longer a continuous form but rather a Datasheet form, which is the default view for a subform! Since Datasheet forms are formatted similar to spreadsheets or queries, all three rows were automatically "snugged" up to each other, resolving the problem. When a form is displayed in Datasheet mode, Access ignores any and all formatting that apperars in Design View and so the extra empty space disappeared. If the form is changed back to Continuous view I suspect the problem will re-appear.
Linq ;0)>
Nov 20 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.