Recent content by vickiwells

Is it possible to get the last edited date for a specific field, not the whole record?

How do I mark this as solved?

I think we've got it! You were right, I was using the "Value Is" instead of "Expression Is. It still wasn't working, so I tried using Nz, and it seems to be working. Thanks again for all the help!:) [CONCEPTUAL_LOCATION_STUDY_SD]<DateAdd("m",1,Date()) And Nz([CONCEPTUAL_LOCATION_STUDY_CD])=0

What I need is for the scheduled date to turn yellow if it's a month or less from today. Then when any date is actually entered in the completed date field I need the yellow to go away from the scheduled field. The expression below works if the completed date hasn't had anything deleted, but...

I need it to look for a date in the first field that's within a month of today's date, but color it only if the second field is blank. Yes, all the fields are in the same table.

You're right, I guess I know why that one didn't work!

I tried this and it didn't work. Did I do it right? DateAdd("m",1,Date()) And Len([CONCEPTUAL_LOCATION_STUDY_CD] & "">0)

I have a multi-value field in a simple data entry form. There's a combo box with dropdown for entering and then I have the value field next to it to show all the current entries. It works fine until I filter on any field, then I get the #Name? error in the value field. Can I fix this?

I have a date field I'm using conditional formatting in. Some of the conditions depend on whether there's any data in another field. It was working fine using ISBlank, until I deleted data from that field in one of the records. Now the formatting doesn't work for that record. What's the "status"...

I have a hyperlink field in a table that's used in various reports. I've edited the address in some of the records, but the change isn't reflected in the reports, they still show the old link. I used the Edit Hyperlink box that comes up when you right-click the field, and done Update All a dozen...

Thanks, but I already did that, that's how I got the table without the autonumber. But I think I just figured out the solution. Instead of using a query to append to the empty table structure, I used copy, paste, append to existing table. The autonumber stayed in the right order. Thanks for the...

I need to add an autonumber to existing data in a particular order in Access 2007. I've set the autonumber field to long integer, increment, no duplicates. Before adding the autonumber field my table is sorted in the order I need the autonumbers to be assigned, starting with 1. However, the...

I'm trying to use a subform to enter records,and I have my relationships or something messed up. I have 3 tables: Orders with fields Order # and other details, Products,with item # and description, and sales, with order#, Item# and description. The subform works fine as long as the item number...

No, the size is my problem. The report is on 11 x 17 paper, landscaped. That's why I can't use Printkey, the screen image isn't readable.

Is there any way to get the image of a report to another application? I can't use Print Screen because the page size is too big to get a readable copy. The exports to Word and Excel don't keep the formatting. I need an exact image of the report. The application I'm putting it in can use...