No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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 & "' … |
|
Re:
please help me. urgent i have one date in a txtBox1.what i want is, after i click the button, the other date will appear on txtBox2. [B]The other date[/B] is the date after several days such as 7 days. so, how or what the coding to enable the other date … |
|
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 |
|
Re:
[COLOR="Green"][B] have to do this The constructor for the class should set the initial fuel level to 0.0 L (assume all fuel amounts are in litres). You'll need to use a Private Double class field. " [ICODE]Private FuelLevel = 0.0 As Double[/ICODE]........when i do like this i that error message.....[/B][/COLOR] |
|
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 … |
|
Re:
I'm making a login in system using one notepad document to store the usernames and passwords. I was wondering if somebody could help me do this as at the moment I'm struggling to get it to match the username to the correct password. For example: On the first line of … |
|
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 … |