Search results

  1. Cliff67

    Azure SQL Gateway/Data warehouse

    Hi Lightwave thank you for the link. I've been going through the whole site and getting tonnes of info for my boss. many thanks Cliff
  2. Cliff67

    Azure SQL Gateway/Data warehouse

    Hi CJ thanks for the insight Cliff
  3. Cliff67

    Azure SQL Gateway/Data warehouse

    Hi all Has anyone had any dealing with Azure and connecting to tables. I'm trying to research ways of connecting my database backend to people in both the UK and USA any ideas or guidance would be gratefully received. Some have said a mixture of VPN and Citrix/Terminal Server, but on the...
  4. Cliff67

    Changing Colours on Forms

    Thankfully the Boss has put a stop to that
  5. Cliff67

    Changing Colours on Forms

    Hi isladogs yes I've downloaded the theme manager and it is very good, I've changed one of them for the corporate default so I can revert the db back. Cliff
  6. Cliff67

    Changing Colours on Forms

    :D:D:D what a wonderfully wicked idea...
  7. Cliff67

    Changing Colours on Forms

    Hi MajP that looks brilliant, I will bury it in my DB then uncover it when needed :D
  8. Cliff67

    Changing Colours on Forms

    Hi All Update of the colour changing forms. My boss was over here for a few days and asked my how it was going, when we are going to roll it out etc. He wasn't best pleased that I was "Wasting your goddam time doing this h****s**t" (he is American BTW) so that has been shelved. I really have...
  9. Cliff67

    Changing Colours on Forms

    Cheers Uncle don't think the boss will want me paying for something like that but good call
  10. Cliff67

    Changing Colours on Forms

    Cheers isladogs great little colour changer. I've just got to alter it a little so that when a user changes the setting it is saved for that user only and everyone else who feels the need to change the default setting...that reminds me need a default button on there somewhere Cliff
  11. Cliff67

    Changing Colours on Forms

    Hello everyone, I'm quite advanced with writing my Technical Support database, so far that we are about to roll it out to users in the States (using a mixture of VPN, form timing and other things my IT bod has helped with). It has been well received but now one of the test users has said...
  12. Cliff67

    Problem coding forms to feed tables

    Have you tried to do this in an Append query to see if it works correctly?
  13. Cliff67

    Problem coding forms to feed tables

    You might be missing a reference to Microsoft Access 15.0 object Library (or what ever version you are using). In the VBA code window select Tools from the menu then select References and check you have the reference to the above library, then re-compile your database. At the beginning of your...
  14. Cliff67

    Remote Access to Database

    Cheers, Have a good Christmas, I'm off soon until the new year :)
  15. Cliff67

    Problem coding forms to feed tables

    is it the me.txtGLA bit or the GLA of the childDetials table that it is highlighting?
  16. Cliff67

    Remote Access to Database

    Wow Thanks Colin. I have started to work my way through the code based on the ideas you gave me, this gives me some extra things to think about implementing. I normally develop one part and test it to see what goes wrong then 'bug fix' I know what I want to do and I tend to write it in...
  17. Cliff67

    Remote Access to Database

    Hi Colin many thanks for that, I've mainly developed desktop databases with multi-user access so remote access is really new to me - I found it easier in the days of replicated databases with a master and slave databases. Just a quick question, would you use the active controls dirty function...
  18. Cliff67

    Remote Access to Database

    Thanks for the warning. I will start with 10 minutes and tweak them as I see which ones are used the most. It might be worth my while logging the form/control usage on the lesser used ones
  19. Cliff67

    Problem coding forms to feed tables

    Thanks for the correction James
  20. Cliff67

    Remote Access to Database

    Thank you Doc_Man for your insight. I had an idea that it would not be as straight forward as just getting the VPN going and set up the terminal server. What a fantastic idea of putting a last Touched function behind everything, I will definitely be implementing that. We are a small to medium...
Back
Top Bottom