Search results for query: *

Hi, I have a query which returns me some data like: ID StringData --------------------------- 0 11000111000010000111110101010001 1 01110001010101111000010101000111 How can I convert the StringData (which is actually binary only represented by String ones and zeros) into a...

Hi. I've got a little head scratcher here which i'm hoping someone can help with. I have a table with several fields in it which cater for 60'000 records or so. The table is like this: ID Field1 Field2 ---------------------------- 0 'SomeText' 'SomeText' 1 ''...

Hi. Im trying to create a application to connect to an SQL databse using ADO (so record locking can be achieved). This in itself is no problem except that I want the data connection and recordsets etc to be in a dll, and the code that uses it (including forms etc) to be another dll...

Hi all. I'm currently working on an app that requires the need to ping pc's to check that they are online. The app could pottentially have to check several hundred PC's, and so I've made it a multithreaded application. The problem I'm having is that the code that microsoft suggests for...

Hi, I'm currently writing a WMI application to retrieve information from a remote machine. As part of this, I'd quite like to create the "core" of the application without any of the WMI querys etc in the app, but rather have them called from an external database, so that extra functions could...

Hi, I’m currently trying to develop a report using the version of crystal that comes with .Net 2003 (crystal 9?) and I am having some major problems getting the data displayed. I basically have three tables, one which holds details on Assets (e.g. a monitor) and there locations, one which...

Hi, Does anyone know how I can place an image from an imagelist into a statusbar panel? I stuppidly assumed it was as simple as: Me.Statusbar.Icon = Me.Imagelist.Images(0) but it doesnt work, it gives me an error stating that it cant convert the types. Any help would be appreciated. Thanks.

Hi, I'm building a report using parameters (passed to the report by VB.Net app) and I am getting odd results. This is my selection Formula: ({TblAssets.Desc1} = "rexel" or {TblAssets.Desc1} = "hp") and ({TblLocations.Level5} like{?Site}); if I pass say 'Newcastle' as ?site, then it works...

Hi all. I'm having a problem with passing some parameters to a crystal report at runtime. Heres the code I'm trying to use (found it in msdn). Dim paramFields As New CrystalDecisions.Shared.ParameterFields Dim paramField As New CrystalDecisions.Shared.ParameterField Dim discreteVal As New...

Hi. I'm currently writing an applicaiton that includes some Crystal reports. I'm attempting to use the following code to open a report: Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table Dim tliCurrent As CrystalDecisions.Shared.TableLogOnInfo Dim MyReport As New...

Hi all. Does anyone know how to use the FileOpenDialog to just get a path? i.e. \\Servername\Sharename I dont want the user to select a file or anyhting, just the path. Thanks. Jeff.

Hi, Anyone have any idea as to why this always returns the recordset.count as "-1" no matter how many records there are? Dim SQLConnection As New ADODB.Connection SQLConnection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial...

Hi all. I'm having a problem with MDI forms. I declare my forms at module level (so I can access them from anywhere in the app), and display one as soon as the app starts up (in the form_load sub) so that it appears on the left of the MDIParent (it is used as an "outlook" style icon...

Hi all. Well, I've just taking the first (silly?) step to VB.NET - what a difference. Apart from things being very different, and some things not working (like not being able to put an icon into an imagelist control at design time????) its not too bad (famous last words!). The problem im...

Hi all. I have a wierd problem and I'm not sure if its just me, or if it is an actual problem. Basically I have a function to insert a record into my SQL DB, and if a primary key violation has happened, then I handle the error by showing a message box, and then allowing the user to re-enter...

Hi all. Well, my project is progressing quite nicely until .... ... I came to locking. Having had a bit of experience with both access and SQL, I have decided to make my app run on two different back-ends - Access for single users, and SQL (or MSDE) for multi-user environments. The problem I...

Hi, I hope someone can help me here as I'm pulling my hair out. I'm trying to set up a query to an access database that returns all records where a field contains part of a specified string. This would normally be "Like '*A*'" where A would be the word / part word, but what I want...