|
how do i filter the report between 2 dates and/or 1 item code as report is already designed!
susmita
|
|
|
|
|
You have to create parameter for report that parameter will be assigned at run time.
Thanks & Regards
Kumar Prabhakar
kumar Prabhakar
|
|
|
|
|
Hi
you can use the record selection formula to specify your filter
Kanniah
|
|
|
|
|
HI,
how can i get the index of the selected item in the combobox in a column of the dataGridView?
thanks,
regards
|
|
|
|
|
check out this code
aspx page
asp:datagrid id="Datag" runat="server" Width="100%" AutoGenerateColumns="False" PageSize="10"
asp:TemplateColumn HeaderText="Dropdown test"
ItemTemplate
asp:DropDownList id="DropdownAction" AutoPostBack="True" OnSelectedIndexChanged="DdAction_SelectedIndexChanged" Runat="server"
Code behind file (.cs)
public void DdAction_SelectedIndexChanged(object sender, System.EventArgs e)
{
DropDownList list = (DropDownList)sender;
if (list.SelectedIndex == 0)
{
//Actions for item 1
}
else if (list.SelectedIndex == 1)
{
//Actions for item 2
}
}
Navi
|
|
|
|
|
i set a picturebox control on my form and i load an image to it from the image property , i also set the Visible property to "True" but when i debug the application , i can't see the image in the run mode, only the border of the picturebox. Please Advise
Ali
|
|
|
|
|
Hi!
check the extension for your image, maybe it's not supported on your machine. You may need plugins to see some pictures. Cheers!
Regards,
Hesbon.
|
|
|
|
|
The extention is "JPG" and "Gif" , and i can open those pictuers easly as i'm using windows XP, but i still can't see the picture on the run mode. is there a code i should to load the image in the picturebox at run time , and if yes where to place this code, in the main code body of the form or behind the picturebox itself. please advise and thank you again
Ali
|
|
|
|
|
hi
try to resize the picturebox
Tamimi - Code
|
|
|
|
|
Hello,
I'm trying this code written in VB Script and its returning 0 records, inspite there are records. When I query the index server directly, I get records, but with this code i get 0 records. Can someone help?
Thanks in anticipation,
Rakesh
Dim ixQuery ' Index Server query object.
Set ixQuery = CreateObject("ixsso.Query")
If (Err.Description <> "") Then
MsgBox err.Description
End If
ixQuery.Columns = "filename,rank"
ixQuery.SortBy = "rank[d]"
ixQuery.Query = "Agreement"
ixQuery.Maxrecords = 1000
ixQuery.Catalog = "query://coiw2ptidbdev/system"
Dim util
Set util = CreateObject("ixsso.Util")
util.AddScopeToQuery ixQuery, "/", "deep"
If (Err.Description <> "") Then
MsgBox err.Description
End If
' Run the query (i.e. create the recordset).
Dim queryRS
'Set queryRS = CreateObject("ADODB.Recordset")
Set queryRS = ixQuery.CreateRecordSet("nonsequential")
' Check the query result. If it timed out or return no records, then show
' an appropriate message. Otherwise, show the hits.
If (Err.Description <> "") Then
MsgBox err.Description
Else
If queryRS Is Nothing Then
MsgBox "No records found"
ElseIf (ixQuery.QueryTimedOut) Then
MsgBox "Query Timedout"
ElseIf ( queryRS.EOF or queryRS.BOF or queryRS.RecordCount <= 0 ) Then
msgbox cstr(queryRS.RecordCount)
'MsgBox "No Matches found"
Else
queryRS.PageSize = rowCount
MsgBox cstr(queryRS.PageSize)
If (Err.Number <> 0) Then
MsgBox "Record Display Error: " & Err.Description
End If
End If
End If
-- modified at 2:35 Tuesday 29th August, 2006
rakeshsharma
|
|
|
|
|
Hi,
I cant disable the right window logo key in my application?Can anyone help to find out the solution.
Here is my code
Private Sub Textbox1_KeyDown(Byval Sender as Object,Byval e as System.windows.Forms.KeyEventArgs) Handles Textbox1.KeyDown<br />
if e.keyCode=Keys.Rwin Then<br />
e.Handled=true<br />
End If<br />
End Sub<br />
Pls help me....
|
|
|
|
|
Hi,
i cant disable the right window logo keys when i run my application.
i use the following code to disable the window logo keys, but it just can disable left window logo key.
private sub Textbox1_KeyDown(Byval sender as object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Textbox1.KeyDown
if e.keycode=keys.LWin and e.keycode=Keys.RWin then
e.handled=true
end if
end sub
Pls Help me...
|
|
|
|
|
How about changing your If statement to 'OR':
If e.KeyCode=Keys.LWin Or e.KeyCode=Keys.RWin Then
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
still cannot disable the right window logo key.
If e.KeyCode=Keys.RWin Then
code here also just allow me to disable the left window logo key.
|
|
|
|
|
You might want to set a breakpoint on that If statement and see if its even being called when you hit that key. If it is, then you can peek at the e.KeyCode to see what value it holds. Then you can change the code to look for that value. Be warned! Not every keyboard has 2 Windows logo keys.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
There is an application in VB6 and n no. of user are using that application (.exe). In this applicatin (.exe) every user are interacting with a recordset of SQL Server 2000. If any of user update or delete any of row, a message should be sent to every users telling them that a specific id's row is updated or deleted by <username> in a message box.
I think this can be done by using recordset's dynamic property i.e. "Row Update Notification Property" and "Row Delete Notification Property". But i do'nt know exact coding for it.
Please guide me.
Thanks and Regards
Girish Kumar Sharma
|
|
|
|
|
Girish481 wrote: Row Update Notification Property
This won't tell you the backend database was modified, only that the row in that copy of the recordset was changed.
You're looking for SQL Server Notification Services[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for your reply. Actually, i want that if any user update a specific column or delete the row in recordset; a message should be sent to every user at the same time.
Can you please provide me the way by which i can install SQL Server Notification Services. The link you provided me tell about services; but how to install?
Girish Kumar Sharma
|
|
|
|
|
Items 2 and 3 in this[^] list will let you download NS2.0.
And if you click on this previous link I gave you, there is a section dedicated to Installing it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks. I downloaded the exe file for NS and will try to install on my system. I will let you know if, i found any error. I hope you will favour me in future also.
So many Thanks.
Girish Kumar Sharma
|
|
|
|
|
I downloaded the required exe file and run on my machine; but after installing it:- (I am using SQL Server 2000)
1. How can i start the Notification Service (NS) in Services.
2. How can i use Notification Service for my VB6 Application.
Thanks
Girish Kumar Sharma
|
|
|
|
|
i really can't walk you through the entire process. It would take more than an article to explain it all. Just follow the documentation in the first link I posted and you'll find everything you need. I don't know of any VB6 examples that are still on the Web. It looks like everything has been converted over to VB.NET.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have some problem doing my project i hope that all the kind hearted people around the world will somehow advice me how to go with it thank you. As for now i have to develop a client program that can download and upload to the server with Authentication. Using VB Graphic User Interface but programmed by C.
-- modified at 23:49 Monday 28th August, 2006
|
|
|
|
|
What you want to do is very labor intensive. It'll take so much code to do this that it's impractical. You'd be much better off writting the C code as a COM .DLL and calling it from the VB form.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am trying to get this ActiveX control to work within Word 97:
http://www.codeproject.com/opengl/ntgraph3d_atl.asp[^]
I havr registered the control and made checked the box in the reference table, the control appears on the document as it should, but I just can't get it to draft any of the examples:
Private Sub CommandButton1_Click()
NTGraph3D1.ClearGraph
NTGraph3D1.AddElement
For i = 0 To 40
x = ((i - 20#) / 20#) * 3.15
For j = 0 To 40
NTGraph3D1.AddElement
z = ((j - 20#) / 20#) * 3.15
y = Sin(x) * Cos(z) + 2#
NTGraph3D1.ElementType(j) = 0
NTGraph3D1.ElementLineColor(i) = RGB(255, 0, 0)
NTGraph3D1.PlotXYZ x, y, z, j
Next
Next
NTGraph3D1.AutoRange
End Sub
Am I supposed to make any declarations or something?
Thanks
|
|
|
|