Dirty

[RuralGuy]

Do you have 2007 and 2003 to test with? I assume the db is an .mdb, correct? Did you keep it in ac2000 format?

 

[JEPEDEWE]

Do you have 2007 and 2003 to test with? I assume the db is an .mdb, correct? Did you keep it in ac2000 format?

I dodn't know of "changing teh format"... maybe I did..
How to check, how to get it back in the old format??
It is an imported file from an excel file...
I deleted it, reimported... same problem

The dirty-problem... I changed the line

If Me.Dirty then Me.Dirty =False

into

DoCmd.RunCommand acCmdSaveRecord

I have to test the outcome but I don't get any error...
Now the table-problem!!

JP

 

[gemma-the-husky]

what are you trying to save?

try this.

put record selectors on the form. If the record IS dirty, the black triangle will show as a pencil.

click the pencil, which will try and save the record.

see what happens!

 

[RuralGuy]

I dodn't know of "changing teh format"... maybe I did..
How to check, how to get it back in the old format??
JP

The Title bar should display what format the file is in.

 

[JEPEDEWE]

I opened it with access 2003
In the blue line above the table I see:
BGV Competenties: Table

I can open the table,
sort it
do whatever I want
I can run a query without any problem but, in the program iteself when I run following line

DoCmd.RunSQL "UPDATE [BGV Competenties] SET [BGV Competenties].keuze = False;"

when I add a ' the next line the program runs is

DoCmd.OpenQuery "Keuze_aanpassen_aan_primair"

returning the same error

PFFF

Thank you soooo much guys for your warm help
Really hope thes annoying problems will come to an end soon...
JP