Recent content by mg55345

I am having problems with duplicate records in a query. The reason for this is hard to explain and it's a very complciated database. I do not want to get rid of the "duplicate entries" (they aren't, really), but I do want to remove them from my report. What can I do in a query to limit the...

Thanks, John. I am unable to get it to work. I made some minor changes. Would you mind taking a look at it again to see if any stands out? If ((DateDiff("yyyy", [ArrestedDOB], Now()) + Int(Format(Now(), "mmdd") < Format([ArrestedDOB], "mmdd"))) > 18) Then Me.ArrestedJuvenileAdult.Value =...

Hi everyone, I am looking for help on how to select a value based on the value of a calculated field. If you look at the attached screenshot you will see a form. After the user enters DOB (date of birth), Age ([ArrestedAge]) is calculated based on the following control source...

Nevermind, I think I figured it out. Thanks for the code.

I am not using VBA, I am just using Macro designer. How would I do this? Thanks.

Hi, I have a form with a button w/ macro which generates a report based on the entry currently shown in the form. Think of it as a "generate order receipt" function. I am experiencing problems with data not being updated in the table when a user clicks on the button to generate a report. Not...

Weird... but that worked! Got it. Thanks so much!

Hi, When trying to delete an old field I don't need anymore, I get this error message: "You can't delete the field 'FieldName' It is part of one or more relationships. If you want to delete this field, first delete its relationships in the Relationships window." The problem is, when...

This works perfectly. I hadn't thought of needing to do this in the report itself. Thanks Rookie!

Hi, I am having problems with an Access form. I want to pass a value on to a report that uses 4 different queries to be generated. As you can see in this image, the Printer icon button in the corner launches a report I created. I created this with a very simple macro: As it is...

Thanks, Bob, that is very helpful. In doing so, however, what is the best way to create a form in Access so that novice users can add and delete counties for organizations without having to enter the jointer table to do this?

Hi, I am experiencing some confusion in setting up a many-to-many relational database, and I would greatly appreciate any assistance that anyone may have to offer. Currently, I have two tables: one which is a last of organizations provided services, and the second table is a list of counties...