I'm developing windows application with vb.net in my company.. when i'm trying to develop my skill. i get stuck at auto completion word in gridex janus.. i don't know how to make it.. i have make a collection string to put in value list grid column. but i cannot find code for auto completion word.
View 1 Repliesi use a Janus GridEX1 and that has two Columns
see my codes
Private Sub GridEX1_EditingCell(sender As Object, e As Janus.Windows.GridEX.EditingCellEventArgs) Handles GridEX1.EditingCell
If GridEX1.CurrentColumn.Index = 0 Then
[Code].....
As I'm typing out Xaml in VB.Net Express 2010, it helpfully finishes certain things for me. Most of the autocomplete is fine, but some of it annoys me and it leads me to wonder if I'm missing something or doing it wrong.
If I type:
<GroupBox Header=
It automatically puts a quotation mark before and after my cursor. I've gotten used to the quotation mark before the cursor - I immediately start typing in whatever property I wanted. But now there is a quotation mark after my cursor! I have to reach over to the other side of my keyboard and press the right arrow key to move past it. I find this insanely aggravating, because it breaks my "flow" while I'm typing. Are you supposed to be able to press a close-at-hand key (like tab, but that doesn't work) to move to the other side of the quotation mark or do they really intend for you to have to constantly use the right arrow key?
I want a textbox to have autocomplete. I want the completion to be based off of text that has been previously entered into the textbox. My method of saving seems to work but when i close the program and re run it the autocomplete suggestions arent there anymore.
[Code]...
I am trying to write this loop to find the word start and then insert a word in a column until it sees stop and then go through all the data and do that.
[Code]...
I have a combobox (cmbCharge1) that gets populated by a text file. Inside the combobox, the data inside is laid out like this: 41-1A-1303: EXPIRED REGISTRATION Now, autocomplete works fine, if I start typing in the statute (like the 41 part). But what I need is for it to autocomplete based of whats after the: So if I type in EX, then everything starting with EX pops up.
View 5 RepliesI am creating a word document which has a table in the header. I want to add a Page x of Y autotext into one of the cells but no matter what I try I cannot seem to work out the syntax.
I tried (among other things)
tblTable.Cell(3, 8).Range.Select()
oWord.NormalTemplate.AutoTextEntries("Page X of Y").Insert(Where:=oWord.Selection.Range)
When writing a manual in word I can create table of content. How can I get list of effective pages LEP with possible a loop checking for pagenumber & date then adding data to a table on a page in Word with VBA code/macro?
View 2 RepliesI have constructed my database and I have used auto increment the ID's of each column. When I was testing and inserting data into my tables the auto increment of these column's of course incremented.
Now I am looking to start each individual Id column at 1 and not at the number where it is now.
I know it has something to do with using max value and +1. I have deleted the entire table and have tried everything to re-insert my data and start the ID's at 1, but I have had no luck.
Also to,
I know within Vb I can use a datagrid view and add there and it starts at the max value of the column +1, but when I have another form to add data within columns the column number is not in numerical order, How do include code within that seperate form to auto increment ID column numerically?
I have a datagrid and I have imported it to my project under vb.net language, and the database is MS access any way in this datagrid one table call "Employees" ID - Name - Nationality - Job title and what I want is when I write the ID number of the Employee, all the other details automatically comes upon to his ID number.
View 1 RepliesI have 4 Columns in a ListView. The first one is called Serial No. Every time I populate it, the serial number increases automatically. After populating the ListView couple of times, I select any row(s) and remove it. When I remove one or more row(s) from the listview, serial numbers stays same. I want the serial numbers to be fixed automatically when I remove any number of row(s). How can I do that ??? Here is my code -
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Str(4) As String
Dim newItm As ListViewItem[code]....
I had the following code :
Dim row As Integer = 0 For row = 0 To pdgvDataGridView.RowCount - 1 pdgvDataGridView.Rows(row).Cells(0).Value = row + 1Next
it's to add auto number into first column of each row. The codes running well, but after the codes completed, the first column of each row remain empty.
I am having tremendous difficulty getting word automation to insert a page break in my document. The app is generating letters in word and saving them....the code below shows where I am writing the first page (str.tostring) then all of the code after that are the various ways that I have tried to insert a page break so that it will go to the second page and I can unload information into the second page of the document. [code]
View 1 Repliesi want to autofill a formula down a column of cells in excel. to manually do this, i would double-click the little black square at the bottom right of the cell, but i cannot figure out a way to do this using a macro.
View 1 RepliesI have a datagrid control in my winform application. It has nearly 30 columns. First 2 column are frozen and others can be views using scrollbars.
Its working fine.
I would like to add some functionality on it by allowing user to select a column from column list above and making the datagrid scroll to that column automatically.
So i would like to ask how could i make my datagrid to scroll to specified column automatically.
VB2005 - DataGridViewMaybe not a quirk, maybe more of my misunderstanding of how resizing works. But here is what i want to do. I want to display a dataset to the user in a ataGridView. By default the columns should be autosized to all cells including the headerThat's the default view but the user should be able
View 8 RepliesI'm using VB.net to write a MYSQL application and one feature I need to add is the ability to add a column for each week that my employees worked. For example I want the first column to be called "W1" and the next one to be "W2" and so on, right up to "W52". How would I add a column to my table and have it's name add 1 to its current value? If there wasn't any letters in the name it would be easy but I need it to have the "W" in the title as well to avoid confusion. to add the column I have this:
Alter Table Manager ADD W1 MediumINT;
I just need the part that adds an INTEGER to a VARCHAR datatype if possible... Maybe there should be some sort of data type conversion involved? Just to explain further, the black bar at the very top are the date stamps for each week, I would like to have this included in the datagridview if possible but it is not required. Under each week column the employees will be entering the percents they worked (example: 20%, or 0.20 is one day of work) I know this is an odd way of doing things but its mandatory... and i was wondering if it were possible to automate the creation of these columns rather than me having to manually enter them.
I'd like to autosize listview columns to fit the column names. From what I saw this should do it but it doesn't work for me. Can someone see what I'm doing wrong or know of a way to do it? The listview is designed to dynamically build the coulmns based on the number of coumns in a recordset.
[Code]...
Is there a way to auto-update a listview based on reading a column?
Requirements:
1) The code must make a call to a user-created "Private Sub" to recalculate
2) Update must be automatic. .SelectedItem or clicking a row will not work
3) The formula function cannot be included in Form_Load
I've got everything working if the user selects a row, then clicks an "update" button using .SelectedItem. But with my current program containing 200 rows, it's not feasible. Simply put, how would I go about updating a listview column (0 in this case) based off a call to a formula, then updating the row?
I want to bind a column of my database to my textbox's Auto Complete source.now I want to know How to do that?
View 11 Replies[Code]....
I need to see the next line in the datgrid.
I've got a DataGridView that has a DataTable as it's Datasource. Whenever I sort a column and then edit a cell, after editing the column, the column autosorts so the recently edited cell is no longer in the viewable area. Is there any way to prevent this auto sort from happening and only sort when I click on the columns?
View 2 Repliesi have a form which is having 1 list view and a text box. list view having total 100 rows data list view is having a 5 column column 3 is having two words "yes" and "no" i just want to count the number of occurrence of the word "yes" in column 3 the total row can be count with this code: COUNT TOTAL ADMISSION Dim rowcount As Integer = 0
[Code].....
visual basic 2008 HOW is the word(doc) processing file ,the row column?
View 2 RepliesHow can i forcefully insert a coloumn break in word document through VB.Net?
View 1 Repliesjust want to know if linq to sql auto updated the id column of a class (table row object) after SubmitChanges is called inserting a new row to that table, that would be fantastic, would anyone be able to confirm this?
View 2 RepliesI am trying to set autocomplete for a textbox using data from a column in a table an Access database. Some of those records in the table have no values. I have set the AutoComplete Mode property to SuggestAppend and the AutoCompleteSource property to CustomSource. When I run the application nothing happens when I type into the textbox. The dataset is called DatabaseDataSet and the table name in the database is called Simple and the specific field/colum is called SIM_TAG1
'Create customsource for tag textboxes to suggest tag terms based on what is in database
Dim oTag As New AutoCompleteStringCollection()
For Each term As DatabaseDataSet.SIMPLERow In Me.DatabaseDataSet.SIMPLE
[code]....
I have this database with a table which has the the following but I have no way to decypher it
DATA, TYPE, FILE TYPE, SIZE, DOC TYPE
0x15234324 , Word.Document.8 ,DOC, 19968, WORD.DOCUMENT.8
The field seems to contain a word document stored in a SQL Server IMAGE column
Has anyone come across this before or a way to extract this data in a readable format?
So far I have tried using PHP to extract the file and write it to a word document but not had much luck.
UPDATE: I now have Visual Studio Express and would like a way to extract this data and save to a word document
UPDATE2: This is what I have in VB sofar
Imports System.Data.SqlClient
Imports System.IO
Public Class Form1
[Code]....
I have a table located in a Microsoft Word document. changes has been enabled in this document. I see that I can get the collection of revisions using "ActiveDocument.Range.Revisions" . I also see that I can tell if the revision exists inside a table using "Range.Information(wdWithInTable) " .My question is this:I really need to find out the "ID#'s" that contain a revision on the "SomeText#" column.So for example, if "Some Text 1" was revised, I need to output "ID-1".I am puzzled as to how to implement this logic. Does anyone know of a way to go about this?
View 2 RepliesI do not understand vb comments. I read that it is possible to give a hint in the code completion box when someone (or myself?) is using my code. But I do not find something in visual studio.
View 4 Replies