Search results

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

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

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?

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

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

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

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