473,324 Members | 2,002 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Subform "White Areas"

In a subform that has no records, what is the white area? If a subform has
records and you scroll the records, what is the white area after the last
record? I would like to be able to click in these white areas and run code.

Thanks,

Sally
Nov 13 '05 #1
7 2616
I think you are referring to the new record row that is the last row in the
subform - the only row if there are no records. It's there so you can type
in a new record to be added to the table.

You can test whether the new record row is current by testing the NewRecord
property of the form. Example:
If Me.NewRecord Then
MsgBox "You are in the new record row"
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sally" <sm*****@notmyemail.com> wrote in message
news:zj*****************@newsread1.news.pas.earthl ink.net...
In a subform that has no records, what is the white area? If a subform has
records and you scroll the records, what is the white area after the last
record? I would like to be able to click in these white areas and run
code.

Nov 13 '05 #2
Allen, thank you for responding!

The records in the subform are for display only. Allow Additions is set to
False so there is no new record row. I need to be able to click in the area
below the last record when I scroll and run code. I also need to be able to
click in the area of the subform when there are no records and run code. And
I need to be able to scroll the subform without running code.

Sally
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41**********************@per-qv1-newsreader-01.iinet.net.au...
I think you are referring to the new record row that is the last row in the subform - the only row if there are no records. It's there so you can type
in a new record to be added to the table.

You can test whether the new record row is current by testing the NewRecord property of the form. Example:
If Me.NewRecord Then
MsgBox "You are in the new record row"
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sally" <sm*****@notmyemail.com> wrote in message
news:zj*****************@newsread1.news.pas.earthl ink.net...
In a subform that has no records, what is the white area? If a subform has records and you scroll the records, what is the white area after the last record? I would like to be able to click in these white areas and run
code.


Nov 13 '05 #3
The area below the records in a continuous form is not programmable. It does
respond to Form_Click, but so do other areas of the screen (e.g. the record
selector).

I'm not sure how you expect to scroll the subform without running any code:
perhaps by clicking with the mouse on the scrollbar?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sally" <sm*****@notmyemail.com> wrote in message
news:Du*****************@newsread1.news.pas.earthl ink.net...
Allen, thank you for responding!

The records in the subform are for display only. Allow Additions is set to
False so there is no new record row. I need to be able to click in the
area
below the last record when I scroll and run code. I also need to be able
to
click in the area of the subform when there are no records and run code.
And
I need to be able to scroll the subform without running code.

Sally
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41**********************@per-qv1-newsreader-01.iinet.net.au...
I think you are referring to the new record row that is the last row in

the
subform - the only row if there are no records. It's there so you can
type
in a new record to be added to the table.

You can test whether the new record row is current by testing the

NewRecord
property of the form. Example:
If Me.NewRecord Then
MsgBox "You are in the new record row"
End If
"Sally" <sm*****@notmyemail.com> wrote in message
news:zj*****************@newsread1.news.pas.earthl ink.net...
> In a subform that has no records, what is the white area? If a subform has > records and you scroll the records, what is the white area after the last > record? I would like to be able to click in these white areas and run
> code.

Nov 13 '05 #4
rkc
Sally wrote:
Allen, thank you for responding!

The records in the subform are for display only. Allow Additions is set to
False so there is no new record row. I need to be able to click in the area
below the last record when I scroll and run code. I also need to be able to
click in the area of the subform when there are no records and run code. And
I need to be able to scroll the subform without running code.


What view is the sub form in?
What have you tried so far?
Nov 13 '05 #5
There are actually 42 continuous subforms arranged in a layout like a
calendar. Allow Additions is set to False in the subforms. All the controls
are on one line and the detail section is not exsposed above or below the
controls. The textboxes on the subforms are only for display. There is no
room for a command button.

I tried coding the Enter event of the subform control but when I try to
scroll the records the code runs. I tried coding the detail Click event but
nothing happened. I tried coding the Enter event of the controls and that
worked when I clicked on a control. The problem with that though is that the
code doesn't execute when there are no records or when I click in the white
area after the last record.

Sally

"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:PI********************@twister.nyroc.rr.com.. .
Sally wrote:
Allen, thank you for responding!

The records in the subform are for display only. Allow Additions is set to False so there is no new record row. I need to be able to click in the area below the last record when I scroll and run code. I also need to be able to click in the area of the subform when there are no records and run code. And I need to be able to scroll the subform without running code.


What view is the sub form in?
What have you tried so far?

Nov 13 '05 #6
rkc
Sally wrote:
There are actually 42 continuous subforms arranged in a layout like a
calendar. Allow Additions is set to False in the subforms. All the controls
are on one line and the detail section is not exsposed above or below the
controls. The textboxes on the subforms are only for display. There is no
room for a command button.

I tried coding the Enter event of the subform control but when I try to
scroll the records the code runs. I tried coding the detail Click event but
nothing happened. I tried coding the Enter event of the controls and that
worked when I clicked on a control. The problem with that though is that the
code doesn't execute when there are no records or when I click in the white
area after the last record.


So you haven't tried the form's click event? Seems to me that is
exactly what you want. It fires when you click a record selector
or what you call the empty space below the controls and not when you
click the scroll bars or the detail section.
Nov 13 '05 #7
rkc,

That's it!!! As you said .... the form click event fires when you click the
empty space below the controls. It also fires when you click anywhere when
there are no records. It does not fire when you click the scroll bars or the
detail section. I added the same code in the click event of the controls and
the click event of the detail section and now I can click anywhere in the
subform and the code is executed. If I click on the scroll bars, no event
fires.

Thanks for putting me on the right path!!

Sally
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:qh********************@twister.nyroc.rr.com.. .
Sally wrote:
There are actually 42 continuous subforms arranged in a layout like a
calendar. Allow Additions is set to False in the subforms. All the controls are on one line and the detail section is not exsposed above or below the controls. The textboxes on the subforms are only for display. There is no room for a command button.

I tried coding the Enter event of the subform control but when I try to
scroll the records the code runs. I tried coding the detail Click event but nothing happened. I tried coding the Enter event of the controls and that worked when I clicked on a control. The problem with that though is that the code doesn't execute when there are no records or when I click in the white area after the last record.


So you haven't tried the form's click event? Seems to me that is
exactly what you want. It fires when you click a record selector
or what you call the empty space below the controls and not when you
click the scroll bars or the detail section.

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mark Moore | last post by:
I'm trying to layout a couple text input fields and their corresponding labels without using a table. When I was trying to debug my understanding of CSS, I was *very* surprised to see that span's...
10
by: ryankbrown | last post by:
I was wondering if anybody has a document that states do's and don'ts when programming for a MS SQL DB. I was under the impression that Microsoft once produced such a document. Rather than a "Best...
0
by: Codex Twin | last post by:
hello group: The following is a fragment from a schema which defines the EWethnicCategoryStructure type. As you can see, its type is defined by the SimpleType enumeration EWethnicCategoryType....
9
by: Anders Borum | last post by:
Hello! I have a class that needs to validate the input value, when a programmer changes a specific property on a class. The input should only accept the following pattern {1,n} (alpha-numeric...
4
by: Antoine | last post by:
Herfried and Cor:- I used tracing and actually tracked down the code that was causing the problem most likely. I wonder if you wanted to comment on it. Also I wonder if there is a better way...
9
by: Tristán White | last post by:
Hi I am very new to PHP - actually, this is my second day at it, as I've only recently started a new job last week. We're a charity. I have a "No input file selected" problem. A Google search...
2
by: jphelan | last post by:
I was testing the install and uninstall, on my WindowsXP Pro SP2 machine, of software that I created, called, "inbusiness". Because of the following error message that I received on attempting to...
0
by: Kevin Frey | last post by:
We have a data-centric application where all of the "layout" for each data centric page is to be codified (ie. it is expressed in C# code rather than being expressed declaratively). This...
4
by: asnowfall | last post by:
If I have white space in the <atag, IE interpretes it as line break. I tried setting "whie-space: pre" and it did not seem to affect. Here is a sample. ...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.