Recent content by Turn85

Thanks to you both, managed to get it working in the end. Don't know why it wouldn't work but deleting the original table then building a new one as per Static's code and then manually applying the primary key seems to have sorted it all out. Again big thanks to you both, hopefully the rest of...

I've managed to work out its the auto-increment field that's causing the issue, if i remove the field from the table it inserts the data with the blank columns, if I put in it says the number fields do not match the table, if I try and add a blank entry to the auto-increment field I get a data...

Do the fields in the createTempTable function also have to match my Table if it already exists? I'm getting a error when running the script because it can't match the number of fields being inserted to the number of fields in the table. I also have another field which will only be updated at a...

Thanks Static, that's brilliant! how would I go about putting that data straight into an existing table which has an auto-increment primary key?

unfortunately the system which holds the information does not out put in any format, the only way we can get the info we need is by copying and pasting. Lines can also be identical, there's no unique identifyer.

I chose unbound as the data that needs to be entered can only be pasted from the other system and I need some way of breaking each line down into the require fields and getting rig of the parts I don't need like the description. It takes too long to manually copy and paste each part of each...

Not sure if what I'm trying to acheive is possible in access but thought I'd ask! I've been tasked with creating a system to generate a standardised report and store the data in a database for creating monthly stats and general manipulation. Currently people manually write the reports and...