Yes, it is. The code working so well. I've tried to solve this quite a while but turns out not like I want it to be. I'm in the process to understand your code. Did you use the Breakpoint and Watch as in your article each time you solve a problem? I'm just amazed how you can solve a problem in such a short time.
Thank YOU & Happy Teacher's Day (I think of you as my VB teacher) :)
Mas Juliza Alias
Last Activity: May 21 '12, 02:09 PM
Joined: Aug 5 '10
Location: Shah Alam, Malaysia
-
Mas Juliza Alias started a topic How to get average values from a flexgrid and dump them into another flexgrid?in Visual BasicHow to get average values from a flexgrid and dump them into another flexgrid?
Hi,
I have two tables (MSFlexGrid1 & MSFlexGrid2). MSFlexGrid2 contains data of Date, Time, Water Level, Volume, and Area. Some of the Date are the same in which the data are taken at different times of the same date. What I need here is that the average of the Water level, Volume, and Area data of the same date to be filled in the other table, MSFlexGrid1. The table should contain data of Date and the average of Water level, Volume,... -
Never use it... Why?Leave a comment:
-
I got it. Brilliant use of 'For' and 'If'. I would never thought of that kind of solution. Thank You...Leave a comment:
-
In the code, which line did you assign the first attribute of the ARRrescet into ARRdate?Leave a comment:
-
You are such a HERO! It works really well! Thanks a lot! :)Leave a comment:
-
How to add data from DataGrid into ComboBox list?
Hi,
How to add the list of a combo box with a data in a table from data grid?
I have a data grid connected to a .mdb database in one form, and two combo boxes connected to the same database in another form. I am using Data Environment to connect the objects to the database. I've set the combo boxes' properties, DataSource, DataMember and DataField to the Data Environment, data Table and data Field respectively. The problem is, only... -
problem solved. Thank YOU!Leave a comment:
-
Unneeded line after drawing graph on picture box
Hi,
I have a problem with the graph I drawn on a picture box for quite a while. I have two curves, elevation-storage and elevation-area curves which need to be drawn on a single graph. I managed to draw it nicely if the curves are drawn separately, but somehow when the curves are merged together (by merging the same codes as they are drawn separately) there is an unneeded line appears diagonally from min value to the max value of x,y. How... -
Do I need to use For/Next to add new row? And where to put the APPEND code?...Leave a comment:
-
How to update FlexGrid using data entry form?
Hi,
I have a data entry form where user can enter details to be added into a MSFlexGrid; which is contained in another separate form. The data are supposed to be updated on a new row of the grid each time the Add button is clicked. Here is what I have so far
...Code:Private Sub cmdAdd_Click() Dim i As Integer i = 0 If chkDisplayTable.Value = 1 Then frmDisplayTideGrid.Show Else -
Your code is easier for a beginner like me to understand, and it works nicely. Thank YOU!
If you have time, can you explain to me the different between these lines:
Code:Open App.Path & "\tapahdam_surfacearea.txt" For Input Access Read Shared As #FILENUM
What is 'Access Read Shared' used for?Code:Open App.Path & "\tapahdam_surfacearea.txt" For Input As #FILENUM
Leave a comment:
-
Yes! It is solved successfully. Thanks to Guido Geurs!Leave a comment:
-
How to code a counter?
Hi,
I have a data file with 2 different strings, named as CON and ICON. How to turn the value of each line to integer that work as a counter for each change of string name? For example:
...Code:string counter -------------------------------- POINTS_CON 1 POINTS_CON 1 POINTS_ICON 2 POINTS_ICON 2 POINTS_ICON 2 POINTS_CON
-
To use the data files, create new file (File > New) and download the data file (Download/Import). Data file with positive and negative values of elevation is trapezoidal_vol ume_shift3m.txt file. TQ.Leave a comment:
-
I am facing a problem here. I am using a data with positive and negative values. When I enter the positive value for the elevation, an error message "Run-Time Error '380', Invalid property values" appears highlighting this line
...Code:With FrameGraphRTLx .Left = FrameGraphRTLy.Left + FrameGraphRTLy.Width .Top = FrameGraphRTLy.Top .Height = (Abs(Ymin) - Abs(CDbl(txtElevUser.Text))) * TWIPSy 'highlighted
Leave a comment:
-
Sorry, my mistake. It is Model 740. Portable Tide Gauge Model 740.Leave a comment:
-
Oh I see... So you just add the If function to read the graph data for the first value, am I right? The code works nicely. Thank YOU!Leave a comment:
-
There is a problem here when 0 depth is entered. The volume should be 400 but it appears as 0. How can I fix this?
TQLeave a comment:
-
Oh I see... I am sorry for my limited knowledge. I have searched and read about it. Thanks!Leave a comment:
No activity results to display
Leave a comment: