Recent content by Rich99

I agree - within the confines of what access can do, it's very neat. I was hoping for something that could provide graphical output (like family tree software does), but such a tool doesn't seem to exist!! Excel does have an inquire addin that does this, but it's not customisable enough.

Thanks, I'll have a play!

More like that, yes. I still think that a purely text-based solution is always going to struggle when the relationships become complex, but this looks like it might be close. The other requirement would be the ability to only include parents/children of a given compound. I.e. we currently have...

As a general rule, each compound will only have 1 parent. Technically, some could have 2, but practically most will only have 1. E.g. we take a compound, put it through a chemical modification, and produce a new product with just 1 parent. Your query is close, although the formatting is a...

Apologies, I thought my descriptions and example were fairly clear. I'm not sure what other details you want? It's a simple database, losing multiple compounds. Most compound are derivatives of a previous one, and we want to track those relationships (viewing parent/grandparent etc, or...

Hi, I posted an example above, in post 5. Thanks!

I've had a look at family tree software - while it seems attractive, I can't find any that is flexible enough to let me re-purpose it. I've had a look at the articles that JDraw published, but they look hellish complicated for a noob like me - this system would need to be used by people with no...

The relationship can be many layers deep (effectively it needs to be capable of hundreds deep). A horizontal report would be fine, as long as it's understandable. Funnily enough, someone else suggested a family tree software! I'll go googling now.....

OK - I've attached an example database of various compounds. I've also attached a diagram of what I'd like to end up with - a diagram showing the relationship between the various molecules. In this diagram I've shown all the descendents of compound A, but in reality I'd like to be able to choose...

Hi, any compound can only have 1 parent, but there may be a chain of relationships. By visualise, I mean that I want to click on compound 1 & see what all it's descendents are (and their descendents, and theirs etc), or I want to click on a compound and see the chain of parents all the way back...

I'm not sure if Access is the right tool for this, it's not a tool I'm particularly familiar with - if any can tell me either how to do this in access, or whether some other program might be better, it would be appreciated! We have compounds, we then take those compounds and modify them. The...

OK, I'm making progress. Putting that '.text' on the end, and using the 'on change' property of the particular field, seems to work. Where the text contains numerical data, I've put the code in as Field.DefaultValue = Field.Text. Where it contains text, I've put it in as Field.DefaultValue = "'"...

So I've gone to design view, chosen selection type as 'form', gone to event/before update and clicked on the .... I've chosen code builder, which takes me into VBA. I've added the line you said in between the existing code, so that it says this: Private Sub Form_BeforeUpdate(Cancel As Integer)...

Apologies - I've now gone to design view, clicked on the form (the properties box says 'Selection type: Form') & gone to Event/Before update. I've clicked on the ..., chosen expression builder & typed in what you said. In the 'Before Update' box it now says '=[Stack].[DefaultValue]=[Stack]'...

I selected 'event procedure'. Access said I had to go to design view & set 'HasModule' to Yes, which I did. Then I clicked the ... next to Event Procedure & pasted the code in - I tried putting it in both BeforeEvent & AfterEvent. My VBA now looks like this: Option Compare Database Private Sub...