problem entering new record

edo janssen

Registered User.
Local time
Today, 05:28
Joined
Oct 29, 2010
Messages
16
When I add a new record by pushing the button 'nieuwe vergadering' on form frmOBNCieOvz I'm not able to enter data into it.

Who can help me out?
 

Attachments

Last edited:
There's a language problem here, of course, that makes following things somewhat difficult, but I'm guessing that 'nieuwe vergadering' means 'enter new record;' is that right?

At any rate, I can't find any button named 'nieuwe vergadering' on this form, nor is there the Access native 'Add Record' button on frmOBNCieOvz.

There is a native Add Record on the Subform, sfrmOBNCieOvz, and the reason that you cannot add Records (or edit, for that matter) is that on this Subform is that the Controls named DTLidNaam, Formulier and Deelname each have their Locked Properties set to Yes.

Just out of curiosity, what language are we dealing with here?

Linq ;0>
 
My apologies, i added the wrong db. Right db is added now.

About the language, some words are in dutch.
 
Thought it was Dutch but have never dealt with it before!

So we now have the correct db, but the problem remains the same! On the form sfrmOBNCieOvz,
  • The Control named DTLidNaam has its Locked Property set to Yes.
  • The Control named Formulier has Properties Locked set to Yes and Enabled set to No
  • The Control named Deelname has Properties Locked set to Yes and Enabled set to No

If you go in and set each of these Controls' Properties to the opposite setting they're now set at, you'll be able to add new records.

Linq ;0)>
 
Hi missinglinq,

The problem starts on frmOBNCie itself. When adding a new record I'm not able to enter data in the fields Datum, DT and Locatie. The settings on the sfrmOBNCie are right. The users may not alter the data in those fields.
 
It helps to know which Controls were being the problem. Language is still a problem in following your code, but I've at least located your problem, I think. The following code is locking the Controls in question

Code:
Private Sub Form_Open(Cancel As Integer)
    'Call fMaximaliseer
        If Me.Gefaktureerd = True Then
            Me.Bijschrift18.Visible = True
            Me.sfrmOBNCie.Locked = True
            Me.Datum.Locked = True
            Me.DT.Locked = True
            Me.Locatie.Locked = True
            Me.cmdToevoegen.Enabled = False
        Else
            Me.Bijschrift18.Visible = False
        End If
End Sub
When you place this kind of code in the Form_Open or Form_Load events, it uses the Values of the First Record when the RecordSet loads. My guess is, on the First Record, that Me.Gefaktureerd = True, and so the Controls are being Locked when the Form Opens.

Move the above code to the Form_Current event and it should work when entering a New Record. You might have to include code in the Else clause to set each of the Control Locked Properties to False when Me.Gefaktureerd <> True.

Linq ;0)>
 

Users who are viewing this thread

Back
Top Bottom