Search results

Hello there, I have a question, which I know is most likely very basic, but for some reason I keep drawing a blank on what to do. I figured I would post what I have so far, and see if anyone had some feedback. This database is based on an outline on paper. SO for example: 1. Category...

just so you know....it is a coincidence :D

Thanks for taking the time to give these detailed reponses! The way you layed out the tables above definitely gave me a new route to think along on how it SHOULD be structured. I am going to go back and try to resolve this, again thank you for the help

You are correct in your initial inferrences These are medical surveys conducted over time. A researcher takes the paper surveys, and then inputs them into the corresponding form which represents that particular survey at that particular time. Each patient has an ID number(no specific...

OK There are 9 seperate questionnaires to fill out for each period in time. There are 10 points in time (designated by weeks and months) Week 1 Questionnaire 1 Questionnaire 2 Questionnaire 3 ....etc up to 9 Week 2 Questionnaire 1 Questionnaire 2 Questionnaire 3 ....etc up to 9 Week3...

Thanks for the reply. I know that the way it is designed is not the best, however I was stumped to find a way to accomplish what was needed and meet all normalization forms. Yes, there are groups of tables that are the same HOWEVER the data within them is different for each table. This is...

Hello I have a database set up that is used for data entry. There are about 30 or so tables, and a seperate form for each table. Each form's recordsource corresponds to its unique table. Some of these tables/forms are the same in design, but the data being entered into each is different...

HHUK, in this case there would literally be hundreds of tables and forms, and at least a dozen people accessing them, with more to be added in the future, so ill most likely check out the hyperlinking Thats a pretty sweet idea, right before I read this, I was checking out the VB command...

Ahha! Yes I was thinking of using the hyperlink method, which would link to a seperate mdb file, I just wasn't sure if this was used often. Ideally id want the operation to be: view form with links to dbs -> click link -> current db closes -> linked db opens

Thank you for the response, what I am looking for though, is more along the lines of: Is it feasable to design one database which opens other databases. In other words, this DB would act as a sort of 'switchboard', which will allow certain users to access other mdb files. I didn't know if...

Hello all, glad to be here I wanted to bounce this idea off the members in the forum, its more along the lines of managing multiple databases rather than individual design. I am a recent incumbent at a position where there are many individual access database files for the department. (Each DB...