Recent content by ambs24

Can someone provide me with an example of a DTS package that calls a Stored Procedure from within the VB Script of a transformation? MORE DETAILS We have a COM object that parses out a name. We can call this object from a stored procedure - passing in the full name. The stored procedure then...

A newbie question ... I would like all of the unused space to the right side of my page to have a certain background color. I know I can probably set my tables to 100% and make certain cells the color, but I would rather not do that because I've had better luck using pixels. Using percentages...

I'm looking for a way to set up a command button that will perform the same operation as the import spreadsheet wizard. The wizard is simple enough, but the operation will be performed daily and the parameters will be identical each time, so it seems like a command button would save my users a...

Great suggestion, but it still didn't work.

Thanks for the quick response. I already have a Select Case that establishes the criteria in the AfterUpdate event of txtUnitType. I believe that should accomplish the same thing that you suggested, but it still isn't working.

I have two text boxes (txtUnitType and txtPieces). The visible property of txtPieces is set to No, but I have VBA code to change it to Yes based on the value of txtUnitType. My problem occurs when the value of txtUnitType is updated to one that requires txtPieces to become visible – it doesn’t...