Search results

  1. C

    Pass selected value in list to text box

    I have two forms - Notes and JobLookup Notes contains a number of text boxes for entering data, one of them being for Job No. Beside it is a link to the form JobLookup. This form contains a simple listbox that lists all the job no. Is it possible to pass the selected job no from this list to the...
  2. C

    Check for duplicate and error message

    I have a form - see attached image. The first text box is called Job_No. When a number is entered here how can I check that the number doesn't already exist when the user tabs to the next box. Then if it does exist display a custom message to the effect "This already exists" and not the Access...
  3. C

    Prevent Insertion Of Blank Records

    I have a form that is opened by the following code: Private Sub Status_AfterUpdate() If Status.Value = "WIP - Snagged" Or Status.Value = "WIP - Suspended" Then DoCmd.OpenForm "NotesJobChanged", , , acFormAdd Forms!NotesJobChanged!txtJobNo.Value = Me!txtJobNo.Value...
  4. C

    Passing values between forms

    Ok this is probably easy for you guys but my knowledge of access is limited. I have two forms - Find Job and Notes On the Find Job form I have a text box called 'Job No' and a combo box called 'Status' that I have coded to open Notes if certain conditions are met. The code is Private Sub...
  5. C

    How do I ask user for extra info for report?

    Hi there, I have a report that's generated from a table which has data that has been imported from an Excel file. The report runs great but I'm wondering if it possible to ask the person running the report for extra information to add to the report? I would like the user to enter the month that...
Back
Top Bottom