Search results

I know that has Data has been done to death but i need a little help with it. I feed a Report with a form that picks the dates a Between in each of two subreport's I need the report to only print the people with data in that range. It is currently showing all of the people with blank...

I have report with two subreports. The report is for tracking time off the Type of Time off is Value list "Vacation Approved, Vacation Denied, LOA Approved, LOA Denied, and LOW" my subreports count the History and the current and subtotal the information. One of the employees is being listed...

I have a main report with 2 sub reports. The report is set up as a date range in the Sub reports. somtimes there is no data in the range selected but the main report line still show. How can i get the report to not display the Main report lines if the subreports for that person are Null.

I don't know if this is possible. I would like to Put a List in my Querys criteria. The Current criteria is "Like [Department:]" is there a Way to have this call the Tables list of departments and make the Parameter entry box into a list with a drop down button? I might be out of my mind i...

I'm having problems with my date formats. I've entered into my tables and forms the format of "mmm-dd-yy" I'm assuming that this should display as month (3 digit), Day (2 num), Year (2 num). The problem i'm having is with one of my forms. when i enter the date it displays as Month, year, Day...

this is a bit of a mess please bear with me I have a report that uses values from a Query so far so good. now I have values in a second query (History) and I sumed a Count in that query in a Third query (Historysum). Now I set an unbound field in my report to "[Historysum]![SumOfCountOfTime...

I've set up a from with dates for Archive and Current date Information. I've entered the Follwing code for the Queries "Between ([Forms].[All Absent Data for Date Range].[Start Date Archive]) And ([Forms].[All Absent Data for Date Range].[End Date Archive])" this changes only slightly for...

Hello all i hope someone can help me with this? I've got a Report with 2 subreports. The main report has Employee Lastname, Firstname, department, and a non visable date field for a Between operation. The subreports list the Typeofabsence, count, absencedate, and comment for the History...

I have a Rolling Append and Delete Macro. It's set up as an Autoexec. How do I set it up to run regardless of whether or not the shift key is depressed. I'm currently stumped on this think it should be possable.

This is probably a stupid question and I think the answer is no but here it is. can you run a Access 2000 Db on 2000 and 97 at the same time without converting it endlessly. We have both versions floating around the office. some have 97 because the need it for specific applications. Any ideas...

I have a Query that is working Mostly. the problem stems from a Count Field. The Field in question has the Criteria "<Date()" the field is hovever not working for the only person who has days that meet the criteria and days that do not the Access is displaying the Total # Days? How do i get...

Sub Reports with Bettween I have 2 subreports from Querries that use a Between[start Date]And [end date]. so far it's working fine but is there a way to have the report only ask for the Date once. It currently ask's me twice. I know that it is asking for each subreport. do i need to put a...

I have a Report that Contains 2 sub reports. Is there a Vay to put one of of the values from the sub report into a unbound field on the Main report? The way things are listed right now the Main report lists FirstName, LastName, Vacationelegibity. The two sub repoorts List, Time Off History...

I've got a Form for Attendance entry and i need to populate the form from the Last Name field. I've got the list box to work on the last name but all it does is change my data. If I have Jane Doe listed and i pick Smith from the list box she become Jane Smith. How do I get the form to list...

Is it possable to link a Macro to a form so that when the form is opened the macro will run? I know that a button can be set up to do this But how would the other work. Would you set it up as a Macro to run a second Macro and then open the form?

This has probably been answered but I need to do a Rolling Append and Delete to the Month and Day. I've got the month allright but how do i modify it to account for the Day. Criteria - "=DateAdd("m",-4,Date())" Example as of today anything Nov 12, 03 or before shou;d be removed but i've...

I know this has probably been asked before but when it comes to hard coding i'm lost. I've got Three tables Table Fields Employee List : Employee #, lastname, firstname, vacation_days Time off history : Employee #, Timeoffbooked, Date_booked Time off booked : Employee...

I have 3 tables linked through the same Employee Id. two of the tables are for time off booked and time off history. the Time off data is in a list box one of the items on that list is "Vacation" is it possable to do a count of these entries on both tables and add them together on a report...

Arrgh This report is driving me nuts I've got most of it but these last two items are giving me headaches. I've got a report with sub reports for Time off. Time off current (TOC)is one sub report with attendant query Time off History (TOH)is the other sub report with it's attendant query...

I have an Append and Delete querry to run every day I know how to set this up, the question is how to I keep the data base from asking to confirm all the Appends and deletes. as it does when those are the only items in the macro. Thanks