473,323 Members | 1,622 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,323 software developers and data experts.

connecting text boxes with lines

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.com
http://www.accessmonster.com/Uwe/For...ccess/200804/1

Apr 10 '08 #1
6 2526
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.com
http://www.accessmonster.com/Uwe/For...ccess/200804/1

Apr 10 '08 #2
noe1818 via AccessMonster.com 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
Apr 10 '08 #3
noe1818 via AccessMonster.com 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
Apr 10 '08 #4
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

Jun 27 '08 #5
noe1818 via AccessMonster.com 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 * intHeightPerUnit)
Me.Text2.Top = (10 * intHeightPerUnit)
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

Jun 27 '08 #6
Salad wrote:
noe1818 via AccessMonster.com 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.
Jun 27 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
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,...
1
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...
14
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...
0
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...
11
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...
9
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.
12
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....
1
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...
7
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
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.