Recent content by dbowens

Hello All, I have a table of officials who have served my office in some capacity over several years. Each of them has a service history record. For instance: Person A served on 5/2/2010, 7/1/2013, 8/2/2014 Person B served on 5/2/2010 and has not served since I would like to be...

Here is a screen shot of the query in design view and datasheet

This seems to complex. I cannot get the Dlookup to work in the form. I need it to display the total to date for multiple contributors not just one. These are the formulas that I used. =DLookUp("[SumOfAmountofContribution]","ContributontoDate Query","[ContributorID] =...

Thanks. I am not sure how to use the dlookup function as I have never used it before. Could you provide more info (I checked out the instructions, but I am still a little unsure).

I have a contributor tracking table that is linked to a form of the same name. I created a make table from a query that calculates the total to date for each contributor (based on their contributor ID in the tracking table). I want to place this sum to date, in read only mode, on each...

There is a combination of checked and unchecked. I have attached a copy of the database if you would like to view it.

Below is the code from SQL view and it is not returning any results. SELECT Distinct ElectionNightReturns.Precinct, ElectionNightReturns.ConfirmedPCMCIACard, ElectionNightReturns.ConfirmedIVOMediaCard, ElectionNightReturns.ConfirmedIVOZeroResultsTape...

Bob this works great! Thanks so much for the lesson! You are the man :).

Bob, I have never really used this function before, but I would like to if you believe that it will be more reliable. Would the private sub name be a beforeupdate? I appreciate the guidance on this. Still learning.

Thanks for all the help. I will test that out rainlover. To answer your question Jdraw, I have a form that has 9 different tasks that need to be verified. The tenth field is a complete field. The complete field will only populate as true if all other task fields are populated as true. If all are...

Thanks. So if I have more than two non master checkboxes could I continue like this: If Me.Checkbox1 And Me.Checkbox2 And me.Checkbox3 and me.Checkbox4 Then me.completed=True ElseIf Not Me.Checkbox1 And Not Me.CheckBox2 and not me.Checkbox3 and not me.checkbox4 Then...

This is the SQL: SELECT [Election Night Returns].[Confirmed PCMCIA Card], [Election Night Returns].[Confirmed IVO Media Card], [Election Night Returns].[Confirmed IVO Zero Results Tape], [Election Night Returns].[Confirmed IVO Results Tape], [Election Night Returns].[Confirmed M100 Zero Results...

Still having issues with this. I need to only see where the values are false. If I use the structure you suggested, the query brings back all yes/no fields regardless of whether they are true or false.

Perfect. Thanks man. Learning more everyday.

Thanks. If I place "false" in all of the criteria fields, access brings back no values in the query. Every field that is selected in the query would have to be equal to false. Any other suggestions?