Search results

Well that worked but I changed the date to 1900. That was before the club was in existence. Only problem is that when I put in a date for a payment for that member, it won't update the screen till you hit quit then open it again. That is OK though.

Got the #ERROR message but the others with dates in them are ok.

OK, I see now. If there is no date for any year in the dues, it says Error. It would be nice to do something like 00/00/0000 if they have never paid. Although, I am not the treasurer. She will have to put the dates in.

I'm still getting the same error. The field it should be putting it in is the Last Paid which is under the Joined label. I must be missing something.

Here it is. I have 2 records in it. Both should show 2015 as the last dues paid. Feel free to play with it. The actual database with 140+ records was not sent. I just saved it as this file then deleted all but two records.

=DMax("DatePaid","Dues","RosterID = " & [Forms]![Dues]![RosterID]) gives me the same error. I am putting this in a field on a form that is not part of the Roster table. I am putting it in the Data Control Source using the ... part that brings up the expression builder. Is that the...

I changed it to =DLookUp("DatePaid","Dues","Criteria = #" & [Forms]![Dues]![RosterID] & "#") and still get the same error.

I am getting #Name? in the field. my control source on the form looks like =DLookUp("DatePaid","Dues","Criteria = #" & [Forms]![Dues]![DatePaid] & "#") Am I putting it in the wrong place or improper syntax?

It needs to show the max date for each member as their record is pulled up in the Look Up form. I am not clear on just how to put it in.

Windows 7 Access 2007 I have a form that I want to put a calculated date in. The value is based on a table called Dues, and is the max date for the DatePaid field in the Dues table. The value is not to be editable and I don't want to run a query to get it. The purpose of the field is to...

Hummm, That has definite possibilities! Thanks :)

Yeo. Now I only have two more problems to fix!:)

Thanks. I discovered that but I can't do that readily due to spacing and form flow. I did, however, discover a work around. After selecting the change from the pull down, click on it to turn it black and it works! :)

In my sample, under edit in the switchboard, the Class, ARRL, ARES, RACES, and Skywarn fields are drop down (Value List) items. They won't stay changed.

That didn't do it.

All of a sudden all of my dropdown boxes will not update. I update them, go to the next record then come back and they are just as they were before updating. This happens when I run look up. Anyone have an idea why? I have included a sample.

All of a sudden all of my dropdown boxes will not update. I update them, go to the next record then come back and they are just as they were before updating. This happens when I run look up. Anyone have an idea why?

I don't want to run a query every time I want that info. Can I make it part of a table?

I have a need to get the most recent date from one record and put it in another record. The tables are linked. I don't want to run a query every time the date is needed. All I have been able to find requires a query. Is it possible to do this without running a query every time?

I'd say so. Now all I Have to do is figure out how to close this thread! :)