Search results

  1. M

    Using checkboxes to select query parameters

    Hi all, I have two tables, let's say A and B. Table A contains a number of Yes/No fields while Table B has text fields that contain various statuses. Tables A and B are linked via the status field. I also have a form on which I have multiple checkboxes so that a user can select a which Yes/No...
  2. M

    How to export data in a subform to Excel

    Hello, I have been on several forums, but haven't quite yet managed to crack this one. I think I am also getting tied up because of the Navigation Form. What I am trying to do is export the data contained in an unbound subform that displays data based on parameters that a user has entered on...
  3. M

    Solved Block If without End If

    Hi all, I have a form with two option buttons (RentCharge and OtherCharge). I have code that clears OtherCharge when RentCharge is selected and vice versa. When I click the save button on the form, I have code that runs a series of checks - below. Unfortunately, I get the Block End without...
  4. M

    Unbound control causing grief when executing query

    Hi, Hoping someone can assist with this one that has been bugging me. I have a form on which the user enters a date range before executing a query and showing a report. I have added VBA to ensure the user enters the start date and finish date as well as checking the start date is before the...
  5. M

    DLookup function in Query

    Hi, I have a table 'WeeklyRentHistory' that I want to search using DLookup to return an amount. The amount is determined by using the StartDate from the table 'WeeklyRentCharge' and comparing it to the EffectiveFrom and EffectiveTo dates in the 'WeeklyRentCharge' table. For example, I might...
  6. M

    Automatically adding new records based on date

    Hi, I am creating a database to keep track of rental payments. Somehow, I want to be able to automatically create a new record that will charge the tenant the weekly rent which is based on a start date. For example: Start Date = 01/01/2017 Rent = $200 per week On 01/01/2017, I would like to...
  7. M

    Running a sub on a newly opened form

    Hi, Attempts to find an answer to this have been unsuccessful thus far, so hopefully someone can assist here. I have a form 'Lodgers' open and I open a form 'Payments' using the cmdAddNewPayment button. At the same time, I want to execute the cmdEditPayment sub when the form 'Payments' opens...
  8. M

    Runtime Error 3464 - Data Type Mismatch in Criteria Expression

    Hi, My name is Matt from Perth, Western Australia and I am new to this forum, but have used it many times to seek out advice. Hopefully, someone can point me in the right direction here. I am using Access 2010 and have setup a Navigation Form (named NavigationForm) with a number of...
Top Bottom