Search results

Yes, I notice the link. I am exploring the referenced website. I am just a little intimidated to break apart the code and attempt to understand what is taking place. However, as a beginner to programming, I was hoping to not have to jump from the deep end so quickly. :eek:

I apologize for just responding. However - Thank you! I now know that what I am looking for is possible to create. The layout I required is very similar to the "Doctor Appointment Calendar" format. Do you or anyone have any suggestions on where I can find information of how to create such a...

Thanks everyone for your input! What I am attempting to accomplish is migrating some forms that are currently being manually created within MS Word. My goal is to use Access for all the data collection and still create the forms in a manner that my users are accustom to seeing. The report...

I am looking for information on creating a "Table" report. Meaning, I need my data to be presented within a table (visual presentation) - just like if you were to create it within a Microsoft Word document (with rows & columns). Ultimately, I want to be able to present information within the...

I got it!!! I created a table(s) relationship that works! Thanks for your help… However, now I am beginning to have more questions as I attempt to make use of this option (junction tables). How would: I need to categorize the food selections by meals; Breakfast, Lunch, Dinner & Snacks - yes...

Never… If anything, I am thankful for your help. I am not mad but I am frustrated! I have been consuming too much time attempting to understand - which I believe I do - the use of junction tables. However, I cannot apply them into practice. I have been disassembling my database - so...

Rain, Here is an update of what I have been doing (see the attached database). Needless for me to admit…I am lost! I have been attempting to play around and make my relationships work? I created one form and added my patient information while linking them to the foods table. I don't want to...

I missed it... But that is good. However, I don't reference the Quick Links drop down often. Therefore, I overlooked it. Glad to hear everything is working again :)

Something has really screwed up with the site. Can't get the list of recent posts or the list of one's own posts I am sorry to hear that...:( Have you scan your system for any rouge threats? I am using IE 11 (11.0.17 to be exact) and I am not experiencing any of the issues that you have...

Rain, Have you gone walkabout? Sorry about my absents after asking you a question, I had to put this project aside to work on another project that needed my attention. Would I be correct in saying that the Meals and Food will change over time. Mainly new ones will get added. Yes, the intent...

OK, Just to quickly summarize: I have many Patients that will have many meal plans prepared for them. This means that each Patient can have many meal plans. Within my database, there will be many foods that can be associated with many meals. Therefore, I plan to accomplish the task with two...

Rain, I had to go back and study up on junction tables. At this point, my understanding is that I can accomplish what I need with two junction tables. I have a many-to-many scenario with my tblFoods & tblMeals and also with tblMeals & tblPatients. I uploaded what I have to receive your input.

Thanks for the input… Let me take a step back and show what I am attempting to accomplished. I have attempted to normalize the needed fields from this example taken from the currently used document. This document exist in a Word format and we are attempting to create the process within...

Sorry, I created a graphic to hopefully better explain the direction I am going with the table(s) layout: Same criteria: In this relationship, I should be able to accomplish my need to create records in the Foods table as new items are introduced. I should also accomplish the need to...

I believe I have my tables and their relationships established. Tables.....Patients........Meals......................Foods Keys.......Patient_ID.....Meal_ID..................Food_ID .................................Patient_ID_FK..........Meal_ID_FK In this relationship, I should be able to...

I am only at the design phase, but yes - something I did not think about until you mentioned it. Each patient will come in for a consultation. The meal plan is customized for their needs. I am going to need to maintain a history, the referring physician can at a later time request the...

Sorry, I do not think that I explained my problem well: I have a table name Foods. This table will hold records that will consist of endless food possibilities. But my understanding is that the food entries (the actual records) do not have the be associated with a Patient or a Meal (fields in...

Yes, that is the basics. My issue is that the Food Items table is going to be something that we continue to update by two methods: • The Nutritionist will be able to manually include any item not found within the table. • Data will be imported / added to the table to provide items not...

Hello, I am attempting to create a database using Access 2010. I am going to require three tables; Patients, Foods and Meals tables to create a Nutritional assessment program. My Foods table is going to be a database of food items. I will need to be able to add & remove items from this table...

In regards to colors, I am currently using four colors. Those happen to indicate the different job status levels; Waiting, In Process, Alert and Completed. If I can get the report to work using colors – I may add an additional two (not certain at this time).