10,989 Topics

Member Avatar for
Member Avatar for smile4evr

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 …

Member Avatar for Jx_Man
0
96
Member Avatar for smile4evr

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

Member Avatar for GaryOC
0
224
Member Avatar for pardeep3dec

Hi friends, I have problem of selecting recordset between a specified date. I am giving my coding detail below. I took a field in Ms Access table table name-travel fieldname - doj datatyoe - Text and vbcoding dim db as new adodb.connection dim rc as new adodb.recordset db.open"Provider=Microsoft.Jet.OLEDB.4.0; Data Source='d:\tmgmt.mdb'" …

Member Avatar for GaryOC
0
158
Member Avatar for Bhatti302

[code]Hello to all Masters, I have a problime in the database programming. i am using a Access DATABASE file in the VB6.0 Project. in this project i am creating a veriable such as " Dim s as new ABODB.Connection. but when i run the project it create an ERROR at …

Member Avatar for hakimkal
0
229
Member Avatar for jem00

[CODE]Call CheckLetter(char, letter)[/CODE] What I am trying to do above is send the string char to the procedure CheckLetter, and from CheckLetter I am trying to retrieve letter. How do I do this? All the code from my project. [CODE]Dim Alphabet(0 To 25) As String Dim codeword, wordtoencrypt As String …

Member Avatar for Teme64
0
115
Member Avatar for showstopper2007

how to create reports in which you can see all the NEW members in the current month data report i am using data1 to access records.

Member Avatar for venkatramasamy
0
48
Member Avatar for pardeep3dec

Hi friends, my query not worked. rc.open"select * from travel doj between #"& doj.text &"# AND #"& doj1.text &"#; suppose doj.text=01/09/2008 doj1.text=22/09/2008 but it shows july records also.

Member Avatar for venkatramasamy
0
66
Member Avatar for showstopper2007

this is my first project n i need help in displaying images in imagebox this is the code to display the code which i am using to display images in imagebox Image1.Picture = LoadPicture("C:\images\" & Text3.Text & ".jpg") '<<this works fine>> in the above code the location is C:\images\ , …

Member Avatar for dickersonka
0
108
Member Avatar for jem00

Hey guys, I'm trying to send an array as a parameter and it is not working.... I have set it to passed by reference in my sub. Visual Basic says: "Compile error: Type mismatch: array or user-defined type expected" How may i solve this problem? Yours words of wisdom are …

Member Avatar for jem00
0
140
Member Avatar for hazee

Is there any way to scroll Datagrid on timer basis. Let say there are plenty of records which can not be shown in one screen. An auto scroll should start after 5 seconds and scroll till the last record and all the users . This is to display the records …

0
43
Member Avatar for ma-vi

Hi! :) Im developing an application with visual basic 6.0 for front end and MS SQL 2000 for backend. I've been trying to create a data grid but the error above keep showing up. I wonder what's wrong with the code (since it was system generated I tought it would …

Member Avatar for selvaganapathy
0
234
Member Avatar for psychi_beavis

HI im new here, i would like to ask the code for generating words in random letters.. i have a 5x5 dimension of textboxes, each textbox is randomizing as the button1 was clicked,how am i supposed to generate words with the given random letters??pls help me , teach me the …

Member Avatar for psychi_beavis
0
74
Member Avatar for imagetvr

Hello I am using windows XP I need a small programme in Visual basic 6 with Access 2000 I have two tables for example one table named student other table named section In student table rno is primary key. In section table Rollno is primary key Both tables have datas, …

Member Avatar for K.Vanlalliana
0
135
Member Avatar for pardeep3dec

Hi friends, I took a date picker control on form but it is not showing current date. Is there any way except this datepicker1.value=date ?

Member Avatar for K.Vanlalliana
0
127
Member Avatar for jnanj

hi..im really new here.. im looking for resources that may help me finish my thesis project.. im presently creating a Student information System and im having problems in generating statistical reports especilly because my panel wants it to generate graphical reports on its statistics...plssss help me.. im really desperate to …

Member Avatar for GaryOC
0
88
Member Avatar for jessieminimo12

I'm on developing a project regarding Random access(Hashing function), specifically in Folding. Now my problem is, if i enter a key values, how can i isolate each single values for me to control it. for example: i enter key value 12345 i need to choose the 2nd entry which is …

Member Avatar for GaryOC
0
134
Member Avatar for shakuN

Hi, A newbie to VB6, I have to plot a graph using the picturebox control. I have drawn the 3 line graphs using the "Line" method and using relevant data. I have to shade the triangular portion marked "X" ( resulting from the lines B & C crossing the line …

Member Avatar for shakuN
0
170
Member Avatar for rajeshkhanna_in

[B][/B]Please help me out with this. Crystal reports entertains the MEMO field from ACCESS in three ways (uninterpreted, RTFText and HTMLText). Is there a way in which I can print the object in the MEMO field because I have the tables and diagrams in this field. and they don't print …

0
60
Member Avatar for stupidenator

Hello Everyone, I am having some trouble with a VBA application I am writing for work. I am using ADODB to connect to an Oracle database and return and I want to return a 2-D array from my function. The problem I am having seems to be determining how big …

Member Avatar for stupidenator
0
203
Member Avatar for prateekprashar

Hi, i am using VB6 with Access databse after a long time and have forgotten some syntax. I am using ADODC connection (the dirty method) wherein one makes a connection using ADODC component and setting its properties (ODBC and selecting table/ query). I need to display the fields of a …

Member Avatar for selvaganapathy
0
96
Member Avatar for rapture

Hi all, I'm stuck - it might be easy but I don't work with VB6 much. I have a form that is open and has a button on it which opens a second form overtop of it. when the second form opens it locks the first form. Upon exit from …

Member Avatar for rapture
0
96
Member Avatar for rajeshkhanna_in

[B][/B]Hi all, I have developed a software which is basically is Question Paper Maker. For the questions and answers to be saved I have used access database with MEMO field. Now the entire software is ready and the reports seem to be printing fine on the screen as long as …

0
70
Member Avatar for pardeep3dec

Hi friends, I am unable to fetch out correct result on date base. I am writing following code for fetching all records of a table between two dates. db.execute"select * from travel where doj between '"& doj.text &"' AND '"& doj1.text &"';" but above query can't give record between specified …

Member Avatar for AUGXIS
0
99
Member Avatar for Agrawal_rakesh
Member Avatar for nschessnerd

Hey i have a program running on a server that eats a lot of the processor. How can i see how much (%of processor) it is currently using similar to task manager? i only need it for one process.

0
71
Member Avatar for Skado

:( i have tried by all means but i stil cant code it correctly. pls help! how do i code and call a sub procedure that retrieves 3numbers frm a comma seperated string,eg."30,15,66" then send the string to convert as a parameter & return the 3 numbers using parameters. my …

Member Avatar for Teme64
0
104
Member Avatar for dhanya_piit

[code=visualbasic]Dim MyWord As Word.Application Dim WordDoc As Word.Document Dim MyRange As Word.Range Dim MyTable As Word.Table Dim MyCell As Word.Cell Dim MyCells As Word.Cells Dim MyCols As Word.Columns Dim RetSt As String Dim Pic As String Dim arc As String RetSt1 = Chr(10) + Chr(13) RetSt2 = Chr(13) + Chr(10) …

-1
82
Member Avatar for guest11

hi all, I am using data report tool for showing my reports. Everything is working well i am accessing records from table but when i set datasource to datareport it shows all records excluding last record. I don't understand why this happens. Can anybody tell me about this problem. If …

0
65
Member Avatar for shahriar2403

How can i make my report header variable? I want 2 make my report header label as per a textbox filled in a form. How can i do it? Please help me..

Member Avatar for surveyteck
0
111
Member Avatar for Abu Badr

Hi all, please I want the code in vb6 to save content of all text boxes i put in the form to a database in the internet.. I hope you understand what I want :)

Member Avatar for Abu Badr
0
83

The End.