Search results

  1. T

    Highlighting fields that are null with a different color?

    Ok, I have three dates. I want it so that after I put a date in the first date box (No Show Date) the second date box (kept Date) turns yellow until it is filled in with a date at a later time. As soon as a date is entered into the second date bow, I want it to automatically return to the...
  2. T

    Yes I know this is the General baord, but nobody in query has helped.

    Whoa!!! You rock!!! Thank you so much!!!
  3. T

    Yes I know this is the General baord, but nobody in query has helped.

    Ok, you all have helped me so much in the past, and I thank you for it. I've got a new one. I have three dates in a querie. When you enter the first date (No Show Date), it automatically puts the third date (Due Date) at 30 days from then. The second date (Kept Date) is the date that hopefully...
  4. T

    Mile-O-Phile!!! Holy crap, I finally realized what you mean't by hot!!! It was a typ

    I hope my comment above didn't upset anyone. After posting this I realized I had forgotten the database link. :) :D :p
  5. T

    Mile-O-Phile!!! Holy crap, I finally realized what you mean't by hot!!! It was a typ

    Holy crap, I finally realized what you mean't by hot!!! It was a typo. Here it is again without the typo. Ok, you all have helped me so much in the past, and I thank you for it. I've got a new one. I have three dates in a querie. When you enter the first date (No Show Date), it...
  6. T

    Query to inform me of future appointments???

    Woo Hoo!!! I think I got it!!! THanks alot!!! Now I need to figure out how to get the database to automatically send me an email when ever one of these patients hits my query for an appointment in 5 days. Any help? I know I posted this question earlier, but I found the answer confusing. TD
  7. T

    Query to inform me of future appointments???

    Here, maybe this will work.
  8. T

    Query to inform me of future appointments???

    I tried to attach my database, but it said it was an invalid format. But here is a pic of the query.
  9. T

    Query to inform me of future appointments???

    Whoa Normalise??? Yes that is bascially how mine is setup. What actions must I take to Normalise it??? Thanks.
  10. T

    Query to inform me of future appointments???

    I copied and pasted it into my criteria, but i get nothing, what am I doing wrong. Did I need to make a different query from the one I already have???
  11. T

    Query to inform me of future appointments???

    What I need is to build a query, that when I open it shows me only the patients that will have an appointment 5 days from now. I already have a query built that when I put in the first appointment date it automatically sets up the dates for the next 8 appointments, but what I need is for it to...
  12. T

    Email notification from database?

    I need my database to send me an email notifying me of certain individuals five days before a scheduled appointment. Basically, I want to receive an email stating the names of individuals that will have an appointment 5 days from now. I currently have a query setup with that will automatically...
  13. T

    Email notification from database?

    I need my database to send me an email notifying me of certain individuals five days before a scheduled appointment. Basically, I want to receive an email stating the names of individuals that will have an appointment 5 days from now. I currently have a query setup with that will automatically...
  14. T

    How do I get the database to notify me with an email???

    I need my database to send me an email notifying me of certain individuals five days before a scheduled appointment. Basically, I want to receive an email stating the names of individuals that will have an appointment 5 days from now. I currently have a query setup with that will automatically...
  15. T

    Getting one date field to project a year later on another field???

    I have one field with dates on it, I want another field to be the result of the first field plus 365 days later. Not sure how to go about this, if someone could help I'd greatly appreciate it!!! thanks:)
  16. T

    Query that only looks for month/year????

    Woo Hoo!!! Thanks Cosmos75, it's works great!!!! TDS
  17. T

    Query for finding matching months?

    I want to create a query that finds the matching month, for example I type in jun or mar, and it finds all the records that match that? TDS
Back
Top Bottom