Prohibit change on SOME fields after record is created
I tried to lock the field, but upon locking you can't even enter NEW data.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Now I would like that when I create a new record in tblProductions,
that automatically a new record with the same ID will be created in
Till now, this does not happen, and I guess it is because mostly none of
the fields of tblPlanning are filled in (except for ID, of course). However,
even if the fields are empty I would still like to have a record for every ID
I would like that if I change one of the text fields (it does not matter to what I change it to, just simply change it) another field must also be changed, otherwise the record will not be updated
So eg. if I change the Comment field, I would need to change the Date field as well, otherwise I cant move to the next record
I've created a check field (varCount) to verify if the record already exists so I know it's finding the information, but it won't change focus to the existing record.
I have a table that contains some base information used in pricing parts for various customers. (table SetupData)
Everytime there is a price increase or change of terms I add a new record to the table and move my 'current record' flag (Yes/No) to the new one.
In one instance this change only requires a date and percentage changed and I want to progamatically add the record.
This means, copy of last 'current record' data into the new record, update the date and % fields in the new record to ones provided on a form, and then change the 'current record' flag to this new record.
Using a Recordset seems the best way to .AddNew but how can I copy the last current record into it
Also if I close the form and reopen it those same fields still have the back color changed. Is there a way to fix this?
I have received the error again, but I am a bit stuck this time. It looks like a number of my records are too large and unfortunately they have child records, so I can't just delete them. I can't change the records as I just get the same message again and I can't change more text fields to memo fields as I get the same message.
Is there any way round this? Would it help to split the main table into 2 smaller tables?
I had a form that have a command button to add a record, but I need it to change a value on another record from another table. So when I click the add record button not only new record created but it also change the value on another table.
In my case when I add a new record from that form I also want to change another record value from default value "available" to become "Unavailable" automatically
Am I on the right path or is there an easier way?