Search results

  1. J

    Append Query: Type Conversion Failure

    Hi all, I'm trying to append a query into one of my tables, the query runs fine as a select query but produces an error when used as an append query. I've pasted the SQL of the Query below: INSERT INTO TblSPlan ( StyleID, [Section], PlanDate ) SELECT QryGenerateDates.StyleID...
  2. J

    Record username of last modified when query is edited

    Hi, I've used the fOSUsername() macro to record usernames easily in forms previously. However, I now need the following: a) Generate a query via a filtering form. b) The query should have a checkbox field which has to be ticked if a record is valid. c) The username of the person ticking...
Back
Top Bottom