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

selheight question

P: n/a
I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Command button? You're using a command button?

Would not the multiple selection be lost when focus moves to the command
button?

--
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.

"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...
I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?

Nov 13 '05 #2

P: n/a
Yes, Allen. That does seem to be the problem. Thanks for the heads-up.

Lenny Fincher

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@per-qv1-newsreader-01.iinet.net.au>...
Command button? You're using a command button?

Would not the multiple selection be lost when focus moves to the command
button?

--
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.

"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...
I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?

Nov 13 '05 #3

P: n/a
Create module level variables for the form's SelTop and SelHeight props
that you update using the Form's Click event.
Finally the Access Web contains sample code based on a Timer event that
you can use by simply substituting the method outlined above.
http://www.mvps.org/access/forms/frm0033.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...
I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.