Search results

Thanks, the button on the form was the simplest solution. Sorry, I really did try to explain what I was trying to achieve, but realise it's not always clear to the reader. Thanks again

I'm back, I've been populating my database and the double-click is working really well to locate records on the Main form from the sub form. Unfortunately, though, it seems to filter the main form to just the one record I have linked to and although I can keep double-clicking from the sub form I...

Thankd jdraw - it does just what I need. I was trying to overcomplicate, I think. It's a neat, simple solution and I can use it in other databases where I need to locate a record with a double-click from the datasheet record. Just to clarify for those who don't look at the actual database...

Hi jdraw, Thanks for your help. I have about 350 records - people who DNA match with me and/or my brother. By comparing who matches with whom in my database I can begin to narrow down how we are related. In some cases my matches match with other people who I also match with - it's bringing...

Thanks for your quick reply. I do have very good family tree software, but I have been writing my own database to compare Ancestry.com DNA matches. Each match has their own Main form, just a name with a sub form with all the matches for that one person. Each of the people in the subform are...

I have a simple form with a datasheet subform which could have more than one row of records. I want to be able to double-click on one of the records in the sub form to make the main form locate a record based on the row selected in the sub form. The main form has people's names in it and the...

Thank you, that's useful to know also. Dates and Times are powerful features and are quite complex. Grateful for the help :)

You're a star, thank you. It didn't occur to me to use Now() when populating the field, I did think Date() carried the Date and Time. Thanks for saving me time and effort, much appreciated. It works fine now. Laura

I need to show the exact date and time when records are added to a table. I've created a small table with 3 fields, one of which is DateEntered, Date/Time and the Format is General which should show the date AND the time. Unfortunately it's only showing the Date, both in the table and on a form...

Yes, it all helps enormously, thank you so much for taking the time to explain. I am very grateful.

One other thing, would it be wise and good practice to add this error logging to every procedure or just those where I might anticipate there could be an error? Most of the time I use the default coding that appears when a new button is added to a form, for example in the onClick event. Thanks...

Thank you so much for such a swift and clear reply. I've now experimented and implemented it into my code and it works and I'm very pleased with the result. Thank you Allen Browne too. The only thing I did not use because I'm not clever enough with MS Access is to anticipate the possible Error...

I am trying to make use of the Error Handling code: http://allenbrowne.com/ser-23a.html I've created the tLogError table and I've copied the code into a Module. What I am not sure about is how to call the function.. Can someone give me some example code as to how to use it? Many thanks Laura

plog, once again I thank you so much for your help and advice and again I am sorry I was not clear in responding to your original question. I know it can be frustrating when all the facts are not known. This database was populated a long time ago and is not likely to increase too much in its...

Thank you again. Out of interest, and I think it's not important in terms of this particular project as I detected just one instance where there were 3 people at the same address, how could I handle it to pick up 3 or more? Forgive me if I have not understood you correctly. The order in which...

Thank you, that's brilliant and the min/max did the trick. I'm sorry I didn't answer your question, I thought it related to instances where there might be 3 individuals. I don't think it really matters which Member is picked out for the top line and which for the second (if that is what you...

I noticed there was only one instance of a 3rd name, so I am more interested in finding a way of picking out just two and dealing with the 3rd name instance manually for now until I work out how to do one label per address with two individual members. Thanks Laura

I have been asked to help with an existing Membership Table with individual records for each Member - including title, first name, surname, addr1, addr2, addr3, addr4 and Postcode. Many of the individual members are spouses or family members living at the same address, in most cases just 2 per...

Thank you so much, a lot for me to take in and consider. I appreciate it very much.

Hi Dave - thanks for your indepth reply. I am not sure what "mdbs/mdes" files are. The database at school is still the .mdb format. In order to create the accde file I was informed by a message that I had to first save as accdb, then I could create the accde file. I am still working on a copy...