Search results for query: *

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...

...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 & &quot; Where Id = '&quot; & ID & &quot;'&quot...

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

I have a database that I need to Referance a column called fp_ID to a column called ID and have three columns in that recordset be displayed those columns would be sp , gen, cul any help would be great. if this is not clear please let me know and I will explain it more. Thanks Live to learn...

How would I reset the ConnectionString after I have made the .exe? The database is in the same place as it was on the system that the program was built on. I also created a install setup and I still get the ADO message. I should say it was built on 2000 and I tried to install it on a 95 and...

I made a program that that is using ADO and it runs great on the computer that I set the ConnectionString. But after I build the EXE and test it on a different computer I get this error ADO could not find the specified provider. I do have the db in the same location as it was on the system that...

I have a Access table that has a column that holds a OLE picture .jpg or .bmp , I set up a form with a ADODB control and when I add a the OLE and try to set the DataSource i get a message as follow: No compatible data source was found for this control. Please add an intrinsic Data Control or a...

when I drag and drop the picture it is not updating the database when I click my update, evrything else dos but the Picture. any sugestions Live to learn or die trying