Recent content by Colin Coleman

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...

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 !! ??????

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...

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 ? :):):)

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...

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

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...

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...

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...

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

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

Nope, But i guess im gonna be doing it soon, ....So pray where does one find Compact repair ? Many thanks

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...

Spot on, Thanks very much

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...