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

dynamic popup screen for multiple comments fields

P: n/a
bu
I have a form with a handful of comments fields. I am trying to code the
form in such a way that when the user clicks on the field, a dialog box will
open up displaying the full contents of the field. I want to reuse the same
window for each field ( seems sensless to code a screen n times for n fields
when the only thing that is really changing is the source data ), but am
having all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the popup
to the correct ControlSource, but the data always displays the first record
in the table - it seems to ignore the Filter property - and I have tried
requery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
It's confusing about what you want to display on the popup form - you say
'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it can
not be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of the
field on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code the
form in such a way that when the user clicks on the field, a dialog box will open up displaying the full contents of the field. I want to reuse the same window for each field ( seems sensless to code a screen n times for n fields when the only thing that is really changing is the source data ), but am
having all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the popup
to the correct ControlSource, but the data always displays the first record in the table - it seems to ignore the Filter property - and I have tried
requery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill

Nov 13 '05 #2

P: n/a
bu
Yes, I have screen realestate issues and cannot display the full contents of
a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the
popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say
'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it can
not be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of the
field on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the full contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code the form in such a way that when the user clicks on the field, a dialog box

will
open up displaying the full contents of the field. I want to reuse the

same
window for each field ( seems sensless to code a screen n times for n

fields
when the only thing that is really changing is the source data ), but am
having all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the popup to the correct ControlSource, but the data always displays the first

record
in the table - it seems to ignore the Filter property - and I have tried
requery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill


Nov 13 '05 #3

P: n/a
rkc
bu wrote:
Yes, I have screen realestate issues and cannot display the full contents of
a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the
popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say
'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it can
not be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of the
field on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the


full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code
the
form in such a way that when the user clicks on the field, a dialog box


will
open up displaying the full contents of the field. I want to reuse the


same
window for each field ( seems sensless to code a screen n times for n


fields
when the only thing that is really changing is the source data ), but am
having all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the
popup
to the correct ControlSource, but the data always displays the first


record
in the table - it seems to ignore the Filter property - and I have tried
requery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill


Try the follwing line of code in the DblClick or Click event of one of
the comment controls and see if it's enough for you.

DoCmd.RunCommand acCmdZoomBox

Nov 13 '05 #4

P: n/a
Use the following code for your Close button on the popup form:
Me.Visible = False

Change the AfterUpdate code to:
DoCmd.OpenForm "PFrmDisplayFullComments",,,,,acDialog
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox
Me!NameOfFieldTextbox = Forms!PFrmDisplayFullComments!FullContents
DoCmd.Close acForm, "PFrmDisplayFullComments"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"bu" <bu@nospam.com> wrote in message news:d0******************@fe03.lga...
Yes, I have screen realestate issues and cannot display the full contents of a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say
'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it can not be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of the field on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the

full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code the form in such a way that when the user clicks on the field, a dialog box will
open up displaying the full contents of the field. I want to reuse
the
same
window for each field ( seems sensless to code a screen n times for n

fields
when the only thing that is really changing is the source data ), but

am having all sorts of issues. I have tried dynamically setting the popup windows RecordSource and Filter properties and the text field in the

popup to the correct ControlSource, but the data always displays the first

record
in the table - it seems to ignore the Filter property - and I have tried requery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill



Nov 13 '05 #5

P: n/a
bu
That is *exactly* what I was looking for... something small, efficient, and
clean!!! Thanks a ton!
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:S%***************@twister.nyroc.rr.com...
bu wrote:
Yes, I have screen realestate issues and cannot display the full contents of a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it cannot be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of thefield on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the


full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code


the
form in such a way that when the user clicks on the field, a dialog box

will

open up displaying the full contents of the field. I want to reuse the

same

window for each field ( seems sensless to code a screen n times for n

fields

when the only thing that is really changing is the source data ), but amhaving all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the


popup
to the correct ControlSource, but the data always displays the first

record

in the table - it seems to ignore the Filter property - and I have triedrequery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill


Try the follwing line of code in the DblClick or Click event of one of
the comment controls and see if it's enough for you.

DoCmd.RunCommand acCmdZoomBox

Nov 13 '05 #6

P: n/a
bu
That is *exactly* what I was looking for... something small, efficient, and
clean!!! Thanks a ton!
"rkc" <rk*@rochester.yabba.dabba.do.rr.bomb> wrote in message
news:S%***************@twister.nyroc.rr.com...
bu wrote:
Yes, I have screen realestate issues and cannot display the full contents of a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say'full contents of the field'. Doesn't the primary form display the full
contents? Assuming the field contains the full contents but part of it cannot be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of thefield on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the


full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga...
I have a form with a handful of comments fields. I am trying to code


the
form in such a way that when the user clicks on the field, a dialog box

will

open up displaying the full contents of the field. I want to reuse the

same

window for each field ( seems sensless to code a screen n times for n

fields

when the only thing that is really changing is the source data ), but amhaving all sorts of issues. I have tried dynamically setting the popup
windows RecordSource and Filter properties and the text field in the


popup
to the correct ControlSource, but the data always displays the first

record

in the table - it seems to ignore the Filter property - and I have triedrequery, refresh, etc.

What is the best way to do this? Certainly it has been done before?

Thanks in advance for any help you can provide!
Bill


Try the follwing line of code in the DblClick or Click event of one of
the comment controls and see if it's enough for you.

DoCmd.RunCommand acCmdZoomBox

Nov 13 '05 #7

P: n/a
bu
thanks for the reply, but I went with rkc's post... a gazillion times
easier!!
"PC Datasheet" <no****@nospam.spam> wrote in message
news:bV****************@newsread3.news.atl.earthli nk.net...
Use the following code for your Close button on the popup form:
Me.Visible = False

Change the AfterUpdate code to:
DoCmd.OpenForm "PFrmDisplayFullComments",,,,,acDialog
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox
Me!NameOfFieldTextbox = Forms!PFrmDisplayFullComments!FullContents
DoCmd.Close acForm, "PFrmDisplayFullComments"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"bu" <bu@nospam.com> wrote in message news:d0******************@fe03.lga...
Yes, I have screen realestate issues and cannot display the full contents of
a handful of fields. Unfortunately, I forgot to mention that I need the
calling field to update with whatever changes the user may have made in the
popup... any thoughts?

thx,
Bill
"PC Datasheet" <no****@nospam.spam> wrote in message
news:QT****************@newsread3.news.atl.earthli nk.net...
It's confusing about what you want to display on the popup form - you say 'full contents of the field'. Doesn't the primary form display the full contents? Assuming the field contains the full contents but part of it can not be seen, do the following:

Put a textbox named FullContents on your popup form named
PFrmDisplayFullComments. Put the following code in the Click event of the field on the primary form:
DoCmd.OpenForm "PFrmDisplayFullComments"
Forms!PFrmDisplayFullComments!FullContents = Me!NameOfFieldTextbox

You can use the same popup form for all fields you want to display the

full
contents; just change NameOfFieldTextbox in the code for each field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"bu" <bu@nospam.com> wrote in message news:fK*****************@fe03.lga... > I have a form with a handful of comments fields. I am trying to code the
> form in such a way that when the user clicks on the field, a dialog box will
> open up displaying the full contents of the field. I want to reuse the same
> window for each field ( seems sensless to code a screen n times for
n fields
> when the only thing that is really changing is the source data ),

but am > having all sorts of issues. I have tried dynamically setting the popup > windows RecordSource and Filter properties and the text field in the

popup
> to the correct ControlSource, but the data always displays the first
record
> in the table - it seems to ignore the Filter property - and I have tried > requery, refresh, etc.
>
> What is the best way to do this? Certainly it has been done before?
>
> Thanks in advance for any help you can provide!
> Bill
>
>



Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.