Search results

  1. B

    Automatically generate reference Number from fields on form

    Thank you all for your contributions. I have been able to do it with the following code Private Sub Form_Current() Dim YrCount As Long Dim MyCode As String Dim CountCriteria As String If Not IsNull(Me.InspectionID) Then If IsNull(Me.txtInspectionCode.OldValue) Then CountCriteria =...
  2. B

    Automatically generate reference Number from fields on form

    Yes, it's important that the serial number resets at the end of the year. There is a primary key for each inspection record. The number of inspections per year is not fixed. It varies. The incremental in the serial number must always be in reference to the previous date.
  3. B

    Automatically generate reference Number from fields on form

    Thank you for your response. I agree that it can be a duplication. I will just display the code then. I will be grateful if you could show me how to generate code
  4. B

    Automatically generate reference Number from fields on form

    Thank you for the response. The inspection code is generated when a request for inspection is received and that code is finally used on the inspection report that is generated after the inspection to uniquely identify the inspection report. Could you show me how to add the serial number...
  5. B

    Automatically generate reference Number from fields on form

    I am developing a database for inspection activities that are carried out by my department. Each inspection activity is given a unique reference number called "inspection Code". The Inspection Code is generated by combining a unique code assigned to each entity inspected (Entity Code), a unique...
  6. B

    Textbox to search and filter date field in access

    It works now. I'm most grateful
  7. B

    Textbox to search and filter date field in access

    Thank you, I will try and revert
  8. B

    Textbox to search and filter date field in access

    I have implemented your suggestion, it works fine. However, the format for the date is now dd/mm/yyyy. How do I change the format to yyyy-mm-dd since that is the format my company uses. Thank you
  9. B

    Textbox to search and filter date field in access

    Thanks. I will implement and revert shortly
  10. B

    Textbox to search and filter date field in access

    I will be grateful if you can help with how to convert the date field to string as suggested in your last suggestion
  11. B

    Textbox to search and filter date field in access

    Thanks @MajP for the quick reply. I will implement what you have suggeted and revert.
  12. B

    Textbox to search and filter date field in access

    I am trying to update my access database. I have addedd a textbox called txtSearch on the form. The intention is to search and filter records in the a table called Inspections_LogBookTable as the user types in the textbox called txtSearch. The code works perfectly for text fields but it cannot...
  13. B

    Data in continuous sub form goes blank when form opens in Access

    Thanks MaJP. Its working perfectly now.
  14. B

    Data in continuous sub form goes blank when form opens in Access

    Thank you for your patience. I know I have made a lot of mistakes. I am newbie. I am taking a look and come back ASAP
  15. B

    Data in continuous sub form goes blank when form opens in Access

    I admit I have issues with normalization. Registered Vessels table is meant to be solely be lookup table for the combo boxes "Vessel Name" and "Eu Number" whiles HC_Vessel_Table is meant to store the vessel data during data entry. The issue is that some of the Companies are just processing...
  16. B

    Data in continuous sub form goes blank when form opens in Access

    MajP you rock. the issue now is with the second subform. I want the EU Number to appear based on the Vessel Name. Thanks
  17. B

    Data in continuous sub form goes blank when form opens in Access

    Thank you. I will take a look. i will be right back
  18. B

    Data in continuous sub form goes blank when form opens in Access

    thanks for your swift reply. about using speciesID, does it mean i have to create two tables? one for product type and one for species and use a query for the subform?
  19. B

    Data in continuous sub form goes blank when form opens in Access

    Allow additions is set to Yes
Top Bottom