Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MHadden

  1. MHadden

    Anyone willing to look @ my relationships?

    I think I understand your questions, but to be sure, I'll answer them this way... It would be possible for a physician to prescribe oxygen for a patient to use at 2 LPM during exertion, or while exercising, and 1 LPM while sleeping, then give them the option of turning it up to 3 as needed...
  2. MHadden

    Anyone willing to look @ my relationships?

    Oh yeah, I should have also mentioned the purpose of tblRx. I use this for patients that have been prescribed supplemental home oxygen. The prescription is based on an order, that is stated as XX LPM with XX being the numeric value & LPM meaning "liters per minute". When this is prescribed, it...
  3. MHadden

    Anyone willing to look @ my relationships?

    Thanks. The reason for the last few fields in tblCustomers, is that I was trying to use them for linking, rather than linking all of the other tables via Customer_ID. I tried it, but it didn't seem to work properly. I left them for now, thinking that I may be advised, by someone in this forum...
  4. MHadden

    Anyone willing to look @ my relationships?

    Sorry it took so long, but here is a link to a screenshot of the relationship window, as well as the full database if anyone has time & would like to look it over. I am still reading the fundamentals... http://webpages.charter.net/haddensplace/ Thanks again for any help Michael...
  5. MHadden

    Anyone willing to look @ my relationships?

    Thanks to both of you. Duane, I agree, I should have done a better job at explaining my tables. I forgot that I couldn't just post it here, like some sites. I ran out of time to type it here, and don't have access to web space at the moment, but I will update this thread soon with the...
  6. MHadden

    Anyone willing to look @ my relationships?

    I have been working for a few weeks now, but cannot seem to get the relationships working properly on this DBase. I am just now learning about normalization. When I started out, I only had one huge table. I have now separated it into several smaller tables. My problem is that I want to create a...
  7. MHadden

    Looking for better coding advice

    Keith, Thanks for the idea. It looks like a great idea, but I can't figure out how to make it work. I have the function, the table & the query. What I can't figure is how to call the function, or where to place the last lines of code you provided: [Orders]![Date_Due_Refill] = DateAdd("m"...
  8. MHadden

    Looking for better coding advice

    Eupher, This will most likely prove to be the most helpful advice ever! Thanks so much for explaining this method. I will use it often, I'm sure. Thanks Lots! Michael MichaelHadden@yahoo.com If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given...
  9. MHadden

    Moving Cells via code?

    macropod, Thanks, you're right - this is much easier! Thanks for this method. I really do appreciate all of you that have helped! Thanks, Michael MichaelHadden@yahoo.com If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!
  10. MHadden

    Moving Cells via code?

    Both methods work great! Thank you both for the help. This is going to save me hours of work, I can't thank you enough! - Michael MichaelHadden@yahoo.com If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!
  11. MHadden

    Looking for better coding advice

    I got it! I changed the 6 to MonthsToAdd. The last line now reads [Orders]![Date_Due_Refill] = DateAdd("m", MonthsToAdd, [Orders]![Date_Last_Rec]) And it works perfectly! Thanks to both of you for taking the time to help! - Michael MichaelHadden@yahoo.com If you give someone a fish, you...
  12. MHadden

    Looking for better coding advice

    [Orders] is the subform that has the HCPC code & dates in it. The mainform has the customer information, including insurance info. Thanks for looking at this. I originally wanted to use a Select Case, but since I need to evaluate two criteria, I didn't think it was possible - then again, maybe...
  13. MHadden

    Looking for better coding advice

    Thanks for responding so quickly, I have tried it, but it keeps adding 6 months, no matter what the HCPC case is. To further clarify what I am trying to do, I need to evaluate whether the customer has medicare and receives a product with a certain HCPC code. Medicare has certain time limits on...
  14. MHadden

    Moving Cells via code?

    Hello All: I have an excel spreadsheet project that requires me to change the information from this format: Magnolia House 100 4th Ave W Oneonta AL 35121 St Martin's In The Pines 10 Woodside Dr Birmingham AL 35210 Shelby Ridge Nursing Home Rehab 1000 1st St N Alabaster AL 35007 To this...
  15. MHadden

    Looking for better coding advice

    Hello All: I need to evaluate 2 fields to add a certain # of days to a date due field. The code I am using works very well, but I will have to do this for several scenarios & thought there may be someone out there with a shorter / more efficient way of doing this. The code is below & thanks in...

Part and Inventory Search

Back
Top