var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dumb Newbie
Iva attached my database for view to make sure I at least set that up correctly..
Basically I have a VB program with a custom calendar. I need to load my custom calendar with dates from my Database
In order to do that I must tell you..I refer to the valid dates for the given month the user is in through a variable loop starting with "StartPoint" and ending with "StopPoint"
StopPoint being the number of days in a particular month.
What I need to do is have my program look at the database
Then Determine the month the and year the user is working in
Then load the values for the days of that month for the current employee the user is on
I Started to attemp this as follows:
Private Sub LoadValues()
Dim SQLString, SomeDay As String
Dim I As Integer
Dim StartPoint, StopPoint As Integer
'Add Values to textBoxes
For StartPoint = StartPoint To StopPoint Step 1 'loop only though valid textboxes
SomeDay = MyMonth & "/" & StartPoint & "/" & CboYear.Text
SQLString = "SELECT * FROM TblEmpAttendance WHERE Date = '" & SomeDay & "'"
TxtDate(StartPoint).Text = SqlStatement
Unfortunatley I dont know even where to begin.
I need to load my txtdate(i) textbox array with the values returned in the sql string. Instead it loading them with the sqlstring itsself
I cant even get the sqlstring to get looked at correctly by my program
Thanks in advance-Greg (using vb6 NOt vb.bet!)