Search results

  1. C

    Using Access 2007 as datasource for Word 2007

    Hi all, I have a small Access database with essentially 1 table that contains 6 memo fields formatted to RTF, I have a word 2007 mail merge document that uses a query in the Access db to locate the data it requires to create a employement contract......all fine My problem is the formatting of...
  2. C

    SQL error but not when run in query

    I have a strange one here, I have a routine thhat gererates SQL "on the fly" to duplicate a record (except for the PK filed) in the same table. Code: Function CopytoSelf(iContract As Integer) As Integer On Error GoTo Err_CopytoSelf Dim StrStoreSQL As String Dim adoCon As New ADODB.Connection...
  3. C

    Return Primary Key Value after insert into

    HI, I have created an SQL to copy a record in a table to a new record...fine but how can i get to the primary key or new record that has just been created, as i want to return this value from the copy function.. Thanks Colin
  4. C

    Reducing the size of the application

    I have inherited a Access 2007 Application and want to seperate the data from the "program", i think i have done this using the Database tools-->Move data --> Access database, The original database "app" was about 80Mb and after using the above function/wizard its shrunk to only 59Mb. and the...
  5. C

    Question Seperating data from an existing Access App

    Hi, Can anyone help me regarding a Access 2007 application i have, i want to seperate the data from " The Access Program", where i can send the user a new Program without the data. and i can test the program without seeing the confidential data at the customers site. Do i just copy the...
  6. C

    Extract column names into a string

    Hi, I need to extract all the field names into a string so i can create a SQL "on the fly", as i need to copy all fields from one table to another Except for a couple of fields. can anyone give me a clue where to start ? Regards Colin:)
  7. C

    Creating a Unique index

    Hi I have inherited a database that creates employee contracts in word 2007 that are launched from a form in Access 2007. i am looking for the correct way to be able to have a unique employee number and a version record, I need to ensure that only the current live record version is printed...
  8. C

    How to create a lookup form

    I am new to Access 2007, i come from a Delphi background and am trying to create a master form that contains employment details, i have created 10 other tables like paydetails, holidaydetails, healthdetails, Etc.... I want to be able to load into the master table field for say Paydetails the...
Back
Top Bottom