SGRID2 Cell Data across multiple rows... -
Hi,
I've been using VBaccelerator's Sgrid / Sgrid2 for years.
I am developing an scheduling application that shows different views (Daily/Weekly/Monthly) similiar to the way Outlook Calender presents appointments. However, I can't figure out how to show an appointment that stretches across different rows (i.e multiple hours...).
In Outlook, each appointment stretches over multiple rows to show the duration of the event.
How can I do this with Sgrid2... or event with an API on the sgrid. ????
SGRID2 Cell Data across multiple rows... -
Hi,
I've been using VBaccelerator's Sgrid / Sgrid2 for years.
I am developing an scheduling application that shows different views (Daily/Weekly/Monthly) similiar to the way Outlook Calender presents appointments. However, I can't figure out how to show an appointment that stretch
Filling SGrid2 from recordset -
I have SGrid2 that needs to be populated using ADO recordset. How do I do that?
using sgrid2 on vb.net -
hi,
did anyone know using sgrid2 on vb.net?
DataGridView Multiple rows per one record. -
Hi,
I am working with a DataGridView that I would like to display two rows of data for each record in the DataTable.
I have two uses for this, one, the user wants the information in the first row, and the description in the second. Description is just another column on the same re
DataGridView rows all the same -
Do all the rows in a DGV have to have the same columns? Let me explain ... I am using a DGV with multiple columns to display some data. I want to insert "separator" rows in the DGV to separate my data by category. I want this separator row to basically be one cell (the ful
Textbox data in tabular format -
I have an application in which Im importing data from a table (numbers in multiple rows and multiple columns). The data is subsquently exported out to excel in the same table format.
My problem is that when i import the data, the data shows in the text box in rows and colums (which
Inserting multiple rows of data*RESOLVED* -
I am trying to insert multiple rows of data at the same time by having the admin enter in all the information. its all going to the same table. i was wondering if there is a way to do it...? if you need to see how i am doing it now, ill show you if you ask.
save multiple rows of data in a normal form -
helohh...
i've create a from(normal form) that have multiple rows of textbox (10 rows to be precise)
the problem is... how can i save the data that i've put in those rows???
i've tried using the datStaff.Recordset.Addnew command (i've even tried using the if and elseif. but
Insert as many rows as it says in cell c18 -
I have a macro currently that inserts rows based on values. I want to be able to have it look at cell c18 then insert that many rows starting at the first blank that it finds.
so, if it finds the first blank at h27 on the "DATA" spreadsheet, and c18 says 4, I want it to i
How to add multiple record from datagrid -
i am using ado and datagrid i am trying to add record through code from datagrid. problem is i don't know how to add multiple rows of data from datagrid to recordset. I mean i need to pull last day data of 200 wells its 200 rows then we make changes in this 200 rows of data then i want
Finding data & placing in different cell w/Excel & VBA -
hey all, I have an excel spreadsheet that i am looking in for some product data. the name of the product is in the first column (A). I am looking to the right 1 to 3 cells for some data that relates to the product name. This is what i have so far:
Code:
Private Sub CommandB
compare cell by cell -
hi guys,
i have a datagridview that displays data from database. now what i want to do is take 2 columns and compare the value against each other. so lets say i have 7 columns
1 2 3 4 5 6 7
now all odd columns are blue and all even are yellow. i would
Select cell in bottom right corner of data -
Can someone help me select the cell marked in red on the attached image. I want to add the title in the last column then input a formula in that column to all of the rows, but the number of rows will vary. i was thinking of selecting that cell then filup to the title of the column. Any
query about VBA-deleting rows in excel sheet -
dear friend
i have a value say 25 in A1 cell and 20 in B1 cell.
i am making a macro in VB that in A10 cell it gives A1 X B1 ie 25 x 20 =500.
it works fine and whenever i changes values in A1 or B1 and run the macro , the results get changed automatically.
now the real problem i
Display data in DataGridView using CODE -
Hi Friends,
I am working on VB 2005 express edition.
I want to create Employee Schedular program.
Displaying data in DataGridView without binding cell seems best way to me for my app.
I am having little trouble displaying. Here is my code.
======================================
Multiple row deletion in MSflexgrid *RESOLVED* -
One final question regarding MSFlexgrid.
Now I have changed the selection property of my msflexgrid to selectionByRow. So whenever I click on a particular cell, it selects the whole row. & I can delete that particular row just by calling
fg1.removeitem(fg1.rowsel)
Now If
Automatic Deletion of rows in a Word Table -
I'm producing a number of Reward Statements in Word. The data is held in Excel and the Template in Word with each row having 4 cells. The value I'm interested is in the 3rd cell.
I'm mail merging the 2 together but for specific rows where the data value is zero I need to delete the
Cross-referencing data in multiple Excel worksheets -
I am very new to this, so please bear with me. I have two worksheets with an overlap of data between them. I want the second worksheet to update every time the first worksheet is changed, as well as have the updates appear in red bold. The problem is, the sheets aren't set up the same
HELP determine if a certain cell is merged -
I have an application that reads data from tables in excel. The tables have entries which usually take up one line, then the next line is blank and merged across the table, so in order to get to the next entry I advance 2 rows.
The problem arises when entries take up two rows. In th
Changing color in flexgrid for multiple row/column selections -
I have searched three forums for some code to help me change the celbackcolor of a flexgrid. What I want to do is when the user selects one or multiple rows/columns and clicks a cmdButton color the selected cell/cells. I can get it to color one cell but I can't get it to color multiple
Looking for a simple solution - Find instance of word in A1, if true clear B1 -
I have multiple columns of data in a sheet containing about 15,000 rows. All I would like to be do is look for each instance of the word 'upgrade' in column1 and if this word is found within the string contained in cell A1 then clear the contents of cell B1. This should continue on til
Setting focus in cell in datagridview -
First, let me say that I searched the forums for an answer for my question, and couldn't find one.
I have a datagridview that has 20 columns. Now, only certain cells are required to have data entered in them. When I loop thru the cells for a particular row, and come upon a cell
Pivot Table Drilldown -
Hi,
In Excel 2007, if you double-click a data cell in a pivot table, it "drillsdown" on that data cell. In other words, a new worksheet pops up that lists all the datarows which were used to create that data cell in the pivot table (aka, what was summarized).
My questi
need to search datagrid cells ineternally -
now we have this
we have a datagrid with multiple rows and columns ( we don't know no. of columns nor no. of rows)
we need to invoke a string search until we find it inside any cell
how can i loop through each and every cell in the datagrid.
if i can loop through the cells
list view multiple data -
i am making a form that saves the data to a access database it has a text box for product name then a list box that contains 4 columns and can have multiple rows now i want to save all of those rows with that particular product name and also retain them when required
please help its
[2008] Simple question : hiding the last visible row in a datagridview -
This must be easy but I've drawn a blank so far.
I have a datagridview which I've populated manually (ie not data bound), and I've implemented some filtering functionality that hides rows meeting certain criteria.
The problem I have is that if I hide the last visible row I get an
MSflexGrid, selecting rows data -
I have a populated msflexgrid that pulls data from a db,
what I want is when I doubleclick on a row it pulls rows data.
right now I have it so I can double-click on a cell and pull that data.
code is
Private Sub MSFlexGrid1_DblClick()
tmpRowData = MSFlexGrid1.Text
End Sub
Separate excel cell data into rows -
I have data of multiple line in an excel cell, Separated by "Enter" (ASCII 13).
By using VBA I want to trasfer each line in to separate excel row.
e.g. Cell B2 contains data --
VS6_AIO > 0 OR VS6_DIOE > 0
VS6_QTY_B = VS6_AIO*2 IF VS6_AIO > 0 AND VS6_REDY = '2
Advanced datagrid -
Hi, I have this expense-tracking application called "Quicken" and I noticed it uses a sort of "dynamic" datagrid. "Dynamic" in a way that when the user clicks on a cell, that cell becomes a combobox where cell values can be chosen.
Is there a similar c
Does anyone know about datagrids,etc. -
I hope someone can help me with this problem. I have a datagrid, and I want the user to be able to be able to make multiple selections by using the CTRL key and clicking on the multiple rows that they want to change. Then, a specific field needs to be updated within each of these rows
For Array Gurus Only-HELP! Going Crazy! -
This is what I need to do. I have a table with 6 columns and 5 rows in a form. Each cell has a text box to enter data. Each cell in a column have the same name. For each row of data, I want to save as a recordset and save it in my database table. Each cell in a row would be a diff
How to implement these functions in DataGridView -
Below are questions I have , in implementation in DataGridView.
For each question, I need to find two alternative answers, one is provided by VB.NET by default, if exist, and the other is to implement on our own.
1. I need to copy and paste some rows in a DataGridView to another
Data Grid not updating (Basics) -
I have a data grid with 7 rows, 2 columns (Date & time)
Simple question, as I change and tab off a cell, the datagrid updates correctly. But, If I change a datagrid cell value and click off the grid or exit .. the last cell I was in doesn't get updated.
Usually happens on the
Multiple rows in DataReport -
I have two tables. LogNo is the primary key in Table A and LogNo is foreing key in table B.
I have a DataReport which i have set in the following way.
Set bAnalysisReport.DataSource = recset
recset is an ADODB.RecordSet object that pulls out rows from the two tables
Using an If statement in vba for multiple records in a range -
Hi all. I am using the following bit of code:
Dim rngCalc As Range
Set rngCalc = Range("AD2:AD" & Cells(Rows.Count, 1).End(xlUp).Row)
rngCalc.Formula = "=(8-K2)"
rngCalc.Value = rngCalc.Value
In this case, the first cell to be replaced is AD2 and it co
Editing fixed rows and columns in MSFlexgrid -
How can I have the user edit (Add or Remove) text in the Fixed columns and rows of the flex grid. I was thinking of having the user double_click() on the fixed cell and pop up a small form to type the information he/she wants in the selected fixed cell or just edit the cell and they ca
Flex Grid Multiple Selection -
I have a flex grid that is set to select entire rows when clicked... everything works fine with it so far. If a user selects more than 1 row is there a way to handle the multiple selection of rows? I tired playing around with the clip property but i don't know if that will do what i ne
[2005] How best to have multiple Cell types in a DataGridView Column -
I have some data where each row has several uneditable values and a final cell with an interface based on those values.
Two of the cells are the data ranges of the editable value, one indicates the type of control that needs to be displayed in the editable cell.
I'm okay with getting
VB/Excel Find first empty cell ina column -
Hi there!
Hope you can help me.
I have column "A" with 6000 rows containing data.
A1 to A6000.
But not all rows contains data. Some are empty.
Now i want a code that goes from first row to row 6000 and fill the empty cells with a value from an another cell in the r
Search through a Excel Spreasheet -
Hi I need to search through an excel spreadsheet. The sheet can contain as much as 4465 rows. Data to be searched on will start at Row 2, Column 2. The Rows to be searched are multiple of 144. In other words, my starting row should start at 2, 145, 289...and so forth. My ending Rows sh