Topics Search

Allow Edits on Subform

Allow Edits on Subform
Views: 87
Just a quick question I hope. I am using this simple VB code (see attached) on a button to allow edits to a form. Problem is, clicking the button only allows edits to the form not the subform. How do I modify the code to allow edits to both please
Sponsored Links:

More topics

 

Forms! Allow Deletions/Edits - No

Preview
there, hope doing fine.

I have a main form with subform and looking lock the delections and edits but when I do that so subform is also locked and cant enter new data into it. I have done this for single form but with subform, dont know so far.

it is required bcz when ever open the form so bymistake the old data modified.
 

Cant edit subform of a subform

Preview
Hoping someone can help with what I need to do to allow the following to work:

I have a main formlinked to a subform, within the subform, I have a second subform.

I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second subform.

If I open the first subform directly without going into the main form, I have no problem entering data into the second subform.

All the properties are set to allow edits, allow additions, allow deletions
 

Subform goes out of touch when its table is edited?

Preview
I have an Access 2007 subform linked to the mainfor, and they were both working fine. it linked on the proper parent/child link, edits on the subform tracked the proper parent record, etc. etc.

Then I edited the table bound to the subform simply to make one of its text fields longer; that's all!

Now, data from the subform table does not show up in the subform at all.

I can still add a new record via the subform, but I will only be able to see it briefly (while initially entering it). if I go to a different mainform record and then return to the one that should have the new subtable record, again, it doesn't show.

However, looking directly at the table for the subform shows that the new record (and the old ones) are indeed still allproperly there in their table.
 

Deletions vs. Edits

Preview
Just when I think I'm getting it. I've got a form that I want to allow people to add or delete records, but NOT edit records. I thought that changing the Form properties to Allow Deletions and Allow Additions, but NOT Edits would do this. Silly me.

Is there a way to Allow Deletions without allowing Edits. I need to have some control over what's going in and out of the database.
 

Disallow edits to saved query

Preview
I have a subform bound to a query displaying in datasheet view, and I like the ability to use the built-in arrows in the field names to further filter and sort the query results. However, if I use a filter and then close the form, I get a pop-up asking if I want to save the changes to the query. I don't want the user to be able to change any of the queries. I tried using the 'enabled' property, but that makes the filter/sort unavailable. Is there some other way I can enable the filter/sort but not allow edits to the saved query?
 

Allowing edits in a query based datasheet

Preview
I have a datasheet that looks up data based on a query of two tables. The datasheet shows the data correctly, but it will not allow edits. I tried setting the data entry property to True but this had no effect. Also I was looking for the place where you can set the primary key for the form, but I could not find it. It would be good if edits were allowed on this form,
 

Replace Function with Table Lookup

Preview
I have several records that contain very similar substrings, such as "billable edits" and "edits- billable" that I am trying to standardize (make all "edits-billable" become "billable edits") for simplicity's sake. The challenge is that these substrings occur at the end of lengthy strings. I created a table with two fields, the current substrings and the substrings that I would like to replace them with. How can I connect this table, using a replace function, the edit the original strings? Or is there an alternate way to do this
 

Set subform AllowEdits property from another form

Preview
When my form that contains two subforms is opened from certain other forms, I want to disallow edits on one of the subforms and on the parent.

Docmd.openForm "ParentName"
Forms!ParentName.AllowEdits=False
This only works for the parent-the subforms still allow edits (something that affects totals on the Parent)

I added:
Forms!ParentName.Form.Child2Name.AllowEdits=False

which gives me an error message.

I am using A2007 with W7.
 

command button for allow edits

Preview
I want to emphasize users to be careful of editing data in a specific table, but I want them to be able to fix previous data entry errors.

I know I can go into the data tab of property and select "no" for 'Allow edits'. Is there a code or something I can put into a command button to change "Allow edits" to a "Yes'?

Or is there another strategy to limit accidental changes to data?

Btw, I'm still new to learning codes
 

Set subform AllowEdits property from another form

Preview
When my form that contains two subforms is opened from certain other forms, I want to disallow edits on one of the subforms and on the parent.
My code:

Docmd.openForm "ParentName"
Forms!ParentName.AllowEdits=False
This only works for the parent-the subforms still allow edits (something that affects totals on the Parent)

I added:
Forms!ParentName.Form.Child2Name.AllowEdits=False

which gives me an error message.

I am using A2007 with W7.

I know that I can open the whole form as read-only, but would like child1 to be available for editing. I have searched, and found things that I thought would apply, but am missing something.