Search results

I have a report set up and I can successfully format all returned rows for a given column as I want them. However, what I want to do is only format the latest row on the report. The table that the record comes from does include an End_Date field which is also populated on the row, and the data...

Hello - I am stuck with trying to accomplish the following and was hoping for some assistance! I have a report which I would like to change the text of a field blue if a certain condition is met. What I want to happen on this report is if a specific field has an "Active" - then it will be in...

Does anyone know of a way to compare values in two cells and determine if there is only a character or two difference? I've been asked to find a way to compare two addresses and identify if they are minutely different, such as: 123 Main St vs 123 Main Str They want to be able to easily...

OK - this is probably going to be so simple I am going to slap myself in the face when I get the answer, but for the life of me I can not get this to work. What I need is basically a mask to always make the year in a date field 2013. What I have done is used an Input Mask on Short Date of...

I am putting together a basic document management database which the main purpose will be to locate where documents are at - the actual documents will be stored on a network drive, to which there will be a hyperlink in Access to the document. The problem that I am having with this is coming...

Hello - I have some fields that are only visible when a specific Reason is selected from a combo box. This part of the form is working fine. My issue is, the Reason has to be selected by mouse for it to work. If I tab over to that field if I enter the the letter 'N' to go to the selection I...

Hi everyone and thanks in advance for any assistance. Here is my situation - I left an area which I had made a database for them to track information in. The person whom I handed the database over to decided it was a good idea to tell the users that they can hold down shift when they open the...

Hello, I am working on a Query that will run, and once it does it will change the value of a Yes/No box from "Yes" to "No" I have everything set up and working as I require except for the change part. What I have been trying so far as part of the Macro to run the report is: Action ...

Hello, I have a macro in which one of the things it does is to delete every record on a table. The deletion confirmation warning pops up every time and I can't find a way to stop it. Is there a way to disable that warning, or make the macro tell it yes every time? Thank you!