Search results

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

Thanks, I think that may have done it. It didn't fix the existing query, but when I started a new one, it worked correctly.

The joins are automatic, they are joined in the ODBC database. The number of records showing isn't the problem, it's the number of fields. I'm only using 4 fields from the tables, but 50 or more show up in the datasheet.

I have three ODBC tables linked to my database. When I use them in a query, the datasheet shows all the fields in the table, not just the ones I selected. None of my other linked tables (dbf and Excel do this).I'm now getting the error " Too many fields defined" when I run the query,and wonder...

Rich, I might never have expected Access to provide an easier way do this apparently gargantuan task if it weren't for the fact that my previous database software (Approach, also a relational database) managed it without any effort on my part at all. If forms were properly joined, I could...

I have a text box which is large enough to accomodate 3 lines of text if necessary. However,the word wrap doesn't always work right. On some records it cuts off (doesn't print)part of a word that should have been wrapped to the next line. On other records it works fine. Any ideas why this happens?