Recent content by dbar10

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.