Recent content by popguru

Good afternoon everybody. I'm building an application to record engineer input in Events (jobs) for an engineering company. My main tables are Products, Builds and Events, together with fifty or so reference and ancillary tables which aren't really relevant to this particular head-scratcher...

Ha! That almost works perfectly, but has opened a (new) can of worms. Let's see if I can explain. The form in question, Builds, relates to builds of a given Product. In general, a user will access this form via one of two methods: they'll either apply some filters in a 'Search Builds' form...

I'm back :0) I've almost cracked this. Firstly, I had to tweak the SQL statement to change 'fldDeleted' to 'Deleted' (as that was its name in my tables). I then had to add a third unbound field to my master form and to the oncurrent subform event to include the actual field name of the...

Yep, I did figure out the missing quotation mark once I'd realised that you were cunningly synthesising the SQL-esque statement. Very elegant indeed. I've just finished up some nav interface bits and pieces so, here goes.... :0)

Beautiful! Thanks, CJ_London. That's exactly the sort of thing that I wish I could train my brain to come up with. I'll give it a go now and report back shortly.

Hi everybody, Newbie here. I'm currently building a database in Access 2013. I've used Access many years ago, and not really in anger since maybe 2003, so I've been re-learning quite a lot. Here's an overview of my scenario, and issue: The main purpose of my database is to allow engineers to...

Hello all, I'm Martin, from Leicester. As I'm sure you're all aware, Leicester recently *just* lost out to Hull in an attempt to become the next UK City of Culture so, realistically, I'm only likely to treat people from London, LA, NYC, Sydney, Barcelona, Paris and Hull with any credibility...