473,326 Members | 2,173 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,326 software developers and data experts.

dynamic popup screen for multiple comments fields

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
7 2081
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: bubipoo | last post by:
hi guys, i have a pic that i have created hot spots on. i want these to open popups with limited features (eg: no status, no resizable...) any ideas? darren
5
by: Willem van Isselmuden | last post by:
Hello, I've a problem I hava a page with different popup windows, when I hit a link the first one pops up and with the first open i would like to hit the second link in the parent page so the...
38
by: Shaun McKinnon | last post by:
HI...Here's my problem...I have a popup window that loads when i want it to, but it's not sized properly. I've set the size, but it doesn't seem to work. I've been on 8 different websites to find...
2
by: darius | last post by:
Hello, I seem to be having trouble with a rather simple problem. I am opening a new window with the window.open command, and even though I set scrollbar=yes, I can't seem to get the window to...
11
by: playmaker | last post by:
Hi, I have two buttons calling the same funtion to open a popup window, dinamically built according to parameters passed to the function. The problem: when I click the first button (or the...
7
by: E Michael Brandt | last post by:
I have been lurking here for some time, and now would like to ask a question of you clever coders: My JustSo PictureWindow 3 Extension for Dreamweaver has stumbled in the face of the new Opera...
2
by: assgar | last post by:
Hi Developemnt on win2003 server. Final server will be linux Apache,Mysql and PHP is being used. I use 2 scripts(form and process). The form displays multiple dynamic rows with chechboxs,...
23
by: sandy | last post by:
I need (okay, I want) to make a dynamic array of my class 'Directory', within my class Directory (Can you already smell disaster?) Each Directory can have subdirectories so I thought to put these...
3
by: simora | last post by:
Hi: Need some working sample code to post hidden form data from a php page to a new popup window. 540 x 500 centered. The popup that I'm calling already is formatted and has a TITLE:web-2007.php...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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)...
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
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.