|
You have badly designed the database, and there is no easy way to aggregate this data.
Maybe you could explain what you are trying to achieve, and somebody could make some suggestions on how to go about it better.
Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
|
|
|
|
|
Hi, how can i get the motherboard's unique ID using VB? I have seen recently an article on Code Project describing how to do this using web and .net but i need to do the same in vb.
Rod
|
|
|
|
|
Hello everybody. Below codes didn't run but they could run on visual studio 6.0.
I am using .net 2003. Is there any idea? thanks.
Dim xapp As Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
xapp.Visible = True
xapp = new Excel.Application
wb = xapp.Workbooks.Open("d:\sample.xls")
ws = wb.ActiveSheet
...
|
|
|
|
|
try this :
Dim var_AppClass As New ApplicationClass
Dim var_wookbook As WorkbookClass
Dim path As String = "c:\Book1.xls"
var_wookbook = var_AppClass.Workbooks.Open(path, 1, True, 5, "", "", True, Excel.XlPlatform.xlWindows, "\t", True, False, 0, True, 1, 0)
Dim var_sheets = var_wookbook.Sheets
...
Tamimi - Code
|
|
|
|
|
I want to develop an application in VB.Net which monitors the access to PC. So when PC boots my Application must pop disabling all options like Task bar, right click, all special keyboard function (Like Ctrl+Alt+Del). Can anybody suggest how to achieve this in VB.Net
Regards,
Krishnaraj
|
|
|
|
|
Hi all,
i got this error
An unhandled exception of type 'System.NullReferenceException' occurred in esB_SSR.exe
Additional information: Object reference not set to an instance of an object.
anyone can help me out?
tnx...
-::maximus::-
|
|
|
|
|
You did not send any useful information about the code that casued the problem or what you are trying to do..So don't expect a lot.
|
|
|
|
|
|
Hi,
I am having some Buttons and Radio Buttons on my Form. I am using UP and DOWN arrow keys as Hot keys for some Buttons and I want to assign SHIFT + UP and SHIFT + DOWN keys as Hot keys for some other buttons. How can I do this? The Code for UP and DOWN arrow keys is given below:
Protected Overrides Function ProcessCmdKey(ByRef msg As System.Windows.Forms.Message, ByVal keyData As System.Windows.Forms.Keys) As Boolean
Select Case keyData
Case Keys.Up, Keys.Down, Keys.Left, Keys.Right ' (Left/Right also navigate controls)
If keyData = Keys.Up Then
Button1.PerformClick()
ElseIf keyData = Keys.Down Then
Button2.PerformClick()
End If
Return True
Case Else
Return False
End Select
End Function
.Net Programmer, Software Engineer
|
|
|
|
|
hi
how r u all
i need help i must to do project and in tha form there is combobox and month calendar
and in said the combobx aname if i choice name it will show the information for that parson in data grid
and the month calendar whene i prass in the date it will be show tha information in data grid for this date
can u tell me how can i write the code for that in visual basic
thanx alot
|
|
|
|
|
Hi,
assumming you have a DataTable bound to your grid you will have to set the RowFilter of its DefaultView to a string representing your cirteria. A description on how the filter must look like can be found here[^]. You could also have a look at one of my articles[^] dealing with this or probably even just use the component.
|
|
|
|
|
hanx
i have the database i make but the thinx i need is how can i write
the code in saide the compobox to display tha information for the name that i choice for ex ur name in my database and in the form ther is compobox and i choice ur name and ur information will show in tha datagrid
|
|
|
|
|
I am using Visual Basic 2005 Express Edition and trying to create crystal report using backend access database. When I click Project --> add new item, i cannot find crystal report template to use.
How to add crystal report template to my available list of templates or is there any other way.
Cheers,
Roger
|
|
|
|
|
OK, before you read any further I do not want to rewrite a web server. What I want to do is have my application sat in the system tray and to have a port open to which other clients can connect. When they connect my little app sends it's interface in the form of html files to the client (lets say a web browser on a PDA). The question is: where is there any tutoials on a client/server architecture which transmits web pages?
|
|
|
|
|
|
Anyone know how to programatically create a cursor?
A simple method (Or code to place in a method) like: Function CursorFromBmp(ByVal CursorPicture As Image, ByVal HotSpot As Point) As Cursor would be nice. The cursor should look exactly like the image. The Transparancy Color should be Color.Transparant.
|
|
|
|
|
Whats the difference between Windows Script and VB Script?
|
|
|
|
|
Window Script is the script engine. It can use either of the languages VBScript or JScript.
---
b { font-weight: normal; }
|
|
|
|
|
I just got myself a version of Installshield 11. I'm creating a custom action in the installer using VB Script. How can I execute a file with parameters using VB Script. Do I have to use Wscript.Shell??
|
|
|
|
|
Don't know much about InstallShield, but about vbscript, yes, you need to use the WScript.Shell object like:
<br />
set ws = Wscript.Shell<br />
arg1 = ws.Arguments[0]<br />
arg2 = ws.Arguments[1]<br />
and play with the argument values. I haven't checked the syntax for accuracy, but this should point you in the right direction.
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
if my vb.net form is trying to copy a file to a destination where the file already exists, how would i get it to rename the new file to something different?
eg: if "C:\test.txt" exists then it will rename it to "C:\test01.txt"
and if those two exist then it will rename it to "C:\test02.txt"
so you could get
"C:\test01.txt"
"C:\test02.txt"
"C:\test03.txt"
"C:\test04.txt"
..........
etc etc
|
|
|
|
|
hi
search the destination for the file.
i.e. if you are copying the file "C:\test.txt" user the following :
System.IO.File.Exists("c:\test.txt") , this will return true if the files
exist
Tamimi - Code
|
|
|
|
|
already know that code, sorry but its not what im looking for
im not looking for it to check for it and if its there then it will not copy
im looking for code that if the file is there, it will rename it and send in the same file but rename it
example: when you copy a file in windows and paste it a couple of times
it will make copies like this
Copy of Test
Copy (2) of Test
Copy (3) of Test
etc etc
im trying to make my program do that
|
|
|
|
|
You will have to set up a loop that checks for existence of the file and rename it if necessary, like:
<br />
Dim strExtnOnly as string = ".txt"<br />
Dim strFileNameOnly as string = "test"<br />
Dim blnDone as Boolean = false<br />
Dim strDest as string = "Your destination folder"<br />
dim intCounter as integer= 1<br />
<br />
do while blnDone = false<br />
strFullPath = strDest & "/" strFileNameOnly & strExtnOnly <br />
if File.Exists(strFullPath) then<br />
intCounter+= intCounter<br />
strFileNameOnly = strFileNameOnly & CStr(intCounter.ToString.padleft("0",2)) ' something like that<br />
else<br />
blnDone=True<br />
end if<br />
loop<br />
HTH
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
sir,
I want a function that start the search from the last character in the string for finding the character.
example
this is a string
I want to search for last blank space in the string which occurs before string word.
Thanks and Regards
Amaneet Brar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
