Search results

Yes you can using the 'OpenCurrentDatabase' method. I found this on the MSN website. You also have the 'OpenDatabase' method and the 'NewCurrentDB' method. If you search for the terms in the help file it will give you all the details. HTH

Hi and thanks for your help. I think it has finally been sorted out. I saw another reply by pdx_man about adding a field of datatype DateStamp. I added it and it seems to solved my problem so again, thanks everyone

Thanks Yoritomo, I will try that

Thanks Bob, Maybe that's the problem. I have a combo box which selects data from a table in sql to add to the record but when I try to move to the next record, that's when I get the problem. Peter

Hi Bob, Thank you, yes I did, I made sure all the prime keys were in order and that all the id keys were created and relevant. But it still seemed to make no difference. I was wondering if it has to to with the set up of the relationships etc, but mabe I'm wrong Peter

I've been looking through all the previous posts and it seems that I am doing something wrong. I have two databases, one front end that had all the forms, reports, modules etc. and a backend that had all the tables. I converted the backend tables to MS SQL 2000 and linked them to the front end...