Search results

I got the 30 day to work. Now I'm trying to do another one for a year. I've tried Value<Dateadd(d,365,Date()) and Value<Dateadd(YYYY,1,Date()) And neither is working. What I am trying to do is conditional format a date that is over 1 year old. Any suggestions?

I have several forms in a navigation form. On all the forms, the little search bar at the bottom shows # of 103 records. On my navigation form it shows 1 of 1 and won't allow me to search. It would seem that the search bar is only looking at the current form and not at the records. Can...

I got it. I was over complicating it. Report On Load-Apply Filter-Filter Name(MyQuery) Where Condition=[Aerial Lift]=True Thanks for the help fellows.

I have a table. One of the fields in the table is Aerial Lift. It is a check box. I have a query that includes many fields including the Aerial Lift Check Box. I have a report named Aerial Lifts. What I would like to do is have the report check the query for the aerial lift box and that...

Here it is.

I'm still trying to learn to do this. I have built a completely different database and I think I'm ready to link them. I have 6 total tables. One is named Main - It has Name and other common information for each trainee. Each table has: 1. ID (Auto number) (Primary Key) 2. Foreign Key (on...

Ok guys, thanks. I'll make the adjustments

Thank you namliam. The format I use for date fields is the shortdate. 1/31/2014 If I'm going to use this same format in a text field, do I need to change all my date formats to YYYY/MM/DD or is there something I can add to the text field date to make it work? I actually thought about that...

I think I see what the problem is now. The 1/31/2014 dates that are formatting are text fields in my table. The ones that are not are Date/Time (short date). I had to set some fields to text so I could put "Exempt" in some of them. The ones that are not exempt have dates. What I don't...

It has something to do with the month of January. No matter what date I put in 1/?/2014, it formats it. It doesn't do February. Strange.

Tried the compact and repair. The dates are mostly the last day of a month. It's formatting 10/31/13 correctly, but it's also lighting up all the 1/31/2014, but nothing else in 2014.

I am doing multiple fields at the same time by the way.

Thanks CJ, Yes, I have Field Value Is less than DateAdd("d",30,Date()) Changing it from Now() to Date() did not make a difference

I have fields with expiration dates. I am attempting to conditional format them to show a color when the date is 30 days or less from today. I have: Value<=DateAdd("d",30,Now()) It's working bit it's also formatting all of the dates that are 1/31/2014 for some reason. Not any other 2014...

I have added all the topics and fields.

Did I do the value list correctly? If I understand correctly, I need a third table named audit to tie it all together?

This is what I have so far.

"FieldResult (define a value list NOT A LOOKUP to show the 4 values)" Could you give some further guidance on this part please.

Ok, I think I can do that. I'll be back. Many thanks.

I converted Issues Web Database template from 2010. I should be able to send it by email if somebody wants to put it up.