Search results

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?

Hi There, I have one Access Report, that calculates the totals on bonuses and places that on top of the report. See sample Attachment Now, when I run the Report, nothing is wrong, it shows me the right number. As soon as I print it, is shows me an incorrect (most of the time double) and...

Got it, thanks!

Hi There, I tried the following to get this month/year automatically shown in my report (shown as the name i.e February 2006). This is what I tried. = MonthName(Month(Now()) -> did not return any value. I tried with the expression builder: Month («number») What do I need to fill in this...

Hi there, I have a form (Access 2003) that creates a report which is based on a query. This form was working fine when I had to manually put in the dates, but after creating a pop up calendar to choose the dates from, the report can not be created because the values are empty. This only happens...

Hi Psilolkan, Did that (your assumptions on calling the report via a form are correct), and it hides the form, but I still get the same bug: "the 'Run-time Error '2427' You entered an expression that has no value" I tried it with Bangs instead of periods and made sure the textbox names are...