Search results

  1. TJ01

    Excel vs Access

    I'm coming in pretty late but was just reading this thread with interest and great amusement. I don't know much about chain saw surgery but have spent quite a few years (>30) developing spreadsheet models and Access databases and also training people to do both. I am now concentrating on...
  2. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Hi zeroaccess Sorry for taking so long to reply but I was away on holiday when you posted and I've only just checked back in here today. I'm also not sure why I didn't get an email notification that you had replied here, which I had assumed I would get. Have you settled on a solution yet...
  3. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Hey gang, 3 months later I thought I'd come back and share my experiences with this little project. Just to remind you, I was basically looking for a low-code/no-code solution that would work with a web front-end, to have users fill in forms through their browser and to have data syncing...
  4. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Will do. Thanks for your input.
  5. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Yes but from what I remember, PA users have to be licensed with MS and I'm sure MS would want to keep it that way too. That suggests that PA apps are designed for use within an enterprise rather than for commercial, non-enterprise.
  6. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    By "white-label" I mean we want to be able to package it with our branding, or our customer's, i.e. not Microsoft's or anyone else's. Some of these tools, e.g. Jotforms, allow for that but I doubt that MS would! I'll look into it anyway.
  7. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Yes I've used PowerApps and yes they could do the job but I want to be able to package a white-labelled solution and I don't think we can do that with PowerApps.
  8. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    Thanks for your reply. The forms are fairly straightforward questionnaires with a bit of branch logic where a certain response may lead to other questions. This is easy enough to do with Jotform and other RAD forms tools. The issue with JF and others is that you can't dynamically populate a...
  9. TJ01

    First post

    Thanks Mick.
  10. TJ01

    Web Forms with SQL Azure back-end and Access front-end

    We are looking to build a solution that will allow us to capture data from online forms and to sync data both ways, more or less directly, to a database back-end. The forms have to be web-based, with little or no coding, and the db preferably SQL Server on Azure. It also has to be able to be...
  11. TJ01

    First post

    Thanks Isaac
  12. TJ01

    First post

    Thanks mate!
  13. TJ01

    First post

    I should have also mentioned, I have already setup a small SQL Azure db with an ODBC connection with linked tables into a Access front-end so that we can view and possibly edit the captured data from there.
  14. TJ01

    First post

    Hi there. This is Tony from Sydney, Australia. Hope everyone is OK out in the COVID world. I was an Access developer for many years from the days of Access 1.0 right through to about 2010, building a lot of applications for clients in many different industries, some quite simple and some very...
Top Bottom