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 Chriss Miller 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: peekay
  • Content: Threads
  • Order by date
  1. peekay

    ODBC connnection call fails

    I have tested the ODBC DSN and it works but the following code statement fails with error: ODBC - call failed: Dim Conn As Connection Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DSN=IBSMSbloem;") What can be the problem? Thanks PK Odendaal
  2. peekay

    ODBC in VB6 and MySql

    I have created and tested a database with DSN - see attachment. When I try to open the connection in VB6 I get an error - see attachment (on next message). What can be the problem? Thanks PK Odendaal...
  3. peekay

    Access to MySql

    Reposting from VB6 I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access. 1. Can this be done and are the changes significant? 2. Do I need to use PHP or can I edit directly like I do now with DAO or even ADO. 3. What is the best...
  4. peekay

    Access to MySql

    I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access. Can this be done and are the changes significant? Do I need to use PHP or can I edit directly like I do now with DAO or even ADO. Thanks PK PK Odendaal
  5. peekay

    Extracting table and column names from Access

    I need to know which tables are in an Access database. The closest I can get is : Dim schemaTable As DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) I do not know however how to extract the table names from this. I also need...
  6. peekay

    Extracting table names and field names from database

    I need to know which tables are in an Access database. The closest I can get is : Dim schemaTable As DataTable = Cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"}) I do not know however how to extract the table names from this. I also need...
  7. peekay

    Sending email with SMTP

    I get the following error when using : SmtpMail.Send(MyMessage) Could not access 'CDO.Message' object Can someone help ? Thanks PK Odendaal
  8. peekay

    Image size in datagrid

    I have a webform that a client uses to submit a property listing to our property web page. In the process he uploads his photo of the property - all this I have done correctly including to test whether its a .jpg or .gif file. I have a problem however in that I can only allow a photo of size...
  9. peekay

    Images offset

    I have a problem with aligning the hyperlink images on my web page. I am using styles.css and the image margins are set to 0 for top and left in the style sheet. When I use my local host to run the application everything is fine, but when I publish it there is an offset of about 4 pixels from...
  10. peekay

    Image in datagrid

    I am trying to show an image in my datagrid, but the error -Tag is not well formed - occurs. Can somebody please help. <asp:TemplateColumn> <ItemTemplate> <asp:Image Runat="server" ImageUrl="images/" & "<%# GetImage(DataBinder.Eval(Container,"DataItem.photoname").ToString()) %>"...
  11. peekay

    Source control file

    I inadvertently erased my website's source control file. Can someone tell me how to set it up again. Sorry the search is off PK Odendaal www.odendaal.com
  12. peekay

    Datagrid - text changed event

    I wish to pick up an event when the text of any cell of a datagrid changes. How would I do that ? Thanks PK Odendaal www.odendaal.com
  13. peekay

    Datagrid cell text change event

    I wish to raise and event when a certain cell (datagridtextcolumn)in a datagrid is being changed and the length of the text reaches four characters. I have tried keypress and keyup events but they would not fire. The keypreview property of the form is set to true. Thanks PK Odendaal...
  14. peekay

    Update datagrid dataset

    I have a datagrid set up from an inner join of three tables (orders,ordereditems and costcentres). When I wish to update the dataadapter with the modified dataset I use the dataadapter.updatecommand. I cannot get it right because it seems that I cannot update three tables simultaneously with an...
  15. peekay

    Datagrid clear

    I wish to clear the datagrid before binding it again as presently it only adds the new datarows to the existing ones. I have seen questions here about it but none answered correctly as databindings.clear does not work and the .clear method is not available. Thanks PK Odendaal www.odendaal.com
  16. peekay

    Datagrid - selecteditem

    In asp.net the datagrid has a selecteditem property, but I cannot find it in the windows forms control of the datagrid. How would I determine which row was clicked and how would I retrieve the value of the first column of that row. Sorry I am new to VB.NET - made the long threatened change from...
  17. peekay

    Datagrid - maybe treeview

    When I run my program my datagrid shows only an arrow and a + sign. When I click on the + the datatablename comes up and when I click that the columns are visible. Is it possible to see the columns from the start. I tried datagrid.expanded but it only shows the table name then and not the...
  18. peekay

    A funny thing happened on my way ...

    I am doing a program and use a windows form. I have changed this form almost completely and saved it, but when I run it it still shows me the old form. I have checked the directory which is OK. It is typical of caching of webpages, but I did not expect it with windows forms. Can somebody help ...
  19. peekay

    Datagrid column format (only 10 leftmost characters)

    I have a databound datagrid and wish to show only the leftmost 10 characters of a certain string field in a certain column. How would I do that ? Thanks PK Odendaal www.odendaal.com
  20. peekay

    A new instance of IE6

    While a browser is open with one of my web pages I wish to allow the client to click on a link to open a photo in a new instance of Internet Explorer - how would I do that Thanks PK Odendaal www.odendaal.com

Part and Inventory Search

Back
Top