Search results

I didn't know I could do subreports. That did it. Thanks!

You were right about the floating values. I thought I had gotten them all on a visual check. I thought there was a way to create an unmatched query, but I had forgotten how to do it. That caught the remaining orphans. Thanks!

It took me a while, but I finally figured out why I was having trouble getting this to work. I was trying to set the BeforeUpdate property for the [last_update] field rather than for the form itself. Thanks again for your help!

UPDATE: I finally figured out how to do what I want with a query, so that the preferred name comes out on the reports. That's really the only place that it mattered, anyway. Thanks for all your help on this!

ROTFL!!!! Thanks for this little comment! It made my day!

They're both long ints. I have an autonumbered ID field in the Members table that is used as the related field in the subordinate tables. Why it's working with one subordinate table but not the other two is beyond me.

I understand what you're saying. I do have a fair amount of experience with relational databases in general, but I'm pretty much at the bottom of the learning curve with respect to Access itself. I haven't messed with the forms much because, up 'til now, the hassle just wasn't worth it. I...

So what you're saying is that my two choices are to create a form and use the form to update the change date, or to manually change the date in the table. Is that correct? In this case, I'm the only user, so no harm done.

I just read in another thread about enforcing referential integrity between tables so that deleting a record in a primary table won't leave orphans in a subordinate table. I was able to edit the relationship for one subordinate table to enforce referential integrity (cascade update and cascade...

Hmmm. . . I'm going to have to chew on that one a bit. Do I need to set up a form in order for the preferred name to default to the first name for new records?

I haven't even bothered with setting up forms yet--just the tables. Do I need to set up a form in order to do this? I have that set up as the default in the table design, but it applies for only new records, not existing records that have been changed. FYI, this field is has a date/time...

I have a membership database. The names and addresses are in the Members table, and I have three other tables (linked by a membership number) for email addresses, phone numbers, and notes. These are set up in the Members table as subdatasheets. I have these additional tables so that I can...

How do I set up a date field so that it changes to the current date whenever any other field in the record is changed?

I have a membership database. A number of members go by their middle names or a nickname rather than their first name. I need to keep track of their real full names, but I want the new-record default of the preferred name field to equal the contents of the first name field. How do I set this...