Search results

  1. I

    Monthly report: display month as text in Header

    Worked great! Thank you kind sir!
  2. I

    Monthly report: display month as text in Header

    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...
  3. I

    DB design question...all help appreciated

    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...
  4. I

    DB design question...all help appreciated

    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...
  5. I

    DB design question...all help appreciated

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

    DB design question...all help appreciated

    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...
  7. I

    Multiple forms/single table?

    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...
  8. I

    Multiple forms/single table?

    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...
  9. I

    Linking Main form to another form

    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
  10. I

    Collapse Question

    Just tagging this thread, had a similar issue.
  11. I

    Autofill problem

    Nevermind, I got it. Thanks again.
  12. I

    Autofill problem

    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.
  13. I

    Autofill problem

    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...
  14. I

    Noob question about Query by Form

    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...
  15. I

    Noob question about Query by Form

    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...
  16. I

    Noob question about Query by Form

    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...
Back
Top Bottom