Search results

I have a problem in rounding the value. intMonthToMove = 1,2,3,4..............................200 newvalue = VBA.Round(Monthe / 12) + 1 (This statement doesnot work as below) I need to have newvalue in this way: Month newvalue 1.....12 1 13.....24 2 25.....36 3 37.....48 4 ...etc...

I have to update year after 12 clicks (i.e after moving 12 months) on the scrollbar? Any help really appreciated.

I have to update year after 12 clicks (i.e after moving 12 months) on the scrollbar? Any help really appreciated.

That did not help. As I move scroll bar the month should be moved when the Jan comes again the year should be updated. (check the first post) Moving month works but I not knowing how to update the year. Moving months code is posted. (works) txtYear1 = Format(CDate("1/1/" &...

I have a form with months Jan --- Dec. When click on the scroll bar the months should be moved and the year should be updated. For Example: Year(2008) Jan Feb .............Dec When I click on scroll bar it Year(2009) Feb Mar April ......Dec Jan The year should be updated once the...

I have a form which displays months from Jan to Dec. Wen I scroll horizontal bar of the form, The Jan should be moved next to the Dec. For Example. Jan Feb Mar April May June .........Dec When the horizontal bar is moved it should be in this way. Feb Mar April may June ...

I have months and Years. Is there a way convert that month and year in to the date. For example: I have rectangular bar in a form alligned according to there month say "April" and year say "2009". Now this information should be changed to date such as 4/1/2009. Any help is appreciated.

What does this Clng(CDate(Nz(TxtYear))) mean? Where TxtYear is 2008. Thank you

Scrolling Horizontal ScrollBar Hi I have to scroll horizontal scrollbar and the scrollbar should move back 12 months and forward 24 months. Any help is appreciated.

Finally got it.

It is working partially but there is a small problem. Actually the bars are assigning from the left side of the form. But I need bars after some width The code: Forms!frmRest("Bar" &Row).Left = intExtractMonth * 720 The output when I executed with the previous code: checkbox ID...

These statements worked fine before. Debug.Print rstProjects!DateStarted Count = DatePart("m", rstProjects!DateStarted) But now I am having error: It says "invalid use of Null" at this statement "Count = DatePart("m", rstProjects!DateStarted)" Forms!frmPipeline("recBar" & intRow).Left =...

George, The datestarted worked. Worked: Debug.Print rstProjects!DateStarted Count = DatePart("m", rstProjects!DateStarted) Error: Forms!frmPipeline("recBar" & intRow).Left = Count - Me("recBar" & intRow).Width ------------(1) It says...

George, I am doing this way (I have a recordset that gives the date from the table ) When I debugged it gave me the width of the bar but still confused of this. I am getting error that item not found at this line Count = DatePart("m", rstProject!DateStarted) Could you check the code I...

George, you said to multiply the month of the year(i.e. say july i.e 7) minus 1 times the width of the control. Actually the width is in inches in the properties window. So I do I caluculate it. Any hint is appreciated

The ouput of this should be the rectangular bars should allign according to the dates in the table

I have a date in the table. In form i have a rectangular bars and when I open the form the rectangular bars should open according to the dates in the table. In the form I have months from Jan to dec. In Table I have date in 01/01/2008. How to assign the date in the table to the form with...

I have a date in the table. In form i have a rectangular bars and when I open the form the rectangular bars should open according to the dates in the table. In the form I have months from Jan to dec. In Table I have date in 01/01/2008. How to assign the date in the table to the form with...

Can you give me any hint on how to convert date to twips?

I have a form and I have to move the control i.e. the bar on the form depending on there start date in the table. I tried this syntax but did not work Forms!frmrest("recBar" & intRow).Left = rstProjects.DateStarted It says" overflow" error. Any hint on it.