Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bugzLue
  • Content: Threads
  • Order by date
  1. bugzLue

    WHo to put MS Paint in

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

    ListBox Click update Txt box

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

    Concatanate

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

    Concatanate

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

    Reference Column to Row

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

    Reference Column to Row in VB

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

    Run time error 91

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

    How to get four columns

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

    Replace column with

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

    ADODB Error

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

    ADO and OLE

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

    OLE Drag and Drop

    Is it possible to be able to drag and drop a .bmp .jpg and so on into a OLE window ones it is built. I have a database that contains pictures, if I insert the picture right into the database I can view them but I am trying to be able to drag and drop the picture into the OLE window when I have...
  13. bugzLue

    VB and Shockwave Flash

    I have a flash program running inside of my VB6 program, but I do not want it to loop. I the properties of the Shockwave frame it has loop = true or False. When I set the loop to false it dos not run at all, but when it is set to True it runs but keeps looping. Thanks Live to learn or die trying
  14. bugzLue

    DIplay Picture from Access DB OLE

    I have a field in my access database that holds a .bmp or .jpg as an OLE, I have been trying for days to be able to create a form that will display all the SELECT fields and the pic is one of them. I have tried the VB Data Wizard, ADO with a picture box and a Image box I have set all the data...
  15. bugzLue

    Form within a Form

    I am trying to create a main form and any other form opened will open within the main form. any help would be great Thanks Live to learn or die trying
  16. bugzLue

    Run Time Error / Multiable access

    I am getting a run time error 7866 telling me that MS Access can't open the database becouse it is missing, or opened exclusively by another user. What is happening is that I start the program and will pull the information for the front page, put when I run a Report on the same database, from...
  17. bugzLue

    List Properties/method for VB to MS Access

    I have been trying to find out how I add to a list. Set MSAccess = New Access.Application when I right click on the MSAccess and go to List Properties/method MSACCESS is not listed it was at one time, and the other would be Access.Application Access is not in the list I do have Dim...
  18. bugzLue

    Find command error

    I get a error with the code below the part [ .Index ] this what is shown to me when I debug. the column that I am trying to do the search on is called Code. Compile error: Method or data member not found Private Sub cmdFind_Click() prompt$ = "Enter the full Code for all sibling...
  19. bugzLue

    A easy Question About VB Icons

    After creating the VB Project how do you get it to have the Icon you want? instead of the default. I am running on win 2000 Pro. Thank you Greg Live to learn or die trying
  20. bugzLue

    Need help on a function

    I am looking to find out what the 0x0000FFFF means, any help would be great Thanks RETURN ( cast( ((@jctID / power(cast(2 as bigint),32)) & 0x0000FFFF ) AS INT)); END Live to learn or die trying

Part and Inventory Search

Back
Top