Recent content by Firepen

Hi Guys, This DB is to collect info following an audit review. There are 3 types of dates collected/stored. 1.Dates that always occur – About 12 dates 2.Dates that occur either under condition A or condition B – 8-10 dependant 3.Dates that sometimes occur and sometimes don’t – 0-20 Dates I...

Hi Setare, Is that a Persian name or just happenstance? Welcome!

Hi isladogs, Thanks for the tip, I tried that and it does most of the work. I can only seem to add one set of matching fields in the wizard (1 from from either table) but it's a doddle to add more in the design view or in SQL so a very useful tip. Much appreciated! Thanks Guys

Thank CJ, that was exactly what I needed. A quick datatype change and it all works. I was looking at Joins but W3 and my book only do very basic examples of any thing they show. I knew a non-match from right table gave a null value but hadn't seen it used that way. Now I've gone though it...

Hi Guys, This is a single step in a data import and transformation Mod I am working on, I will need to reapt the step a fair few times. The import is for a number of tables that support cascade combo boxes. Tables mostly contain ids from the lower tier tables (so not to repeat data). The IDs...

Hi Guys, Having a bit of trouble with this, I only know as much VBA as my Access book teaches and it's not the focus of the book. My aim is to change the value of tblMakesTemp.NBody to the correct ID for that Value (tblBodyTypesTemp.BodyTypeID) as part of an import Mod. I need to check all...

Hello, So I am new to access, have been learning access, sql and vba since April in my spare time, working from home so have a little more than usual. As such I appolgise now for obvious errors and questions. I'm in the UK. Tech fan and avid gamer, mostly Overwatch and single player games...