Search results

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?

I have a table that has a list of tasks and checkboxes attached to them to be checked once the task is completed. I need to run a query on the table that will only bring me back the tasks with a completion that is false. Everything that I read online indicates that this is a difficult task...

Ok great. I will give it a shot. What exactly do you mean regarding using the sub procedure? Still fairly new at coding language and practice. It also seems you have advanced knowledge in coding. Could you recommend some resources for learning more VBA? Thanks!

If you were using a combo box for the product names, I could give you code that would populate the cost via an on change event for code builder. Its an option if you have no other.

In an access form, I have several checkboxes. There is one checkbox titled "Complete". The complete checkbox needs to be true only if all other "non master" checkboxes are true. If all of the non master checkboxes are not checked, I need the complete checkbox to be false. This is the code that I...

Hello everyone! Developing several access databases and very much interesting in using the forum to maximize the full potential of access through VBA code!