Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like have access find the location of each txtbx and draw a line from
it to the other textbox?
Thanks
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200804/1 6  2566 
noe1818 wrote:
>Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like have access find the location of each txtbx and draw a line from
it to the other textbox?
Thanks
Forgot to mention this will be on a report
--
Message posted via AccessMonster.c om http://www.accessmonster.com/Uwe/For...ccess/200804/1
noe1818 via AccessMonster.c om wrote:
Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like have access find the location of each txtbx and draw a line from
it to the other textbox?
Quick answer. Yes.
>
Thanks
noe1818 via AccessMonster.c om wrote:
Just a quick question about lines:
Is it possible to connect a text box (e.g. txtbx1 to txtbx2 and txtbx2 to
txtbx3) with lines where txtbx1,2,&3 move up or down according to their
values? Like have access find the location of each txtbx and draw a line from
it to the other textbox?
Thanks
Probably write your code in the OnFormat event for the band.
You should be familiar with the Top, Left, Height, and Width properties.
Dim lngNum As Long
lngNum = Me.Text1.Left + Me.Text1.width
Me.Line1.Left = lngNum
...etc
Small Town http://www.youtube.com/watch?v=wT051lq5Xh0
I'm not too savy with code, so if you could help me out by explain exactly
what I have to write, I would appreciate it a lot.
Salad wrote:
>Just a quick question about lines:
[quoted text clipped - 4 lines]
>>
Thanks
Probably write your code in the OnFormat event for the band.
You should be familiar with the Top, Left, Height, and Width properties.
Dim lngNum As Long
lngNum = Me.Text1.Left + Me.Text1.width
Me.Line1.Left = lngNum
...etc
Small Town
http://www.youtube.com/watch?v=wT051lq5Xh0
--
Message posted via http://www.accessmonster.com
noe1818 via AccessMonster.c om wrote:
I'm not too savy with code, so if you could help me out by explain exactly
what I have to write, I would appreciate it a lot.
You had another post, titled "move from top of page". I wrote the code
that does the connecting of boxes and moving text boxes up and down and
posted it there.
Find my code. Create a new report. Drop 2 text boxes into the Detail
band and 1 line. Name them Text1, Text2, and Line1. Next, drop my code
into the report's code module. Then run.
I set it to 10 up/down levels at 45 twips each. For testing, change the
Me.Text1.Top = (1 * intHeightPerUni t)
Me.Text2.Top = (10 * intHeightPerUni t)
lines. Change the 1 to some other number, the 10 to another and rerun
to see the up down movement and the line connects....and determine what
1 unit of height should be between 2 text boxes.
The 1 and 10 above are values you need to supply in your report.
Bottom line is...most of the code is done for you. I only have 2 text
boxes. You'd have to modify it for more text boxes and change the text
box names.
OnlyTheLonely http://www.youtube.com/watch?v=IfKmoBYZWz0
>
Salad wrote:
>>>Just a quick question about lines:
[quoted text clipped - 4 lines]
>>>Thanks
Probably write your code in the OnFormat event for the band.
You should be familiar with the Top, Left, Height, and Width properties.
Dim lngNum As Long
lngNum = Me.Text1.Left + Me.Text1.width
Me.Line1.Left = lngNum
...etc
Small Town
http://www.youtube.com/watch?v=wT051lq5Xh0
Salad wrote:
noe1818 via AccessMonster.c om wrote:
Find my code. Create a new report. Drop 2 text boxes into the Detail
band and 1 line. Name them Text1, Text2, and Line1. Next, drop my code
into the report's code module. Then run.
BTW, enter
="Text1"
and
="Text2"
as the control sources of the textboxes so you can run the new report. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Michael Hill |
last post by:
Hi, folks.
I am writing a Javascript program that accepts (x, y) data pairs from
a text box and then analyzes that data in various ways. This is my
first time using text area boxes; in the past, I have used individual
entry fields for each variable. I would now like to use text area
boxes to simplify the data entry (this way, data can be produced by
another program--FORTRAN, "C", etc.--but analyzed online, so long as
it is first...
|
by: Bob Sanderson |
last post by:
I have a form with several fields in-line in the detail. I am using the
borders of each text box to form a grid. The resultant output resembles a
spreadsheet. The problem I'm having is that in the text in one field is
too long for the text box to display, the box expands vertically (it's set
to "can grow"). This would be ok if the adjacent cells would expand as
well so that the borders still line up. Instead, the single box grows to...
|
by: simonmarkjones |
last post by:
Hi, I'm having a bit of trouble editing an old database that was
created quite a while ago by someone else.
There is a form that lets the user select a member of staff and show
details about the training they have had.
What im trying to add to this is an email button which emails the
person selected - i've managed to be able to do grab the email and
create a new email message with the coresponding email adress.
|
by: ray well |
last post by:
hi,
my app has two parallel rich text boxes containing the same content in 2
different languages. the lines parallel each other, line #3 in english
contains the same content as line #3 in french.
i need the two boxes to syncronize, if someone scrolls and clicks on line 23
in the english side, it should scroll to line 23 in the french side, and the
same from french to english.
|
by: Edson Peacock |
last post by:
I have a report with sub reports, one of the subreports have 12 text boxes
that are 2" high and I want them all to grow if one goes to 3" high.
If anyone has any suggestions they are very much appreciated.
Thanks
| | |
by: Bill (Unique as my name) |
last post by:
Please suggest some links or sources which show how to set up form text
boxes in VBA.
Thank you so much.
|
by: ljungers |
last post by:
I'm on the home streach of my project and found that my "Reset for New Search" command button not working as desired. What should happen is that when the button is clicked a Event Procedure is run. That event procedure should clear the text boxes that are used for a search query that loads the results into a list box on that same form.
When clicked, all is cleared in the text boxes, and the list box is cleared but shows column seperator lines...
|
by: BEETHOVEN |
last post by:
Is there a way to count how many lines are in a text box on a Access
97 report? I have a report that has a text box and sometimes the box
will be 2 lines long and sometimes 3 lines long. I need some other
text boxes to adjust depending on how many lines are in the text box.
Below is some code I found in this forum but does not work. It does
not matter if I use a CR (Carriage return) Chr$(13) or LF (Linefeed)
Chr$(10) or both.
Dim n...
|
by: scottbouley |
last post by:
I am creating an Access report that replicates a preprinted grid form by using bordered text boxes. Each detail row on the preprinted form accomodates two lines. However,some of my records consist of several lines. When the print view is generated, the first two lines appear in the text box and the remaining lines appear in a blank white space after the bordered area. I want to split records with more than two lines into multiple bordered...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
