Search results for query: *

Hi Guys I am loading a combo box With cboSalesCallReason .Clear Do Until rs.EOF .AddItem Trim(rs!CallReason) .ItemData(.NewIndex) = rs!URN rs.MoveNext Loop End With I need to set the combo box depending on the .ItemData (the URN)...

I am running a stored procedure which populates a table and has a IGNORE_DUP_KEY and a clustered index on it I am getting the message that "Duplicate key was ignored" which creates an error in the calling VB program Can this be suppressed or changed somehow? I have tried a number of things...

Hi all really hope you can help me out here.. I know Inet is not the best but this is protocols they use and they won’t let me change them... That said I have been working on this for hours and about to give up, if only I could, I can’t seem to get or put files onto the sFTP site even though I...

My VB6 program calls a stored procedure (SQL server 2000) that runs the code outlined below CREATE PROCEDURE [spExportResetDNP] @TableName as varchar(50) AS Declare @SQL as varchar(250) Set @SQL = 'UPDATE ' + @TableName + ' SET ExpProcess = Null Where ExpProcess = 1' Exec (@SQL)...

Hi all This is/should be a simple one but for some reason I just can’t get it, I think my brain has gone for a long walk. I load the listview from a recordset and when the user clicks on a row I want to be able to look in a particular element and if that element holds a true value we can then...

Hi all Does anyone out there have any idea on how to get the The KeyPress event to trap the Tab key. I have to write a routine to block the input of certain characters due to the fact that these characters are causing errors when exporting the report into excel. I can trap all except the tab...

I have a program that dynamically adds tabs to the SSTab control, I will not know their captions and so will not know there widths. The problem is that at the moment the program is running .TabsPerRow = .TabsPerRow + 1 .Tabs = .Tabs + 1 .TabCaption(.Tabs - 1) = sCaption...

Hi all hope you can help as this has been bugging me for days. I need to create a temporary table to then report on, the table column headers need to be the values from one table and the column content from another… it goes a bit like this. I have a table that has among other things a...

When is it best to use Call or not. For example if you had a method below in one class Public Sub LoadData(ByVal ID As Integer, ByVal Desc As String) Now to call it from another class would you use LoadData intID, strDesc OR Call LoadData(intID, strDesc) both do the same so is one...

Hi all I am creating a multitab control dynamically I now need to delete certain tabs an so get rid of all reference to that particular tab and controls held on it. I cant find how anywhere???? Very frustrating can you help?

Hi I am trying to get a variable to hold 7 decimal places, simple i thought use FormatCurrency but this does not seem to work with a variable of currency? Try the code below Dim UnitPrice As Currency UnitPrice = FormatCurrency(2.1276595, 7) UnitPrice will = 2.1277 The Currency...

Hi all A rather simple problem but I have not touched SQL for 2 years and I am slowly getting back to it, so am a bit unsure of what could be simple problems. I have a populated existing Money column in a table that now has to change to a datatype of Decimal(17,7) Can I just do an Alter Table...

I have inherited a report that has 4 group headers on which the report will be sorted, I have been tasked to add an extra one, this is where my problem begins. I have added an extra groupheader to sort by but from what I can tell a value is not being added into the RecordSortFields. I have...

Using VB When adding a GroupHeader how do you edit the reference i.e In the designer the group header reads Group Header #1: ado.ExecutiveCode – A (GroupHeader1) I add a new one it reads: Group Header #2: ado.CustomerCode – A (Section3) I want (section3) to read (GroupHeader2)...

Hi all I am suppressing a Group header through VB (ExecGroupHeader.Suppress = True) I now need to add a ‘New page before’ if the Group Header is suppressed. So in the ‘New page before’ option in the Section Expert I am checking to see if the GroupHeader is suppressed but can not figure out what...

This may sound strange, well it is, I have a MSFlex grid that is populated with 37 columns and 6 rows, this is all fine. When you use the horizontal scroll bar (vertical not required) to view the columns on the right, focus goes from the top row to the bottom row and does not move to the right...

I am writing an application, which will both launch and pass parameters to a second application. I think the best way to launch the second app would be to use the Shell command passing the parameters to the second app. Would you agree… All well and good, now the user will install this second...

Hi all, I want to run a batch file that will move various specified files to the System32 folder at the moment I use: For XP copy ..\utilities\buildexe\buildexe.exe c:\windows\system32 2000 and below copy ..\utilities\buildexe\buildexe.exe c:\winnt\system32 Is it possible to run one batch file...

Hi all I need to populate a treeview useing the image list to provide the images for the nodes. I have about 200 existing icons in a resource file, what I want to do is instead of loading the image file with all the images at design time I want to loop around the resource file at run time when...

I need a hand here. I create a node when the user picks the ‘Create New Child Node’ option from a menu.... this is not a problem the problem is the naming of this node, as this will be user definable. After the Node has been created it needs to be selected with the blinking cursor in the name...