Search results

Vba Ah.... So it's all down to VBA. It seems like it's going to be a lot more complicated than I thought..... I'd better get cracking with some VBA.... :)

I'm currently experiencing a very bad headache from having stared at my screen and googled all day. I'm now trying to find a way to get the data from Access into a Word document, all nicely formatted, with headings for each coin Denomination and the data filled in from the access database. I've...

More Progress Great Success! After a good long weekend (I ended up in the Peak District - which was nice), I came back to work on Tuesday and i sure felt the pain. I simply couldn't concentrate on anything and try as i might, i couldn't get my head around all that was explained, the SQL...

I know exactly what you mean and i actually agree with you on the redundancy of some of the data. It might make sense to remove some of the redundancy because having a meaningful primary key would be very useful. In practice however, the PeriodHeading is useful on its own merits and also the...

Good news..... :) I've managed to use your instructions to separate out the Varieties successfully. I've also applied the same method to other separated out content such as Denominations and Types which i've called tblDenominations and tblTypes respectively. I've created a relationship between...

Thanks tehNellie! I'm going to run through that when i get home ..... It looks very clear and simple, and i finally feel like i'm beginning to understand how this is working and tying together You've been a fantastic help and i really can't thank you enough!.... Hope you're having a fantastic...

Ok, sorry for being a pain in the ass. but i'm not quite there yet. I've tried modifying your SQL code but i think i'm simply not proficient enough (yet) so I was hoping you could look at the following and re-write it so it will work without modification (so that i can then understand how it...

Thank you VERY much for all this help and your effort replying. I'm going to try this out now..... I'll let you know how it goes! :-) Oh, i've updated my second post.... I just want to make sure you saw the following: "I now have a "Varieties" table with all of the varieties now in it stored...

Thanks tehNellie, that sounds ideal. I'm not exactly sure how to run that bit of code there, which i know i'll need to edit. I'll give it a try though. What does the "variety." refer to? Should I replace "Table1" in the SQL code with "Stock" because thats the name of the primary table? Also...

Hi, i'm new here and I know there's a lot going on but i was hoping someone could point me in the right direction or give me a few tips... I've imported a very large (nearly 15000 records) set of data into an Access database as one big huge table storing various bits of information about coins...