Our New Provincial Office
15 Toronto Street, 8th Floor
Toronto, Ontario M5C 2E3


Membership Database Log Out | Topics | Search
Moderators | Register | Edit Profile

StJohnOnline.ca / CadetsOnline.ca » Active Discussions - All Members » Membership Database « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Dan Plant
New member
Username: Plantd

Post Number: 2
Registered: 02-2005
Posted on Tuesday, March 29, 2005 - 07:47 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Does anyone track membership information in a database? Info like name, rank, address, Public Duty hours, training hours, uniform issue, etc. Trying to streamline all the different lists in the Brigade and tired of having to change multiple lists every time someone changes phone or address.

Once again trying not to reinvent the wheel.

Thanks
Dan Plant
103 Cornwall
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 86
Registered: 11-2003
Posted on Friday, April 01, 2005 - 02:12 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

I use a database to track personal data as well as training/certification data - works well for me and the plus is I can migrate the info into excel as needed
Top of pagePrevious messageNext messageBottom of page Link to this message

Dan Plant
New member
Username: Plantd

Post Number: 3
Registered: 02-2005
Posted on Friday, April 01, 2005 - 03:35 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Any chance of sending me an empty copy of the database? What program are you using?

Thanks
Dan Plant
daniel_plant<at>yahoo.com
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 87
Registered: 11-2003
Posted on Saturday, April 02, 2005 - 05:43 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

sure. I've got duties all weekend and it's still an "ongoing work in progress" as I'm always thinking of ways to tweak it but not a problem - I'll send as soon as I can.

It's in Access.
Top of pagePrevious messageNext messageBottom of page Link to this message

Carmen P. White
New member
Username: Tiger_kick

Post Number: 3
Registered: 11-2004
Posted on Saturday, April 02, 2005 - 06:25 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Would I be able to receive a copy also?

Thanks
carmen.white@sja.on.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Dan Plant
New member
Username: Plantd

Post Number: 4
Registered: 02-2005
Posted on Saturday, April 02, 2005 - 08:36 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Great! Looks like there is interest out there. Maybe with a little collaboration we could have a database template that all divisions could use. Thanks for the help.

Dan Plant
Top of pagePrevious messageNext messageBottom of page Link to this message

William Woodstock
Senior Member
Username: Wwoodstock

Post Number: 125
Registered: 01-2004
Posted on Saturday, April 02, 2005 - 09:14 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Hey, could I get a copy of it too. I think Durham Regions branch is doing something like this, but being the CSC of my division, it would help me out too. So if you could send me a copy. Thanks Lana.
Wwoodstock@on.sja.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 88
Registered: 11-2003
Posted on Saturday, April 02, 2005 - 10:11 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

wow! looks like I'll be busy! Like I said, on duty this weekend so I'll do it ASAP. If anyone else wants a copy you can email me at lhart@on.sja.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Philip Casimiri
New member
Username: Jeepzj

Post Number: 3
Registered: 08-2004
Posted on Tuesday, May 03, 2005 - 06:10 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Please send me a copy as well.

Thanks in advance,
--Phil
phil.casimiri@on.sja.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Michael Simpson
Intermediate Member
Username: Mdsimpso

Post Number: 26
Registered: 07-2003
Posted on Monday, June 13, 2005 - 09:09 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Hey, Could I also get a copy of the database for Halton Hills. I have been trying to play with some templates for tracking the membership information. Your template may give me the ideas I need to finish it.

Thanks in advance.

Mike
Top of pagePrevious messageNext messageBottom of page Link to this message

Catherine Di Cesare
Member
Username: Catherine

Post Number: 12
Registered: 12-2002
Posted on Monday, June 13, 2005 - 10:42 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

I'd like to jump on the bandwagon of getting a copy of that database :-)

Thanks!

Catherine
cdicesare <at> on.sja.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Carmen P.
Junior Member
Username: Tiger_kick

Post Number: 10
Registered: 11-2004
Posted on Monday, June 13, 2005 - 03:16 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

hi can you resend the copy of your database, it may help if i give you the right e-mail cheers

carmen.white@on.sja.ca
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 103
Registered: 11-2003
Posted on Tuesday, June 14, 2005 - 11:09 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Sure no problem to you X 3. To the folks that I sent it through the sja webmail - did you finally get it ok? If not let me know and I'll send it through my regular email. You can email me at lhart@on.sja.ca and let me know if you didn't get it please.

(Message edited by ldh on June 14, 2005)
Top of pagePrevious messageNext messageBottom of page Link to this message

Justin Baumgardner
Intermediate Member
Username: Justin622

Post Number: 19
Registered: 12-2004
Posted on Monday, July 18, 2005 - 07:10 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

hey if someone is there I would like to know the unit designator of the Barrie Cadets Division
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 107
Registered: 11-2003
Posted on Monday, July 18, 2005 - 08:31 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Justin, if memory serves it is Y0107 I believe. Hope that helps.
Top of pagePrevious messageNext messageBottom of page Link to this message

Michael Simpson
Senior Member
Username: Mdsimpso

Post Number: 44
Registered: 07-2003
Posted on Monday, March 27, 2006 - 10:21 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Did anyone receive a copy of the database?
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 130
Registered: 11-2003
Posted on Monday, March 27, 2006 - 10:24 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

I did send them through the SJA email but never received confirmations if they were received or not
Top of pagePrevious messageNext messageBottom of page Link to this message

William Woodstock
Senior Member
Username: Wwoodstock

Post Number: 192
Registered: 01-2004
Posted on Monday, March 27, 2006 - 01:46 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Oh, sorry, yeah I got it but I don't have the program to run it on so it wouldn't work.
Top of pagePrevious messageNext messageBottom of page Link to this message

Dan Plant
New member
Username: Plantd

Post Number: 5
Registered: 02-2005
Posted on Monday, March 27, 2006 - 02:59 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Hi Lana,
My SJA e-mail is for access to the intranet only. Can you send it to me at my yahoo?

daniel_plant<at>yahoo.com

Thanks.
Dan Plant
Div 103 Cornwall
Top of pagePrevious messageNext messageBottom of page Link to this message

Lana H
Senior Member
Username: Ldh

Post Number: 131
Registered: 11-2003
Posted on Monday, March 27, 2006 - 03:43 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Not a problem I don't think Dan. I just need to find where I buried the sample file - I did a major housecleaning on my computer..and I'm trying to compile and repair 3 years of missing Unity info for our honours and awards - oh joy! Just so you know, this is an Access Database but I will see if I can convert to Excel if that would help anyone - certainly you can use the info and set it up in excel so I could send you a Field List and the type of info that I have in it if anyone likes. The other problem with access is that when you copy it it does strange things to the original so if anyone prefers I can burn it to a CD or disk if you want to send me one - pls return postage pd though - I've used snail mail like twice in 4 years so I don't even know how much a stamp is anymore ... lol - you can email me at lanasja@rogers.com and let me know

(Message edited by ldh on March 27, 2006)
Top of pagePrevious messageNext messageBottom of page Link to this message

T. J. Bradley
Senior Member
Username: Tjbrad

Post Number: 82
Registered: 03-2005
Posted on Monday, March 27, 2006 - 04:27 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Lana,

I would love a copy to St. Marys SJA
stmstj<at>execulink.com
Top of pagePrevious messageNext messageBottom of page Link to this message

T. J. Bradley
Senior Member
Username: Tjbrad

Post Number: 83
Registered: 03-2005
Posted on Monday, March 27, 2006 - 04:30 pm:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Lana,

I would love a copy to me at
stmstj<at>execulink.com
Top of pagePrevious messageNext messageBottom of page Link to this message

Joshua Jenne
New member
Username: Jjenne

Post Number: 1
Registered: 06-2007
Posted on Monday, January 23, 2012 - 08:43 am:   Edit Post Delete Post Print Post    Move Post (Moderator/Admin Only)

Does anyone still use an access database to track the information for their CSU. I am finding that we are running on multiple spreadsheets and duplicating work.

Thoughts.

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image

Username: Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Password:
Options: Enable HTML code in message
Automatically activate URLs in message
Action:

Topics | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration