Search results for query: *

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

Once you have a combo box populated with data from a lookup table, is there an easy way to get the combo box to display one of the values, dependant on the value from a recordset. Many Thanks

I appear to be having a problem passing zero values into my command object to run a stored procedure in MS Access. If the field in Access is to contain text, I check beforehand and assign null if there is no user input in that field on the ASP, the stored procedure runs fine. However, this...

Thanks for all your help. Would mit99mh be able to post or send me the copy of the code. I am populating the boxes from a database. Thanks john.lamont@nihe.gov.uk John

I've never used Java before. Would anyone have a very simplistic example of how to do this, or be able to give me a hyperlink to one. John

Hi Everybody I have been struggling to find a way to populate a combo box dependant on a user selection on a previous combo box. Could someone please give me some guidance. I would prefer to use VBScript if possible. Many Thanks John