Search results

  1. L

    Form Filter Printing

    Thanks to the help from the users on here I now have a working form that shows when a customers MOT is due based on Month Buttons. There is a report that prints MOT letters using the data from this. In order to print the letters you have to select a tick box for each customer you want to send...
  2. L

    General Code Question

    My programming skills are somewhat limited and I'm wondering if there is a better way of writing the following? I'm just interested to learn and make better code :) Private Sub Preview_Click() On Error GoTo Err_Preview_Click If IsNull([AccountCustomer]) Or [AccountCustomer] = "" Then...
  3. L

    Avoid/Prevent Can't Save Record Error Message

    Hi I have a form which is used to enter car parts, the form has a Save button and the X at the top right hand corner. I have the following code in place to make sure the user enters the required fields. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim msg As String, Style As Integer...
  4. L

    Combo Boxes for Dates

    Hi all I have a form where you select a customer, then type in the first day of the month you require and again for the end date. The problem is the user has to know how many days there are in the month which not everyone can remember. It's also a long winded way. I have an idea but not sure...
  5. L

    String Encryption

    Hi, This is my first post here so I'm hoping it's in the right place. Basically I have a Access application that I need to distribute to different customers, at present there is nothing stopping anyone from copying & pasting the file and editing whatever they feel like, stupid I know. What...
Back
Top Bottom