Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GRID???
- Thread starter fifa
- Start date
Check out the properties of the grid with the property sheet.
You'll find a property called: GridLines.
HTH,
Weedz (Wietze Veld)
veld4663@exact.nl
They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.
After the GoldRush - Steve McConnell
You'll find a property called: GridLines.
HTH,
Weedz (Wietze Veld)
veld4663@exact.nl
They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.
After the GoldRush - Steve McConnell
FIFA,
If you mean remove a "row" in the grid, remember that it's just the visual representation of the rows of the underlying table/cursor/view - just "delete" that row. You may need to use DELETE, change the filter, or requery the underlying data to accomplish this.
Rick
If you mean remove a "row" in the grid, remember that it's just the visual representation of the rows of the underlying table/cursor/view - just "delete" that row. You may need to use DELETE, change the filter, or requery the underlying data to accomplish this.
Rick
- Thread starter
- #5
Hi,
Thanks for your reply,
Paka,I read data from an Alias "Art_con" and I control cursor by preesing enter key and the cursor moves to next row but I want to remove row if I make a wrong instruction, how can Iresolve this?
Thanks for yopur attention.
Thanks for your reply,
Paka,I read data from an Alias "Art_con" and I control cursor by preesing enter key and the cursor moves to next row but I want to remove row if I make a wrong instruction, how can Iresolve this?
Thanks for yopur attention.
Fifa,
As Rick says, the grid is just the visual presentation of the data in a table. So you need to change the data to alter what the grid shows.
There is a property of a grid called DeleteMark. This defaults to TRUE and you see a narrow column on the left side of the grid. Clicking in that column sets the underlying record as DELETED().
Then set the grid's RecordSource to an empty string [], then either pack the table, or re-run the view/selection and then set the RecordSource back again. That's the way I've done this sort of thing and it seems to work for me.
Hope that helps,
Stewart
As Rick says, the grid is just the visual presentation of the data in a table. So you need to change the data to alter what the grid shows.
There is a property of a grid called DeleteMark. This defaults to TRUE and you see a narrow column on the left side of the grid. Clicking in that column sets the underlying record as DELETED().
Then set the grid's RecordSource to an empty string [], then either pack the table, or re-run the view/selection and then set the RecordSource back again. That's the way I've done this sort of thing and it seems to work for me.
Hope that helps,
Stewart
- Thread starter
- #7
Hi,
Thanks for your reply and attention, it works now I have problem with scrollbar of the grid of the 2nd form (form1 call form2 which is a search grid for form1)I can go down with cursor but I can't go up only by mouse, notes I'd like to use only keybord never mouse.
Thanks for your attention.
Thanks for your reply and attention, it works now I have problem with scrollbar of the grid of the 2nd form (form1 call form2 which is a search grid for form1)I can go down with cursor but I can't go up only by mouse, notes I'd like to use only keybord never mouse.
Thanks for your attention.
- Status
