Search results

Hi Guys, I am looking for some help generating some statistics from data held in an Access 2007 database. The scenario is that we have tblLearner that contains personal information, name, contact details for our learners. We have a second table called tbl4WeekReview linked to tblLearner where...

LoL, as i said above... Ps, on reviewing post, there is no asterix in my code after the INSERT INTO, that seems to be something this forum has done automatically :S ! Ive edited my original post to take out the asterix, god knows where they came from! Issue remains.:confused:

I cant see anything with the code either, but I had a thought, I know it may sound silly, but have we checked that the entry form capturing this data that is validated before added isn't indeed itself bound to the table the data is going into? - That might explain why its getting added twice...

Same error, highlights INTO tblCandidate part.

Run Time Error 3134: Syntax error in INSERT INTO Statement Field types are all correct for what I'm putting into them :).

Hi there thardyjackson, I could only replicate this error when I did not have privileges to the folder I was trying to create the file on. I logged onto a domain, which blocks direct files onto C:/ and replicated the error you got. I then created a subfolder on the C:/ called BLAH, and...

Ps, on reviewing post, there is no asterix in my code after the INSERT INTO, that seems to be something this forum has done automatically :S

Hi Guys, New here, and have been a little stuck on a VBA thing. normally I'm quite good at finding solutions, but because this error message is so loose and broad, im finding it hard to decipher what I'm doing wrong, I'm hoping one of you seasoned professionals might just take a glance and know...