|
formula=Sum ({@DebitBalance})
Why above function cause error "This field cannot be summarized"
Actually @DebitBalance has value of number. Any ways that i can sum up @debitbalance?
|
|
|
|
|
Is {@DebitBalance} a formula too?
<italic>Work hard, Work effectively.
|
|
|
|
|
yes, inside that is :
if Sum ({Entries.Debit}, {Entries.AccountName})>Sum ({Entries.Credit}, {Entries.AccountName}) then
formula= Sum ({Entries.Debit}, {Entries.AccountName})-Sum ({Entries.Credit}, {Entries.AccountName})
end if
|
|
|
|
|
Although the formula always returns number, I don't think you can sum it. The Crystal Report couldn't recognize it as number. You have to look for another solution.
<italic>Work hard, Work effectively.
|
|
|
|
|
hi all,
i am currently developing a project in which i have to display images in a crystal report from a database . when i am storing the image in bmp format in the database then it works fine but when i am storing it as jpeg format then no image is displayed in the crystal report.
i am using crystal report 7.5 and vb6. i am using stream object to store image data in the database table .
if anyone have any idea please help me to solve this problem.
from
arnab
|
|
|
|
|
hi
i want make a program that must run in LAN, and i programming in vb and do not know if by VB, i can run it in LAN.
if yes,how i can conect it to SQL server data base
Please help me
|
|
|
|
|
daneshmand wrote:
how i can conect it to SQL server data base
using connection string
|
|
|
|
|
Set the the server name or the server ip as the data Source.
<italic>Work hard, Work effectively.
|
|
|
|
|
thanks
please introduction me a website about VB and VB.net and benefits them
|
|
|
|
|
Use google.
<italic>Work hard, Work effectively.
|
|
|
|
|
Better yet, Amazon and get yourself a couple of good books on VB or VB.NET, whichever your using.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
If my datagrid is readonly = true.
Then it cannot be modified from inside datagrid but i want to allow deletion of row if 1 or more rows are selected and this is event raised after a button is pressed.
How to code this?
|
|
|
|
|
Is there any free tool that can convert my vb.net forms to asp.net
smita
|
|
|
|
|
|
If your code is well written, you should be able to just write an ASP.NET presentation layer, but as has been said, it's a totally different model, and the way you code it is way too different for a wizard to deal with.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I have a windows apllication which has flexgrid.This application works fine when it is run from the local hard disk.But when this application is accessed from another computerin the network it gives.System.security.securityexception
Using try catch i found the error was Request failed
What i actually want is deploy my application on one machine and acces it from other machines without deploying on each and every machine
smita
|
|
|
|
|
Why does the flexgrid give a security exception ? Is the error message wrong, and you just need to deploy the grid ? ( Flexgrid isn't a WinForms control, it's an old one, isn't it ? )
smita_roy@insuranceassist.co.in wrote:
What i actually want is deploy my application on one machine and acces it from other machines without deploying on each and every machine
You really can't do that with the presentation part of the code, although you can do it with your data stuff, if you can configure all instances of the app to look to your machine. This means you need to code for concurrency issues, obviously.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi all,
I have given an option of deleting a row of a grid by pressing Ctrl-F6
But this key is not working
The same function is getting called by other keys like Ctrl-F7
Since Ctrl-F6 is a windows shortcut key to toggle through windows,so how to disable this key of windows.
Please get me a solution
Thanks in advance
|
|
|
|
|
I am trying to use the ms internet transfer control to download binary files from the internet using the execute statement. I am only using a very basic piece of code as a test, however by using the debugging tools, and stepping through the code one line at a time, the Inet controls statechanged event is not called. The execute statement is
Inet1.Execute URLname, "GET"
I have tried setting the other properties of the inet control to no avail. In addition I thought about adding a piece of code either before or after the code to make sure the inet control is not currently executing, something like
If Inet1.StillExecuting = True then
DoEvents
End If
If anyone has any thoughts on what is going on I would be very appreciative,
Cheers,
Mark
|
|
|
|
|
hello everybody,
can anybody tell me is it possible to implement a peer to peer network between two pocket pc via Wi-Fi?
my meaning is can both of the pocket pc communicate with each other using Wi-Fi? such as IrDA or bluetooth, both pocket pc can send message to and receive message from another pocket pc..
if can, how to implementing it? is it need a server or access point?
|
|
|
|
|
I want (desperately) to do something very simple (i think or at least thought.)
I want to have a web page that simply has a link that you click, this runs a command line app and then returns the output to HTML.
{ie click here the and the system shows you the contents of C drive. Or shows you custom enviornmental settings.)
I just want command line interaction I do not want WMI workarounds (I figured how to do that on my own.)
I want to use VBscript... i know how I would do this if i could use Perl... the coding is not my actual issue, it is the nuances of VBscript and Command line interaction.. alas Perl does script to command line and back so much more smoothly than VBscript seems to but I am a newb with vb altogether...
Thanks very much for you time!
|
|
|
|
|
|
I have been trying to get this api to work in VB.NET, but have no clue how. I have the equivilent code in VB6, but can't get it converted to .NET. If anyone has an example, or know how to do this in VB.NET any help would be appreciated.
Enes M
|
|
|
|
|
Enes,
I am trying to do the exact same thing as yourself. I feel that I am close to a solution, it's just not 100% correct. I am trying to get NetSessionEnum working with level 2 or 502.
I get the data and correctly populate the structure with the first session's details, but when I go to populate subsequent sessions the data is being loaded into the wrong fields. My structure appears correct according to Microsoft's web-site.
If I get it working correctly I'll post the result, hopefully you can do the same if you beat me to the solution.
Regards,
Paul T.
|
|
|
|
|
Give this a try:
'Structures
'Requirements as of March 2005.
'Client : Windows XP, Windows 2000 Professional, or Windows NT Workstation.
'Server : Windows Server 2003, Windows 2000 Server, or Windows NT Server.
Private Structure SHARE_SESSION_VALUES_502
Dim strComputerName As String 'The name of the computer that established the session.
Dim strUserName As String 'The name of the user who established the session.
Dim strNum_Opens As String 'The number of files, devices, and pipes opened during the session.
Dim strTime As String 'The number of seconds the session has been active.
Dim strIdle_Time As String 'The number of seconds the session has been idle.
Dim strUser_Flags As String 'Describes how the user established the session.
Dim strClientType As String 'The type of client that established the session.
Dim strTransport As String 'The name of the transport that the client is using to communicate with the server.
End Structure
Private Structure SHARE_SESSION_INFO_502
Dim strComputerName As IntPtr
Dim strUserName As IntPtr
Dim strNum_Opens As IntPtr
Dim strTime As IntPtr
Dim strIdle_Time As IntPtr
Dim strUser_Flags As IntPtr
Dim strClientType As IntPtr
Dim strTransport As IntPtr
End Structure
'Constants
Private Const NERR_SUCCESS As Long = 0
Private Const ERROR_MORE_DATA As Long = 234
'Variables
Private m_colSessionDetails As New Collection
Private m_strComputer As String
Private m_lngSessionLevel As Long
Public Sub Initialise(ByVal p_strComputerName As String)
Dim lngLoop As Long
m_strComputer = p_strComputerName
' Connect to the remote computer
test(p_strComputerName)
End Sub
Private Sub test(ByVal p_strComputer As String)
Dim p_lngRtn As Long
Dim p_intptrBuffer As IntPtr
Dim p_lngPreMaxLen As Long
Dim p_lngEntriesRead As Long
Dim p_lngTotalEntries As Long
Dim p_lngResumeHwnd As Long
Dim p_intPtrNextBuffer As IntPtr
Dim p_strClientName As String
Dim p_strUserName As String
Dim Share_Struct_Size As Integer
Dim SI502_Pointers As SHARE_SESSION_INFO_502
Dim SI502_Values As SHARE_SESSION_VALUES_502
Const cnstProcName As String = "Test"
Try
Do While m_colSessionDetails.Count > 0
m_colSessionDetails.Remove(1)
Loop
p_strComputer = "\\" & p_strComputer
p_strClientName = ""
p_strUserName = ""
p_lngPreMaxLen = 0
p_lngResumeHwnd = 0
'Try the Win XP, 2000 Server and 2003 Server option first, if that fails - then try
'the option for Win Me, 98, and 95.
m_lngSessionLevel = 502
p_lngRtn = NetSessionEnum(p_strComputer, _
p_strClientName, _
p_strUserName, _
m_lngSessionLevel, _
p_intptrBuffer, _
p_lngPreMaxLen, _
p_lngEntriesRead, _
p_lngTotalEntries, _
p_lngResumeHwnd)
If p_lngRtn = NERR_SUCCESS Then
If p_lngRtn <> ERROR_MORE_DATA Then
Share_Struct_Size = Marshal.SizeOf(SI502_Values)
For i As Integer = 0 To p_lngEntriesRead - 1
p_intPtrNextBuffer = New IntPtr(p_intptrBuffer.ToInt32 + (Share_Struct_Size * i))
SI502_Pointers = Marshal.PtrToStructure(p_intPtrNextBuffer, GetType(SHARE_SESSION_INFO_502))
SI502_Values = New SHARE_SESSION_VALUES_502
SI502_Values.strComputerName = Marshal.PtrToStringUni(SI502_Pointers.strComputerName)
SI502_Values.strUserName = Marshal.PtrToStringUni(SI502_Pointers.strUserName)
SI502_Values.strNum_Opens = SI502_Pointers.strNum_Opens.ToInt32
SI502_Values.strTime = SI502_Pointers.strTime.ToInt32
SI502_Values.strIdle_Time = SI502_Pointers.strIdle_Time.ToInt32
SI502_Values.strUser_Flags = SI502_Pointers.strUser_Flags.ToInt32
SI502_Values.strClientType = Marshal.PtrToStringUni(SI502_Pointers.strClientType)
SI502_Values.strTransport = Marshal.PtrToStringUni(SI502_Pointers.strTransport)
m_colSessionDetails.Add(SI502_Values)
Next
End If
Else
'TODO - Enumerate Sessions using level 50.
m_lngSessionLevel = 50
End If
'Clean up the buffer
Call NetAPIBufferFree(p_intptrBuffer)
Call NetAPIBufferFree(p_intPtrNextBuffer)
Exit Sub
Catch e As Exception
Err.Raise(p_lngRtn, _
cnstProcName, _
e.Message)
End Try
End Sub
Regards,
Paul T.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
