Search results

  1. B

    Question about best practice on overwriting records vs deleting records

    I have a database tracking various audio, video and network connections. Each cable is identified with an alphanumeric code that consists of a 3 characters and a four digit number, the source and destination of the cable and the equipment that is connected by the cable. Currently, our...
  2. B

    Solved Filtering Forms Based on a Calculated Field

    In my database, I have a form titled frmEquipTrack that has a calculated field titled txtMainDueDate that is supposed to be the date that a piece of equipment is supposed to be serviced by. When I I am trying to filter the forms by the date in the txtMainDueDate field so that I only get records...
  3. B

    Filtering Forms Based on the condition of two check boxes

    I am trying to filter forms based on the value of two check boxes. I have a check box called activeEquipment on a form that I am using to track if a piece of equipment is being actively used. The value of the box is True if the Piece of Equipment is being used and false when the equipment has...
  4. B

    Solved Creating Function To Lock Text Boxes and Combo Boxes When A Form Loads

    I have two forms where I would like to have the combo boxes and text boxes based on how a user opens the form. Since I have two forms, I thought that I would write a function but I am having issues. First off, I know that my code in the function to lock the text box is wrong, but I can get the...
  5. B

    Solved Checking for duplicate data on a form against data in a query

    I am working on a database that will be used to keep track of various cable that are used to connect equipment. The cables are broken down in to cable categories and then by cable numbers. And I need to avoid duplicate cable numbers. I have a query that is based of a table called...
  6. B

    Solved Importing records from Old Access Database into Access 365

    I am trying to re-create a database for equipment tracking at my work. The problem that I am not sure how to handle is importing some of the data from the old database into the new database. The old database has four tables that I have to get data from but some of the data that I need from each...
Back
Top Bottom