Recent content by Syerston

gaudibri You are an absolute STAR!!! Many Thanks John

I wonder would anyone out there be able to help. I currently import a text file into a SQL table using a small VB executable which calls a DTS package. However the organisation that sends the file has now changed its format. It now includes two different sets of records, each having a...

Hi Everybody, Would anyone be able to point me in the right direction for information on returning error messages from a DTS package back to the VB application. John

Thanks James I've got it.

James thanks for replying. I am using @@Identity How would Scope_Identity fit in below. P.S. I know nothing matches in the statement INSERT INTO ClaimantDetails (****.....) VALUES (@ProviderID @Address2, @Address3, @Postcode, GetDate()..) SELECT @@Identity If @CreditDebit = 'c' or...

Hello everybody. I run an insert in a stored procedure and return the identity value for populating a field on the next insert. However, I have now set up a trigger to fire on the insert to the first table which populates an Audit table. The identity is now returned as the identity from the...

James you are a star and because of that you get one.

I cannot find that option. In fact as far as I can see date and currency fields do not even have Allow zero length.

Would anyone have any idea why I can not save a null value to a date or currency field in MS Access. The required property of these fields have been set to no. Below is a snippet of code to explain what I am doing. 'Current NAV If Len(Request.Form("Current NAV")) > 0 Then...

I'm having a bit of trouble with an Update SQL string being passed to a MS Access table via a Command object. The problem arises if the date field or number field currently contains a value, and I try to delete the value from the form and then run the update string. I have tried setting the...

Tarwn A big star for you. Your example works perfectly. My own stupid typing doesn't. Many Thanks John

Sorry to trouble you again Tarwn but the page is not displaying. This is the code as it now appears. <SELECT name=&quot;cboDistrictOffice&quot; size=&quot;1&quot;> <% 'Check for database errors Call CheckforErrors(oConn) 'Create Recordset and Connection Set...

Thanks for replying Below is the code I am using to populate the combo box. I have also returned another recordset with the property details, the field that relates to this particular combo is rsProperty(&quot;District&quot;). Therfore I need to populate the combo as below and then set the...

Scrub that. It didn't work. Any ideas.

It's okay. I got it to work using the &quot;SELECTED&quot; attribute of the OPTION Element. John