Search results

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

Hi Chris, Thank you for telling me about the Shrink Property it worked. :) I will also try spending more time on trying to get the code to work taking into account your suggestion of the dot rather than dash and the other suggestions in this post. When I am not tired ;) I would just like to...

Hi JHB, I have attached the sample it is the only select query and report in the database. Qry_CompleteIncomeExpenditureReport - Query and Report Name. Thank you and have a wonderful day. :)

Hi JHB, Thanking you for your response. Sorry I haven't responded earlier. I have tried as suggested On format option, also I tried putting it under on Current and On No Data just in case. But when I put it under the On format option or any of the others I have tried. It remains the same...

Hi Paul, Firstly I would like to thank you for your time in helping me. :) It worked but it hid all the fields including the ones that had text. I have attached what happen when I carried out using the code below. Thank you once again. Have a wonderful weekend. :)

Hi there, I have been trying to figure out how to make a textbox if it is null to be invisible on a report. My experience in programming is somewhat limited so any help is greatly appreciated. This is one of the ways I have tried but I maybe on the wrong track. I selected the detail section on...