Search results

??? Ok Rich that question throws me.... What i need the reports to show is the range of dates from a start date to an end date. The Database is split into Current 4 months and an archive for and data that is older than that. But the user needs to be able to check a Employees absence history...

Ok lets try this Ok my idea did'nt work like i thought it would. How does one set up the code in the form and the Query? I think i know how to set up the form but I don't know how to have that feed into the Queries, It would have to feed in to each subreport query right?

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

Try using a Filter If you filter the Data instead of finding the next button should move you between like records. It works for me I have a Employee Database and 3 employees with the same last name. hope this helps

That sounds very Pretty. I'll try it. I got things to work however with my own answer the non-visable date field in the Main report works. considering my users K.I.S.S. is the only way to go. :rolleyes:

What do I sound that stupid....:) No no no :) .....I tried to open it in 97 and the system could not find it. I stoped right there. :cool: I'll try that.

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.

OK the question then becomes...... ......How does one create a Frontend and backend? :confused: also my database is built in 2000, would that affect things?

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

Further Information Well on Further investigation all future dates are being regognized as being "<Date()" what criteria should I be using to avoid this problem? everthing else on my reports and queries work. This is the last thing i need to fix. this Datbase is for Time Off. On my report...

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

Question? Do you have an HoursWorked Field? If you do then you can eliminate the check box altogether and just run a Query for anyone that works over 10 hours.... I don't know much about conditional formating in access but this might help.

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

Figured it out I figured it out the Combo Box wizard was the way to go. I just told it to pick the record from the Combo Box Value. DuH i should have figured that out with out help. somtimes the brain just won't engage.

HasData Rich Ok i've tried searching HasData but nothing seems to match my problem. My sub reports are a list of Types of Time Off (vacation. LOA. LOW) and a count. With a Sum of the count in the Time Off Booked footer. I need to pull only the Vacation Sum from the footer and transfer it...

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?

Duh I should have seen that my self...:rolleyes: I'm kicking my self Thanks

now I'm stumped well now i understand what was wrong and I tried it. No datatype mismatch. but it still will not remove the Nov 1-11 entries. I know i've got at least 2 but the Query Appends 0 rows of data. should the -4 be inside the () ex. "Month(Date()-4))" or am I way off the mark?