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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sentra52

    Help with loop thru a form to apply timer function to multiple fields

    Here's my problem area. I got the text boxes on the form set up to project dates. In the first row of dates, when the required date = current date, It flashes off and on and the third date becomes visable.I'd like for this to happen for the next 2 rows of data (loop thru). I have a sample...
  2. Sentra52

    I got text to blink, but I need to apply action to multiple fields

    Sorry, I'm still learning and I tried to keep it short.I'd send an example, but I'm on vacation and I won't get back into the office until next week. My form tracks 250 individual's training. Each course has to be scheduled 30-90 days prior to the due date. My form for each person looks like...
  3. Sentra52

    I got text to blink, but I need to apply action to multiple fields

    I've researched and got my text to flash when the criteria is met ex(scheduled date = order date + 30 Then ...) the problem I'm having is that on my form, I have multiple dates for one person: Trainee Course InitDate SchedDate Due Date 001 350 30 Sep 02 30 Aug...
  4. Sentra52

    Calendar style report help

    I've got a query that pulls up individual data based on dates. Is thare a way to output this data onto a calendar type report? I can pull up individual calendars for each person, but i need a "master" calender for all monthly inputs for all the people.
  5. Sentra52

    Calendars-putting multiple inputs onto one

    I have set up a calendar system. I can pull up an individual calendar which shows what that persons monthly schedule is. What I need now is a way to make a "master Calendar" to show everyone's data on one. Any help would be greatly appreciated.
  6. Sentra52

    Email issue-invalid argument from code

    Oop! forgot...email to: witherst@yahoo.com
  7. Sentra52

    Email issue-invalid argument from code

    Hoooooorrrraaayyyyy! I've got a winner! Thank you very much. This will make a lot of people happy! We were manually doing alot of paperwork, tracking, and reporting. This will get 2 people out from behind desk and back on the planes....My Commander will "crap his pants"! His...
  8. Sentra52

    Email issue-invalid argument from code

    Thanks for the recommendations. I made the recommended changes but now I get "Object variable or with block variable not set" hermanlaksko, I had the form and record open to get visuals when the task was running because it get very noisy in my work area (Air Force Base Flightline)...
  9. Sentra52

    Email issue-invalid argument from code

    I'm just learning VBA so I am easily confused by it. I've designed a database which queries the main table looking for dates that are equal to the current date. I built a form and report based on this query. The email address is in the query, form, and report, but it varies depending on the...
  10. Sentra52

    Email to multiple people from address on report and automation

    That's what I am attempting now, but I am stuck trying to write the code. I'm not a programmer by trade, just stuck in this position temporarily due to maternity leaves. I have limited knowledge os access 2000 so I'm beating my head against the wall in between playing exec assistant and...
  11. Sentra52

    Email to multiple people from address on report and automation

    The problem with that is the people that I send reports to change daily depending upon the information in the report. Once the macro and query run, it generates a report for everyone that requires it that day. Only the names that need the report are there, not the entire email group.
  12. Sentra52

    Email to multiple people from address on report and automation

    I'm fairly new to Access so, please bear with me...I've set up my database and got it to output a report to my email using macros and queries . But what I really need is for the report to go to multiple people whose email addresses are on the report. This is a daily report and I need help to...
  13. Sentra52

    How to get access to auto email on a specific date

    I have my database set up to project employee performance evaluation dates at 6 month and yearly intervals. I would like to have access email the employee and his supervisor when the projected dates match the calander date
  14. Sentra52

    Projecting future dates

    I'm trying to get access to project future dates from the date i initially enter. For example, If I entered 6 Jan 2002, I would want one field to project out 3 months, another 6 months, and the third one year. Thanks in Advance

Part and Inventory Search

Back
Top