Search results for query: *

Thanks dhookom, you know sometimes just get too close to the forest to see the trees. I matched the date format on both the table and the form and it worked fine.

Can't seem to get my head around this one. I am upgrading a database that keeps track of employee attendance points. I have built a Macro that runs a series of queries to update records and such on an employees record. The problem I'm having is I have made a make table query to form the...

You were right they fixed the problem and all is well. Thanks

I am running Exchange 2003 on a Server 2003 machine. Recently have discovered that we had one customer that we could not send or receive emails from. I turned up SMTP logging and sent test to the customer and this is the error message that I got: Event Type: Error Event Source: SMTP Protocol...

Never mind, I found the problem. In the form date field I had formateed for short date with an input mask for a 2 digit year. Going back to the properties I found that in the format bbox it had been cleared after putting in the input mask. So I entered the short date format again and now it...

Yes the EHNOTTM.TRDATE is a date field. This is the date of the attendance infraction. The EMASTER.INACTIVE field is a Yes/No The Expr1 - Expr6 were setup by the person that originally built this database and are referred to in other places. Might be a little difficult to make any change to...

I am fine tuning a database for our HR person. I have run into a problem that has me stumped. I need for the query to return employee records for a date of an attendance offense and all records for events 365 days back. Below is what I have now, however Access says that the expression is too...

Thanks you PHV. I changed it to your suggestion but I am still getting the same error message. SELECT DISTINCTROW EMASTER.FILENO, EHNOTTM.TRDATE, EHNOTTM.REMARKS, EHNOTTM.ACODE, EHNOTTM.EXCEPTION, EHNOTTM.SEQ, EHNOTTM.ECODE, EHNOTTM.FMLATIME, EHNOTTM.OCC, EHNOTTM.HRSMISS, EHNOTTM.ROCC...

This is the query that is running the report: SELECT DISTINCTROW EMASTER.FILENO, EHNOTTM.TRDATE, EHNOTTM.REMARKS, EHNOTTM.ACODE, EHNOTTM.EXCEPTION, EHNOTTM.SEQ, EHNOTTM.ECODE, EHNOTTM.FMLATIME, EHNOTTM.OCC, EHNOTTM.HRSMISS, EHNOTTM.ROCC, EHNOTTM.TOCC, EHNOTTM.TERM, EMASTER.STATUS, EMASTER.NAME...

Between [Enter Report Date]-365 And [Enter Report Date]. This expression is too complex according to access

Reportdate is [Enter Report Date;]. The value has to be entered twice?

I have a query field called TRDATE that is the date of an attendance offense. I need to retrieve all records based on the report date minus a year. Between Date()-365 And Date() doesn't work because my report date my be a week or more ago based on payroll periods. Please help. Thanks

Thanks randy, I see it now

I am writing a macro to SetValue in a field on my form. This will activate on the AfterUpdate event from the Verify checkbox. I believe this to be the expression I want but, for the life of me I can't get the syntax right. I've tried so many different combinations. I just keep getting the...

Oh gotcha. Thanks you very much for all your help. I think that sometimes I just get to overwhelmed and forget to step back and think it through "step by step". you have been a big help once again. I appreciate this site more than you know.

Thanks DHookum. My problem is I don't understand writing code that much. I've never had to go into it that deep. But, I guess I will do some research and see what I can figure out. So, the code that you wrote, does it just get a Sum of the hours worked up to that record? Is there a way for...

I have a macro assigned to the AfterUpdate of SchedSearchList!ScheduleWorkerfrm!Form.TextStart and TextEnd and Verify. This is assigning the hours worked to Schedule1.HoursWorked just fine. But when I run the code nothing happens at this point. Not getting any errors either. Should it work...

DHookum, I have been working with this and this is what I have done. In the Schedule1 table I added: HoursWorked double RegHrs Double OTHrs Double RegHrsPaid Date 'these will be populated w/ Date() when Verified OTHoursPaid ShortDate From Forms!SchedSearchList...

dhookum, your code got me to thinking and I realized that I could use the query that pulls the schedule records put in some hidden calculation fields in the schedule record and then when click verify apply the results to the Shedule1 table. I will have to add to Schedule1 fields like HrsWorked...

dhookum, I need your help a little more if it's okay. Your idea is awesome but I need a little help. I am incorporating your code in the On Click command on the Verify check box on my scheduling screen. The Payroll clerk goes through the schedule and timecards when they are received and...