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...
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...
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...
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.
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.
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...
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)...
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...
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...
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.
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.