Search results

  1. Q

    SQL ADD COLUMN works but doesn't display

    G'day, I am using Access 2007. The following code works to create a new column in the table called 'Matrix': DoCmd.RunSQL "ALTER TABLE Matrix ADD COLUMN [" & newjob & "] INTEGER;" However, the new column is not visible in the Table 'Matrix', even if I close and reopen the database. Yet I know...
  2. Q

    Programming partial replication

    During the process of creating a partial replica using the Partial Replica Wizard, a dialog box is displayed which lists tables that my filter does not directly apply to. As stated in the dialog box, "tables that aren't bold aren't related to the filtered table with referential integrity...
Back
Top Bottom