Search results

  1. A

    Copy autonumber to another field in same table

    I need to make changes to a table already containing data. Currently the autonumber field is simply there as a primary key, but I now wish to use it for another number field (Accession No) which was previously completed manually. As this doesn't seem possible or practical (as I need the...
  2. A

    Cascading combo box with conditional msgbox

    I am using the below sub to create a cascading combo box, which works fine. However, not every subject in tblsubjects has a subcategory, so I want a msgbox to appear only when there are subcategories to choose from. At the moment I am using If Me![Subject2] = "Dispute Resolution" Or...
  3. A

    Adding 3 weekdays to date

    I'm an Access novice! I have a table with a library loan date field defaulting with today's date and a due back field. I want the due back field to show a date 3 weekdays after the loan date. I've tried using DateAdd("w",3,Date()) but this just adds 3 days, not weekdays. Does anyone know how...
Back
Top Bottom