Make new Table? Feedback / Suggestions

Bonifaceg

Registered User.
Local time
Today, 14:28
Joined
Oct 26, 2004
Messages
18
Hi.
I am quite new to Access, and have learnt quite a bit from your forums. I need some pointers on how to do the following. Any & all help is appreciated.

I have a database to keep track of residents at a shelter. One of the requirements is that they all "check-in" every evening, or they lose their bunks. How would I go about tracking this, separate from the stay Information (Number of days stayed, date moved-in, etc), without creating a new table for each day? (Or do I have to create a new table for each day to note who was in and who defaulted to "check-in"?)

I have attached a zipped file.
Thanks again.
 

Attachments

Create a new table:

tbCheckIns
CheckInID Autonumber
ResidentID Foreign key to resident descriptor table
dtCheckID Date field which has both a Date and Time component

Use a form, which has tbCheckIns as its recordsource, and at least the following controls (1) a combo box to select the Resident, (2) a locked check box to stuff Time() into when the resident checks in (on AfterUpdate event of) the combo box, and (3) a unique identifier the Resident knows (birthdate, birth city). You might include a delete button on the form to delete the current record if the wrong Resident is checked in. Is is too much to also use a birthdate or some other unique identifier to veryify the person checking in is who he/she says he/she is. If not, your database isn't really much good for reliably tracking Residents.
 
Thanks. I have table with:

CheckInID, (AutoNumber)
CheckInDate (Date),
ClientID (Lookup to Table on Clients),
DailyCheckIn (CheckBox to check Client In for the day).

The Unique Identifier I use is the client's SSN. The form is something I will need to look into, as most of the terms you referred to I have only seen in passing & don't know how to use (or their use for that matter). Will I need to have a CheckOut table also?

Thanks again. :)
Bonie.
 
Modify youy table as follows:

CheckInID, (AutoNumber)
SSN (Unique identifier)
CheckInDate (Date)
DailyCheckIn (Checked in)
CheckOutDate (Date)


Will a client ever have multiple checkins, say for a family having m ultiple rooms? This would be allowed using this record structure. You'd just have multiple records for a given SSN.
 
General Help for a Newbie

Hi again. (Zipped File Attached)

I have made changes to my table structure eliminating table-level pull-ups. I did try to use Candace's example (having a text field in the table with pic path), but was unable to resolve the OnCurrent and OnOpen events errors. These events were, in Candace's eg, on the form. I tried it on my PersonalInfo edit form and got a multitude of errors (Not code savvy ). Is there something right off the bat that I'm missing?

For the Nightly Check-in problem, I have created a table (TodaysStays) where I wanted to move data back & forth between (Q: With entering & deleting data so often, isnt there a chance of corruption / data loss?), but was unable to figure-out a query to do this. (My train of thought was as follows:
1) Pull records of current clients - Current Client Query, pulling from Table StayPeriods
2) Populate this information into Table TodaysStays
3) Flag Checked-In clients
4) Move data into Table StayPeriods
Is this a good way to do it or is there a more expedient way to do this? For clients with other data (Suspensions, Bars, etc), will this looping cut-out the information tied-in to them and show them as new check-ins with no adverse history?)

Is there a way I can have information from the table TodaysStays update to table StayPeriods automatically (say at the end of the day or at a particular time (8:00PM) )?

I expect to use table StayInfo to view all the information on a client. Is there a way to update records automatically from other tables before it? (Eg. When I enter a client (PersonalInfo) and check him in (Check-In, TodaysStays, & StayPeriod), can this information be automatically updated to table StayInfo?)

Thanks Again & Kind Regards,
Bonie.
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom