Hi,
I'm generating a TreeView structure in the VB6.0 screen.
I wanted to copy the same treeview into the Excel sheet.
Is it possible ? If so how???
Pls help
BSB
Last Activity: May 12 '08, 04:17 AM
Joined: Jul 27 '07
Location:
-
Copying a Treeview data from VB6.0 to Excel 2000
-
Converting from excel 2000 to excel 2007
hi,
I was working with excel 2000 contaning macros and pivot tables.It was working fine for years.
My system is updated with excel 2007 now. The macros and pivot tables are not getting refreshed properly...
And it says there is some integrity problem.
Can somebody help me on this???????????
thank u -
Minitab and VB6.0
Hi,
I want to set the Minitab settings according to my project requirement... from VB6.0 ..
how to do? -
*************** *************** **********
thank u... -
Maintain the session in VB6.0
Hi,
In my VB application,I have many forms.
In one form I have 4 dropdownlist(dd l)
used by one user.
I wanted to make ddl selected value to be the last selected value by that user
say one dropdown is called ddlCountry containing country names
say first time the user selects USA and performs some operation, and he closes the application.
When the second time he... -
*************** *************** *************** ***
thank u lemme check...Leave a comment:
-
VB code to automate mouse to click a button
Hi
I use VB6.0 as front end...
I want something like,
When my application displays a particular message, It should trigger an event which clicks the button
Say whenever " Hello World " message is displayed, my program should make my mouse pointer to and click the button "GO"
I should be able to use this function at many places
Is there any... -
thank u....it worked...Leave a comment:
-
Macro that changes a particular column in pivot table.
Hi,
I'm executing Excel macros with VB as my front end
In my excel sheet...
i have pivot tables...
I need a macro that would change the particular column in the pivot table (say col K of the sheet ) . Change col K value from 1 to 0
I have 5 worksheets in one workbook.
On 3 worksheet i have to perform these operations....
can someone guide me -
Output parameter in "Find Duplicate " query of access
Hi,
I generate a "Find Duplicate" query for one table that will return some records
I want to capture those records in my VB code.....
This is my code...pls guide me how to proceed....
*************** *************** *************** *************** *************** ************
adocmd.CommandT ext = sQueryName
adocmd.CommandT ype = adCmdStoredProc
adocmd.ActiveCo nnection... -
One more doubt,
the query that was executed is the find duplicate query
say if the count retrieved is 10...
I need to select all those 10 records
How to do that????...Leave a comment:
-
\]
hey thank you..it works...Leave a comment:
-
Retrieve record count
Hi I use VB 6.o as my front end... execute a query in Access... by the following code
sQueryName = "[Warranty Update 12 Month Rolling #2]"
adocmd.CommandT ext = sQueryName
adocmd.CommandT ype = adCmdStoredProc
adocmd.ActiveCo nnection = conAdo
adocmd.CommandT imeout = 1200
adocmd.Execute
I wanted to retrieve the record count that is affected ....... -
thank you...
i got it run...Leave a comment:
-
VB as Front end and SQL as database
How to code in VB to get connected with SQL database and to perform delete function in one of the tables -
I have copied it from the criteria of the access query ....
and my table "APR 2007 Warranty Data w/ Adj Cost" has two joins
field one join with "Tbl2"
and field two join with "tbl3"
i hav to write the update queryLeave a comment:
-
Convert the Access query to equilent SQL query with VB as front end
IIf(IsNull([Product Hierarchy])=True And IsNull([Types]![Type])=True,"UNKNOWN ",IIf(([Types]![Type])="CHECK" And (Left([Unit Ser No],2)="58" Or Left([Unit Ser No],2)="59"),"Resi dential",IIf(([Types]![Type])="CHECK" And Left([Unit Ser No],2)="56","Comme rcial",IIf(IsNu ll([Product Hierarchy])=True Or ([Product Hierarchy])="",[Types]![Type],IIf(IsNull([Types]![Type])=True... -
*************** *********
Hi,
but I'm binding the datagrid dynamically...
and using the same grid at different places.......Leave a comment:
-
Displaying of number field in datagrid from VB
Hi,
I use VB in front end and Access database at backend....
The fields in the database are updated by other application...
On of the field is the Number (Cost) Column...
The number in the database is stored as
3
23.434
2.9
0.8
I need some uniformity while extracting these values and displaying it in the front end vis DATAGRID...
When datagrid...
No activity results to display
Leave a comment: