Recent content by grubnz

Hi Pat, Hope all is well. I was reading this and understand the three normal forms. I have the Primary Key autonumber As the primary key to keep numbering consistent. And I have the entered date Field Then because people like having Year-Seq Number(resets each year) Would I then be able to...

Thank you The_Doc_Man, For the information it is good to know. Thank you for your time. Enjoy your New Year and all the best for 2018.

Hi arnelgp, No worries you weren't late. I had to go to bed as it was getting onto 11pm and I had a long day. :) Thank you very much for all your time that you have spent on this. I have just had a look at the completed code. Have a wonderful New Year and All the best for 2018. Ani

Hi The_Doc_Man and missinglinq, Thank you both for your for your posts, I appreciated what you have taught me. Have a lovely day. :) Ani

Hi arnelgp, Hope all is well. Thank you for your assistance. I have tried the code below. I tried altering different items to see if I could get it to work but I don't have the knowledge... I have got it to come up with the first number in the sequence. But it came up with the same number...

Welcome :) I totally agree this is an amazing forum, I have learnt so much over the years.

Hi there, I was wondering if I could get some advice please on testing code that will only change yearly. I have created a LogNumber (CustID), With a customisation of the code that I have found in this forum thank you...

Hi Mark, Thank you for your response. I work for an airline. Publications to maintain aircraft with, are link to an aircraft type or multiple types depending if it is a generic compnent. Hope I have clarfied it a bit better. Thank you Have a wonderful day. Annie

Hi Minty and Mark, Minty - Thank you for the link I will have a look at this. Mark - Pub - Publication, AircraftHolding where I held the aircraft types for a particular record. e.g. I have 1 publication but this publication maybe used for three different aircraft types. So it would be 1 to N...

Hi there, Hope all is well. I am building a database at work. I was going to use the multiple field in access but then that didn't fit the design principals and also reading some other posts apparently it isn't a good idea to use this functio anyhow. Maybe I am not doing this correctly. So...

Hi Arnelgp, I have got it to work :) With your assistance and knowledge. Thank you for your patience. Have a lovely week. All the best, Regards, Annie

Hi Arnelgp, Hope all is well. Thank you for your assistance yesterday greatly appreciated. I did what you mentioned and have been trying work out the Run-time error ‘6’: Overflow issue today with unfortunately limited success as my knowledge of VB isn't very strong at the moment. I have...

Hi Plog and Arnelgp, Thank you very much for your replies. I read the information on the compound keys. Arnelgp, I have tried the code below sorry for my ignorance. Is this where I should be putting it in the database. As below? I created a form and placed an unbound field on the form and...

Hi There, I hope I have put this in the right place. I had tried doing this from another post on here suggested txtUniqueNumber = Number & Format(Date, "ddmmyy") & ID What I did was txtUniqueNumber = Format(Date, "yyyy")&"-"&ID Didn't quite do what I wanted. What I am trying to achieve...

Hi Paul, Thank you for the naming convention post from now on I will use this naming convention. It will make things simpler. :) Have a wonderful day. Regards, Annie