Recent content by bugzLue

Is there Paint or some sort of drawing tool in components? What I need to do is put paint or some sort of drawing tool on a form to be able to draw examples that I then can save in to a database (MS SQL 2000). Live to learn or die trying

I am using a listbox with four columns and I would like to click on a row in the list box and have the ID column populate the txtbox or even have all four columns populate four text boxes. any sugestion on how I can do this would be a great help Thanks Live to learn or die trying

Thank you you are right it is working now. again thank you for your time and help Live to learn or die trying

THANK YOU THANK YOU That was it Thank you Live to learn or die trying

I have a Auto number that I want to concatanate this text I have tried this code but it will not work. please help. this was SELECT (id(cast id as char)+' '+species+' '+genera+' '+cultiver) From plants AND THIS WAY I get the text to concatanate SELECT Cast (id as CHAR) ID...

Thanks for your help. That put all of it in one column, I get the number now but the text is only showing up as dots 1 ... 3 ... thanks for again for your help Live to learn or die trying

I have a Auto number that I want to concatanate this text I have tried this code but it will not work. please help. this was SELECT (id(cast id as char)+' '+species+' '+genera+' '+cultiver) From plants AND THIS WAY I get the text to concatanate SELECT Cast (id as CHAR) ID...

Thanks for your help But this pulls no Records. What I am trying to do is the number in PO_ID is linked to the same number in ID. example: ID Name PO_ID PE_ID 1 your mothers name 2 Your Fathers name 3 You 2 1 4 You Sibling 2...

Can anyone help me with code for SQL or Access? I need to be able to reference one column to the primary column and output the row from the primary column. so if po_id is 2 then it will go over to ID column look for 2 and row 2 prints out. ID(PK) Name Address CSZ PO_ID PE_ID 1 Bla bla 123...

Can anyone help me with VB code for Access or SQL? I need to be able to reference one column to the primary column and output the row from the primary column. so if po_id is 2 then it will go over to ID column look for 2 and row 2 prints out. ID (PK) PO_ID PE_ID ID Name Address CSZ PO_ID...

Right click on data grid Properties under General DefColWidth the only thing with this is that all Columns are set to the same width. Live to learn or die trying

And this is the code for the function: Private Sub Select_Data() Dim itmNew As ListItem Set rsPlants = New ADODB.Recordset Set rsPlants = objPlants.Select_Hybrid ListView1.ListItems.Clear If...

This is the code in the class: Public Function Select_Hybrid(Optional ID As String) As Object Dim strSQL As String On Error GoTo BadSelect strSQL = &quot;SELECT * FROM Plants&quot; If Trim(&quot; &quot; & ID) <> &quot; &quot; Then strSQL = strSQL &...

I am getting this Runtime error '91' Object variable or With block variable not set and this is where the Debug gos to: Private Sub Select_Data() Dim itmNew As ListItem Set rsPlants = New ADODB.Recordset ====> Set rsPlants = objPlants.Select_Hybrid...

How can i get columns to show in a DBcombo box? Thanks for any help Live to learn or die trying