Daily Event Log Database

[Pintglass]

Hello

I am trying to create a database to log events on a daily basis, the log is to record events for my disabled daughter.

We have a behavioral specialist who is trying to help my daughter with certain aspects of her daily routine. So the database would be to try and build up a picture of her routine. At the moment we are using a printed out form (Created in Excel)which we fill in each day.

Could any of you give me any tips on my table structure for this database?

I have attached the file created in excel for you to have a look at i hope this will give you enough information to give me a few pointers.

Many Thanks Pintglass

View attachment Daily Event Log.xls

 

[boblarson]

Here's a quick go at it. It might need some adjustment since I'm doing this very quickly.

 

[Pintglass]

Thanks Bob for the help on this. I have just one question in the tabletimeframes would i have to have fields for each of the time frames.

Thanks again Pintglass

 

[boblarson]

No, you just have what I have there. The ID and the description so the time frames would be in the table like:

1     0700-0900
2     0900-1200
3     1200-1500
4     1500-1800
5     1800-2100

That is, unless you are actually wanting to store the actual date/time together. (that just jogged me - you at least need EventDate in the tblEvents table as well)

 

[Pintglass]

Sorry bob im having a hard time picturing this, what values will be held in the tblTimeFrames then.

Thanks Again Pintglass

 

[boblarson]

Sorry bob im having a hard time picturing this, what values will be held in the tblTimeFrames then.

Then when you store the Event, you are selecting one of the Time Frame Values from a combo box which then stores the TimeFrameID in the tblEvents table and NOT the TimeFrame text itself.

 

[Pintglass]

Bob, could you just elaborate a bit more on the relationships between the tables as i am not sure that i am following them correctly.

Thanks again Pintglass

 

[boblarson]

Not sure what to explain. If you build the tables and then try to link them on the Primary/Foreign key in the relationships window, you will see that, for example, it will be listed as a One-to-many for the link between tblTimeFrames.TimeFrameID and tblEvents.TimeFrameID and so on. PK listed in one table is going to be FK in the other.

 

[Pintglass]

Yeah thanks bob I've got it now.
Im just trying to think of the best way to create my forms i was hoping to create something similar to the excel file that i have but im not sure i can do it like that.

Thanks Pintglass

 

[boblarson]

Yeah thanks bob I've got it now.
Im just trying to think of the best way to create my forms i was hoping to create something similar to the excel file that i have but im not sure i can do it like that.

Thanks Pintglass

It would probably take quite a bit of code to make it like the spreadsheet. But using a form/subform it should be quite functional. Let me know if you run into any problems creating them.

 

[Pintglass]

I've got a rough main form done using combo box's what im trying to do is have a subform in the excel style showing the values entered for the particular date.

I've been trying to set the control sources of text boxes using dlookup something like this

DLookUp("EVENTVALUE","EVENTSTBL","EVENTITEMID=1 and TIMEFRAMEID=2"and EVENTDATE=Forms!EventForm!EventDate")

But im not getting anywhere.

Thanks for all your help Pintglass

 

[boblarson]

First run Compact and Repair on the database you have and then ZIP the file by right-clicking it and selecting SEND TO > COMPRESSED FOLDER. Upload that zipped file to the forum here and I'll take a look to see what you have.

 

[Pintglass]

Bob this is my db file the textbox on the event form is only for testing i was going to create a subform when i could get it to work.

Thanks Pintglass

 

[boblarson]

It looks like you have it most of the way. I moved the comments to its own table and used a subform. And removed the extra field from a couple of tables.

 

[Pintglass]

Thanks Bob for the new db i will have a look and let you know how it is.

Pintglass

 

[Pintglass]

Bob, i know you said that it would be a lot of code to have a form like the spreadsheet, but i would like to have a go at doing this as how it is at the moment its hard to remember what data has been entered with there being so many different values.

Was my idea of using dlookup to populate unbound text box's no good.

If not could you suggest any other method to achieve a similar result.

Thanks again Pintglass

 

[dreeds]

Hi, I know this is a late reply but here's an alternate solution... sharedevents.net - I created it to help give people access to their daily routines and to set reminders, notifications, and to learn from other similar people/families, in part to help extended family members living with autism.

If you think what you see might be useful, please get in touch and I can work with you to build something useful.

Hoping your family is well,
Dean