Search results

  1. E

    update subform from form

    Hi John, Thanks for you input. I think the syntax is right. When I use msgbox to show the value of the syntax I get the value which belongs to the record on the subform.
  2. E

    update subform from form

    I have a form with a subform. On the mainform I have some buttons. When I select a record on the subform and then I push a button on the mainform I want the record on the subform be updated with the data I put into the inputbox. Below the code I already have to update the record on the...
  3. E

    DSum with empty field

    Yes, that's the trick. Thanks a lot!
  4. E

    DSum with empty field

    Already tried that, gave me #error, there's also a ) too much in the code.
  5. E

    DSum with empty field

    Hi Severin, Your sollution doesn't work. It gives a #name-error.
  6. E

    DSum with empty field

    I have a form on which plots are displayed by their owner. When you change a plot it gets an enddate and a new plot is created with the new data. On the form I want to show the state from January the 1st of the past three years. I do this with DSum. However, if a plot has no end date it is not...
  7. E

    problem entering new record

    That did the trick. Thanks for helping me out.
  8. E

    problem entering new record

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

    problem entering new record

    My apologies, i added the wrong db. Right db is added now. About the language, some words are in dutch.
  10. E

    problem entering new record

    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?
  11. E

    insert into problem

    I've build a db to calculate fee's for people who are present at meetings. It works fine but I want to add a function to afterwards add people to the meetings. Herefor I've build a searchfield on the form where I insert the meetings. What I want is that when I select a person in the searchlist...
  12. E

    sequential numbering

    Thanks John. Found the right code by myself. Broke the code into two parts. This is the right code SeqNum: DCount("[DTCieLid]";"tblOBNSpecVacRegel";"[DTCieLid] = " & [DTCieLid] & " AND [DTCie] = '" & [DTCie] & "' AND [Jaar] = " & [Jaar])-DCount("[DTCieLid]";"tblOBNSpecVacRegel";"[DTCieLid] = "...
  13. E

    type mismatch on cancel

    Thanks Paul, this problem is solved!
  14. E

    sequential numbering

    For my db I would like to have a query that generates a sequential numbering on multiple criteria. Now it only generated the seqnum for DTCieLid. DTCieRegelId - DTCieLid - DTCie - Jaar - SeqNum 1 - 55 - een - 2010 - 1 2 - 55 - twee - 2010 - 1 3 - 55 - een - 2010 - 2 4 - 55 - een - 2011 - 1 5 -...
  15. E

    type mismatch on cancel

    When I cancel the inputbox of if i leave the inputbox empty and click on OK I get a type mismatch error. The field OBNVac is a currency field. Who can help me out? Dim Controle As Integer Dim sInputE As Currency Controle = DLookup("OBNVac", "tblHeffingTarief", "Jaar = " & "[Tekst0]") If...
  16. E

    export to xml

    I build a module for creating invoices by batch. Now I want to automate the process to enter the invoices into our accountingprogram. Therefor I'm creating an xml-file. However I cannot get it right to put multiple invoices in it. The code so far: 'Private Sub Command33_Click() Sub...
Back
Top Bottom