I posted a question about a week ago about can grow vertical lines. Someone
posted a link to someone that has set up a database that does that but I
can't figure out all the code to make it work. Is there something I can
import into my database or copy and paste in a module? Basically I can't
figure out what all that code means, and cant get it to work.

Ummm, what was the link or the database? No one here can see what code
you're refering to to make suggestions.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II


"Code Agent" <(E-Mail Removed)> wrote in message
news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>I posted a question about a week ago about can grow vertical lines. Someone
> posted a link to someone that has set up a database that does that but I
> can't figure out all the code to make it work. Is there something I can
> import into my database or copy and paste in a module? Basically I can't
> figure out what all that code means, and cant get it to work.

Someone sent me this link: www.lebans.com There is a database you can
download that has the code for it


"Gina Whipp" wrote:

> Ummm, what was the link or the database? No one here can see what code
> you're refering to to make suggestions.
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
>
> "Code Agent" <(E-Mail Removed)> wrote in message
> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
> >I posted a question about a week ago about can grow vertical lines. Someone
> > posted a link to someone that has set up a database that does that but I
> > can't figure out all the code to make it work. Is there something I can
> > import into my database or copy and paste in a module? Basically I can't
> > figure out what all that code means, and cant get it to work.
>
>
>

Sorry about that

http://www.lebans.com/PrintLines.htm

"Gina Whipp" wrote:

> Okay, which database, there are quite a few there.
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
>
> "Code Agent" <(E-Mail Removed)> wrote in message
> news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
> > Someone sent me this link: www.lebans.com There is a database you can
> > download that has the code for it
> >
> >
> > "Gina Whipp" wrote:
> >
> >> Ummm, what was the link or the database? No one here can see what code
> >> you're refering to to make suggestions.
> >>
> >> --
> >> Gina Whipp
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >>
> >> "Code Agent" <(E-Mail Removed)> wrote in message
> >> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
> >> >I posted a question about a week ago about can grow vertical lines.
> >> >Someone
> >> > posted a link to someone that has set up a database that does that but
> >> > I
> >> > can't figure out all the code to make it work. Is there something I can
> >> > import into my database or copy and paste in a module? Basically I
> >> > can't
> >> > figure out what all that code means, and cant get it to work.
> >>
> >>
> >>
>
>
>

Okay, which database, there are quite a few there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II


"Code Agent" <(E-Mail Removed)> wrote in message
news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
> Someone sent me this link: www.lebans.com There is a database you can
> download that has the code for it
>
>
> "Gina Whipp" wrote:
>
>> Ummm, what was the link or the database? No one here can see what code
>> you're refering to to make suggestions.
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>>
>> "Code Agent" <(E-Mail Removed)> wrote in message
>> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>> >I posted a question about a week ago about can grow vertical lines.
>> >Someone
>> > posted a link to someone that has set up a database that does that but
>> > I
>> > can't figure out all the code to make it work. Is there something I can
>> > import into my database or copy and paste in a module? Basically I
>> > can't
>> > figure out what all that code means, and cant get it to work.
>>
>>
>>

Is it the PrintLines? Is this the code you are refering to?

Me.ScaleMode = 1
Me.ForeColor = 6723891

'Repeat the following line of code for each vertical line
' 1*1440 represents 1 inch
Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Draws line at Left Margin
Me.Line (0.6667 * 1440, 0)-(0.6667 * 1440, 14400)
Me.Line (1.4583 * 1440, 0)-(1.4583 * 1440, 14400)
Me.Line (2.25 * 1440, 0)-(2.25 * 1440, 14400)
Me.Line (3.5833 * 1440, 0)-(3.5833 * 1440, 14400)
Me.Line (7.4167 * 1440, 0)-(7.4167 * 1440, 14400)
Me.Line (8.25 * 1440, 0)-(8.25 * 1440, 14400)
Me.Line (9.1667 * 1440, 0)-(9.1667 * 1440, 14400)
Me.Line (10 * 1440, 0)-(10 * 1440, 14400)

'the 14400 is an arbitrary number to increase the line to the max of a
'section.


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II


"Code Agent" <(E-Mail Removed)> wrote in message
news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
> Someone sent me this link: www.lebans.com There is a database you can
> download that has the code for it
>
>
> "Gina Whipp" wrote:
>
>> Ummm, what was the link or the database? No one here can see what code
>> you're refering to to make suggestions.
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>>
>> "Code Agent" <(E-Mail Removed)> wrote in message
>> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>> >I posted a question about a week ago about can grow vertical lines.
>> >Someone
>> > posted a link to someone that has set up a database that does that but
>> > I
>> > can't figure out all the code to make it work. Is there something I can
>> > import into my database or copy and paste in a module? Basically I
>> > can't
>> > figure out what all that code means, and cant get it to work.
>>
>>
>>

I am looking at that one but what about the code I provided below. I am
desperately trying to figure out WHERE I got it (Maybe someone watching this
thread will know) but it works for vertical lines. I put it on the
Detail_Format of my report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II


"Gina Whipp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is it the PrintLines? Is this the code you are refering to?
>
> Me.ScaleMode = 1
> Me.ForeColor = 6723891
>
> 'Repeat the following line of code for each vertical line
> ' 1*1440 represents 1 inch
> Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Draws line at Left Margin
> Me.Line (0.6667 * 1440, 0)-(0.6667 * 1440, 14400)
> Me.Line (1.4583 * 1440, 0)-(1.4583 * 1440, 14400)
> Me.Line (2.25 * 1440, 0)-(2.25 * 1440, 14400)
> Me.Line (3.5833 * 1440, 0)-(3.5833 * 1440, 14400)
> Me.Line (7.4167 * 1440, 0)-(7.4167 * 1440, 14400)
> Me.Line (8.25 * 1440, 0)-(8.25 * 1440, 14400)
> Me.Line (9.1667 * 1440, 0)-(9.1667 * 1440, 14400)
> Me.Line (10 * 1440, 0)-(10 * 1440, 14400)
>
> 'the 14400 is an arbitrary number to increase the line to the max of a
> 'section.
>
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
>
> "Code Agent" <(E-Mail Removed)> wrote in message
> news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
>> Someone sent me this link: www.lebans.com There is a database you can
>> download that has the code for it
>>
>>
>> "Gina Whipp" wrote:
>>
>>> Ummm, what was the link or the database? No one here can see what code
>>> you're refering to to make suggestions.
>>>
>>> --
>>> Gina Whipp
>>>
>>> "I feel I have been denied critical, need to know, information!" -
>>> Tremors
>>> II
>>>
>>>
>>> "Code Agent" <(E-Mail Removed)> wrote in message
>>> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>>> >I posted a question about a week ago about can grow vertical lines.
>>> >Someone
>>> > posted a link to someone that has set up a database that does that but
>>> > I
>>> > can't figure out all the code to make it work. Is there something I
>>> > can
>>> > import into my database or copy and paste in a module? Basically I
>>> > can't
>>> > figure out what all that code means, and cant get it to work.
>>>
>>>
>>>
>
>

Okay, I got my code from here: http://support.microsoft.com/kb/q208429/ no
modules, just like the sample code I sent to you.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II


"Code Agent" <(E-Mail Removed)> wrote in message
news:6E1CD703-1EDD-4ABC-A906-(E-Mail Removed)...
> Sorry about that
>
> http://www.lebans.com/PrintLines.htm
>
> "Gina Whipp" wrote:
>
>> Okay, which database, there are quite a few there.
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>>
>> "Code Agent" <(E-Mail Removed)> wrote in message
>> news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
>> > Someone sent me this link: www.lebans.com There is a database you can
>> > download that has the code for it
>> >
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> Ummm, what was the link or the database? No one here can see what
>> >> code
>> >> you're refering to to make suggestions.
>> >>
>> >> --
>> >> Gina Whipp
>> >>
>> >> "I feel I have been denied critical, need to know, information!" -
>> >> Tremors
>> >> II
>> >>
>> >>
>> >> "Code Agent" <(E-Mail Removed)> wrote in message
>> >> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>> >> >I posted a question about a week ago about can grow vertical lines.
>> >> >Someone
>> >> > posted a link to someone that has set up a database that does that
>> >> > but
>> >> > I
>> >> > can't figure out all the code to make it work. Is there something I
>> >> > can
>> >> > import into my database or copy and paste in a module? Basically I
>> >> > can't
>> >> > figure out what all that code means, and cant get it to work.
>> >>
>> >>
>> >>
>>
>>
>>

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"Gina Whipp" wrote:

> I am looking at that one but what about the code I provided below. I am
> desperately trying to figure out WHERE I got it (Maybe someone watching this
> thread will know) but it works for vertical lines. I put it on the
> Detail_Format of my report.
>
> --
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
>
> "Gina Whipp" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Is it the PrintLines? Is this the code you are refering to?
> >
> > Me.ScaleMode = 1
> > Me.ForeColor = 6723891
> >
> > 'Repeat the following line of code for each vertical line
> > ' 1*1440 represents 1 inch
> > Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Draws line at Left Margin
> > Me.Line (0.6667 * 1440, 0)-(0.6667 * 1440, 14400)
> > Me.Line (1.4583 * 1440, 0)-(1.4583 * 1440, 14400)
> > Me.Line (2.25 * 1440, 0)-(2.25 * 1440, 14400)
> > Me.Line (3.5833 * 1440, 0)-(3.5833 * 1440, 14400)
> > Me.Line (7.4167 * 1440, 0)-(7.4167 * 1440, 14400)
> > Me.Line (8.25 * 1440, 0)-(8.25 * 1440, 14400)
> > Me.Line (9.1667 * 1440, 0)-(9.1667 * 1440, 14400)
> > Me.Line (10 * 1440, 0)-(10 * 1440, 14400)
> >
> > 'the 14400 is an arbitrary number to increase the line to the max of a
> > 'section.
> >
> >
> > --
> > Gina Whipp
> >
> > "I feel I have been denied critical, need to know, information!" - Tremors
> > II
> >
> >
> > "Code Agent" <(E-Mail Removed)> wrote in message
> > news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
> >> Someone sent me this link: www.lebans.com There is a database you can
> >> download that has the code for it
> >>
> >>
> >> "Gina Whipp" wrote:
> >>
> >>> Ummm, what was the link or the database? No one here can see what code
> >>> you're refering to to make suggestions.
> >>>
> >>> --
> >>> Gina Whipp
> >>>
> >>> "I feel I have been denied critical, need to know, information!" -
> >>> Tremors
> >>> II
> >>>
> >>>
> >>> "Code Agent" <(E-Mail Removed)> wrote in message
> >>> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
> >>> >I posted a question about a week ago about can grow vertical lines.
> >>> >Someone
> >>> > posted a link to someone that has set up a database that does that but
> >>> > I
> >>> > can't figure out all the code to make it work. Is there something I
> >>> > can
> >>> > import into my database or copy and paste in a module? Basically I
> >>> > can't
> >>> > figure out what all that code means, and cant get it to work.
> >>>
> >>>
> >>>
> >
> >
>
>
>

You're most welcome!

--
Gina Whipp


"Code Agent" <(E-Mail Removed)> wrote in message
news:4C7F4360-8DD5-432B-A173-(E-Mail Removed)...
> Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> "Gina Whipp" wrote:
>
>> I am looking at that one but what about the code I provided below. I am
>> desperately trying to figure out WHERE I got it (Maybe someone watching
>> this
>> thread will know) but it works for vertical lines. I put it on the
>> Detail_Format of my report.
>>
>> --
>> Gina Whipp
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>>
>> "Gina Whipp" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Is it the PrintLines? Is this the code you are refering to?
>> >
>> > Me.ScaleMode = 1
>> > Me.ForeColor = 6723891
>> >
>> > 'Repeat the following line of code for each vertical line
>> > ' 1*1440 represents 1 inch
>> > Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Draws line at Left Margin
>> > Me.Line (0.6667 * 1440, 0)-(0.6667 * 1440, 14400)
>> > Me.Line (1.4583 * 1440, 0)-(1.4583 * 1440, 14400)
>> > Me.Line (2.25 * 1440, 0)-(2.25 * 1440, 14400)
>> > Me.Line (3.5833 * 1440, 0)-(3.5833 * 1440, 14400)
>> > Me.Line (7.4167 * 1440, 0)-(7.4167 * 1440, 14400)
>> > Me.Line (8.25 * 1440, 0)-(8.25 * 1440, 14400)
>> > Me.Line (9.1667 * 1440, 0)-(9.1667 * 1440, 14400)
>> > Me.Line (10 * 1440, 0)-(10 * 1440, 14400)
>> >
>> > 'the 14400 is an arbitrary number to increase the line to the max of
>> > a
>> > 'section.
>> >
>> >
>> > --
>> > Gina Whipp
>> >
>> > "I feel I have been denied critical, need to know, information!" -
>> > Tremors
>> > II
>> >
>> >
>> > "Code Agent" <(E-Mail Removed)> wrote in message
>> > news:985159EF-BDFE-4FF6-9F12-(E-Mail Removed)...
>> >> Someone sent me this link: www.lebans.com There is a database you can
>> >> download that has the code for it
>> >>
>> >>
>> >> "Gina Whipp" wrote:
>> >>
>> >>> Ummm, what was the link or the database? No one here can see what
>> >>> code
>> >>> you're refering to to make suggestions.
>> >>>
>> >>> --
>> >>> Gina Whipp
>> >>>
>> >>> "I feel I have been denied critical, need to know, information!" -
>> >>> Tremors
>> >>> II
>> >>>
>> >>>
>> >>> "Code Agent" <(E-Mail Removed)> wrote in message
>> >>> news:43DCE572-1951-4927-B305-(E-Mail Removed)...
>> >>> >I posted a question about a week ago about can grow vertical lines.
>> >>> >Someone
>> >>> > posted a link to someone that has set up a database that does that
>> >>> > but
>> >>> > I
>> >>> > can't figure out all the code to make it work. Is there something I
>> >>> > can
>> >>> > import into my database or copy and paste in a module? Basically I
>> >>> > can't
>> >>> > figure out what all that code means, and cant get it to work.
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>