|
 I don't have a problem with creating the report itself (it is alot the same as Microsoft Access reports). I don't know how to edit the report at runtime.
When the user selects only a certain group of participants to display (for instance participants with the surname beginning with S...).
How do I use that SQL query to display only the selected people?
|
|
|
|
|
Ohhh ok so you're having a problem with you're SQL statements. The way I use crystal is that I point to a stored proc on my SQL database and pass the parameters to the stored proc. I'm guessing you're building the SQL statement in the crystal report itself. You're going to have to make a parameter and pass that to your SQL statement:
e.g.
CREATE PROCEDURE spGetUsers<br />
@Letter VARCHAR(1)<br />
<br />
AS <br />
<br />
SELECT [Columns] FROM [Users] WHERE[Surname] LIKE @Letter + '%'
Should work - You just have to pass that @Letter varchar to the statement.
Hope this helps - if you need any more help just ask. Isn't there a lecturer at Tukkies? 
Beware the chickens, for in their silence, they plot...
Life is too short to be taken seriously.
-- Oscar Wilde
|
|
|
|
|
hello i need help in shuffling playing cards and loading them into an image combo
paakwesinartey
|
|
|
|
|
Sounds like you need a BogoSort[^] algorithm.
--
Ian Darling
|
|
|
|
|
Hi,
I have got a picturebox that displays an image in correspondance with the node selected in a treeview. What i want to do is when a node is renamed for the file that the picturebox is pointing to to also be renamed. The problem i get is the filenotfound exception from the rename. I am pretty sure tho not 100% that this is because the image file is being displayed in the picturebox at the same time that i am trying to rename the file. I have tried makign the picturebox empty as well as trying to use image.dispose() but i cannot seem to get it to work.
Help would be VERY appreciated thanks
Dean
|
|
|
|
|
A PictureBox stores the image at that time and is not tied to the image. For instance, if you changed the image (added a line or something), the changes are not reflected automatically in the PictureBox. This requires change notification.
More than likely, you're not giving a fully resolvable path to the file, which is either a fully-qualified path or a relative path to the current working directory (not necessarily always the directory from which your app is running). The best thing you can do is debug your code using the excellent tools in the IDE. Debugging code is half the battle.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
I have a text dispalyed in text box of my application.
I want to search this text and find certain strings only, lets say links only and have them displayed in a new text box of my application.
How can I do that? Please help!
Thank you
|
|
|
|
|
Try the System.Text.RegularExpressions namespace.
Nick Seng (the programmer formerly known as Notorious SMC)
God, I pity me! - Phoncible P. Bone
|
|
|
|
|
Hello every body
Is it possible to change the calling convention of an method in VB.NET ?
If yes how can i do that ?
|
|
|
|
|
can you give an example of what you want to do?
Nick Seng (the programmer formerly known as Notorious SMC)
God, I pity me! - Phoncible P. Bone
|
|
|
|
|
I have to use a legacy C DLL. Some functions in this DLL need Callback as parameters. The Callback are writen in VB.NET. When I pass the address of Callback to the DLL function non managed code, its work (I mean the DLL call may Callback). But it seems to be a stack corruption after the end of the callback call because the callback use _stdcall convention (Default and the only one supported in VB.NET and C#).
|
|
|
|
|
I would like to add a click event to a webform ListBox.
I have read how to do it in VB.net, but I can't make it work for a webform Listbox. (reference article on this site www.codeproject.com/vb/net/sublcassing_Lis;)tBox.asp)
Lyle B. Hunt
|
|
|
|
|
I didn't add a click event but I did attach a bit of Client-side Javascript to a combo box. You should probably be able to apply the same idea to a list box but I son't know how useful it will be in your situation.
cboList.Attributes.Add("onchange", "JavaScriptFunction();")
Beware the chickens, for in their silence, they plot...
Life is too short to be taken seriously.
-- Oscar Wilde
|
|
|
|
|
I'd like to ensure a string I'm manipulating has not become too long to be a valid path. Can anyone shed some light on this for me?
Thanks,
Jeff
|
|
|
|
|
Most win32 c++ compilers have a _MAX_PATH constant defined - I'd search the Web/MSDN and see what this is defined as ... I would have thought VB had a function sitting over a win32 api that returns a path, the MSDN specs for that API should eventually yield that max it returns ...
ps .. I took this >> from the MSDN CreateDirectory API page (The GetCurrentDirectory function doesnt show what you're looking for, unfortunately) ..
"There is a default string size limit for paths of 248 characters. This limit is related to how the CreateDirectory function parses paths.
To extend this limit to 32,767 wide characters, call the Unicode version of the function and prepend "\\?\" to the path. For more information, see Naming a File."
so depending on what you define _MAX_PATH to be, you can just check the string length against it ..
Sorry, that probably doesnt help much
|
|
|
|
|
Hi,
How to I can get all folders name and files name in CD ROM, but not scan all content of CD. Because scan all data is very slowly.
Please help me for this problem.
H.Dung
|
|
|
|
|
You didn't mention if your using VB6 or VB.Net.
Here is a VB.Net method:
<br />
Dim myPath As String = "C:\test" <br />
Dim myDirectory As System.IO.Directory <br />
Dim mySubDirectory As String <br />
<br />
If myDirectory.Exists(myPath) Then <br />
For Each mySubDirectory In myDirectory.GetDirectories(myPath) <br />
MsgBox(mySubDirectory) <br />
Next <br />
End If<br />
Regards
Wayne Phipps
____________
Time is the greatest teacher... unfortunately, it kills all of its students
LearnVisualStudio.Net
|
|
|
|
|
Hi,
I use VB.6 and I want get all directories and files in CD ROM but I don't want scan all content of CD ROM.
Please help me.
Thanks.
H.Dung
|
|
|
|
|
I have found the definitive answer! Unfortunately, it's not what I wanted (although it is what I expected). In summary, to quote the article found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetdep/html/redistdeploy.asp,
"Applications and controls written for the .NET Framework require the .NET Framework to be installed on the computer where the application or control runs."
Oh, well, time to roll back to VB6! And .Net was so.... nice! I'm losing my warm and fuzzy feeling....
>I originally wrote:
>In VB 6.0, you could place your VB app on a disk along with the VB runtime DLL, and it would work (from disk) on any Wintel >machine; no need to have VB installed.
> Is there any way to do the same thing with VB.NET? I have a VB app that must be run on WinXP machines that >don't have the .NET framework installed (and for security reasons  I can't install it, either, which would be the >simplest thing, eh?). Is there a list of the magical contents of the .NET framework that I can copy to my disk?
>Is my only hope to revert to VB6.0 and use the DLL magic method  ? Thanks in advance for any guidance.
|
|
|
|
|
You're out of luck - AFAIK the framework has to be installed using dotnetfx.exe to use a .NET application.
--
Ian Darling
|
|
|
|
|
Sounds like your application should have been an ASP.NET web application since you can't control what configuration your clients would have.
Of course, web applications require the client to have an internet connection (or network for intranet web servers) but that's a lot more common currently than clients with the .NET framework.
|
|
|
|
|
Yes you can. There is a compiler that says that it will compile it too native code.
http://www.remotesoft.com
Bo Hunter
|
|
|
|
|
The native code compiler looks interesting, but I can't find any information about it other than the short blurb on their main page. There is no pricing or download information.
|
|
|
|
|
Same here. If they want us to buy it, they should give us a way to do it. 
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
Hey all,
I get the following error when using the load method of XMLDocument (the XML
is in string format)
There is no path, it is justa string... <confused> anyone come across this?
TIA,
Matt
--------------ERROR-------------
An unhandled exception of type 'System.IO.PathTooLongException' occurred in
mscorlib.dll
Additional information: The path is too long after being fully qualified.
Make sure path is less than 260 characters.
--------------ERROR-------------
--------------CODE ERRORING ON------------
trackXMLdoc.Load(trackXMLstr) 'dim trackXMLdoc as New XMLDocument()
--------------CODE ERRORING ON-------------
--------------XML (from debug window)-------------
trackXMLstr "<AlbumTracks>
<Track>
<Title>Shitbag 9</Title>
<ID>2962</ID>
<Path>\\Mediabox\Music\Gomez\Abandoned Sopping Trolley Hotline\Gomez -
Abandoned Shopping Trolley Hot - 01 - Shitbag 9.mp3</Path>
<TrackNum>1</TrackNum>
<AlbumID>261</AlbumID>
</Track>
</AlbumTracks>" String
--------------XML (from debug window)-------------
PS. There was more XML and I can post/email it if it'd help. But the message blackmailed me ;o). Made me think of the poor chaps with 56K modems!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
