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!

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

Recent content by Keyth

  1. Keyth

    PHP/IIS to SQLServer connection issues

    I cannot believe this site is still going, how cool! Can anybody help please. I would like to convert this code to use the sqlserver connection methods. <?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); $server = "localhost:1433"; $user_name =...
    • Keyth
    • Thread
    • Replies: 1
    • Forum: PHP
  2. Keyth

    IN Function

    I know it looks daft how the table has been designed but I am building on something that has been in use for a long time, when I posted this thread I thought it was too much work to re-design. @r937: I know what you mean and I am aware of database relationships, ive been building dbs and...
  3. Keyth

    IN Function

    Good day to you all. I have an nvarchar value stored in a table, example such as '(15645),(15646)' and '(15680),(15679),(15678),(15677)' under field name SALES_ORDER_ITEM_ID Example Query; [code=sql]select Pallet.*, Purchase_Order_Item.SALES_ORDER_ITEM_ID from
  4. Keyth

    Use report as label layout

    Sorry, answered my own question! Report Section Expert/Details/Layout .... This is where you configure the label size.
  5. Keyth

    Use report as label layout

    Hello all I want to configure a report to print a label 3 across and 7 down on an A4 page size. Can anybody advise on where to find instructions on how to do this? Thanks Keyth
  6. Keyth

    The type initializer for &lt;module name&gt; threw an exception

    I had this exact same exception recently. I have a main app which loads several class libraries (DLL) and one of the libraries needed re-compiling. When I did, the application threw an 'object not set to an instance of an object' exception. I narrowed it down to an empty string (string =...
  7. Keyth

    Copy Database locally

    OK thanks for all your help guys(n gals) I'll have a go with selecting filenames and backup/restore. Regards, Keith
  8. Keyth

    Copy Database locally

    Hmmm. Thanks for your replies. To specify the restore filename requires the location of the original doesnt it? how can this be done without knowing file locations? Or is there another way?
  9. Keyth

    value of a field in a gridview when updating after change

    Not sure if this is what your mean?? Dim row As DataGridViewRow = Datagridview1.CurrentRow Dim RowID As Integer = row.Cells("ID").value
  10. Keyth

    vb2010 and access database error in program files

    Install to the new path At runtime change your connectionstring property to point to the new path Example: Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Me.OleDbConnection1.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data...
  11. Keyth

    Copy Database locally

    I see there are plenty of posts about how to copy database, I have worked with db files quite a lot. without detaching the database and copying files etc, is there not a way it can be done with SQL query? I have an app which I would like to adapt so that at startup it prompts the user to run a...
  12. Keyth

    IDE Problem with multi-project solution

    Yeah hell exactly, maybe I need to re-install :(
  13. Keyth

    Newby solution required

    Hi Jason What handles the request and response without a web page in use? Do you know where I can get examples to see how it all comes together, are there any sites you know of? Thanks, Keith
  14. Keyth

    Crystal Reports has hide the Formula Editor (and I want it back)

    Reboot your computer with one screen?
  15. Keyth

    move data from one database to another

    Its a shame you cant migrate your work to SQL Express 2008 as it would handle all that with one query. I think best way you can do it is with data reader. Load values into a dataset. Loop though row by row and execute insert command to archive database. You really need to migrate to SQL...
See more

Part and Inventory Search

Back
Top