Recent content by ncwatt

  1. N

    Check for duplicates when importing excel into existing table

    I've very recently had to write an Access database that imports a large volume of data from a Cobalt system so that it can then be processed. Not saying this is the best way but it worked very nicely and might give you a few ideas. The file being imported is a CSV with over 450,000 entries...
  2. N

    Access 16: how to schedule export of table data to a text file daily at specific time

    You could use a VBScript which is run from Task Scheduler. I did create one for you which worked with the attached database to produce the attached text file. I did have to ensure I had the Microsoft Access Database Engine Redistributable installed otherwise the VBScript would fail because it...
  3. N

    Hello from Lester Ohio, USA

    Hi Tim Newbie to the site as well. dBase3 eh? No fancies GUIs in them days! Proper hardcore ha.
  4. N

    Back making Access databases

    Yeah, I've been given 2 weeks to get version 1 up and running. It will be basic, but at least it isn't lots of different spreadsheets.
  5. N

    This Customization Was Already Loaded

    Went for a run and had a think about it. Do you want one ribbon which is the main one (displayed across the whole app), and then have additional ribbons displaying more options depending on the form loaded? Using your example DB you had "Main" as the ribbon for the whole database. I've then...
  6. N

    This Customization Was Already Loaded

    If you open the form in design mode and on the properties screen go down to Ribbon Name, you will have a drop down with the 4 ribbons you have setup. I've only used Main and it works fine when you put the form in to Form View. You don't load Ribbons on top of Ribbons. Your complete XML should...
  7. N

    Back making Access databases

    Hi folks, Around 7 years ago I left IT management and joined a whole different kind of career. So, it's even longer than since I worked on Access. Well, I joined a new department this week and the IT department at my current employer gave a 3 to 6 month turnaround for a database to run our...
Top Bottom