smile4evr

hi all.... this is another thread on datareports... i need to know how to work if i have an sql and i wish to give it in my front end and run the report from the front end... please help!! thanking in advance!!

hi all! my project is with VB at the front end and MS Access at the back end!...i wish to know how to connect to MS Outlook based on a mail id taken from my employee database! please help... very very urgent ! thanks a lot!...

hey all! please help me to check for validaiton such that... i hv few textboxes and combo boxes and if data is not entered in them then the submit button should be locked... and also tell me where should i write the code as in .... in form_load or submit_click... …

HI ALL....all posts n posters in daniweb hv helped a lot alwayz...one more help needed...i want to know about datareports.... now i need my reports to be generated under different conditions...... it should be able to retrtieve da data as well as print if required! ive tried through many sites …

hi all... i want to know if using simlpe combo with dropdown style 2 (where you cant type ur own data) im not able to retrieve data coz its showing that its has read only property... is it possible that i can change the syle property of my combo box... …

hi... i have a small doubt in hw to check the initial charecters in text... like if the first two letters of my text is OS or TP... so based on that i should be able to select which database to select... and one more doubt is dat suppose i …

hi... this is a small doubt in VB6... i am making a request form... in which one of the fields are reasons... now i want it such if my user send in a new reason then it should get written into my database and generate it as a part of …

hi all!... i have a small doubt... incase i have a database field for ID and i want my id to be of 5 digit field length... and append with zeros incase there are less than 5 digits... example if the number is 34 it should become 00034 please help!.. …

hw to add multiple conditions in a single update statement?? my project goes code like this... [code] If release.Enabled = True And nonosc.Enabled = True Then Dim rst12 As New Recordset Dim sql12 As String sql12 = "update Passport_Release_Information_N set Ename2='" & taker.Text & "' ,Any_ID1='" & takerid.Text & "' …

is this solved???

please can u help me with all basic VB coding like... if command button is clicked from one form how can i link it to another form in the same project and a few examples of simple codings at the basic level... thankx a lot!

please help me out in wat could be the error in the below code as it is not running when it comes down to the openrecordset statement! [code] Private Sub cmdOK_Click() Dim rst As DAO.Recordset 'check for null password If IsNull(Trim(userid)) Then MsgBox "User Name required.", vbExclamation userid.SetFocus Exit Sub …

can someone please help me with using tabs and hw to set the system date in vb6

just try this out... Private FuelLevel As Double FuelLevel = 0# ... i guess ur not suppose to assign where u r declaring.... not too good wid VB...sorry if nt much of help...

hey all... my project is showing some error in this code... plz help... [code] Dim RS As New adodb.Recordset Dim getname As String Dim logginname As String getname = "SELECT E_name FROM Employee_Details WHERE E_ID ='" & logid.Caption & "'" CN.Execute getname RS.Open getname, CN Label7.Caption = RS.Fields(0) [/code] thnx! …

i hv a vb6 form connected to the ms acess... it has multiple tabs so if a user wants to make any one of the two then a unique key should be followed... preferably the key should be followed by the system year as this could be used for many …

hi every1... i hv a doubt in updating my date... i hv a textbox asking for the number of days(days1).... n a dtpicker1 that should show the date after the number of days(days1) from the date the form is run and submitted.... there is a lable today that takes the …

Hi all... please help me with this code... i hv retrieved the id of the employee from the login n stored it as a lable in my form- logid but now with respect to that i want to get the employee name... please help very urgent!! [code] Dim rs As …

sorry but y don u try storing ur usernames and passwords in an access and then combine the both as in notepad it is easily editable! not much sure of hw to do in notepad thatz y! -smile4evr

hi... im finding an error in the following statement... here department is my database name... n deptid n deptname is the name of the fields on the form... when i run the form it shows "No value given for one or more parameters." [code]sql = "INSERT INTO Department(Department_ID,Department_name)VALUES(deptid,Text2)"[/code] please help …

Im not able to run my program witht the following code! [ICODE] Dim rst As ADODB.Recordset Dim sql1 As String sql1 = "insert into Passport_Release VALUES('0259','14/09/2008','returned')" CN.Execute sql1 As Recordset [/ICODE] instead of the last statement i even tried CN.Execute sql1 alone.... but nothing is working... i doubt if error …

i have made a sstab with three tabs... i want to know that if i hv to assign different funtions like only one tab should be active for one user at a time where as the other should be disabled... please help soon... very urgent

hi... ive connected my VB to my data base with the following code.... [code=visualbasic] Private Sub Form_Load() Set CN = New ADODB.Connection cString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Desktop\DATABASE FINAL\Passport Requirements.mdb" With CN .ConnectionString = cString .CommandTimeout = 20 .CursorLocation = adUseClient .Open End With nw... i want to connect every …