Search results

  1. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hi Arnel Sorry for delay in replying. Other projects diverted me from this. And I did try to adjust the properties of each of the section headers, but to no avail. I must have missed something> I have trimmed the DB down now. It is attached below. I have left a few publishers in the DB...
  2. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hello All With Arnel's suggestions, I can indeed say I have made some progress on this. So, many thanks. However, even after taking out almost the identical elements from your DB, Arnel, and adjusting what I thought were the principles i had gleaned, I still cannot implement what I need. I...
  3. A

    How do I create a report to output to a specific layout for records going back a number of years?

    I simply imported the tables,and queries, including relationships. I have restored a backup now, so no problems. I just thought you should know what has happened when someone else has tried to import those object from your DB. Many thanks for the help, though. I will use that as a template...
  4. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hi Arnel Many thanks for the sample DB. I think I kind of understand the ideas. I will attempt to implement something similar. This is a specific query for yourself. I think I made an mistake. i tried to import the tables and queries from your sample into my DB. However, now I am getting...
  5. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Thanks for the suggestions. I will give those a go now!
  6. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hi All Arnel, thank you so much for your suggestion. It worked - mostly! Basically, I had too many headers turned on (report and page, with the page having several fields in it). As i say, it mostly worked. The thing I cannot work out is how to ensure that there are always twelve rows per...
  7. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hi Arnel and June7 Thanks for your input. I will attempt Arnel's solution First. I will then sanitise the DB and share it, as needed.
  8. A

    How do I create a report to output to a specific layout for records going back a number of years?

    Hello to All You Experts out There By means of assistance I have got from these forums, I have got two major steps closer to finishing my project. Thank you. Here is another issue that I have that must be core functionality for the DB app I am producing. I have tried getting it to work on a...
  9. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Hello All (especially those who have offered suggestions to this topic already!) To my delight, I managed to get this working! Previously, to stop people fiddling around with the ID field (primary Key) on the form, I had set the enabled property to that particular text box to False...
  10. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Hi Bob I will clean out the records apart from a few, and let post a copy. It will likely be to krrow, as i have never actually had to do that before myself! Many learning curves!
  11. A

    Using a check box on a bound form to control the NotinList combo box event to take 2 controls from form, inserting into 2 fields in another table

    Dear Experts For me, this is big issue No.3 stopping me from completing this DB. The Goal: On a bound form, with many different controls, one of which being a combo box control with a list of Managers/Team Leaders, and another being a check box indicating whether the person whose record it is...
  12. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Hi Many thanksnfornthe suggestions. And thanks to moke123 form the sample DB. Wow! I have a feeling I have a lot to learn before I know how to implement that level of sophistication in this DB I am working on!! I am not even sure which parts I need to extract and adapt to use for my...
  13. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Thansk for the thoughts, Gasman. If a duplicate name is entered, the organisation involved wishes to: (a) check if the person that is having their details inserted at this time is indeed the same person that has already been recorded in the DB. If they are indeed the same person, then looking...
  14. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Hi OK, here is the code, as it stands in the VBE: Private Sub Publisher_First_Name_BeforeUpdate(Cancel As Integer) Dim NewPublisher As String Dim strLinkPublisherCriteria As String Dim PublisherNo As Integer NewPublisher = Me.Publisher_Surname.Value & Me.Publisher_First_Name.Value...
  15. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Once again, dear Gasman and CJ_London, you are correct. I will attempt to do better. I tried the code that CJ_London kindly posted. It runs, but for some reason, just as was previously happening, it is is loading the first record in the table (ID No.2), rather than the ID of the record that...
  16. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    You are right. Many apologies. By trying to make my naming clearer (to others before this posting), i made it much worse. Sorry. Next time, I will do better. I will give your kind suggestion a go and let you know. (I hope it is that easy!)
  17. A

    Solved No.2 - Again - Avoid Duplicate Records - Using Form-validation - Using two controls -LastName & FirstName

    Dear Experts Thank you for your patience. I have another issue when trying to implement form-level validation. This is a bound form that can both be used to displat records and input new infor ation for volunteers. Goal: To avoid duplicate records by comparing LastName concatenated with the...
  18. A

    Introducing Myself - Access All Areas

    Hi Everyone Just found this area to introduce oneself, even though I have already posted a question. Sorry! I was first introduced to MS Access in 1997! I tried VBA when it was VBA5 the following year. But then changed directions when I went into the IT industry, when I became Comms...
  19. A

    Solved Avoiding Duplicate Values using Form-level validation in VBA - for dates (European format)

    Gasman Good point. Your suggestion clarifies matters, for sure. I will change that and no doubt know much easier whic one to use in the future!
  20. A

    Solved Avoiding Duplicate Values using Form-level validation in VBA - for dates (European format)

    To Gasman, Darnel, and Isaac A big thank you. I have incorporated elements of all of your suggestions and found a solution (your suggestions were fundemental and I would not have been able to work this out without you, nor understand what is going on within the code). Both the DLookup and...
Back
Top Bottom