Search results

  1. I

    Copy/Append record into same table

    Hi All, I have the following append statement that is throwing back this error "Parameter [@SCHEDULE_ID] has no default value". It is a stored query and is used via a web page. I have tested the variable before it goes into the query and it has got a valid values. It is something to do with...
  2. I

    Paste Command Failing

    Hi, I have a Word Macro that does the following: 1. Opens Word document with macro in it "DOC1". 2. Creates a new document "DOC2". 3. Opens another document "DOC3" that is acting like a template of sorts. 4. DOC2 is selected and copies the entire document to the clipboard. Then pastes it into...
  3. I

    Copy queries from mdb to txt

    Hi All, I would like to read/iterate through all queries in an access db and write them to a txt file. This will include the name of the query and the sql text. Any ideas?
  4. I

    Extract queries to txt file

    Hi All, I am trying to update queries in one mdb to another with a bulk update. In order to do this I want to extract out into a txt file all queries with the name and SQL statements. I know SQL Server does this, is it possible in access or maybe I'll need to create a vb script, any help would...
Top Bottom