Student Sign In/Out Database

[roseannej78]

In the Learning Center, my boss wants a database to replace the old database (not MS Access) we are currently using. We keep track of students signing in and signing out of the Learning Center. He’s asked me to work on it. I’m hoping that we could start using this new database (see attached-created by "theDBguy") by mid-summer because we like it very much, but, of course, it needs modifications to meet the Learning Center requirements. I e-mailed theDBguy that created this and asked him if we could use his database. He said yes that we could use it and modify it to our liking. He said he would love to help, but he’s been really busy and he doesn’t know when he will be able to work on it. So I was hoping that you could help me. Attached is the database that we want to use. Also attached are the changes that we want. Please play around with it so you can see how it’s set up and check all the VBA codes, which I'm not familiar with at all. If you have questions, please don’t hesitate to ask me anything.

Thank you in advance!

Roseanne

 

[Royce]

Are you looking for someone to make the changes for you? (Pro-bono?) Hire help? Or give you some guidance on how to do it?

 

[roseannej78]

I'm needing guidance (a lot-haha) as to how to change this to my modifications. See "ASC Changes"; these are the changes I want. Thanks in advance.

Roseanne

 

[Royce]

I'd suggest you start figuring out how to make the changes you need one at a time.

Open the Visual Basic Editor, then search for "Welcome back". You'll find the code that pops up the message. Study it a bit and it see if you can figure out where you would have to copy it, and what changes would be needed to make it pop up where you want it. Also, frmNewStudent is a good one to study. The code is real simple, and uses several basic's you'll need, like opening a form, showing a message.

Work with a copy of your database and try making some changes. When you get to something that stumps you, post a specific question, and people will usually jump in and help. That's how I started with Access 95. (Was it still CI$ and bulletin boards then?)