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  

Timetable



 
 
Thread Tools Display Modes
  #31  
Old October 14th, 2006, 03:03 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

Come back with the exact code that you are using and the line(s) causing the
error.

--
Duane Hookom
MS Access MVP

"hobbit2612 via AccessMonster.com" u27332@uwe wrote in message
news:67c0ad6bd886e@uwe...
Hi Duane,

Thanks for getting back to me.

Unfortunately the code doesn't seem to work, it still won't work if the
test
dates are blank.

The error message that it shows is Run-Time error '13': Type mismatch.

I know the code you gave me was to test whethe the field are blank. Due to
the query that i've set up I can see whether the fields are blank. is
there
anyway to actually say to ignore any blank test date fields?

Many thanks

Chris

Duane Hookom wrote:
You can test for Null with the function IsNull().

For intTextBox = 1 to 7
If IsNull(Me("txtTest" & intTextBox)) Then
Me("txtTest" & intTextBox).Visible = False
Else
Me("txtTest" & intTextBox).Visible = True
lngStart = DateDiff("d", datStart, Me("txtTest" & intTextBox)
Me("txtText" & intTextBox).Left = (lngStart * dblFactor) +
lngLMarg
End If
Next

Duane,

[quoted text clipped - 38 lines]
you
mean?


--
Message posted via http://www.accessmonster.com



  #32  
Old October 14th, 2006, 03:17 PM posted to microsoft.public.access.reports
hobbit2612 via AccessMonster.com
external usenet poster
 
Posts: 107
Default Timetable

Duane,

No need to worry. After I sent my post to the forum I continued to try
different ways of writing the coding from the limited knowledge I had, as I
said before I am keen to learn.

I had a bit of a brain wave and I managed to change the coding very slightly
and it works a treat.

I really can't thank you enough for all the help that you've given me over
these last few weeks. It would be great to buy you a drink, but that's
obviously not practical with you living in the States and me in the UK.

But I am really so grateful for helping me out with this troublesome project
that I had.

Kind regards and once again sincere thanks.

Chris


Duane Hookom wrote:
Come back with the exact code that you are using and the line(s) causing the
error.

Hi Duane,

[quoted text clipped - 33 lines]
you
mean?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200610/1

  #33  
Old October 14th, 2006, 03:29 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

Glad to be of assistance. Just find the most attractive lady in a pub and
buy her a drink. Tell her it is compliments of Duane from Wisconsin in the
States!


--
Duane Hookom
MS Access MVP


"hobbit2612 via AccessMonster.com" u27332@uwe wrote in message
news:67c15bfccf5b4@uwe...
Duane,

No need to worry. After I sent my post to the forum I continued to try
different ways of writing the coding from the limited knowledge I had, as
I
said before I am keen to learn.

I had a bit of a brain wave and I managed to change the coding very
slightly
and it works a treat.

I really can't thank you enough for all the help that you've given me over
these last few weeks. It would be great to buy you a drink, but that's
obviously not practical with you living in the States and me in the UK.

But I am really so grateful for helping me out with this troublesome
project
that I had.

Kind regards and once again sincere thanks.

Chris


Duane Hookom wrote:
Come back with the exact code that you are using and the line(s) causing
the
error.

Hi Duane,

[quoted text clipped - 33 lines]
you
mean?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200610/1



  #34  
Old October 14th, 2006, 03:38 PM posted to microsoft.public.access.reports
hobbit2612 via AccessMonster.com
external usenet poster
 
Posts: 107
Default Timetable

Duane,

No problem at all!

Regards

Chris

Duane Hookom wrote:
Glad to be of assistance. Just find the most attractive lady in a pub and
buy her a drink. Tell her it is compliments of Duane from Wisconsin in the
States!

Duane,

[quoted text clipped - 28 lines]
you
mean?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200610/1

  #35  
Old March 15th, 2007, 07:05 PM posted to microsoft.public.access.reports
Iman[_2_]
external usenet poster
 
Posts: 1
Default error

my time line are in years, my project activities may span 20 years.

I tried the code below and it works, when I modify it to use my data I get "Method or data member not found (Error 461)"

and the debugger is at the boxtimeline

what should I do?

Thank you


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 




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


All times are GMT +1. The time now is 11:18 AM.


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