Search results for query: *

Well i have a booking system. Each new booking is added onto the end of the existing range as a new row. Each of the existing rows has various formats on the cells. On click of a button i want to make the first cell on the row below the last row in the range active. I thought i could find the...

thank you that works but when i try and then copy the contents of the last row which your function leads me to I can't get it to work dynamically and keep copying and pasting the last row to the next one down. Thanks for your help though. stewart never looked at excel vba til now I'll stick to...

I need to add a row into an excel spreadsheet after the last row with text in it. Either through a macro or vba. Just can't seem to get there. Any ideas recieved gratefully!

I have a .bak file which is the full backup of a database. It is a sql server7 back up. I want to run it on a 2000 version but I can't find where to do it??? I've found restore database but the wizard is confusing and I can't see where you choose the bak file to restore. do i have to create the...

I am planning on storing word documents in sql server. I have been told that the text datatype the 2gb thing)does not actually store the objects but just provides a pointer to them. Does this mean I'll have to store the documents somewhere on disk and provide pointers in the actual text field...

Ah, thanks,I didn'know it was an ansi warning, The Identity field is an Int (4) primary key field. I'm actually appending data and changing the datatypes with cast and convert, the majority of them I'm moving the size of the varchar down to (20) from (50). But I'll experiment with killing the...

On an Identity primary key column, when I try to insert records from tableA to tableB, I get the truncated data error. The datatypes of the destination column and the source are the same datatype - int (4) Help??

I'm new to SQL Server and would like some help. I have a table in 2000 called clients. I want to import data in from another 2000 table called clients (which is in the original DB.)However the table in database 1 which I'm importing from has differing datatypes and sizes. How can I get the data...

I'm using a macro to run this function: Function OutputToSnapshotViewerQ() Dim Qryview As Variant,QryName As String On Error GoTo OutputToSnapshotViewerq_Err Set Qryview = Screen.ActiveDatasheet QryName = Qryview.Name DoCmd.OutputTo acOutputQuery, QryName, acFormatSNP...