A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dynamically Move Controls in Report



 
 
Thread Tools Display Modes
  #1  
Old July 14th, 2004, 02:14 PM
Andy
external usenet poster
 
Posts: n/a
Default Dynamically Move Controls in Report

Hi;

Have a report that prints to a four column custom label. Some printers
bleed the text over the columns' margins and the Controls need to be
"Nudged" left or right.

Is there a way to Dynamically Move a Control in a Report?

Example: MSFT's rptsmp001.mdb gives an example of a popup form that appears
when the report opens and the user can sort alphabetically by Customer Name,
City, Etc. "On the Fly", (Dynamically).

Searched for: dynamically move controls in a report AND dynamic controls in
a report AND a few other combinations in MSFT's Access Support Center,
Lebans.com, http://www.mvps.org/access and even used a search engine.
Nothing Yet.

Is there a way to allow a user to Dynamically Move a Control in a Report?

Andy


  #2  
Old July 14th, 2004, 02:44 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Dynamically Move Controls in Report

The calendar reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4
move controls all over the place based on time values stored in records.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Hi;

Have a report that prints to a four column custom label. Some printers
bleed the text over the columns' margins and the Controls need to be
"Nudged" left or right.

Is there a way to Dynamically Move a Control in a Report?

Example: MSFT's rptsmp001.mdb gives an example of a popup form that

appears
when the report opens and the user can sort alphabetically by Customer

Name,
City, Etc. "On the Fly", (Dynamically).

Searched for: dynamically move controls in a report AND dynamic controls

in
a report AND a few other combinations in MSFT's Access Support Center,
Lebans.com, http://www.mvps.org/access and even used a search engine.
Nothing Yet.

Is there a way to allow a user to Dynamically Move a Control in a Report?

Andy




  #3  
Old July 14th, 2004, 03:13 PM
Andy
external usenet poster
 
Posts: n/a
Default Dynamically Move Controls in Report

Duane;

Thank You for Your reply.

Did check the example at:
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

It isn't the answer for this particular need.

What is needed is an "Input" box that would ask the user for an increment,
preferrably in inches, to move a control "From Here To There". Similar to
Dynamically sorting a report in MSFT's rptsmp001.mdb example.

Andy

"Duane Hookom" wrote in message
...
The calendar reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4
move controls all over the place based on time values stored in records.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Hi;

Have a report that prints to a four column custom label. Some printers
bleed the text over the columns' margins and the Controls need to be
"Nudged" left or right.

Is there a way to Dynamically Move a Control in a Report?

Example: MSFT's rptsmp001.mdb gives an example of a popup form that

appears
when the report opens and the user can sort alphabetically by Customer

Name,
City, Etc. "On the Fly", (Dynamically).

Searched for: dynamically move controls in a report AND dynamic controls

in
a report AND a few other combinations in MSFT's Access Support Center,
Lebans.com, http://www.mvps.org/access and even used a search engine.
Nothing Yet.

Is there a way to allow a user to Dynamically Move a Control in a

Report?

Andy






  #4  
Old July 14th, 2004, 03:51 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Dynamically Move Controls in Report

Add a column to the query your report is based on:
MoveInches:[Enter the Number of Inches]
Add the text box for MoveInches to your report and use it in your code.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Duane;

Thank You for Your reply.

Did check the example at:
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

It isn't the answer for this particular need.

What is needed is an "Input" box that would ask the user for an increment,
preferrably in inches, to move a control "From Here To There". Similar to
Dynamically sorting a report in MSFT's rptsmp001.mdb example.

Andy

"Duane Hookom" wrote in message
...
The calendar reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4
move controls all over the place based on time values stored in records.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Hi;

Have a report that prints to a four column custom label. Some

printers
bleed the text over the columns' margins and the Controls need to be
"Nudged" left or right.

Is there a way to Dynamically Move a Control in a Report?

Example: MSFT's rptsmp001.mdb gives an example of a popup form that

appears
when the report opens and the user can sort alphabetically by Customer

Name,
City, Etc. "On the Fly", (Dynamically).

Searched for: dynamically move controls in a report AND dynamic

controls
in
a report AND a few other combinations in MSFT's Access Support Center,
Lebans.com, http://www.mvps.org/access and even used a search engine.
Nothing Yet.

Is there a way to allow a user to Dynamically Move a Control in a

Report?

Andy








  #5  
Old July 14th, 2004, 10:47 PM
Andy
external usenet poster
 
Posts: n/a
Default Dynamically Move Controls in Report

Duane;

Thank You.

Andy

"Duane Hookom" wrote in message
...
Add a column to the query your report is based on:
MoveInches:[Enter the Number of Inches]
Add the text box for MoveInches to your report and use it in your code.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Duane;

Thank You for Your reply.

Did check the example at:
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

It isn't the answer for this particular need.

What is needed is an "Input" box that would ask the user for an

increment,
preferrably in inches, to move a control "From Here To There". Similar

to
Dynamically sorting a report in MSFT's rptsmp001.mdb example.

Andy

"Duane Hookom" wrote in message
...
The calendar reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4
move controls all over the place based on time values stored in

records.

--
Duane Hookom
MS Access MVP


"Andy" wrote in message
...
Hi;

Have a report that prints to a four column custom label. Some

printers
bleed the text over the columns' margins and the Controls need to be
"Nudged" left or right.

Is there a way to Dynamically Move a Control in a Report?

Example: MSFT's rptsmp001.mdb gives an example of a popup form that
appears
when the report opens and the user can sort alphabetically by

Customer
Name,
City, Etc. "On the Fly", (Dynamically).

Searched for: dynamically move controls in a report AND dynamic

controls
in
a report AND a few other combinations in MSFT's Access Support

Center,
Lebans.com, http://www.mvps.org/access and even used a search

engine.
Nothing Yet.

Is there a way to allow a user to Dynamically Move a Control in a

Report?

Andy










 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Specify Filter criteria before running report Nikos Yannacopoulos Setting Up & Running Reports 3 June 25th, 2004 09:36 PM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
Txtbox controls on report that call functions Stephen Setting Up & Running Reports 4 June 10th, 2004 11:17 PM
use data entered in unbound controls (on a form) when printing a report Karen New Users 1 May 25th, 2004 08:17 PM
Weird happening when moving controls on report David Setting Up & Running Reports 2 May 25th, 2004 07:30 PM


All times are GMT +1. The time now is 07:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.