Recent content by Keyth

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

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

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

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

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

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

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

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?

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

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

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

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

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

Reboot your computer with one screen?

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