devilz

Dear reader (s), In my AccessDB, JanuaryDay(Table) having two columns JanDate & JanShift. JanDate contains all the dates of each month and JanShift contains text value for each date. Its like: Id JanDate JanShift 1 1/1/09 SM 2 1/2/09 M ……………………… ……………………… 31 1/31/09 M I Can retrieve the recordset …

In my AccessDB the column monthDate having data type: “date”. In VB6.0 label.caption is the value which I need to save in monthDate. Like: Label1.caption= 2/24/09. Problem is how will I convert the label.caption as date value so that i can save it in monthDate column. I don’t want to …

Can any one please help me?? Using VB 6.0 and Access DB. [code] ssql2 = "INSERT INTO JanuaryDay (JanRm_id) SELECT rmd_id FROM RmIdIndex WHERE rm_id= " & CLng(txtrostermid.Text) rsName.Open ssql2, conName, adOpenDynamic, adLockOptimistic rsmnth.Open "select * from JanuaryDay", conName, adOpenDynamic, adLockOptimistic rsmnth.MoveFirst Do While Not rsmnth.EOF ‘here is the problem. …

Hello reader(s), In table1 i have 3 columns named: emp_id, month, year. First i'm inserting emp_id from a recordset with validation from a text box. Problem is: In the same row i need to insert data of month and year column from individual text box. Code should like: insert into …

Hello reader(s), Here is my code: [code] Private Sub Combo1_Click() Dim r conName.Provider = "Microsoft.Jet.OLEDB.4.0" conName.ConnectionString = App.Path & "\rosterdb.mdb" conName.CursorLocation = adUseClient conName.Open rsid.Open "select * from DayWiseRoster", conName, adOpenDynamic, adLockOptimistic ' in below loop i got the problem. it prompts "loop without do" Do While Not rsid.EOF If …

I’m very very new in VB6.0 in my project I need a function where I want to pass month name as variable value which will be selected from a combo box by user and the function will generate the full date from starting to end along with the weekday name. …

Hello readers, I'm very new with VB6.0. Can you please help me?? There are two tables in my Access DB. Users are inputting Emp_id(PK) in Table1. Under combo_click i need to save all Emp_id from Table1 into emp_id column(FK of Table1) of Table2. It is possible to save date in …

I’m very very new in VB6.0 in my project I need a function where I want to pass month name as variable value which will be selected from a combo box by user and the function will generate the full date from starting to end along with the weekday name. …