Search results

BINGO! Tell him what he's won, Johnny! I was referencing the values in the fields in the original Table. Apparently it wants values from the current Form, which, of course refer back to the original Table. Well that ended two days of frustration. Thank you so much!

I changed the names of all the fields, buttons, and labels on the entire form and still have the #Name? error. Other ideas? Babe-in-the-woods

At the risk of sounding really dense, what are controls, and where do I change them? I just searched the MS Access Help file for Control and got a bazillion hits which seem to thread through every single aspect of the program. Can you narrow it down for me?

Surely this problem comes up more than I can find it when I search these archives. I want a field in a form to display whether folks have paid their dues (Yess) or are late (Noo). Here is the expression I built by selecting what I thought were the right elements from the Expression Builder...

I think I got it. I used the Help to look up Make-table Queries. I followed the directions, followed the false trail, came back to the main trail, skipped over the extraneous directions after trying them, and eventually got a table in the Table section that I can change the date types on. So...

Thanks again. That seemed to work except I cannot change the data types on the query. There seems to be a way to make a new table out of a query in the Access help section. My eyes are crossing right now from the late hour, so I'll check it out in the morning.

This sounds like what I'm looking for. Thanks. Couple more questions. So far, I think I can do that. Do you mean the "Design View," instead of "edit view?" Did I mention that I'm pretty dense on this stuff. The official database lexicon is trouble enough, please don't go using slang on...

First off, I'm not computer challenged at all, but I am completely database challenged. Even the "Databases For Dummies" books throw me for a loop, so please be patient with the way I ask this question. And if I don't understand the replies, I'll do my best to look up the words, but this stuff...