|
I know almost 0 about vba, but I believe it is just a subset of vb6? So I would guess that you would have the same problems. If you have vba though that means you have some of office installed on the users cpu. If you have outlook that might work for you.
|
|
|
|
|
i know,why make it difficult, with outlook is it quite easier
but i don't wanna use outlook.I got it in vb6,hope i can use the code
in vba,but im gonna finish work today I'll try it tomorrow
so anyway thank u
Thanx
|
|
|
|
|
can someone help me sending a email in vb via smtp?
Thanx
|
|
|
|
|
problem solved
Thanx
|
|
|
|
|
I need help on Crystal Reports. Can anyone tell me where I can find a manual on the net that can help me? 
|
|
|
|
|
There is built in help for Crystal Reports in VS.NET. I've also found Google to be invaluable, particularly Google Groups. You might have luck at the CrystalDecisions webiste too - there's a lot of stuff there.
--
Ian Darling
|
|
|
|
|
Hi,
I found this really helpful...
http://www.crystalreportsbook.com/
Hope that helps,
Martin
|
|
|
|
|
What are you trying to do exactly? You also might want to try looking in Google groups. The Crystal that comes with .NET is very buggy so if somethings not working it might not be a problem with your code.
Beware the chickens, for in their silence, they plot...
Life is too short to be taken seriously.
-- Oscar Wilde
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
