Recent content by ironvid

Hi I know this should be simple But I just can't get my head round it!. I have a table which stores information on files: [ID] [Files] [Boxes] [Count] ID FileNo BoxNo Count 2 123456 Box1 10 3 654321 Box1 15 4 258852 Box1 25 5 654456 Box2 20 6 753357 Box2 10 7 951159 Box2 10 I want a...

Hi Cheers namliam The "dbo_ " was just because I pasted it from access The problem was the "&" need to be changed to "+" and the Quote marks to ' Final query: UPDATE MT_Document SET MT_Document.Text_Field_8 = [Text_Field_1] + '-' + [Text_Field_2] WHERE (((MT_Document.ID_Job)="0000000004E")...

Hi I have a simple query that I use in access which works great! UPDATE dbo_MT_Document SET dbo_MT_Document.Text_Field_8 = [Text_Field_1] & "-" & [Text_Field_2] WHERE (((dbo_MT_Document.ID_Job)="0000000004E") AND ((dbo_MT_Document.Is_Batch)=0)); I can't get it to work in SQL Server, I have...

Hi I am having problems with the ColumnHistory contol on a form! =ColumnHistory([RecordSource],"Comments","[contact_ID]=" & Nz([contact_ID],0)) which just gives me "#error" anybody had any experience with ColumnHistory; has there does not seem to be much info on the web about it thanks...

Hi I Have two table.... Table 1 (index) Auto id box file_number surname first name done Table 2 ( archive) Id archive file_number surname first name Question 1 How can i query the table to give me a list of all box's that have ALL THE RECORDS IN THAT BOX in the archive table and an...

I am designing a table and I need one of my columns to automaticlly enter the date in when a record is created. In MSSQL i Simply add (getdate()) into the default Value Thanks for any help Regards....stephen

Hope this makes sense If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be...

If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be updated with the...

I didn't explain very well Where the contents of another field match Name (unique Key) So where the name value fields match between the batch & documents table the contents from the page field in the document field will be inserted into the page field in the batch table. hope that makes sense

Thanks to everone in forums for help with my access frontend If anyone can help with my ms sql 2000 backend I have this question:- I am designing two tables : Batch Documnets In both tables i have a field called "page" How can I design the page field in the batch table to be updated with...

sounds simple and it was! I,ve been through those dialog boxs hundreds of times before aswell thanks for the help!!!!

In my database i have a linked table through ODBC to my sql2000 server. when i first open that table or form linked to that table it asks me for login details for the sql server Is there away to save these detail so it never asks again ? sounds simple !! regards....stephen

thanks for the help guys but can someone please explain how I use the expression Len([FieldName]) / 15 this is totally new to me. regards......stephen

Jon the linked image name is unique so ;00;0000000000M could only appear once Mile-O-Phile all the data is entered automaticly by an app which generates the file names and enters them into the relivent field. this makes it impossible to have another table or change the structure of the...

ignore the names, just used those names to make it easy to describe the problem I can't send the DB because it's a large sql2000 database I just use access for the frontend,but i have made a sample of the table in question in access there no keys setup in this table if you need to see the sql...