Heh,
It's funny how it can react. I didn't modify the code of my forms or anything. 2 on click functions used to work now it doesn't.. Only thing i did was compact and repair database...
Weird
And the Debug.Print Function looks good and have the right values...
Hehe
Weird............ Unsolved mystery
To know if it was appending/updating I changed Currentdb.Execute to DoCmd.RunSQL ..
And it's appending/updating 0 records lol :|
Well all my INSERT INTO SQL Statements aren't working (Doh !)
Always when I think i'm done, there's something
I think I found out why it does that... It's cause I compacted and repaired the DB
Cause I deleted the values in the tables where the insert and update were taking place and then compacted the database
If any of you have suggestions... to get it fixed let me know
It's funny how it can react. I didn't modify the code of my forms or anything. 2 on click functions used to work now it doesn't.. Only thing i did was compact and repair database...
Weird
And the Debug.Print Function looks good and have the right values...
Hehe
Weird............ Unsolved mystery
To know if it was appending/updating I changed Currentdb.Execute to DoCmd.RunSQL ..
And it's appending/updating 0 records lol :|
Well all my INSERT INTO SQL Statements aren't working (Doh !)
Always when I think i'm done, there's something
I think I found out why it does that... It's cause I compacted and repaired the DB
Cause I deleted the values in the tables where the insert and update were taking place and then compacted the database
If any of you have suggestions... to get it fixed let me know
