Search results

  1. B

    Intranet Smartphone ACCESS query

    Thanks, I did download/install/try Longtion ... spent a few hours with the examples ... although it looks like it may have potential, for me, it didn't provide a simple solution ... PLUS $$$ ... the KISS approach I posted above does all I needed with the only cost being my time ... was hoping...
  2. B

    Intranet Smartphone ACCESS query

    OK So here is a Simple Solution: - xampp with: apache & php - set odbc connection to the access db file mdb or accdb - create index.php file in the apache htdocs folder ----------------------------------------------------------------------------- <?php if(isset($_GET["Param"])) {...
  3. B

    Intranet Smartphone ACCESS query

    I built something similar to this a few years back but involved painstaking/manual coding/debugging ... created a jquery for a WP page which in turn called, using ajax methods, a server side php script passing along client inputs ... the php script did a db query plus some calculations but only...
  4. B

    Intranet Smartphone ACCESS query

    have job board scheduler running in access and just want the workers to be able to look at their phone to find their next task in priority ... I have a query that creates a list ... now need some web style service that can create an HTML rendering
  5. B

    Intranet Smartphone ACCESS query

    With all the options out there, can't seem to focus on a simple solution that doesn't have any ongoing costs attached either for tools or services ... needing to have smartphones (android or ios using html) be able to go to a local intranet web page and display a simple canned status query (db...
  6. B

    Frustrated with Access 2016 SQL Query not accepting a literal string in compound/nested iif

    see my first post ... this is my formatting .... ms removes all the cr/lf and whitespace
  7. B

    Frustrated with Access 2016 SQL Query not accepting a literal string in compound/nested iif

    footnote ... this all stems from MS ACCESS not accepting AS WRITTEN FORMATTING ... very hard to debug the blob that occurs once saved ... Perhaps the newer versions of MSA have options to correct this but being that I only touch code every other year I haven't gone looking for better options
  8. B

    Frustrated with Access 2016 SQL Query not accepting a literal string in compound/nested iif

    ok thanks ... duly noted ... MS Word has fouled me up for other things in the past ... stuck doing an update on a W10 machine which doesn't have all my dos tools on it otherwise would have seen that ... managed to rewrite this statement again from scratch in the SQL Edit window and it finally...
  9. B

    Frustrated with Access 2016 SQL Query not accepting a literal string in compound/nested iif

    query entered SELECT Schedule.*, [Work Orders].Jobdescription, [Work Orders].Schedulecomment, [Work Orders].Customeritems, [Work Orders].InvoiceDate, [Work Orders].Invoicenumber, IIf(Not IsNull([Work Orders].invoicenumber)=True,”Invoiced”, IIf([Work...
  10. B

    Crash When Add Option Group

    max 754 Control Changes to a form/report ... one might expect this was meant to allow for UNDO ... but ... UNDO didn't work in this situation and with a handful of mostly static controls (< 30), defined at most once over a 2 year period of service, kind of hard to fathom hitting 754 changes...
  11. B

    Crash When Add Option Group

    Ok thanks for the idea ... so ... created a NEW Form with just the Group Option ... this saved with no issues ... THEN ... copied this object back to the Form and it now saves ... guess this is a workaround ... BUT ... WT_ ? :banghead: The reply for save form to text file must have been sent...
  12. B

    Crash When Add Option Group

    Similar issue with 2k3 ... started new db, relinked back end tables, copied queries and forms, then attempt to add an Option Group to an existing form ... as soon as I save the Form, Access Crashes ... the original file saved the form change BUT the form NO longer opens in RUN or DEV modes even...
Back
Top Bottom