Search results

  1. P

    Using append query after entering new record

    The program I am working with has an option to add a new record to another table using a button. Not all the records, even new ones, need to be appended. The append query works fine in all situations but one--when a new record is entered and saved, the append query button returns 0 records to...
  2. P

    using temp variable to append specific number of records to table

    I need to extract a specific number of records into a table using a MakeTable or Append command using a temp variable, e.g. TempK&SA. Previously on the forum I was shown how code could be added to the OnOpen function to use a temp variable to select a specific number of records to report. ACCESS...
  3. P

    Using TempVar variable in SELECT TOP N

    I have read a number of the threads on using a variable in Select statements using VBA code, however I gather my limited knowledge of VBA within a module is catching me off guard in making it work. The report the query is attached to requires a bit of sorting and would be much easier to modify...
Back
Top Bottom