Search results for query: *

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

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...

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...

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...

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

Hello everybody Is there an easy way to ensure when the page loads any combo boxes populated from recordsets appear as blank entries until the user clicks the arrow. John

I'm new to the world of asp so please bear with me. What I'm doing is populating a combo box with two columns, a period and an ID. The combo box will display the period but store the ID in the tenant table. THIS PART I'VE MANAGED TO DO. <select name=&quot;cboName&quot; size=&quot;1&quot;> <%...

Hi everybody Would you have a look at the following snippet of code. SELECT n.ProviderID, n.SchemeID, Sum(Total) FROM NormalPaymentSchedule n INNER JOIN ClaimantDetailsTest c ON c.ClaimantID = n.ClaimantID WHERE n.Period = 1 AND n.YearNo = 1 GROUP BY n.ProviderID, n.SchemeID, c.ProtectedCase...

The date time pickers I have on a SSTab are not behaving the way they should. If the validation event fires the focus will remain on the control as long as the user clicks on any control in the tab or anywhere on the form. However, if the user clicks on another tab or indeed on the label of...

Hi I'm having problems holding a timestamp value in a column of a listview. When I try and reference the value it returns nothing. The column itself is hidden from the user, but I need to hold the value until the user makes a selection from the list. Any ideas John

What is the best way to remove the zeros from the start of a string. Unfortunately the string can contain characters as well as numbers. Thanks in advance John

Could somone please have a look at the following piece of code and tell me what I am doing wrong. I am trying to populate @ReturnId with @@identity and use the value to insert into the second table. But it keeps coming up with an overflow error. CREATE PROCEDURE InsertClaimant @ProviderID...

How can you reset an integer variable, which is private to the form, with a value of nothing, without unloading the form. John

Is there a quick way to de-reference all private variables on a form without having to call them individually, or unload the form. John

Hi I have a list view on the third tab of a SSTab control. When the user is working at the top of the form the listview is not visible as the first tab has focus. However, when the listview is populated it comes to the front of the SSTab. I have tried sending it to the back but to no avail...

Could anyone help please? The code below returns the result set from a stored procedure. How can I set the cursortype of the recordset using this method. As I am using the EOF and BOF properties of the recordset to see if it contains records, I need to specify something other than forward...

This is a project I have inherited from another employee. The project in question has two parts. The source files for the user interface, including all forms and code modules held in one project, and the class modules held in another project. The class modules have been complied into a DLL...