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 Mike Lewis 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: Keyth
  • Order by date
  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 =...
  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...
  16. Keyth

    Newby solution required

    Hello, I am a newby to ASP.Net but have many years of experience in VB6-VB.Net 2010 and little experience with Java/Servlets. I want to start coding ASP. I have a situation where my host will not allow IP access to MySQL databases. My site is currently built with wordpress and but for my...
  17. Keyth

    DateTimePicker - Tab Between Hours and Minutes

    What happens when you use your right (or left) key?
  18. Keyth

    IDE Problem with multi-project solution

    I'm assuming these are written in VB are they? Are the other dlls compiled to include debug info? Ive had similar problem and the only way to correct is to close open files in main project, rebuild dlls to include messagebox to allow break, then keeping files loaded in main project rebuilt dlls...
  19. Keyth

    TabControl Problem

    Check your validation on the tab control or controls on the tab pages. Other control validation methods may be stopping the first click of the button but after the control validation has been passed, the second click may trigger the call on the button. Only a thought! for example...
  20. Keyth

    DatePart(ww, DateTime) Function

    Thanks drlex, no I hadnt even looked at the pages using the links, I will check though now you mention that thank you.

Part and Inventory Search

Back
Top