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...

Maybe I am looking in the wrong place, but I cannot find anything about master/child links in the form property sheet. I select my form than go to view, properties. I have the "all" tab selected, but still cannot find anything. Where is this master/child property?

I think so. I have the autonumber primary key in the main table linked to a primary key number field in the sub-table.

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...

Yep, thanks. I had to go back to the initial form that the subform is based on, but it worked. Thanks for the tip.

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.

So how can I get around the limitation of 255 fields on one form? Will a sub-form work for that?

Is that readsource created by the query a "hidden" table? In, other words, is there still the limit of 255 fields using this method?

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...

Alright, I will try to be more specific. I have several patients. The patient is the only person I have any personal information on (name, address, etc.) (So even if a relative would become a patient later, it would not matter.) For confidentiality reasons, the name of the patient and other...

I had actually tried this before and when I tried it again, I got the same result. When I try to enter text into that field that i have done your suggestion to in form view, I get the "error ding" and a message at the bottom that says "Control can't be edited; it's bound to the expression...

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...