473,597 Members | 2,157 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What is wrong with this VBA code?

I downloaded TimeLines.zip from
(http://www.mvps.org/access/reports/rpt0018.htm) and I think I found a
bug in it but I can't seem to fix it. When you open this go to the
table and enter a new event and put it's start date at like12/01/1999
and the end date at 12/31/1999. Then go to the report and find your new
entered event. If it does what it does on my computer you will notice
that for some reason the bar is in the wrong place. I'm guessing that
it has something to do with the math in the detail_Format section. The
report is perfect for what I need but if you put in an event in the
latter half of the timeline it doesn't seem to show correctly on the
chart. Any Ideas.
Thanks
Shawn Yates

Jul 18 '06 #1
11 3281

Oops I forgot to post the VBA code here is all of it:

Option Compare Database
Option Explicit

Private mdatEarliest As Date
Private mdatLatest As Date
Private mintDayDiff As Integer
------------------------------------------------------------------------------------------------------
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

On Error Resume Next

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
Me.boxGrowForDa te.Visible = True
Me.lblTotalDays .Visible = True
intStartDayDiff = Abs(DateDiff("d ", Me.StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", Me.EndDate, Me.StartDate))

If intStartDayDiff = 0 Then intStartDayDiff = 1
With Me.boxGrowForDa te
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor
End With
Me.lblTotalDays .Left = Me.boxGrowForDa te.Left
Me.lblTotalDays .Caption = intDayDiff & " Day(s)"
Else '
Me.boxGrowForDa te.Visible = False
Me.lblTotalDays .Visible = False
End If
End Sub
---------------------------------------------------------------------------------------------------------
Private Sub Report_Open(Can cel As Integer)
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordse t("SELECT Min([Start Date]) AS MinOfStartDate
" _
& " FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatEarliest = rs!MinOfStartDa te
End If
Set rs = db.OpenRecordse t("SELECT Max(IIf(IsDate([End
Date]),CDate([End Date]),Null)) " _
& "AS MaxOfEndDate FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatLatest = rs!MaxOfEndDate
End If

mintDayDiff = DateDiff("d", mdatEarliest, mdatLatest)

Me.txtMinStartD ate.Caption = Format(mdatEarl iest, "mm/dd/yyyy")
Me.txtMaxEndDat e.Caption = Format(mdatLate st, "mm/dd/yyyy")
Set rs = Nothing
Set db = Nothing
End Sub

Jul 18 '06 #2
Classic bug, the left position is set before the width.

So
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor

Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@p 79g2000cwp.goog legroups.com...
I downloaded TimeLines.zip from
(http://www.mvps.org/access/reports/rpt0018.htm) and I think I found a
bug in it but I can't seem to fix it. When you open this go to the
table and enter a new event and put it's start date at like12/01/1999
and the end date at 12/31/1999. Then go to the report and find your new
entered event. If it does what it does on my computer you will notice
that for some reason the bar is in the wrong place. I'm guessing that
it has something to do with the math in the detail_Format section. The
report is perfect for what I need but if you put in an event in the
latter half of the timeline it doesn't seem to show correctly on the
chart. Any Ideas.
Thanks
Shawn Yates

Jul 19 '06 #3
Hi Shawn,

As a general rule you should avoid using 'On Error Resume Next'.
Anything could be happening in your code and you would not realise what
was going on (it also makes debugging easier as the code will stop
where the error occurs).

Good Luck

Nick

Shawn Yates wrote:
Oops I forgot to post the VBA code here is all of it:

Option Compare Database
Option Explicit

Private mdatEarliest As Date
Private mdatLatest As Date
Private mintDayDiff As Integer
------------------------------------------------------------------------------------------------------
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

On Error Resume Next

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
Me.boxGrowForDa te.Visible = True
Me.lblTotalDays .Visible = True
intStartDayDiff = Abs(DateDiff("d ", Me.StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", Me.EndDate, Me.StartDate))

If intStartDayDiff = 0 Then intStartDayDiff = 1
With Me.boxGrowForDa te
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor
End With
Me.lblTotalDays .Left = Me.boxGrowForDa te.Left
Me.lblTotalDays .Caption = intDayDiff & " Day(s)"
Else '
Me.boxGrowForDa te.Visible = False
Me.lblTotalDays .Visible = False
End If
End Sub
---------------------------------------------------------------------------------------------------------
Private Sub Report_Open(Can cel As Integer)
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordse t("SELECT Min([Start Date]) AS MinOfStartDate
" _
& " FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatEarliest = rs!MinOfStartDa te
End If
Set rs = db.OpenRecordse t("SELECT Max(IIf(IsDate([End
Date]),CDate([End Date]),Null)) " _
& "AS MaxOfEndDate FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatLatest = rs!MaxOfEndDate
End If

mintDayDiff = DateDiff("d", mdatEarliest, mdatLatest)

Me.txtMinStartD ate.Caption = Format(mdatEarl iest, "mm/dd/yyyy")
Me.txtMaxEndDat e.Caption = Format(mdatLate st, "mm/dd/yyyy")
Set rs = Nothing
Set db = Nothing
End Sub
Jul 19 '06 #4

Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
..Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
..Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?

Jul 19 '06 #5
I would write the procedure something like

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))

If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t +
..boxMaxDays.Wi dth Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) .boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
..lblTotalDays. Width
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub

--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?

Jul 19 '06 #6
I should have added:-

Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.

My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--

Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))

If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
..boxMaxDays.Le ft
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub

--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...

Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?


Jul 20 '06 #7
I should have added:-

Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.

My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--

Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))

If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
..boxMaxDays.Le ft
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub

--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...

Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?



Jul 20 '06 #8
For a fully working database, if you have an issue then the On Error
Resume Next gets round with out having to write reams of code then yes
it is just another tool. However if you are developing a database it
is and I think that you will agree a big no no. I feel that if you do
use it you should use it only for the lines of code that need it, then
turn the error handling on again.

Good Luck

Nick

Terry Kreft wrote:
I should have added:-

Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.

My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--

Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))

If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
.boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub

--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
>
Jul 20 '06 #9

Terry Kreft wrote:
I should have added:-

Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.

My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--

Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff

If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))

If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
.boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub

--

Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
>
Jul 20 '06 #10

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

Similar topics

125
14654
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from software giant such as Microsoft SQL Server, Oracle, and Sybase? Is PostgreSQL reliable enough to be used for high-end commercial application? Thanks
72
5799
by: E. Robert Tisdale | last post by:
What makes a good C/C++ programmer? Would you be surprised if I told you that it has almost nothing to do with your knowledge of C or C++? There isn't much difference in productivity, for example, between a C/C++ programmers with a few weeks of experience and a C/C++ programmer with years of experience. You don't really need to understand the subtle details or use the obscure features of either language
121
9990
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather than a PHP IDE. It only supports basic IntelliSense (or code completion) and doesn't have anything...
51
13339
by: WindAndWaves | last post by:
Can anyone tell me what is wrong with the goto command. I noticed it is one of those NEVER USE. I can understand that it may lead to confusing code, but I often use it like this: is this wrong????? Function x select case z
46
4184
by: Keith K | last post by:
Having developed with VB since 1992, I am now VERY interested in C#. I've written several applications with C# and I do enjoy the language. What C# Needs: There are a few things that I do believe MSFT should do to improve C#, however. I know that in the "Whidbey" release of VS.NET currently
13
5029
by: Jason Huang | last post by:
Hi, Would someone explain the following coding more detail for me? What's the ( ) for? CurrentText = (TextBox)e.Item.Cells.Controls; Thanks. Jason
1
1460
by: GS | last post by:
I got a combobox box that I load at load time. the Item and vales ended up in reverse order of each other, what went wrong? the database table has the following row code value ebay http://www.ebay.com google http://www.google.com yahoo http://www.yahoo.com However in the drop down list displayed value used ebay http://www.yahoo.com
98
4546
by: tjb | last post by:
I often see code like this: /// <summary> /// Removes a node. /// </summary> /// <param name="node">The node to remove.</param> public void RemoveNode(Node node) { <...> }
9
2114
by: Pyenos | last post by:
import cPickle, shelve could someone tell me what things are wrong with my code? class progress: PROGRESS_TABLE_ACTIONS= DEFAULT_PROGRESS_DATA_FILE="progress_data" PROGRESS_OUTCOMES=
20
2802
by: Daniel.C | last post by:
Hello. I just copied this code from my book with no modification : #include <stdio.h> /* count characters in input; 1st version */ main() { long nc; nc = 0;
0
7885
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,...
0
8271
Oralloy
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...
0
8258
tracyyun
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...
0
6686
agi2029
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...
1
5847
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5426
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();...
0
3881
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3923
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2399
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.