Graphic interface to Access data?

[Pendragon]

Hey gang,

Thanks for the help over the years. Got a new project and I know that Access
as a Front End is not going to work ("you want a spreadsheet").

Working with volleyball people who are used to using "an Excel database"
(cough, cough) because they can lay out a grid of courts, see what teams are
where and who the officials are. I've built an Access database to process
all of this information. What the users can't wrap their heads around is
reading a listing of courts with names which doesn't look like their Excel
grid, and not being able to go directly into "Court 5 at 11 am" and change an
official, have that automatically update that official's work history and
earnings record, etc etc etc. Someone tried to do this last year in Excel
with a TON of cell references, equations, some programming, and the thing
gagged and puked on the first day. Wasn't pretty.

As I said, I've already set out the tables, relationships, and forms for
entry and management, though the latter I guess more by an Access user. Is
there a software or developer's program out there where it will create an
interactive grid based on a data source? By interactive I mean once the grid
is created, being able to somehow go to a specific record, make changes,
auto-updates, etc., but still look like a grid?

Keep in mind that these court grids are NOT consistent for time spans. For
example, courts 1-10 run 2 hr matches from 8am-2pm, but courts 11-25 run 1.25
hr matches from 8am - 12pm and courts 26-30 don't start until 10:30am and run
1.75 hr matches until 4pm. Fun stuff.

Thanks for any ideas.

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples and also the Crosstab Query in Flex Grid demo which
may do what you need.

http://www.rogersaccesslibrary.com/...p?FID=21&SID=bc153c21ec64e89z38fb679b5z316d54

HTH

Peter Hibbs.

 

[Banana]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples and also the Crosstab Query in Flex Grid demo which
may do what you need.

Peter already gave you one sample. I also wrote another sample
demonstrating "spreadsheet-like" entry demo, using crosstab query &
temporary table.

http://access-programmers.co.uk/forums/showthread.php?t=162765

Best of luck.

 

[Mark Andrews]

I also have a flex grid sample:
http://www.rptsoftware.com/help/microsoft_access_thirdparty/

You could use a scheduling control such as
http://www.codejock.com/products/calendar/?platform=com
I went down this route to build a scheudling application that is better than
what you can get out of something like a flex grid (full drag and drop,
various other little touches)
However I warn you up front it's about 10 times more difficult going this
route.
I recommend using Access alone or Access with a simple third party grid
component.
ComponentOne sells the enhanced Flexgrid (but you need to buy the suite for
approx $800).

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[madaleine arantes]

Hey gang,

Thanks for the help over the years. Got a new project and I know that
Access
as a Front End is not going to work ("you want a spreadsheet").

Working with volleyball people who are used to using "an Excel database"
(cough, cough) because they can lay out a grid of courts, see what teams
are
where and who the officials are. I've built an Access database to process
all of this information. What the users can't wrap their heads around is
reading a listing of courts with names which doesn't look like their Excel
grid, and not being able to go directly into "Court 5 at 11 am" and change
an
official, have that automatically update that official's work history and
earnings record, etc etc etc. Someone tried to do this last year in Excel
with a TON of cell references, equations, some programming, and the thing
gagged and puked on the first day. Wasn't pretty.

As I said, I've already set out the tables, relationships, and forms for
entry and management, though the latter I guess more by an Access user.
Is
there a software or developer's program out there where it will create an
interactive grid based on a data source? By interactive I mean once the
grid
is created, being able to somehow go to a specific record, make changes,
auto-updates, etc., but still look like a grid?

Keep in mind that these court grids are NOT consistent for time spans. For
example, courts 1-10 run 2 hr matches from 8am-2pm, but courts 11-25 run
1.25
hr matches from 8am - 12pm and courts 26-30 don't start until 10:30am and
run
1.75 hr matches until 4pm. Fun stuff.

Thanks for any ideas.

 

[Pendragon]

Great responses! I will do some investigating and look at the examples
provided. Thanks very much for the feedback!