Search results

  1. K

    How to round up field to 2 decimal places.

    Sorry if this has already been discussed on this forum, but I haven’t found it as yet. I am using Access 2013 and have 4 currency fields, the first 2 with amounts, the 3rd to calculate the tax owed on a calculation of these 2 fields and the 4th to calculate the total of the previous 3 fields. I...
  2. K

    Duplicate Record

    Hello All Please excuse me as I am a novice. I have searched the forum but need a little bit of extra help. I have an application form with a command button to duplicate a record (created from the wizard). All works well but users forget to change the date field to the current date, so I end...
  3. K

    Select criteria for report

    Hi All I have created a report based on a query based on 2 tables - one with client name & client id and the other with client visits eg date, details, invoice amt and paid etc. The report shows all clients with all client visits. I would like to select from a list box a single client and...
  4. K

    Merge Problem

    Hi All I am a big novice when it comes to access so please excuse my ignorance. I need to create a word template from a form created with a query. My problem is that I don't want the null fields to merge to the template (there can be up to 30 blank fields), currently the useres have to delete...
  5. K

    Help with auto filling fields on a form

    Hi I am a real novice at code but was wondering if anyone could help. I have a from called Forms Request with the following fields: Client (Combo Box), Address, Suburb, State, Post Code etc... I also have a table called Client with the following fields: Client Id:, Client:, Street Address...
Top Bottom