Search results

I am trying to add a "find record" button to a form. I just used the command button wizard to make one. It works fine to locate a record with a certain value in a selected field in the main form, but it does not work in the subform. If I select a field in the sumform to search for a value in...

I have a subform set up inside of a main form in a one-to-one relationship with an autonumber as the primary keys in the main table and a number field as the related primary key in the secondary table. I have "cascade update related fields" and cascade delete related records checked." Every...

Is it possible to make a button in a form to delete an entire record? It would actually have delete rows from several tables, since each record is across multiple tables. Also if it could have a confirmation box such as "Are you sure you want to delete the entire record?" that would be great...

Is there a way to hide the controls at the bottom of a subform that allow a user to change records? I don't want the user to be able to change them manually, as this will cause problems. Thanks.

I have my database structure layed out, but I am having trouble making a form for it. If I use the form wizard to select fields from multiple, related tables it places them fine. And all the fields from all the tables show up in the field list box. But I need to know how to do this without the...

I am trying to build a database that ends up having well over 255 fields for each unique "ID #" (the primary key). I know Access won't let you build a table that large. I am sure the solution lies in making multiple, related tables; but I am stuck. I have made another table that uses the same...