Search results

Hi Micron, sorry for expressing myself so badly, if that was the message I transmitted. What I meant was that this basic single table design is, I think, fit for purpose for this particular fairly simple and small-scale application. I never was an absolute wizard at programming. Good enough, but...

Thank you for those observations, I appreciate the engagement. I don't think I'm at liberty to post a db copy, sorry. I inherited this application so I don't know whether it started life as an Excel worksheet and got migrated to Access. You're quite right though to say that I'm bringing an Excel...

Thank you again for taking the time to think and write about this, it is kind of you. It's literally decades since I made my living as an applications designer/developer so I expect my thinking is outdated. I'll write it down anyway ;-) The specific coding challenge I was asking for help with...

Thank you anyway, I do appreciate you taking the time to try to help me.

Sorry for not responding to that sooner. I have a solution that works, with the last part of the file path ( e.g. "\Specimen Signature\") hard coded in each of these "Is the document present?" fields. But it just seemed to me that this can't be the optimal solution because in each case the hard...

Thank you... I think this is where, as I feared, my ignorance is going to be really embarrassing. So I had Specimen Signature: GetFile([FilePath] & "\Specimen Signature\") and following your suggestion - taking it quite literally - I changed it to Specimen Signature: GetFile([FilePath] & "\"...

Rene, thank you for this. I see what you've done and I think it's very likely that I will have use for that code at some point in the near future. It doesn't really answer the problem I'm trying to solve here though (except for providing some ideas for refining the function that looks for the...

Thank you again. I had trouble opening the file Rene posted due to security restrictions on my work computer. I need to try on my personal laptopn after work. Your comments about Excel are appreciated. I inherited the database and I started to build complementary Excel spreadsheets to do useful...

Thank you for that suggestion. As a former developer and system designer, I understand the concept of normalisation, but I'm not really seeing what the practical benefit is here to breaking my current single table down into multiple tables. The evidence documents really just equate to ticks in...

Hi, 250 records ATM and 9 different evidence documents for each.

Wow, sorry everyone, I was not checking in here over the weekend and I'm amazed at the level of activity. Thank you, I appreciate your time and effort. Also sorry I obviously didn't explain my problem well. I'll give it another try. My database is a singe table, a list of people with information...

Apologies in advance, I'm an absolute beginner so likely to display embarassing ignorance. I have a table containing details of people. I keep documents relating to these people in individual folders. I'm trying to create a query that shows me whether I have certain specific documents on file...

I started as a trainee programmer in 1976 so I have a reasonable grasp of coding concepts (not so much OO). I haven't been a professional coder for decades though. I use Office - especially Excel - a lot. I've never really learned VBA, I just Google to find something close to what I want to do...