Search results for query: *

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

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

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

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

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

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

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

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

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!

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!

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

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

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

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

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

To ALL - Thanks for responding!!! PHV - Thanks for the link, I'll see what they have. PSeale - Unfortunately, we are not using exchange & yes, it would be the best way to approach the problem. Skip - Sorry for the confusion. Until you mentioned it, I hadn't thought about how the Date / Time...

After re-reading my post, I realized that I left out the fact that I need this to work for dates, rather than times. most of our equip. will be loaned out for a 2 week period each time. I am still batting my head against a brick wall it seems. Thanks for any help... MichaelHadden@yahoo.com If...

Hello All! I have spent weeks trying to do this, then spent several days looking for shareware / freeware. I need a DBase to use for resource scheduling. I have certain pieces of serialized equipment that we loan out as needed, but we have had the problem of 2 people trying to loan out the last...

Thanks to both of you!! Skip's code did work, but only after I changed "IsVisible" to "Visible", like Roy-Vidar said to do. I haven't noticed a problem using SelText, so I didn't change it to Value, but I'm keeping an eye on it. Previously, when I tried it without specifying a property, it...

Greetings All: I have need to check a field to see if it contains the string "GEN" if it only contains this string the following code works great, however, almost all of the textboxes contain a 10 letter word & these three letters show up in some of them. I have tried many different variations...