Search results

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

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

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

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

I have a report, based on 2 queries. As you can see in the attachment I have ShopID header, and a report is mostly reporting for 8-9 shops. In that specific query I entered: Between [StartDate] and [EndDate]. The annoying thing is, every time I create a report, it asks me for the StartDate...

When I add something in a table using a form, I always want an automatic date, namely today's date. So I set this in the form with NOW (). The only thing is, when I view my records a day later, it automatically adjusts the dates. I don't want to type in the date every time, because it's always...

I have 3 tables in my database; 1) Policies, 2) Salespeople and 3) Shops. We have a several shops, and each shop has their own salespeople. In the table Policies we have to select the shop where the policy is sold, but also the salesperson that made that sale. As soon as we receive a policy from...