listview problem using vb6

Can anyone please let me know how do the following thing in listview control using vb6.i have added the items to the listview control with property set to Fullrowselect=False. In this case only first item(text) will be selected. If user rightclicks on the item(text) , I need to show one menu and if ...

listview control for vb6.0 help

is there any way to make a ListView Control in VB6.0 on report mode to behave just the same as teh listView Control in Outlook 98? I want to be able to remove, add, and sort columns, and also save the view, so when loading the program again, i can have select different saved views. I will apreciate ...

create table vb6

greetingsis it possible to create table from vb6....the fld that i have to use is stored in a table..which is being updated.. ...

How to write to text file instead of viewing data in listview?

all . I have a search result that is outputed to listview in my vb6 form and i wonder how i can write the output data in to text file which is readable instead of showing it listview. I be happy if an expert show me how .ThanksHere is my code that displays data in lisview . I want the data to be wri ...

Problems with listview control

VB programmers,I've got a problem with the listview control of VB6. I've created a listview with report view and two columns. The first column is 1/3 of the width of the listview, the second column is 2/3 of the width of the listview. Evrything's OK, but when the listview contains such a lot of item ...

ListView.... and flat scrollbars...

HiOk this is the last time I ever used the listview... it only gives me ****... LOLAnyway... what's up with the flat scrollbars in a listview.I have VB6 and they made it as a property... but that doesn't work... I tried Chris his flat scrollbar sendmessage, but that doesn't work either... I have the ...

List View Control on VB6.0

is there any way to make a ListView Control in VB6.0 on report mode to behave just the same as teh listView Control in Outlook 98? I want to be able to remove, add, and sort columns, and also save the view, so when loading the program again, i can have select different saved views.I will apreciate y ...

combine 2 statment

how to combine this 2 statment.. IsConnected("Select * from manager_table", False)Call Loader()IsConnected("Select * from Clerk_table", False)Call Loader()i hve 2 listview, 2 table from accessdatabase..i put listview in tabcontrol..1 in tab 1 & second in tab 2... ...

Need a Simple Unbound Control

Is there a simple control I can use with ASP.NET to display an unbound list with multiple columns (like the ListView control in VB6.)It seems that you can use the GridView. but it seems really complicated to populate (with unbound data.)Can you use the ListBox to do this? ...

How can I query data into 1 listview in VB6?

I'm trying to create a user interface using VB6 by querying data from MS Access 97.The case is: For ID number 1, I have 5 transactions to be retrieve and displayed in a listview in VB.'Sample Access table that I haveID | Transaction | date1 | test1 | Jan 01, 20061 | test2 | Jan 03, 20061 | test3 | J ...

Informix table insert from VB6

Question...I am inserting a record into an Informix table. One of thevalues I insert is 0 (zero) into a serial field. What I was hopingsomeone could answer is how can I retrieve the value of theserial field after the insert from the VB6 program? ...

When Selecting From A Table Variable To VB6 In A Sproc The Recordset Doesnt Open

Im using ADO 2.6 With VB6 Im creating a table variable and use it to group a large union Insert Into @MyTableVariableSelect XUNIONSelect yUNION Select ZSelect Sum(SomeField) From @MyTableVariableGroup by Somethingthe recordset in VB6 never opens when executing the sproc performing this, its strange, ...

how to create new table in MS Access2003 database using VB6

I want to create new table in Access database during the runtime of my VB code. I am developing a "Library Management System" using VB6. At first i have used SQL statement to do the job. But it worked for once & then it stopped working. No error message was displayed. I am using " ...

Saving multiline text in sqlserver7.0 table from vb6 apps

all, this is my question :-I've created a table in ms sql server 7.0 using the enterprise manager. there i've a field named "address" which is a varchar type field. now in my vb6 apps i used a multiline textbox to write address. now when i'm trying to save the address from this textbox to ...

VB6 / Access DAO Add Field to Existing Table/Query

I have a VB6 application that uses DAO to read and write MS Access files. Since the program uses Access files exclusives, it was written in DAO instead of ADO. The recordsets within the program are based on queries in the database. I need to add a field to the table and query. I'm sure I can figure ...

VB6/ADO/ODBC Can't save large WMF image in table (ERROR: Lost connection to MySQL server during query)

I am writing an application in VB6 where a part of it is save image files into a MySQL table. This works for 99.9% of the time. It encounters a problem when i try to save a large WMF (13MB) file. Other file types of this size or greater work fine... The error I get is: "[MySQL][ODBC 3.51 Driver ...

create dbase table with vb6

I want to creat and fill an Widget.dbf file using vb6.I know that is possible to update (fill) the table only if I use Ms Dao 3.51 Object library (not 3.6) reference.this is the codeDim myWS As WorkspaceDim mydb As DatabaseDim myTDef As TableDefDim myRS As RecordsetDim myFld As FieldSet mydb = OpenD ...

FOXPRO 2.5 Table Created From VB6 - Not a Database File Error

experts, I've tried using DAO and ADOX to create dbase tables from VB6. The problem with these is that I can't manipulate the width and decimal places of the fields with a numeric data type. I guess, this is because "Jet DB engine that VB uses tends to translate field types and sizes into what ...

Randomally Acess Data in Sql Table by Vb6.0

I m using vb6. plz tell me how can i access data in sql table by vb coding like.....eg. In sql table i hard code the 20 question i want every time when we click the next button on vb form then display question no-2 & IInd time i click the button question no-5 & IIIrd we click question no. 19 ...

how to display multiple table querry in a listview?

i am a newbie want to know how to get values from two tables in database. I have three tables one is the student information and the other table is the subject and grades .Both tables have id number which may join them together But what i need to do is, i have a listview that i named lvMasterlist wh ...

VB6 ADO ListView

Please help me in VB6 ADO ListView Database Connection ...

Create table using VB6.0

I am using VB6.0 to develop an application where the user must enter data in 5x5 table.How do I create such a table during runtime? ...

How to write vb6.0 codes to add additional new column to previous access table

I need someone to help me with VB6 codes to add new columns to already created Access database table at run time.Secondly, i needed to create a duty rota table that keeps track of staff duties for 365 days. I am a bit confuse as i intended placing the fields (Columns) as the days and the names (rows ...

displaying columns from ms access table to a listview in vb.net

guys can you please help me in displaying columns from my ms access table to a listview in vb.net..i use oledb in connecting to ms access.. ...

Print listview items as a receipt in VB6 project

Hye therePlz help me to print the Column of ListView as a receipt.I have no idea how to print ,i have to use datareport of VB6. or what? this is an VB6 project.waiting for replyzeb noon ...

List of images (using ListView Control or Table Control)

I need to do the following:Create the linear list of images (originaly, these images are stored in DB as metafiles, but I can convert them into bitmaps). The size of each image will be about 200x50 pixels. It would be better if standard control (ListView Control or Table Control) is used for this. W ...

how to Create temporary table in VB6(vb6 newbie)

I'm juz newbie to learn vb6how to create temporary table in VB6 coz need save temporary data inside.And need display back they data out..thx .. ...

Using VB6 to format Excel WS as a Table

I've successfully exported an MSFlexgrid to an Excel workbook sheet, and want to format the sheet with excel's canned Table Style "Table Style Light 1". This is the basic alternately-colored rows with drop-down lists at each column head for sorting. I am using Excell 12 (Office 2007), but ...

how to make a table in .txt file within vb6

helloi am creating a .txt file in my vb6 and records are taken dynamically from my database at vb run time.but records are not aligned.i want to make a table in the .txt file and and want to display that record in that table itself.i am just sending my code how .txt is creating and records and field ...

to display field heading of table in html file within vb6

i have create a .htm file within vb6 and records are coming dynamically at run time in a table in .htm file but field heading is not coming .plz help me to display field heading.i'm sending you code of creating .htm file and making table in the file and how records are coming.thiese are the codes:Di ...

Append 2 table from Ms Access using Vb6

I have problem to append table with same field and no Primary Key using VB6, the table are Student1 and Student2. Both of fields is:------------------------------------------------------------NmStudent----------DateofBirth-------------Class------------------------------------------------------------ ...

Existence of a table in vb6

How do I test for the existence of a table in vb6?Any help will be highly appreciated ...

Deleting multiple rows from a listview,vb6

I am doing an application in VB6 in which i have a ListView. I have four columns and some rows of data. i have checked the option "Multi Select" and also "Checkboxes". I have to select multiple rows by checking the check boxes and delete all the checked rows. Can someone tell me ...

Deleting a table, Running Query using ADO in vb6

I am using vb6 and access2000. I need to make a copy of one of the tables in my access database so I can manipulate a bunch of data but keep the original data in tact. I need to do this at runtime. I am using ado to connect to the database now. How do I first, delete the old copy of the copied table ...

Simulate MS-Word TABLE in VB6

I need to create an ActiveX Control in VB6 that simulates the TABLE of MS-Word document.It should support adding or deleting cells/columns/rows in the table apart from being able to do merge/split cells, span rows/columns e.t.c.In addition each cell of the table should act as host to accomodate cont ...

Filling ListView With Database Table

i have a listview in and a form and i want to fill with a table from a database.i have writtem=n the following functon:Public Sub preparelist(ByVal lst As ListView, ByVal str As String)Dim rs As New ADODB.Recordset' Dim rscount As New ADODB.Recordset' Dim constr As String'constr = "Provider=SQL ...

creating a multiplication table in a ListView control

I'm trying to create this multiplication table for one of my assignments but I can't quite get it working and hoping someone can help. Basically what the program has to do is create a complete set of multiplication tables where both the multiplicand and multiplier vary from 1 through 12 and the tabl ...

FOXPRO 2.5 Table Created From VB6 - Not a Database File Error

experts, I've tried using DAO and ADOX to create dbase tables from VB6. The problem with these is that I can't manipulate the width and decimal places of the fields with a numeric data type. I guess, this is because "Jet DB engine that VB uses tends to translate field types and sizes into what ...

vb6 listview group subtototals

i have developed a vb6 program that displays reports using the listviewam able to generate the grand totals but would like to calculate both the group subtotals and the grand total.please bail me out quickthis is my codeIf rsstarpof.State <> adStateClosed Then rsstarpof.CloseSearchSQLString488 ...

counting each repeated Items in Listview using vb6

Hi, All I have large number of words in Listview and I want to count each repeated word and pt the result in a new listview for examplethe new list view must be like table bellowword frequency go 100the 300they 400 .....and so on , Please can any help you kind action really appreciated ...

VB6 - MySQL 5 - don't load some field from the table

Hi, I'm with a strange problem that occur in some fields of the table that are not being loaded in the form I'm usign the visual basic 6 as front end and MySQL 5. When I do in this way the form load the fields from the table. i.e: rsMySQL.Source = "Select * From tb_alunos But in this another fo ...

how to edit mysql table using vb6.0

I'm using MySQL with vb 6.0. I'm not able to edit and update mysql tables. But I'm able to add new record in my table. Please give me solutin to this problem. ...

VB6 or VBA - Copy table contents from one database to identical database

Ladies and gentlemen, first I want to wish each and every one of you a wonderful and prosperous new year.This is not really a problem. I am looking for an efficient and quick way to copy table content from one database to identical tables in another identical database.I have two Access databases: ...

VB6 - Create mew table using input from two other tables

Gentlemen,I have two badly designed tables - I didn't design these table, they where passed on to me. The tables are so cumbersome I have to create a new table, to be able to use their data.Please see attachments to have a clear idea of the table design flaws:The tables are: "TblProgrammersHrs ...

VB6 ACCESS table union issue

After creating a rs with UNION ALL two tables it's possible know record byrecord the original table source (using any extra SQL feature or somethingelse)SQL = "SELECT * FROM tabA UNION ALL SELECT * FROM tabB ORDER BY field"Set rs = db.OpenRecordset(SQL) ...

ODBC MySql & VB6: Filling listview or datagrid with Select Statement results

Does anyone know how to automatically fill a listview or datagrid with the information retrieved from a select statement without specifying recordset!field1,recordset!field2 etc?? For example, mysql query browser allows you to execute a statement and automatically populate the fields below. Any help ...

How to leave NULL value in access database table in VB6

I m creating an access to VB6 connectivity Project.I ahve problem that VB6 Gives not me permition to leave any field NULL sowhen i save my record it genrate ERROR 94 That is invalid use of null valueIn my project it is not necessary to fill all the fields.PLEASE give me coading to leave alny field N ...

.NET How to retrieve data from a MySQL table on to the datagridview or ListView in C# windows

how do i retrieve data in mysql tables on the datagridview or listview in C# and mysql? ...

How to compare 2 string from different table using vb6 badly need help

Private Sub Command1_Click()Set rs1 = DB.OpenRecordset("Table1", dbOpenDynaset)If rs1.EOF = True ThenMsgBox "Record is Empty"ElseMsgBox "Got IT"rs1.MoveLastIf Not rs1.EOF Then rs1.MoveFirstDo While Not rs1.EOFIf rs1!Name <> "" And rs1!age <> " ...

how to put the listbox or listview data to a table?HELP!!!

i split a string and store at listbox.The problem that i face now is how to add 4 new column at existing table("customer") and put the listbox data into these 4 new column.Can any1 teach me or show me the code? ...