Is there a way to do Sorting and Grouping on a continuous form, similar to a report?

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

Let's say I was looking at tools - rather than having a line after each
item, I'd like a line after each header; e.g. screwwdriver, or hammer
 
I'll look into this - I'm having trouble figuring how the data is laid out
in the Flex Grid control though... I wish it was a little easier than that.
Plus I would have to install the .dll on other people's machines - not
necessarily an option with secure PCs.
Thanks
Michele

Peter Hibbs said:
A Flex Grid Control will probably do what you want but it will involve
a fair bit of VBA code. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.
Click to expand...
 
Michele.

If you used a FlexGrid control you would lay out the data in the way
you have shown in your example, that is the point of this control, you
have complete flexibility over the layout.

You could merge the common fields so that your data would look
something like this:-

------------------------------------
| Screwdriver | Flat tip |
| |Phillips |
-----------------------------------
| | Ball Peen |
| Hammer | Claw |
| | Sledge |
------------------------------------

And yes, you would need to copy the Flex Grid control file
(MSFLXGRD.OCX) to each PC and register it. Not sure about the security
issues though, I assume that is a company policy.

The only other alternative that I can think of is to create a
temporary table, write some code to copy the relevant data into it and
then use a List Box control to show the data in the format you want.
Obviously you would not then be able to edit the data but perhaps you
don't need that facility.

Peter Hibbs.


I'll look into this - I'm having trouble figuring how the data is laid out
in the Flex Grid control though... I wish it was a little easier than that.
Plus I would have to install the .dll on other people's machines - not
necessarily an option with secure PCs.
Thanks
Michele

Peter Hibbs said:
A Flex Grid Control will probably do what you want but it will involve
a fair bit of VBA code. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.
Click to expand...
Click to expand...
 
Using the sample I downloaded I was totally unable to figure out how to
place an item on the grid - that was my question - not how to lay it out in
rows and columns.

Peter Hibbs said:
Michele.

If you used a FlexGrid control you would lay out the data in the way
you have shown in your example, that is the point of this control, you
have complete flexibility over the layout.

You could merge the common fields so that your data would look
something like this:-

------------------------------------
| Screwdriver | Flat tip |
| |Phillips |
-----------------------------------
| | Ball Peen |
| Hammer | Claw |
| | Sledge |
------------------------------------

And yes, you would need to copy the Flex Grid control file
(MSFLXGRD.OCX) to each PC and register it. Not sure about the security
issues though, I assume that is a company policy.

The only other alternative that I can think of is to create a
temporary table, write some code to copy the relevant data into it and
then use a List Box control to show the data in the format you want.
Obviously you would not then be able to edit the data but perhaps you
don't need that facility.

Peter Hibbs.


I'll look into this - I'm having trouble figuring how the data is laid out
in the Flex Grid control though... I wish it was a little easier than
that.
Plus I would have to install the .dll on other people's machines - not
necessarily an option with secure PCs.
Thanks
Michele
Click to expand...
Click to expand...
 
If you have downloaded my demo program from Roger Carlson's web site
then you should be able to find one or more examples on how to
populate a FlexGrid control.

From your description I would think you need to use the AddItem
command to add a new row for each item. Normally you would create a
recordset from a query which returns the records you want to display
and then iterate through the recordset one record at a time and add it
to the FlexGrid. If you study the example code you should be able to
work it out, if not then post back with any specific problems.

HTH

Peter Hibbs.

Using the sample I downloaded I was totally unable to figure out how to
place an item on the grid - that was my question - not how to lay it out in
rows and columns.

Peter Hibbs said:
Michele.

If you used a FlexGrid control you would lay out the data in the way
you have shown in your example, that is the point of this control, you
have complete flexibility over the layout.

You could merge the common fields so that your data would look
something like this:-

------------------------------------
| Screwdriver | Flat tip |
| |Phillips |
-----------------------------------
| | Ball Peen |
| Hammer | Claw |
| | Sledge |
------------------------------------

And yes, you would need to copy the Flex Grid control file
(MSFLXGRD.OCX) to each PC and register it. Not sure about the security
issues though, I assume that is a company policy.

The only other alternative that I can think of is to create a
temporary table, write some code to copy the relevant data into it and
then use a List Box control to show the data in the format you want.
Obviously you would not then be able to edit the data but perhaps you
don't need that facility.

Peter Hibbs.
Click to expand...
Click to expand...
 
Back
Top