Search results

  1. C

    Question Compact & Close database option

    I think your existing database is copied and given a different name, then the old one is being deleted and the new one is renamed. Catalina
  2. C

    Question Access Database Deployment

    Can't you just attach it to an email? That's how I do it. Catalina
  3. C

    Question Access Database Deployment

    You may want to rethink the decision not splitting the database. Suppose a user needs an upgrade, if it is not split he would have to send the whole thing to you to make the adjustment, and then you need to send it back. And in the mean time it can't be used. If it is split, you can just make...
  4. C

    Db for MSDS sheets and safety stuff

    I don't have automation in linking them. Giving the nature of the database and the link naming it has to be a manual process. It is a db I started in dBase III in the mid 1980's and moved it to Access in 2001, I believe. It is not growing very fast, so some manual adding is no problem to me...
  5. C

    Db for MSDS sheets and safety stuff

    May be another question to ask yourself is how many (concurrent) users there will be and from where they have to access the db. I have an Access db that contains links to over 14,000 images, and it works great. The new attachment field is easy to use but still causes bloat. I understand it...
  6. C

    I need to write a custom error message for a before update procedure

    Just do a search on this forum, this topic has been handled numerous times.
  7. C

    CRM Database

    How about checking here: http://www.databaseanswers.org/data_models/index.htm Catalina
  8. C

    Backup Question

    You're welcome. Catalina
  9. C

    Backup Question

    That's how I do it, I copy the BE of all databases at least once a day. I have that process automated through backup software. And if there is extensive use, I do more often just to be on the safe side. I keep may be 5 or 6 copies so I can go back a while if needed. It is not unthinkable that...
  10. C

    problems calculated fields

    I'm glad you found the solution. Catalina
  11. C

    problems calculated fields

    Without being able to look at your database it is impossible to say what is wrong with it. Catalina
  12. C

    Why my Access File is to Big

    Do a search here for Compact and Repair.
  13. C

    Pictures as backgrounds for forms

    I tried it recently with some nice gradients. It basically looked great but then I ran into an old problem, form flickering when moving the mouse over some controls. I removed the picture and no more flickering. Using Access 2010. Catalina
  14. C

    Track number of records in a query

    I tried it, and it works perfectly. Thanks (again) Bob. Catalina
  15. C

    Track number of records in a query

    I found the following code a long time ago, credit to the person who wrote it. It should do what you are looking for. Put a textbox named 'txtCurrent' on the form. The following code goes in the ON Current Event of the form. Private Sub Form_Current() Dim sCurrent As Integer Dim sTotal...
  16. C

    Track number of records in a query

    Wouldn't =Count(*) do the trick? Catalina
  17. C

    delete key

    Is that a question?
  18. C

    Hello from the Great White North!

    I lived in Canada for a while (Kingston, ON). Beautiful place, wonderful area, nice people, but too cold and too much snow for me. From a sunny Southern Arizona (79 F, 26C), welcome. Catalina
  19. C

    CHeck Box for Shipping Address

    I missed you, got very worried already. :eek: Catalina
  20. C

    CHeck Box for Shipping Address

    Then stop working so hard Bob, we need you here! :) Catalina
Back
Top Bottom