Search results for query: *

Hi, I have to create a text file that outputs data in certain chuncks like this: Name, 10 chars [1-10] Number, 2 chars [11-12] Code1, 3 chars [13-15] Code2, 3 chars [16-18] I put all the fields from the dataset next to eachother in a single table cell and the idea is to let the user export to...

Hi, I have a sort of stupid table structure on the project I inherited. It's a list of what work was performed that uses codes like this: CustomerID | Date | Code1 | Code2 | Code3 | Code4 I want to know all work that was performed for a certain period and thus need to count the distinct codes...

Hi, I'm looking for some advice on cornering an annoying bug I cannot recreate! I'll just paste the code here: Public Sub CreateView( _ lv As ListView, _ lvTemp As ListView, _ dtFromDate As Date, _ dtToDate As Date, _ Optional sFilter As String = "" _ ) Dim rs As New...

Hi, I'm pretty new to C# .Net 3.5 so go easy on me... I want to test if a list of dates is sorted. I use LINQ to extract the DateTime field from a ObservableCollection<T> with either ToArray or ToList. I do this twice, with and without orderby clause. The (simple?) problem is how do I compare...

Hi, I'm trying to build a setup program for my application. The Package & Deployment Wizard keeps asking for file "3". When I look at the project references I can see two references to *.DLL\3: Visual Basic runtime objects and procedures C:\WINDOWS\system32\msvbvm60.dll\3 Microsoft VBScript...

Hello everyone! I have the strangest problem. In my main form I somehow trap linebreaks in textboxes with MultiLine = True. Problem is I don't know where this code is! It's a pretty old application... On a new form I added (a dialog box) this input filter trap key magic is non existing...

Hi, I have a rather complex application that has a main ListView that gets refreshed from the database on a timer. When data has changed I hide the ListView while I rebuild it. Problem occurs when another app has focus and the ListView is updated on my app, and the ListView in my app is the...

Hi, I'm working on a project where sometimes I want SmallIcons (from an ImageList) displayed for a ListView, and sometimes I don't want icons (or blank space in front of each ListItem). How can I switch back and forth during runtime? I don't want to introduce another ListView instance...

Hi, I want to run some code when the user changes a ListView scrollbar. I tried this page http://vbnet.mvps.org/index.html?code/subclass/lvscrollbars.htm but had some problems with error 91 Object variable or With block variable not set trying to hook the window. Is there an easier way to pick...

I have a function that checks how many minutes an event overlaps a certain period like this: dbo.udf_CountMinutes(event_start, event_end, from, to) When I have a very long event it can overlap two periods and I want to count the overlapping minutes on both ends, but I do not want to count the...

Hi, I have a list of events that I want to filter on certain days and time of day. My events are in a table called events with event_start and event_end datetimes. My proc goes something like this: create table #days ( from datetime, to datetime) insert #days ( from, to ) values (...

Hi, I get an error trying to MoveFirst on a Recordset. I've been debugging but I can't figure it out... Here's what I've got: Set cmd = New ADODB.Command With cmd .ActiveConnection = myConn .CommandType = adCmdStoredProc .CommandText = "usp_GetDayList 'Parameters... End With Set rs =...

Hi, I have problems setting up a manual print job from VB6. I want to print the contents of a ListView with some custom formatting (flexible column width and separator lines). When I get an error on the previous print job the next try always gives me a 396: Orientation cannot be set within a...

Hi, I have a stored procedure that takes a datetime input parameter. Sometimes this variable has a date and a time but for the procedure to work as intended I have to have date 00:00:00.000 only. What is the fastest way to clear the timepart right away? I'm thinking of doing this on the first...

Hi, I have a couple of stored procedures running on SQL Server 2000 that outputs some debug data that's really important for debugging my VB6 application. Is there any way I can catch these outputs when running a ADODB Command in runtime? One of the procedures returns a Recordset in addition...

Hi, I have a question similar to thread183-1370666. I have two stored procedures. PageCheck reads table PageIndex and sometimes updates a corresponding table, and PageEdit marks records (pages) in PageIndex as "dirty" so when the next read comes in with PageCheck the table gets rebuilt. I'm...

Hello, I've read the FAQ but couldn't see the answer there. Not much luck googling either. The question is simple. How do I pass a NULL value to a stored procedure that's expecting a datetime value? cmd.ActiveConnection = myConnection cmd.CommandType = adCmdStoredProc cmd.CommandText =...

Hello, I want to look at listening in on a MSMQ but I can't find the reference to whatever library I should use... I suppose I want MSMQ 3.0 or something? I'm at work and I don't have access to the Windows XP CD cause these workstations come preinstalled with image, so where do I get the...

Hi, I have a strange behaviour in a timer event that refreshes the contents of a list. Sometimes it steals the focus from other applications even though my app is "behind" the application the user is currently working on. I assume this is because of the SetFocus method? I use this to...

Hi, I have a VB6 application that does XOR encryption on a password. I have a web service that needs to test the communication and thus encrypt the plain text password but I have no idea how to work System.Security.Crypthography in C# .NET. No luck googling either. Can anyone help me out...