Recent content by janfolmer

Hi Keith, Great, that was the solution, thanks

I emptied the whole database, and named it test. You can see in my userface what my struggle is. You can have a look around, ..

Hi Ken, I did that, I'm saying that I only get notified (in case of a duplication) when I completed my whole form with 9 fields. I want to get a message as soon as I entered the first field, the PolicyNumber field. The table already does not accept dublications.

Hi There, I use a form to add data to a table. The first field in my form (PolicyNumber) must check the entered value in the form directly from the table. *(Now it notifies me when I completed all the other fields in the form and when I ready to add this as a new record in the table). I tried...

Hi There, I found this neat from design which flicks between different form shown in an unbound area. I posted a sample db, as I experience difficulties to get the correct link to a form from a query. I have been referred to this page: http://www.mvps.org/access/forms/frm0031.htm and I tried...

Hi There, I have a form with a search field for an unique field, that looks up records in the table that belong to that unique field. See Code: Private Sub cboLastName1_AfterUpdate() On Error Resume Next Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String...

Thanks a lot, exactly what I was trying to find out!

Hi There, I was wondering, in a form (to add records in the Table) with a date field, can I limit that field to only previous dates. This will reduce errors in the table, no future dates anymore. Thanks in advance,

Hi Neil, thanks a lot. Works like a charm

Perfect Neil, never thought of a query. Only when I add new employees, the query does not update automatically. Is there a way to update the query on adding one record in the main form?

Hi Neil, Thanks for your reply. The business process is as followed: I need to capture new employees in the table. For that I use that form. But I would like to see the 3 last added employees. So in that subform, I can quickly see the last three added records in the table, just for checking...

Hi There, I have got this form, consisting of 1 form (that needs to add a new record to a table everytime) and 1 subform, that needs to show the last three records of the table. My problem is that I cannot get it right, now both forms (form and subform) are showing the details on just one...

Just saw that I posted the comment twice, sorry

Ok, I moved it (the whole event) to OnPrint. It's working now, partially, as now the totals of just the first page (of a 3 paged report) are summed up. How can I include the other pages into the total in the report header?

Ok, everything, that is, the whole event, is moved to OnPrint. Now it's printing correctly, but it only takes the totals of the first page of the report. So that code is working, only... How can I get it to a total for all the pages?