Search results

  1. Z

    Create Excel from Access

    I like the methods outlined by Access Jitsu in this series of Youtube videos. Maybe it will help you. Incidentally, the transfer spreadsheet methods seem to have stopped working in the later access updates and I have reverted to simple exports and then formatting in Excel later.
  2. Z

    The Virus that came from China.

    Carefully chosen words. Those who want to follow his line that it was made by China will still hear "made in china". His speech team is hoping that his detractors will be weakened by those hearing his admission that it wasn't made in China but just came from there.
  3. Z

    Form to handle duplicates

    Yes, this is exactly the outline that I think I need to use. Has there ever been a template created for this that you know of.
  4. Z

    Laboratory work table linked to an alert table one to many join help

    Another point on structure: One type of test can be taken by many patients One patient can have many tests of the same type One clinician can have many patients One clinician can order many different types of test. You will need some junction tables to cope with many to many relationships. In...
  5. Z

    Form to handle duplicates

    Very useful - this will definitely form part of my solution
  6. Z

    Form to handle duplicates

    Thanks - I will look at those - I suspect Soundex will be the most appropriate
  7. Z

    Form to handle duplicates

    There is a long and painful story of why this data exist in this format. Let's just say copies on an excel system for tracking equipment inventories sent out to multiple sites with semiliterate individuals completing the data (and refusing assistance from anyone with knowledge). When all the...
  8. Z

    Form to handle duplicates

    I have a large inventory database. There is a table of type of object eg: "4 drawer Filing Cabinet". There are multiple duplicates of this due to misspelling "4 drawer Filing Carbinet" "4 drawer Filling Cabinet" "4 draw Filing Cabinet" The primary key of this table has then been used in other...
  9. Z

    Extracting digits from Date of Birth

    That got it solved - it was actually a problem of referencing the box on the form. Just adding the me.DOB to the code and your method sorted the issue. Thank you!
  10. Z

    Extracting digits from Date of Birth

    After some experimentation I now have Yr2Dig = Format(Me.DOB, "yy") Mnth2Dig = Format(Me.DOB, "mm") Day2Dig = Format(Me.DOB, "dd") extracting the correct figures from the Date of Birth. I now have the problem that Format(me.DOB,"mm") produces just 6 for June whereas I need it to...
  11. Z

    Extracting digits from Date of Birth

    I am not allowing the user to change table design. I have made the DOB format dd-mmm-yy because that is what appeals to my visual sense. If in implementation the users ask me to change the format to dd-mmmm-yy or yyyy-mmmm-dd etc I don't want to have to recode the database
  12. Z

    Extracting digits from Date of Birth

    Sorry when I say txt field I mean DOB is the txt box on my form that is bound to the underlying field Date of Birth which is a Date/Time field.
  13. Z

    Extracting digits from Date of Birth

    The identifier is not used as a primary key in my database - that is why it is not any sort of autonumber. I am just recording it for cross-compatibility with other systems.
  14. Z

    Extracting digits from Date of Birth

    Yes the DOB stores a valid date. Currently I have DOB set to dd-mmm-yy format (i.e. 14-Jan-67) I was hoping to use code that would not depend on the particular date format in the DOB text field so that the format can be freely altered to suit user needs. The underlying access table obviously...
  15. Z

    Extracting digits from Date of Birth

    Hi all I am stuck on what should be a simple problem. I am working with a database where the organisations unique ID for people starts with there date of birth in reverse order (yymmdd...) In the flow of my form it is easiest to enter date of birth first. In the after update event I would...
  16. Z

    Front End Auto-Update

    Great bit of code. Since my users will she the front end in a variety of places on their PC, is there a way to grab the current path of the outdated front end before closing it, and then inserting that path into the copy statement, so that the new front end is chipped to the same location the...
  17. Z

    Simple intro

    Hi, I am from South Africa. I am a doctor and mainly use access to find efficient small database solutions for health care. I am a still a beginner in terms of using VBA to make interfaces more efficient
Top Bottom