Search results

  1. C

    how to remove existing fields and notes from the ready-to-use template?

    You will have to remove from the form manually. When you add, delete or change fields in a table they have to be accounted for in forms, reports, queries and maybe code. They do not show or disappear automatically.
  2. C

    Relink Access tables from code

    I use JStreet Relinker. http://www.jstreettech.com/downloads.aspx
  3. C

    PBaldy and his growing family tree

    Compared to our former neighbors we are beginners: they have 27. But's it's not in the numbers, is it?
  4. C

    PBaldy and his growing family tree

    Just last night I was informed that #12 is on its way.
  5. C

    PBaldy and his growing family tree

    Most of them live fairly close although we don't see them often. One of them is now 10 years old and the last time I saw him he was just a few days old. Anyway, since I cannot impress you with my mediocre Access skills I though I would try it this way and stand out in the crowd.
  6. C

    PBaldy and his growing family tree

    You all have some catching up to do. A month ago we welcomed #11.
  7. C

    Problems with Thai script on forms

    It's Mother's Day Weekend, not a lot of members are visiting the forum. Tomorrow someone will respond, I'm sure.
  8. C

    Disable right click for Access application (not the form)

    Check the database in the attachment, It should have the functionality you are looking for.
  9. C

    Thans grom Holland

    I lived in Groningen and Zwolle.
  10. C

    Thans grom Holland

    Where about in Holland do you live?
  11. C

    First Post : Introduction

    I used dBase III & IV in the mid 80's. I still have copies of them and may be one of these days I'll set up an old DOS computer and run them again for nostalgic reasons.
  12. C

    need help with Church Database

    How about a table for just individuals and a many to many relationship to a table for groups (Family, Choir, Volunteers, etc.) So an individual can belong to many groups. Someone can belong to a family and be a member of the choir as well as being a volunteer etc. It can go beyond...
  13. C

    Goodbye Access

    Goodbye zooropa67.
  14. C

    Question How to check numeric input data

    I always use this in the On Ke yPress Event of the form field to make sure only numbers are entered If KeyAscii < 48 Or KeyAscii > 57 Then KeyAscii = 0
  15. C

    Logo

    Can't you just re-size the logo and then insert it again?
  16. C

    Sort on number ads 0

    Access 2013. Table field is set to: Number/Byte, 0 decimals. The field is used to sort records in a particular order. In the form it is set to Standard, no Decimals and no Default Value. When I create a new record and type in: 1, it makes it 10, 2 becomes 20 etc. If I delete the value and...
  17. C

    Email from form

    Did you do a search on this forum or anywhere else? There is plenty of sample code available.
  18. C

    Refresh on form close using VBA

    You're welcome, I'm glad I could help.
  19. C

    Refresh on form close using VBA

    How about re-querying the combo box upon closing frmCity? In the OnClose Event of frmCity try: Forms!FirstForm!MyCombobox.requery Replace FirstForm and MyCombobox with the actual names. You can also put the code behind a close button on frmCity
  20. C

    Making copy of a table

    Sometimes extensive updates have to be made to a table using an update query or loop through a record set. In order to be able to undo changes in case of a mistake I am thinking about the following procedure: In code: 1 - Make a copy of the table 2 - Make the changes in the original 3 -...
Back
Top Bottom