Search results

  1. G

    Append Query Field Name Problem

    When I produce an append query that has field names such as 2007/08, the field name is truncated to 2007/8, which results in the query failing. SQL: INSERT INTO [tblTemp Input] ([2007/08], [May-07] Becomes: INSERT INTO [tblTemp Input] ([2007/8], [May-7] when the query is saved and re-opened...
  2. G

    Append Query Field Name Problem

    When I produce an append query that has field names such as 2007/08, the field name is truncated to 2007/8, which results in the query failing. SQL: INSERT INTO [tblTemp Input] ([2007/08], [May-07] Becomes: INSERT INTO [tblTemp Input] ([2007/8], [May-7] when the query is saved and re-opened...
  3. G

    Run Code Scheduler

    Hi, what is the best way to run access VBA code at a certain time of the day? I want to set up a form so that a user clicks a button and at 1am the following morning a sub is run. I can do this using a While loop but obvisously this means that the timing code has to run continuously. I do not...
  4. G

    Transfer text into a database other than current database

    If I call a procedure in another database the code in that database will run, I'll call it the "Remote" database. An instruction such as "docmd.OpenQuery" in the remote procedure will run a query in the remote database. OK, but what doesn't work is a TransferText instruction such as...
Back
Top Bottom