Search results

  1. A

    Editing a Linked Table

    Okay, I think I've done enough due diligence to ask this question. I need to know if there is a way to edit a linked table like deleting a row. I've done this to link the table: DoCmd.TransferDatabase acLink I've tried this to set the permission to ReadWrite: Const ReadOnly = 1 Set objFSO =...
  2. A

    Help inserting a table into a form using VBA

    I use a button to search and link to an .xlsm file, but after linking the file, I want to import the file into an existing form using VBA (instead of drag/drop into the form). Can someone please let me know the proper command to do this, i have looked everywhere online and cannot find it :banghead:
  3. A

    Syntax error When transferring records with checkbox filter

    For the life of me I can't figure this out :banghead: I'm trying to transfer records from a table in one subform to another subform (on same form) using a checkbox as a filter: Private Sub TransferAndReview_Click() Dim db As dao.Database Dim strSQL As String strSQL = "INSERT INTO Forms![Extra...
  4. A

    Using an IIf statement to search a field for contents

    Hey, I need to use an iif statement to search a field (column) for a certain word. The field is in tblEquipmentName and the input is in tblWorkReport Ex. iif(input from tblWorkReport is in field from tblEquipmentName,...,...) Thank you
  5. A

    Combobox selection error

    Hey I have a combobox selection for a field in tblInput where the user can also type in a selection not from the list. When an item from the list is selected other fields in tblInput automatically populate. The problems is whenever the user inputs text an error comes up. To invoke the...
  6. A

    Use Checkbox to copy a record in one table to another

    Access 2013 Hey, I'd like to copy checked records from one tale to another after a user presses a button. Ex. The table 'Equipment List' has a checkbox column that the user can check off as they scroll through the table on a form. When the user presses a button, after they are completed with...
  7. A

    Copy Parts of one Table to Another on Form Load

    Access 2013 Hey, I have a table that I would like to contain columns from other tables when the form containing the table is loaded. Example: I open a form to input information into the table 'Equipment Input', but I want Equipment Input to be partially loaded with columns from another table...
  8. A

    Using a checkbox form from one table to populate another table

    Hello, Thank you for taking the time help me with this inquiry. I'm looking to find a means to do a few tasks: 1. I have a table which lists all of the equipment we use in our company and would like to use it as a template in a form so that users can select a checkmark if the equipment is being...
  9. A

    Ajochung Introduction

    Hey All, I'm a relatively new Microsoft Access user who is happy to have found this forum and am grateful to have experienced users available to help with creating rich databases for work and personal use. I've recently moved to California from Canada (yay, no more winter snow!) and am trying to...
Back
Top Bottom