|
For Each logo In htLogoGroupCount
Dim Count(logo.Value.Count - 1) As Integer
For i As Integer = 0 To logo.Value.Count - 1
Dim sOptLogo() As String = logo.Value(i).Split(":")
Count(i) = sOptLogo(1)
Next
Dim MaxCount As Integer = Array.IndexOf(Count, Count.Max())
Dim sLogoValue As String = logo.Value(MaxCount).ToString
Dim sOptLogoName() As String = sLogoValue.Split(":")
alstOptimize.Add(sOptLogoName(0))
Next
I will assign value to count by adding ":" symbol in htLogoGroupCount in value from htLogoCount and then try above code but i will do it by Linq.
|
|
|
|
|
I don't want to copy entire row how do I do this ..
This is a copy of the macro I want to amend
Private Sub Workbook_Open()
Dim i, Lastrow
Lastrow = Sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Personel").Range("A2:N10000").ClearContents
For i = 2 To Lastrow
If Sheets("Master").Cells(i, "B").Value = "Personel Abby" Then
Sheets("Master").Cells(i, "B").EntireRow.Copy Destination:=Sheets("Personel").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i
|
|
|
|
|
Delete "EntireRow" or use it with the right Selector ...
|
|
|
|
|
I am designing a accounting system application prototype,and need some help on how to build Chart of Accounts using VB 2010
|
|
|
|
|
You should probably try defining what you mean by a chart of accounts and what you expect to be able to do with this wonderful creation.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Chart of Accounts is a list of hierarchical accounting system which is designed as per the generally accepted accounting principles
|
|
|
|
|
You need a database (or other storage system) to persist you data.
Account Table
Link table to form your hierarchical structure
You then need a user interface so the user can perform CRUD operations on the tables. Simples!!!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Uhhhh no. We know what an account of charts is supposed to BE. The questions you need to answer to yourself is describing in detail exactly what data you need, how you're going to get it, and how your going to present that data to the user. Without that description you have no target to code for.
You haven't done that.
|
|
|
|
|
Hello !
I have working before on a vb.net application with MS Access Database. On my application I had a Function "Compact_And_repair" that is called every time the application is closed. This function will compact and repair the Ms Access database file.( After this function is called , the database size is decreased)
Now I'm creating an application that use a Sql server database. I'm asking if I can do similar action to a SQl server database .
If yes , which are the instruction to do this from inside my vb.net application ?
Thank you !
|
|
|
|
|
Since you post multiple questions, you are well aware of the general rules of asking questions and what many of the repsonses will be.
So, this should have been done already, but it is hasn't.
1. Search for a solution yourself
2. If you find a solution and have a SPECIFIC issue implementing it, ask for help.
3. Do not ask someone to give you the entire solution.
|
|
|
|
|
There is no such concept in SQL Server. It applies ONLY to Access databases.
|
|
|
|
|
"Don't" for server-databases; size is less of an issue than speed. It is also of no concern to the application using the database, it is a concern for the database-admin, the owner of the server.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have noticed , that my database size continue to increase , and even when I delete records the size is not decreased.
Is this a problem ? And if yes , what I can do from inside of my application ?
|
|
|
|
|
satc wrote: that my database size continue to increase , and even when I delete records the size is not decreased.
The size of the file is not affected, since it is not removing the record; it is merely marking it as free space. That is by design 
satc wrote: Is this a problem ?
Most database-servers will not release the space.
satc wrote: And if yes , what I can do from inside of my application ?
You could shrink the file if the space is that important, but that may piss of the DBA if it is done at an inconvenient time.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
I am designing a Form using VB 2010, I am unable to completely design the form as they is not space to place more controls on the form.
Using the form properties, I can set the Maximum Width of Form to 1044, and Maximum Height is 788 only
I have gone through some solutions, which seems to be not clear to my question.
Kindly lemme know, if we can increase the height of the form to 1000 during design time
thanks & regards
Prem
|
|
|
|
|
..and how would that work during runtime? If the form is full, it might be better to introduce tabpages.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Can you please send the procedure step by step using tab pages
|
|
|
|
|
Take a TabControl and put it on your Form.
Size it like you need.
Define the TabPages as you need (and perhaps give them a Name).
Put your Controls on the TabPages like on your Form before.
You could switch between the TabPages by clicking them ...
Try it ...
|
|
|
|
|
Thanks Ralf, for the time being i will use tabcontrol which allows me to fit all my controls in a form. But if i can increase the height of my form that will be great.
I donno, why this property has only 788 as the height, when we have a scrolling option.
regards,
Prem
|
|
|
|
|
Please read your Thread completly.
Here are the postings of Eddy and Dave which answers the question and delivers a (work-around) solution
|
|
|
|
|
Any WinForm tutorial using the TabControl would do. Alternatively, you could scroll the contents as explained here[^].
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
What Screen-Size do you have (in your System) ?
|
|
|
|
|
|
OK ... that is what I supposed.
Your Screen-Resolution defines your maximum Form-Size.
modified 23-Jun-15 13:46pm.
|
|
|
|
|
The maximum visible size
We do have scrollbars, but I still prefer tabs.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
