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. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|