Recent content by mapfax

Thanks for your assistance...v much appreciate :)

I'm not sure, I've just changed it back and it is now working after checking out your note, whereas before I was sure I was getting the same multirow error. I also didn't have a PK just an identity. I had just added a PK to test this and have removed again. But both versions now work with or...

I've just changed it to this (as per BOL's multirow trigger) IF UPDATE (dtPostcardSent) UPDATE tblsubcomments SET LPI_1 = (SELECT COUNT(bitworkingday) FROM tblDWPeriod WHERE dtsActivityDate BETWEEN dtSubCaseReceived AND dtPostcardSent AND bitworkingday = 1) WHERE subcaseid IN...

Hi I actually had a calendar table tblDWPeriod courtesy of www.tek-tips.com/faqs.cfm?fid=4532) but wasn't sure how to implement that idea. I have changed the trigger code but still can't figure how to evaluate multirows, works with 1 record. Is it done with a subquery, if so, how...

Sorry I neglected to mention I am using version 7 if you are referring to UDF's. I presume that means I cannot use a function, correct? ps. I had problems with the date datatypes going over as nvarchar. When I used datetime they seemed to be passed in the wrong format. It seems to work for...

I am going round in circles with this, can someone point me in the right direction. I am not sure if I am approaching this the correct way. I have a table with dates, e.g. received, acknowledged, closed. I am trying to calculate the business days using a stored procedure which works for 1...

Thanks James I checked and double checked my datatype assignments and now it is working.

Have tried using CAST and CONVERT unsuccessfully, keep getting the same error 'syntax error converting datetime from a character string'. I am passing dates between a trigger to a stored procedure. The dates are being passed as nvarchar and are converted to a string char(20) in the input...

Hello, Can't seem to understand what is wrong here. Within an Access Project connecting SQL 7.0, I have a search form for customers and a main form for displaying the customer details. For existing customers there is no problem except for a new customer I can't get >DoCmd.OpenForm stDocName...

Thanks for your help. I had tried this but this didn't work either. My SQL stmt is being pulled from a table which has no quotations. So when trying to reference the control it was just be read as part of the string. Anyway I explored the parameterized SP and found this successful. I had...

If it helps, I found a good article about creating Valid Time Tables for auditing purposes. www.accesshelp.net > survival guide. Mark.

Can anyone help me with this? I am trying to work out the quotes, syntax etc to set a rowsource on a form using VBA. The SQL rowsource would look something like: SELECT colA, colB, colC FROM tbl WHERE colA Like '% & form.control & %' ORDER BY colA I have tried all sorts of combinations and...

Thanks for the replies guys. You are right my syntax I posted was incorrect (mistyped), but I have narrowed my problem down. I thought the above line wasn't working but debuggings shows it does. My problem lies with referencing the fields collection for the recordset to determine the field...

Hi, I am having real problems resolving this issue, can someone help? I have an Access project 2000 attached to SQL Server 7. I am trying to convert code written specifically for Access mdb. The code is designed to set an object to: Set rs = Forms(Form).Control(Subform).Form.RecordSetClone...

I think I've found what I am looking for. I need to use the 'SaveToSQLServer' method on the DTS package object. For example: -- Set oPKG = DTSGlobalVariables.Parent oPKG.SaveToSQLServer "(local)", "","", DTSSQLStgFlag_UseTrustedConnection -- Although I am using...