[ALVINCHAAND]

Help required. thank you in advance for any help provided

In a form where the user is supposed to enter a date, the user can
click on a link, which pops up a small calendar within that page (not
a popup window) so that the user can select a date. After the user
clicks on a date, the calendar disappears and the form is filled with
the selected date.How do i acheive this in the Userform?

sorry my print screen aint working...so cant attach my userform to show but basically what my form does is asks user for input of the following:
DATE
ITEM( COMBO BOX WITH MAINTENANCE, RENTAL, DONATIONS ETC)
REMARKS (TO ADD MORE DETAIL OF THE CASH SPENT)
DEPOSITS
WITHDRAWALS
BALANCE

CALCULATE AND UPDATE BUTTONS

[dineeshd]

You can achieve this by using datetimepicker control. Add reference to Microsoft Windows Common Controls 6.0 (SP6), you can find the control there.

[ALVINCHAAND]

hello
thank you for the fast response. problem is i am just a beginner in VB. I dont quite understand what i am supposed to do.could u pls elaborate more? how do i add a reference? sorry for the inconveniences.thank you

[dineeshd]

Go to Project Menu-->Components, from the list select "Microsoft Windows Common Controls 6.0" and apply. New controls will be added to toolbox.

[thava]

right click on the toolbar click components

[dineeshd]

thava, on 19 Aug, 2008 - 06:41 AM, said:

right click on the toolbar click components

Yes you are right, components can be accessed from toolbar too.

[ALVINCHAAND]

dineeshd, on 18 Aug, 2008 - 02:52 AM, said:

Go to Project Menu-->Components, from the list select "Microsoft Windows Common Controls 6.0" and apply. New controls will be added to toolbox.

Thank you i finally got my calendar to work....
Now for another question:

in my userform, user will be able to enter a deposit amt and a withdrawal amt...
i need to be able to compute the balance.... also must be able to add previous balance to this amt...
how can i go abt doing so?
i know that i m supposed to take the value the user enters by doing a deposit.val-withdrawal.val=currentbal
this balance must be added to the previous balance to give the user the updatedbalance. how do i call the previous balance value from the excel sheet?

ALVINCHAAND, on 21 Aug, 2008 - 06:29 AM, said:

dineeshd, on 18 Aug, 2008 - 02:52 AM, said:

Go to Project Menu-->Components, from the list select "Microsoft Windows Common Controls 6.0" and apply. New controls will be added to toolbox.

Thank you i finally got my calendar to work....
Now for another question:

in my userform, user will be able to enter a deposit amt and a withdrawal amt...
i need to be able to compute the balance.... also must be able to add previous balance to this amt...
how can i go abt doing so?
i know that i m supposed to take the value the user enters by doing a deposit.val-withdrawal.val=currentbal
this balance must be added to the previous balance to give the user the updatedbalance. how do i call the previous balance value from the excel sheet?

Private Sub CMD_CANCEL_Click()
Unload Me
End Sub

Private Sub CMD_CALCULATE_Click()

'DEPOSITS -WITHDRAWAL = currentBalanceAmt then need to add this balane amt to the previous to get the most uptodate balance to display in the userform and in the excel spreadsheet db

End Sub

Private Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

Private Sub ITEM_COMBO_Change()
ITEM_COMBO.DropDown
End Sub
Private Sub CMD_UPDATE_Click()

Dim iRow As Long
Dim WS As Worksheet
Set WS = Worksheets("CASH_FLOW08") 'CHANGE TO SHEET NAME THAT U WISH UR UPDATE TO APPEAR IN


'find first empty row in database
iRow = WS.Cells(Rows.Count, 1) _
  .End(xlUp).Offset(1, 0).Row


'copy the entered data to the database
WS.Cells(iRow, 1).Value = Me.DTPicker1.Value
WS.Cells(iRow, 2).Value = Me.ITEM_COMBO.Value
WS.Cells(iRow, 3).Value = Me.REMARKS.Value
WS.Cells(iRow, 4).Value = Me.DEPOSITS.Value
WS.Cells(iRow, 5).Value = Me.WITHDRAWAL.Value

'clear the data after first set of data is entered in db so that user can enter next set
'Me.DTPicker1.Value
Me.ITEM_COMBO.Value = ""
Me.REMARKS.Value = ""
Me.DEPOSITS.Value = ""
Me.WITHDRAWAL.Value = ""
Me.DTPicker1.SetFocus

End Sub

[thava]

put a opening balance variable and use that to store the pervious balance

[ALVINCHAAND]

thava, on 21 Aug, 2008 - 08:27 AM, said:

put a opening balance variable and use that to store the pervious balance

Thank you for the quick response. IS this the way of doing it?
Also this is incomplete...i need to call the previous balance value from the database and add it to the curBal.
How do i do that?

How do i assign the curBal to be displayed in the Available Balance(Av_BAL) Textbox when the calculate button is pressed?

[code]
Private Sub CMD_CALCULATE_Click()

Option Explicit

Dim curBal As Currency
Dim awithdrawal As Currency
Dim adeposit As Currency
Dim Av_BAL As Currency

awithdrawal = WITHDRAWAL.Text
adeposit = DEPOSITS.Text

curBal = DEPOSITS.Text - WITHDRAWAL.Text
'but this is incomplete...i need to call the previous balance value from the database and add it to the curBal.
How do i do that?

'How do i assign the curBal to be displayed in the Available Balance(Av_BAL) Textbox when the calculate button is pressed?

End Sub

[thava]

could you explain your database structure
and which fields to store deposit, with drawal erc..

[ALVINCHAAND]

thava, on 21 Aug, 2008 - 06:01 PM, said:

could you explain your database structure
and which fields to store deposit, with drawal erc..

hi there

my database is very simple

just the following columns

Date (from the datepicker)
item (selected frm the combobox values in userform)
remarks (textbox for user to input additional info)
deposits (this field can be left blank if no deposits made or a value can be entered)
withdrawals
balance (still figuring out the formula for this... )
came up with =SUM(CELL("contents",F5)-CELL("contents",E6))+CELL("contents",D6)
where balance=f5, withdrawal=e6, deposits=d6

cuz i need to have the previous (balance-withdrawal)+deposit to appear in the next row when its updated but it doesnt seem to work too well...any sugestions on this?)

on the userform, i want the latest balance to be computed and displayed.how do i do that?