Oracle Spread Table Control?
Does anyone know what this is or how to use it? If you know where I could find any documentation, I've search Oracle throughly, I'd be very appreciative. Thanks, Jeremy
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Spread Control
<html><head><meta Name='keywords' Content='commtouch, pronto, mail, free email, free, branded, web based, free web based email, communications, internet, software, advertising banners, e-mail, free software'></head><body ><div align='left'><font ><blockquote><blockquote><TT>Hi,<BR>
I have a problem...<BR>
I have two forms Form1 and Form2<BR>
Form1 has a spread control(3rd party)<BR>
On dblclick of spread control, i load form2...it has text boxes...i <BR>
fill the data in those text boxes...onclick of ok button on form2 i <BR>
nee to display these values on spread control...but the wierd thing i <BR>
have come across is it's loading another form1 and displaying the <BR>
values from form2...<BR>
Can any body tell me y this is happening?what cod be the mistake i <BR>
did?<BR>
<BR>
Thanx<BR>
sai<BR>
</TT><br><br><font><p align=left><br>Get India's Fastest E-mail, Free For Life Time at: http://helloindia.zzn.com<br>
Help Spread Control
Hi All,
I want To change the color of every character in the perticular cell of a spread control.
For that I have used the selstart,Sellength and selforground property but it doesn't works.
The code is :
SpreadBottom.Row = 1
SpreadBottom.Col = 4
For i = 0 To UBound(ArrSpreadTop) - 1
SpreadBottom.SelStart = i + 1
SpreadBottom.SelLength = 1
SpreadBottom.SelForeColor = vbRed 'or any color
Next
Thanks
Spread Control
Hi,
I am using FarPoint Spread control in my VB6.0 project. One of the form in the project contains 3 spread controls. I have to print contents all the 3 spread controls on a single sheet. Using the available properties, one spread only can be printed on one sheet. Does anybody have a solution for this??
Thanks in advance.
Farpoint Spread Control
I'm having problems with Farpoint's spreadsheet control.
I've got wide columns (wider than the form on which they are displayed) and I want to horizontally scroll so the user can read all the text in the column. By default the control's scrollbars move one complete column at a time.
Can anyone help? I can post an example project if you don't understand what I'm getting at.
Spread Control [FarPoint]
Hi all.
I'm using the FarPoint Spread control and need to get a command button embedded into the spread [so when the spread scrolls the button stays in the cell/position it was embedded in and scrolls with it]
I've tried using Spreads CellTypeButton but it looks as thou you can only call pre-defined Spread functions, which is not what I need as I have my own function the needs calling on click.
I've tried the standard VB CommandButton but button does not link/embed itself to the spread it floats on top so when you scroll down on the spread the button remains in the same position.....
Can anyone help out with this one pls??
Many thanks.
Rocks
How To Sort The Columns In Farpoint Spread Control
I would like to sort the rows in Spread control on 5 columns. But Spread supports sorting upto a max. of 3 cols. How can I solve this problem.
early reply is appreciated
Chakradhar
Software Engineer
IT Solutions India
Banagalore
Query Linked ODBC Table: VB -> Access -> Linked Oracle Table
Hello,
I am trying to access an Oracle Table through a Linked Table setup in Access 97. I had originally just tried to connect directly to the Oracle table from VB, but that isnt working out like I want it to....the queries are not going through well. I want to do it now having Access act as the middle man in between. This is my code so far:
From my connection module
Code:
MDBFile = "H:DataBlah.mdb"
'Set a reference to the ADO Connection object
Set g_objConnRemedy = New ADODB.Connection
g_objConnRemedy.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & MDBFile & ";
Code:
Set g_objRS = New ADODB.Recordset
csSql = "SELECT ARADMIN_PM___CALL_TICKET.Submitting_Unit__, Count(PM___CALL_TICKET.Ticket_Number__) AS [Call Type-Other] "
csSql = csSql & "From ARADMIN_PM___CALL_TICKET "
csSql = csSql & "Where(((ARADMIN_PM___CALL_TICKET.Call_Origin) =""1"""
csSql = csSql & " Or (ARADMIN_PM___CALL_TICKET.Call_Origin) = ""3"""
csSql = csSql & " Or (ARADMIN_PM___CALL_TICKET.Call_Origin) = ""4"""
csSql = csSql & " Or (ARADMIN_PM___CALL_TICKET.Call_Origin) = ""5"")"
csSql = csSql & " And ((ARADMIN_PM___CALL_TICKET.Create_Date_Time__) >= ""1149120000"""
csSql = csSql & " And (ARADMIN_PM___CALL_TICKET.Create_Date_Time__) < ""1149292800"")"
csSql = csSql & " And ((ARADMIN_PM___CALL_TICKET.Status) <> ""6"")"
csSql = csSql & " And ((ARADMIN_M___CALL_TICKET.Problem_Type) <> ""Misc Tfer Call Int""))"
csSql = csSql & " GROUP BY ARADMIN_PM___CALL_TICKET.Submitting_Unit__"
Debug.Print csSql
g_objRS.Open csSql, g_objConnRemedy, adOpenForwardOnly, adLockReadOnly, adCmdText
Now the above SQL Statement works when in a access query, so thats why I directly copied and pasted it. Is it correct that I am assuming that I can access the linked table as if it were a normal table designed in Access? Also, my connection string for ADO is at least correct, cause I setup a generic table with like two columns just to test and I was able to retrive the data.
Edited by - mlosso on 6/23/2006 8:02:00 AM
Dropping A Table In Oracle 7.3
All,
I have been trying to use VB to drop a table in Oracle 7.3 and it is taking a while to execute the query. Is there anything that I can use to improve performance of a program when doing something like this? I am just using:
MyConn.BeginTrans
MyConn.execute("Drop table " + cmbTableName.text)
MyConn.CommitTrans
Probably don't need the BeginTrans and CommitTrans statement because these are DDLs anyway.
Another thing that may be of interest, I am using an Oracle 8.1 client to connect to the Oracle 7.3.
Thanks,
Raj Antony V
Creating A Table In Oracle
Hi!
Just wondering the best way of creating a Table in an existing Oracle Database. I have tried creating a table using an ADOX connection. But I have been getting a "The Parameter is incorrect". Not sure exactly what that means or why Im gettting that error.
Is the better way to use SQL commands?
Thanks!
Creating New Table In Oracle
hi..
how to do a creating table statement in vb for connection to oracle?
i have establish the connection using ADOB.
VB Code:
dim conn As New ADODB.Connectiondim rs as new ADOB.Recordsetdim conn as string conn = "UID= " & user_id & ";PWD=" & password & ";DRIVER={Microsoft ODBC For Oracle};" _ & "SERVER=" & dBase & ";" [color=Purple]set rs = conn.Execute( "CREATE TABLE ADMIN( admin_id number) ")[/color] <--- error message With db .ConnectionString = conn .CursorLocation = adUseClient .Open End With conn.close
i am not sure if the code are right or not? however, the table is not created.
how? i have the error msg --> "Object variable or With block variable not set" what does it means? which variables or mine is not set?
ocw
How To Unlock An Oracle Table
I've got some VB code that, using SQL, is supposed to delete a record in an Oracle table. However, when my code gets to the SQL, receive a message that says, "Cannot update table, table currently locked."
Questions: What causes this, when I am the only user using the table, and how do I go about resolving the lock?
Thanks to you smart ones in advance!! I appreciate your help immensely.
Added green "resolved" checkmark - Hack
Foxpro Table To Oracle
Can any one pls. send me the code for uploading a foxpro table to Oracle
using VB.
I am new to this Oracle stuff, I had been working only with SQL Server +
VB.
Thanks is advance
Regds
Muralee
Insert Into Oracle Table
I am getting error number 3251 (Current recordset does not support updating. This maybe a limitation of the provider or the selected locktype.)
I am using Microsoft's OLEDB provider for Oracle. I am running Oracle 9i.
The recordset is opened like this:
lrs.Open "XXROT.ROT_CSI", cnn, adOpenKeyset, adLockPessimistic, -1
The error is at the addnew line:
lrs.AddNew
Any help would be appreciated
Lock Oracle Table
Hi all,
I have a sql statement that will update all the records in the table. However, the updating operation should be done in the table locked manner. I tried the following but it seems that vb does not support the Oracle statement of "lock table ...". Below is my sql statement:
'''''''''''''''''''''''''''''''''''''''''''''''
set rs = dbconn.Execute("lock table table1 in
exclusive mode ")
'''''''''''''''''''''''''''''''''''''''''''''''
while the rs does not reach EOF, the following sql statement will be executed :
'''''''''''''''''''''''''''''''''''''''''''''''
set rs = dbconn.Execute("update table1 set field1
= 'value1'")
'''''''''''''''''''''''''''''''''''''''''''''''
However, when the updating process is running, i could still change the data in the table through sql Plus for Oracle.
Is there any other syntax i can use to lock a particular table in Oracle? Thanks in advance.
How Can I Get Return Value That Is A Table With 2 Column From Oracle SP
The Code look like that:
Oracle side:
PACKAGE Simple_Package AS
TYPE t_pk1Type1 IS TABLE OF VARCHAR2(100)
INDEX BY BINARY_INTEGER;
TYPE Errordetails IS RECORD
( Code VARCHAR2(50),
Description VARCHAR2(1000)
);
TYPE Terrordetails IS TABLE OF Errordetails INDEX BY
BINARY_INTEGER;
PROCEDURE proc2
(
i_Arg1 IN NUMBER,
ao_Arg2 OUT t_pk1Type1,
ao_Arg3 OUT Simple_Package.Terrordetails
);
END Simple_Package;
PACKAGE BODY Simple_Package AS
PROCEDURE proc2
(
i_Arg1 IN NUMBER,
ao_Arg2 OUT t_pk1Type1,
ao_Arg3 OUT Simple_Package.Terrordetails
)
AS
i NUMBER;
BEGIN
FOR i IN 1 .. i_Arg1 LOOP
ao_Arg2(i) := 'Row Number ' || to_char(i);
END LOOP;
FOR i IN 1 .. i_Arg1 LOOP
ao_Arg3(i).Code := i;
END LOOP;
END proc2;
END Simple_Package;
I try to use this VB code but i get Access vaiolation or syntacx error:
Dim QSQL As String
Dim CPw1 As rdoQuery
Dim Iusername, Ipassword As String
sUserName = "'CUSTOMER'"
sPassword = "'CUSTOMER'"
QSQL = "{call Simple_Package.Proc2(?,{resultset 3, ao_Arg2}," _
& "{resultset 3, ao_Arg3},{resultset 3, ao_Arg3})}"
Set CPw1 = Cn.CreateQuery("", QSQL)
CPw1(0) = 2
' in this point i get the Error
Set Rs = CPw1.OpenResultset(rdOpenStatic, rdConcurReadOnly)
is vb support this data structure as in (ao_Arg3)
How Can I Get Return Value That Is A Table With 2 Column From Oracle SP
The Code look like that:
Oracle side:
PACKAGE Simple_Package AS
TYPE t_pk1Type1 IS TABLE OF VARCHAR2(100)
INDEX BY BINARY_INTEGER;
TYPE Errordetails IS RECORD
( Code VARCHAR2(50),
Description VARCHAR2(1000)
);
TYPE Terrordetails IS TABLE OF Errordetails INDEX BY
BINARY_INTEGER;
PROCEDURE proc2
(
i_Arg1 IN NUMBER,
ao_Arg2 OUT t_pk1Type1,
ao_Arg3 OUT Simple_Package.Terrordetails
);
END Simple_Package;
PACKAGE BODY Simple_Package AS
PROCEDURE proc2
(
i_Arg1 IN NUMBER,
ao_Arg2 OUT t_pk1Type1,
ao_Arg3 OUT Simple_Package.Terrordetails
)
AS
i NUMBER;
BEGIN
FOR i IN 1 .. i_Arg1 LOOP
ao_Arg2(i) := 'Row Number ' || to_char(i);
END LOOP;
FOR i IN 1 .. i_Arg1 LOOP
ao_Arg3(i).Code := i;
END LOOP;
END proc2;
END Simple_Package;
I try to use this VB code but i get Access vaiolation or syntacx error:
Dim QSQL As String
Dim CPw1 As rdoQuery
Dim Iusername, Ipassword As String
sUserName = "'CUSTOMER'"
sPassword = "'CUSTOMER'"
QSQL = "{call Simple_Package.Proc2(?,{resultset 3, ao_Arg2}," _
& "{resultset 3, ao_Arg3},{resultset 3, ao_Arg3})}"
Set CPw1 = Cn.CreateQuery("", QSQL)
CPw1(0) = 2
' in this point i get the Error
Set Rs = CPw1.OpenResultset(rdOpenStatic, rdConcurReadOnly)
is vb support this data structure as in (ao_Arg3)?
Put A Date Into An Oracle Table's Field?
I had a project that was using SQL, and then had to modify it to put a date into a field, going from MS Access to Oracle. Here is what the code looked like:
strSQL = ""
strSQL = strSQL & "INSERT INTO MasterPN "
strSQL = strSQL & "(PN, Description, FSCM, "
strSQL = strSQL & "ATAPN, ESDS, SPN, "
strSQL = strSQL & "Keyword, CompVal, DimData, ModUser, ModDate) "
strSQL = strSQL & "VALUES ('" & rsTemp!PN & "', '" & strDescription & "', '" & rsTemp!Fscm & "', "
strSQL = strSQL & "'" & strATAPN & "', " & intESDS & ", '" & strSPN & "', "
strSQL = strSQL & "'" & rsTemp!Keyword & "', "
strSQL = strSQL & "'" & rsTemp!CompVal & "', '" & rsTemp!DimData & "', "
strSQL = strSQL & "'SYSTEM'" & Now()
conOracleDb.Execute strSQL, , adExecuteNoRecords
This did not place a date into the desired field. So, I deleted that piece of code and put in the following code:
strSQL = ""
strSQL = "SELECT * From MasterPN"
rsPart.Open strSQL, conOracleDb, adOpenStatic, adLockOptimistic, adCmdText
If Not (rsTemp.EOF = True And rsTemp.BOF = True) Then
rsPart.MoveLast
rsPart.AddNew
rsPart!PN = rsTemp!PN
rsPart!Description = rsTemp!Description
rsPart!Fscm = rsTemp!Fscm
rsPart!ATAPN = rsTemp!ATAPN
rsPart!ESDS = rsTemp!ESDS
rsPart!SPN = rsTemp!SPN
rsPart!Keyword = rsTemp!Keyword
rsPart!CompVal = rsTemp!CompVal
rsPart!DimData = rsTemp!DimData
rsPart!ModUser = "SYSTEM"
rsPart!ModDate = Now()
rsPart.Update
End If
And that code worked!! My question...... can anyone tell me why one way doesn't work but another way using the same Now() function does work? This one drove me nuts for the better part of a day.
Are there issues between MS Access date functions and date items in Oracle?
Any help and advice on this will be greatly appreciated. Thanks!!
Added green "resolved" checkmark - Hack
How To Store The Time In A Oracle Table...??
I am using VB6 with oracle 8i as back-end.
I am using the following code to update record which has a 'Date' data type (oracle) field. The update happens correctly, but how can I store even the time in the same field?
strSQL = "UPDATE xxx.AT_VRC_ADVANCES SET
strSQL = strSQL & " , AV_UPDATE_DATE = " & "to_date('" & Format(Now(), "DD-MMM-YYYY") & "', 'DD-Mon-YYYY')"
oRS.Open strSQL, cnn, adOpenForwardOnly, adLockPessimistic
thanks
nath
Sorting A Field In Oracle Table?
When i am insering a record through VB6 form to oracle table, the last record i have entered is not saved as the last row, rather it is saved anywhere such as a 3rd or 4th row. I have used OLEDB MSDAORA provider and ADO 2.1. Can u solve these problem?
Another topic is how can i make indexed ( duplicates or no duplicates) a field in Oracle in design time of the table like Access? I am new in Oracle plzz Help me
VB6 Array Data To Oracle Table
I have an array in VB6 with elements corresponding to columns in a table in oracle.
How can i go about populating a table from the data within the array? Whats the best method?
thanks in advance for any help!
Copy An Oracle Table To Access
HI
I need help in copying a table in Oracle to an Access Database.
I am trying to use the INSERT INTO sql but i am getting the error of "missing keyword".
The sql that i am using is : strSQL1 = "SELECT * INTO AccessTable IN 'AccessDataBasePath' FROM OracleTableName"
Can anyone help??
Error Connecting Oracle Table
I am unable to connect with oracle when i try to select a table having blob datatype.
In vb6, i added a ado library 2.x. code sample as follows:-
dim cn as adodb.connection
dim rs as adodb.recordset
---- in form load event
set cn=new adodb.connection
set rs=new adodb.recordset
cn.open "dsn=west" , "sys" , "change_on_install"
rs.open "select * from test" , cn, .............
------------------- it is giving error when i try test table with blob column, but ok for other tables non-blob column...why ?
Can't Store Double Value In Oracle Table
I am doing a project in vb 6 and oracle8 as backend. I have used "driver = {Microsoft ODBC for Oracle};uid=nan;pwd= sa" as connection string in ADODB.CONNECTION object. But i can't update a field containing double value. It gives an error message invalid number while update statement. Please help me immediately.
How To Get Numeric Data From Oracle Table
Hi,
I want to know how to get numeric field value from oracle table.Here is my code.I am getting 0 value only,
cnn.Open "Driver=Oracle ODBC Driver;Data Source=ORCL;User ID=scott;PWD=tiger;"
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.source="select * from emp"
rs.Open "emp " , cnn, , , adCmdTable
text1.text=rs("empno")
text2.text=rs("ename")
rs.close
Here i am getting only 0 value for empno field and enames i am getting.
In database empno is Number datatype.
Please if anybody know solution for this let me know.
thanks in advance.
syamala
Sending Data From Excel To An Oracle Table
Ive been asked to figure out how to export a range of data from an Excel spdsht to an Oracle table. Has anyone had any experience with doing this and can give me some direction in how to go about this?
HELP!! Populate VB6 DATAGRID With Oracle Table Data
I'm a novice at VB(6) and wish to populate a datagrid by connecting to oracle table. I've an ADODC data control inwhich I've used Connection String and given the SQL query after selecting cmdText option. The test connection also succeds but only empty datagrid is displayed when I run the page.I've connected the datagrid to ADODC1.pls help me to solve this problem. After this i want to print this form using VB command.Pls tell me how 2 go abt it.
Insert Excel File Into Oracle Table
Hello all;
My boss just gave me a weird request - he wants to know if it is possible to insert an Excel file into a BLOB column of an Oracle database. Thus far, I have been playing around with the ADODB stream object:
<vbcode>
Set mStream = New ADODB.Stream
mStream.Type = adTypeBinary
mStream.Open
mStream.LoadFromFile App.Path & "" & "Book1.xls"
STR = "insert into test_table values(1, " & mStream.Read & ")"
cmdCommand.CommandText = STR
......
</vbcode>
....but when I try to execute the command, I get an invalid character error....I have also tried using the to_lob function from Oracle, but the same error persists...any ideas would be greatly appreciated (please assume all ADO objects are OK - I did not include all the code) THANKS MUCH!!
Import Excel-Data Into Oracle-Table
Hello from Germany,
how is it possible to read Data from an excel-sheet and insert the data into a specific Oracle table?
Thanks for Your help and examples!
Best regards
Marlon
How To Insert A Date Field In Oracle Table
I am using VB5 and oracle as backend I want to insert a date value in a date field of a table. what insert statement shoud i use??
i tried number of permutations.
e.g.
sqlstr = "insert into customerqry(cid,Billing_End_Date) values(1, " & Format("20/11/1999", "short date") & ")"
it is giving me errror.
please anyone help me. it is a bit urgent.
thyanx in advance
Calling Oracle Stored Procedure With Table Datatype
HI,
Following is the Oracle Storeprocedure where MYTABLETYPE is
create or replace type myTableType as table
of varchar2 (255);
create or replace procedure usp_cusip(IN_cusip IN MYTABLETYPE)
IS
BEGIN
NULL;
END;
is it possible to call this storeprocedure from VB, If yes how to pass the input value..
I Need To Copy A Internet Explorer Table Into A Oracle Database!!
I need to copy a internet explorer html file which includes a table into a oracle database. I need to create a visual basic front end that will allow me to copy the details from a table and automatically insert this copied view into a oracle database. If anyone can provide any suggestions, books, resources, postings it would be much appreciated thank u all :)
[SOLVED] Insert Into Oracle Table Select * From Csv File
Hi.
I need a little help from somebody who knows about ADO and databases more then I do.
I'm using ADO 2.8 from VB6.0 and I'm trying to insert some data selected from three Access97 tables, located in two databases, into an Oracle database, over a very slow network (64kps).
I wrote a small app that does this - and also works ;) - but it used recordset.addnew and recordset.update to send the data in Oracle. So it was pretty slow ( it sends 1 to 3 records/second).
I needed the data badly (and fast) so I changed the approach and I decided to write an app that creates a csv file, that I manually compressed, copied on the server and loaded on Oracle.
It took me 4 hours to bring the data from 26 locations - copy yhe app, run the app, compress the csv resulted, copy the csv on the server, put everything into one big csv file (~400 MB) and upload it with SQL Loader in Oracle. So, over 10,000,000 records from 26 locations in 4 hours, that's over 700 records per second.
This means that my initial approach was wrong so I started to read and I reached the conclusion that the best thing to do is to try to upload that csv resulted, from the local machines, using SQL statements, and have one big INSERT.
But, when I run this code:
Code:Database.Open "Provider=MSDAORA;Password=xxx;User ID=xxx;Data Source=xxx"
SqlQuery = "INSERT INTO oracle_table select * from [Text;DATABASE=D:].[1.csv]"
Database.Execute SqlQuery
I get an error: ORA - 00903 , invalid table name, and I'm sure the oracle table exists and that I write the name corectly
Funny, with mdb works:
Code:Database.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=DB1.mdb;DefaultDir=d:;Uid=Admin;Pwd=;"
SqlQuery = "INSERT INTO table1 select * from [Text;DATABASE=D:].[1.csv]"
Database.Execute SqlQuery
So, I guess it's something with the Oracle driver
My questions are:
1. What did I do wrong? (Of course, I still believe I did nothing wrong )
2. Is there any way to send all the data from a csv in an Oracle database without using Addnew and Update ?
3. If yes, can someone help me with an example?
Thanks.
Edited by - S K on 7/7/2006 4:23:53 AM
Populating Combobox With Previous Selection From Oracle Table.
I need to pull in a selection made from a combobox, which is populated from a lookup table in Oracle, and stored in a record. I need to have this selection display when I pull in the record for editing (using SQL). I cannot get the value to display in the combobox and I do not know what else to try. I would appreciate any ideas.
Adodc With Join Of A Table And A Synonym Through A Dblink On An Oracle Database
I use an adodc where the select statement is a join between a table and a synonym on an Oracle database. The synonym is linked (dblink) to a table in another database (schema and instance) and I have the select rights on it.
My problem is that everything is fine on the development machine but does not work on the client machine. All adodc work without problem except the one that works with the synonym : I got the error "Adodc1 : Data type not supported".
Could this be linked to the fact that I try to access the synonym and that some dll or something linked to adodc, mdac ... is of a different version on the client machine ?
Any help or hint about something I should check would be greatly appreciated.
Thanks in advance.
"LONG RAW" Data Out Of Oracle Table
(VB6.0, Oracle 8.0, NT4/5.5)
Hi
I have an Oracle table where one field contains data of the type "LONG RAW".
Anybody know a way to visualize the contents of such a field? (I only want to display it, not work with it at all)
Loading the table into a DataGrid, the field in question only displays an "unknown character" (sort of a thick vertical line). A MSHFlexGrid does not show the field at all.
Any suggestions? Thanks
----Silvia Hansel----
Fp Spread
i am using va(or fp) spread in VB...i want a column of the spread tp expand vertically as i enter a large amount of text into it,..how can i do it?thx!
Va Spread Help
I am using the vaSpread control in a project and I need to know the column and row I am over when the MouseUp event occurs. This event only gives me x and y coorodinates. Can someone help me out with this.
Thanks
About Farpoint Spread 3
i'm using vb 6.0 and farpoint spread 3....
so here is the problem, i want my cell to be a
combo box....
i want the combo box to contain the existing schema
on my database
i already have the sql statement to know the existing
schema on my database, how do i link the result to be displayed as
items on my spread.... (cell type is combo box)
thanks in advance...
Spread Sheet?
I want to create a grid like excell sheet but don't know where to start.
I want to beable to alow the user to save the sheet which will have types and amounts....eg.
Type Title Cost
CD Pink $4.00
Tape (name) $2.00
LP (name) $3.00
more...
I want to let the user load/edit/save the grid, (excell like), but I need to be-able to save the enteries in another table as well.
I also need to have the Type as a drop down box.
Any ideas of what to use? I know that I can use ole and embed a spread sheet but can you extract each line and incorperate into an ado table? And does the user need to have Excell on there pc?
Spread.vbx Download
where can i download spread.vbx
i have a vb program but it says "spread.vbx" missing
can somebody help
cheers
|
TRACKER
