Thank you very much,
But, no can't do.
TextMatrix only retrieve a specific cell.
Example: TextMatrix (1,0) only retrieve cell (1,0) of the MSHF, But it can't be used if I choosed / double-clicked random cell in my MSHF. It'll be showing the same data each time I double-clicked the MSHF
I want to display entire data in the same row when I double-clicked any cell in My MSHF. Example: I double-clicked cell...
nairda
Last Activity: Aug 10 '07, 08:01 AM
Joined: May 14 '07
Location:
-
Double Click on MSHFlexgrid to show data
Hi all,
I have a MSHFlexgrid to show my database and some textboxes to show datas I choosed from MSHFlexgrid.
I would like to know if there's a way to show a specific data I choosed from MSHF in my textbox by double-clicking the data in MSHF.
I know these script:
...Code:Private Sub DGrid DblClick() With DGrid Text1.Text = .Columns(0).Text Text2.Text = .Columns((1).Text -
Oh I see...
I'm still working with lots of grids. Usually just for displaying database.
Sheridan is great, quite easy to use.
Ok then. See you!
nairda...Leave a comment:
-
Sorry,
I'm using VB 6.0 Enterprise Ed.
I've tried using Sheridan Data Widget, It's cool. But I lost my Sheridan Installer and I think I don't need any third party product for my simple program.
Any suggestion? What are you using then? What the advantage using it compared with MSHFlexgrid?
Regards,
nairda...Leave a comment:
-
Thank you very much!
Yeah, I've tried to do it manually by looping the process through each row until it reach certain row. It works well. I'm just wondering if there's a way to sum all data in one column automatically.
Ok then, thanks.
Nairda...Leave a comment:
-
Mathematics Operation on Flexgrid
Hi all,
Is it possible to do a mathematics operation on Flexgrid data?
Example: In Flexgrid I have 2 columns, with 10 rows of data each. I want to sum all the rows in column 1.
Is thera any way to do that?
Thank you.
Nairda -
Ok, thank you.
It's working great.
Nairda...Leave a comment:
-
Select data from different worksheet
Hi,
I'm working with VB 6 and Ms Excel. My Excel Workbook has 3 worksheets.
I want to retrieve data from one of the sheets and show it in my Flexgrid, but I don't know how to select a spesific sheet.
I've wrote this code so far:
...Code:Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Private Sub Command1_Click() Set xlapp = New Excel.Application Set xlbook = xlapp.Workbooks.Open("C:\XLTAB.xls") -
Ok then,
I'll give it a try.
Thank you very much for your help.
Regards,
nairda...Leave a comment:
-
Thank you very much,
Yes, I want to take data FROM Excel, and then put it on my FlexGrid.
So, I have to filter the data from Excel before place it in my Flexgrid, right?
Is there anyway that VB could automate the Excel filtering so I don't have to filter Excel manually before place the data in my Flexgrid?
Thank you so much again.
Nairda...Leave a comment:
-
Hi, thank you Killer42,
But I'm so sorry, I can't find the article you've told me.
I only found how to show only visible cells from filtered Excel table. It's not covering my problem.
My problem is I want VB to filter my Excel data and show it to my MSHFlexgrid.
I have an Excel table (tbstudents) contains a view columns (StudentName, Address, Grade, etc). I want to show all data of a student named "Charlie"....Leave a comment:
-
Filtering Data from Excel Table and Show It in VB
Hi there,
I need help processing data from Excel in VB. I have a MSHFlexgrid to show data extracted from Excel. I'm able to show a range of cells from Excel table to my Flexgrid, but that's it. The problem is, I can't filter the data I wanted to show from Excel table. Is it possible to filter Excel data using SQL command? I've tried several ways including SQL command like "select Name from tbcustomers where Name....."
Please... -
Hi Ahmad,
You should pack your project using "Package and Deployment Wizard" before running your project in another PC, because not all PC have a similar system files.
The wizard will help you making a setup / installer file from your project.
It's important for you to pay attention to your WindowsXP Service Pack. Because if you made your project package in Service Pack-1, It isn't gonna run well in Service Pack-2....Leave a comment:
-
Great then!
What table do you want to close? Your database table or datagrid table?
Sorry Steve, I don't know how to show booked equpment in the calendar. Perhaps you could post a new thread regarding this problem.
Thank you.
Nairda...Leave a comment:
-
Hi there raman,
Could you please tell me how you update / edit data in you datagrid. Is it by clicking a data in your datagrid, show it on texboxes, and then you save it back, OR else? It's related with how you gonna update your access database.
Thx
Nairda...Leave a comment:
-
Hi tigger,
First, it's better for you to get your combobox's list directly from your database. It means that every time your database changed (e.g: added new names or deleted a name), the combobox will be updated automatically.
To link your combobox to your database, you can use these codes:
Private Sub Form_Load()
Dim conec As New ADODB.Connectio n
Dim rs As New ADODB.Recordset
...Leave a comment:
-
Hi,
I think You can't do that. Because no matter how your database date length, the user only selected date 20 and 21.
Assume that today's date is 7/21/2007.
If user picked 2 dates (1= 7?20/2007, 2= 7/21/2007), You can only show date 20 and 21. Because the 22 is not yet happened.
The point is, if you have a criteria to filter your data, you can't show others datas outside the criteria.
To filter the date...Leave a comment:
-
Geez, We've headed to a wrong way then. Sorry.
If it's an input form, why bother filtering your startdate and enddate? Just give the guests some comboboxes to fill the date and month they wanted, and then save it to your reservation database after they clicked a command button.
Nairda...Leave a comment:
-
Hold on, I got confused here.
What's your programs's story exactly? You want to show a report from your guestdatabase OR you want to make a reservation form to fill by guests?
Nairda...Leave a comment:
-
Not at all, Steve. This what the forum is for.
Ok, I'll give you a picture:
I have a hotel reservation Ms. Access table (RESERV.mdb). It contains some columns (CHECKINDATE, CHECKOUTDATE, ROOM_NO, GUESTNAME, etc).
And then I have this report form which I use for setting some criterias to show the report. In this case I want to show list of all guest stayed in my hotel between CHECKINDATE in combo1 and CHECKOUTDATE combo2....Leave a comment:
No activity results to display
Leave a comment: