Search results

Worked great! Thank you kind sir!

Hello, I have a report that displays records on a monthly basis. The report is based on a query, and the specific month is selected as a number (1-12) by using the following: Field: Month([ProtocolDate]) Criteria: [Choose a month from 1-12] So, if I want the report to display only the...

This is an example of what the report will look like. Thanks for having a look. I'm hoping to get input on the design, as this is a return to basics after trying on three other attempts to get this DB developed. This was before I knew what normalization was, and had a table with all the...

I goofed again. Threre are actually 4 more tables... 6. tblMedications MedName (haven't designated a PK yet, not sure if I need to. Only ServiceB2 will have meds associated with it, but it can have up to three meds. Each med has a dosage) 7. tblDosage Dosage 8. tblIsolCode IsolCode (this...

Sorry, I posted in the wrong forum. Could the Moderator please relocate it to DB Design/Theory forum? Thanks

Hello everyone. Hope your holidays are going well. I have been given the task of developing a DB that will be used to generate reports for scheduling services for clients. These are medically related services and are provided around the clock. I have divided the Services into two broad...

You guys are right. I found out what normalization was after I started working on this database. I was hoping to work through this on my current db to see if I can get it to work, but I'm at the point of scrapping it, and starting all over. I have a couple of questions on design, but I'll...

Hello friends, I have a pretty noobish question. I was wondering if it was possible to have several (3 in my case) different forms that apply data to a single table? The main table has three different types of data: 1. Client info 2. Services A 3.Services B. Each type of data has about...

Hello friends, I have a similar issue, I think. I won't hijack this thread, but if it wouldn't be asking too much Lightray, could you expand on this: Thanks

Just tagging this thread, had a similar issue.

Nevermind, I got it. Thanks again.

Awesome, thank you John. So, I didn't designate a source for the text, brilliant!:rolleyes: One more question if I may? What would be the easiest way to have the combo box display only the frequency (column 1) during selection, and simply have the text boxes fill appropriately? Thanks again.

Hello friends, I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box. I have a table with the following fields: PK - autonumber Frequency - text TimeD - text TimeN - text The frequency...

I just realized I set up my switchboard wrong. I did it a second time using the wizared gemma suggested, but I am still having the same problem with the search button. That is, when I hit the button, and enter a search criteria, the resulting data opens in a datasheet view. I would like for...

Hi gemma, Thanks for the quick reply. I love huskies, BTW. I tried using the wizard when I first made the switchboard, but I'm not sure I went about it the usual way. I simply made a form using the form wizard, and call it my switchboard. The best I could do was to get the record to...

Hi all, I'm pretty new to Access, but catch on quick. I have posted this question at another access forum, but have not received any input - maybe it's in the way the question was asked.:confused: I have a developed a database to track patient ID, patient name, then several other fields of...