Replies

Many thanks Steve.
As far as the code goes, I understand the approach and where I was going wrong.
I need to explore array formulae -they seem very powerful yet succinct methods of achieving a variety of solutions. I’ll need to look at each of the functions used and to see what they do.
I find my fumblings useful. I’ve been teaching advanced chemistry for 20 years and it puts me in the same frame of mind as one of my students.

Again, many thanks.

Rob

Many thanks Steve. As you know, it works a treat. Two points: if you have the time and inclination, would you briefly run through with me exactly what this array formula does? Secondly, I assumed that the code to perform the calculation would be straightforward – my maths and logic isn’t particularly weak, but I am a relative beginner with respect to VBA – yet I am yet unable to accomplish it. Is there something particularly tricky about the task.

Again, many thanks.

Rob

Thanks Bryan. I’m trying to get my head around two sets of code. I’m still a relative beginner wrt Access. The exercise will do me good. I’ll get back if I experience difficulties.

Best Wishes

Rob

Thanks Hans. I’ve downloaded the code and I’m working my way through it.

Regards

Rob

Thanks John and Charlotte for your suggestions which I will follow through. I was aware that third form normalisation of the data would require an owners_pets table to be set up. I was working through some initial ideas when I came across my original problem.
With help from yourselves and others in the forum, my old and saturated brain is beginning to see a glimmer of light.

Many thanks

Rob

Thanks Rupert for taking the time to offer your help yet again. I made a mistake when I replied to your post. I used the term ‘Customer’ when I meant ‘Owner. I only have three tables: Owner, Vet and Booking and no queries. I will check carefully your suggestions.

Again, thank you,

Rob

Thanks Rupert for responding. Mystery! I have made no queries yet in the project and no vet information is stored in the owner’s table. Everything appears as it should.

Thanks again.

Rob

Thanks Rupert. I now understand. However, another problem has arisen. I can select any owner and vet which is saved to a booking table except the first owner in the list. I get a message which reads ” You cannot add or change a record because a related record is required in table tblCustomer. I don’t understand what is going on because I am only looking up the owners from this table:the control source for the owners combobox points to a field in the bookings table. Everything works fine with every other owner selection.
Any ideas? I hope I’ve expressed the problem adequately.

Thanks

Rob

Thanks Mario for your rapid response. It works a treat.

Rob

I too have experienced this problem. I believe it’s to do with crosslinking of files, that is, different files point to the same part of memory. I resolved this by unchecking the ‘fix faults automatically’ option prior to running ScanDisk, then by accepting any suggested prompts. I no longer use ScanDisk – I use Norton Utilities which appears to be more effective.

Rob

From a thermodynamic perspective : 298 Kelvin.
273 Kelvin = 0 degrees C.

Rob

I’ve rearranged a couple of lines of your code and those lines which I don’t think are necessary I’ve memoed out.
It appears to work now. See attachment.

Rob

Thanks for your time and advice, Phil and Preston!

Rob

Thanks Preston. If I were to delete all the shortcuts flagged by jvc16, could I then re-establish only those that may need?

Rob

Thanks Sam. That’s really useful.

Rob