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

    Ok, dont know if this helps but i replaced the open call with this DoCmd.RunSQL StrStoreSQL, False and guess what....... it works as well !!! So does the recordset component parse the sql by a different engine or summit ?? still drivin me crazy !! ??????
  3. C

    SQL error but not when run in query

    Thanks for looking at it, I am a bit lost how to post an example, as my data is seperate from the code, can i just post the db/vb parts or will it just fall apart, the data files are about 100Mb. The "contract" field is an autonumber field and is also the PK field for the table, hence when...
  4. C

    SQL error but not when run in query

    Well done, you are correct, but unfortunatley my post of the SQL was "doctored" purley to see if the semicolon had any effect on the code, so yes sorry... it works in the Access query either way, but not at all in the ado.recordset method. why ? :):):)
  5. 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...
  6. C

    Return Primary Key Value after insert into

    Thats Great, gives me an idea what VB in Access can do, so im gonna sleep on it as it 5 mins to midnight here in the UK. Thanks Very much as well Colin
  7. C

    Return Primary Key Value after insert into

    Lost me there, I dont care so much the primary key given, wether it skips jumps or sings, i just wanna know what it used in the insert into sql record. Please bear with me, im used to programming in Delphi against Firebird and SQL databases, and the recordset in my usual language, returns a...
  8. C

    Return Primary Key Value after insert into

    i have seen it before where the delay through the network (some stations are in Germany) and others in the UK, cause all sorts of problems in the real world, I wish i could go back to running on local 100Meg networks.....Drives me nuts !! So is it possible for me to extract the record details...
  9. C

    Return Primary Key Value after insert into

    ihva a function that does the insert Function CopyToArchive(SSql) As Integer On Error GoTo Err_CopyToArchive Dim StrStoreSQL As String Dim adoCon As New ADODB.Connection Dim adoRst As New ADODB.Recordset Set adoCon = CurrentProject.Connection StrStoreSQL = SSql adoRst.Open StrStoreSQL, adoCon...
  10. 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
  11. C

    Reducing the size of the application

    Found it under the Magic "splat" then Manage....Cool its now shrunk from 66Mb to 907Kb...I am impressed, now i can email it.... Thanks Guys and Galls
  12. C

    Reducing the size of the application

    Nope, But i guess im gonna be doing it soon, ....So pray where does one find Compact repair ? Many thanks
  13. 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...
  14. C

    Question Seperating data from an existing Access App

    Spot on, Thanks very much
  15. 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...
  16. C

    Extract column names into a string

    expression A variable that represents a Database object. is all it says.....did i do it wrong ?
  17. 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:)
  18. C

    Creating a Unique index

    So Do I...... SO i am purified.....Now i just have a little coding to do to copy the 20 memo fields over, not sure where to start doing that, but im looking ..... I had to use memos because the Word inserted text is about 10K in some cases. Anyway....very helpfull Thanks Guys...#
  19. C

    Creating a Unique index

    thanks Neil, Any chance of stepping me through how to actually do it, because the dialog box that lets me create indexes, wont allow me to type 2 field names on one line ...... where did i go wrong ? Cheers Colin
  20. C

    Creating a Unique index

    Thanks Guys, im gonna forget about compound indexes in Access and do it your way by making a copy of the master table and archiving each record in when the employee contract is printed.... much safer as you say when you dont understand the odd ways access works. Im sure i read you can create...
Back
Top Bottom