Search results

The tables do need to be separate. I cannot post my entire database due to size and confidentiality reasons. I think I have fixed the relationships, but the subform is still not working. Does anyone know how to fix it? Thanks

Relationships How can I change the relationship from 'one to one' to 'one to many'?

Database Example See attached for example of problem

I tried that If I remove the Header portion the subform appears blank when I return to form view. It also give the error: The text you entered isn't an item in the list. Select an item from the list or test that matches an item on the list.

Master/Child Properties My field properties are set as such: Source Object: Pro1-1ASTM Link Child Field: RID Link Master Fields: Header.RID Enabled: Yes Locked: No (see attached picture) I tried changing the master field link to just RID, but when I switch from design view to form view the...

I have a subform in a form. I have linked the forms together with a common field. Whenever one clicks into the subform, they receive this error message: The LinkMasterFields property setting has produced this error: 'The object doesn't contain automation object 'subform_name." Please help me...

I have dug a little deeper into the problem. I no longer think the record is not saving in the form. The records are just out of order. How can I control the record order?

I appoligize for my Access vocabulary not being quite up to par. I am opening the form from the forms tab on the database window.

I have a form with 100 records. I create a new record each day. Sometimes I need to reference an old record so I scroll back in the form for find the record I am looking for. I have recently created a new form. This form allows me to create a new record, but if I close out the form and...

My data entry is set to NO, but I don't think that is causing the problem. I want to be able to enter data on a new form but also be able to scroll through and view historic forms. My current problem is I am able to fill out a new form but once you click off of it, you cannot return to it even...

I have recently created a new form that saves data to three different tables. I can enter information into the form, when I close the form I do not get an error message. When I reopen the form, however, the record is not there. The information was saved to all three tables. Why is the form...

Two questions: 1) I have created a new form to replace an old form. However, I am a little nervous about deleting the old form. Is there a way I can hide it or move it so it doesn't confuse my data entry technicians (they are very easy to confuse). 2) I have a drop down list on a form which...

Not Quite I don't think I was specific enough with my question. I want to insert a different picture into each form screen. Kind of like a field entry area. The attached picture is what I am seeing.

I want to insert pictures into forms. I don't want to use links, the image must appear on the form. I created an OLE but when I insert the picture it appears very small with the file name underneath it. The icon box was not selected during the insertion procedure. I am using bitmap files, I...

In the future should I create relationships in the Forms/Queries database, the Tables database, or both are the same?

I have two databases, one containing the tables and one containing the forms and queries. The forms/query database is built from linked tables from the tables database. I would like to expand one of the fields from 7 characters to 9 characters. I planned on doing the in the table database...

My users have to fill out a work request form. Lately I have been having problems with a few users copying over forms they shouldn't. Is there a way I can lock out or freeze past forms? In other words, the form the user is filling out freezes when the form is closed. I also need past forms...

Thank you, However Thank you for the help and the pointers on relationship links, however, the form you created still uses a subform. I have a database full of forms that do not use subforms, I would attach one to show you except I can't compress it enough to upload. However, if I have not...

I have attached an over-simplified version of what I have been working on. I would like to create a single form with fields from two tables. I do not want to use a subform. So far I have been able to create and view my desired form, but I cannot type in all the fields. Any ideas or...

The tables are related. I do not want to use subforms. I know there is a way to do it without them, I have been working with a database that is full of them.