Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BJZeak
  • Content: Threads
  • Order by date
  1. BJZeak

    Struggling with finding an answer to a simple question

    Expecting the issue is my failure to clearly describe the question MS Access has provided in many of its wizards the ability to selectively pick from a list on the left and add to a list on the right Was looking to implement something like this for a project without reinventing the wheel ...
  2. BJZeak

    Would this simple IoT configuration provide an adequate block to Internet Access?

    This is a Security measure I have been using for over 10 years without really knowing if it is effective. Objective: block an IoT device from any Internet Access but still retain local access. Will the following measures achieve this Objective or can this IOT Device still find a way to call...
  3. BJZeak

    Global Timer Variable

    Trying to do something I thought would be real simple ... basically looking to have a Counter that resides on a PI Raspbian (unix) that could be Cleared, Set, Run and monitored from a node-red client ... this timer is required to control a relay ... on during count and off when 0 ... this is...
  4. BJZeak

    OFS 2016 update KB5001969 causing shared file issues

    KB5001969 has caused an issue where MS ACCESS can no longer open Shared Files ... MS posted an acknowledgment of this issue on 22/Dec/2021 (for 2016 and above) and stated that to correct this, users must manually go to the ACCOUNT screen in ACCESS and press the update Button ... I have 3 OFS Pro...
  5. BJZeak

    Looking to understand the feasibility of creating a SEND only POSTFIX solution for an IOT (pi) ctrlr

    Pi (Raspbian) located on a remote mountain top being used to monitor and control some electronic equipment via an Internet connection ... currently using ssmtp to send I'm alive and Alarm emails to a support email address via gmail's smtp servers ... this gmail service stopped working a while...
  6. BJZeak

    Can a Query have Dynamically filled columns?

    Trying to eliminate a number of "like" reports that differ only on how N fields are populated from a primary table ... the original designer created N report variations ... now ... any minor changes have to be applied to N reports instead of one ... plus ... adding any filters to this report...
  7. BJZeak

    requery delema

    Sorry in advance ... although I have years of programming experience, my VBA time has been minimal Have an ancient 1997 app (converted to 2003 and running in 2003, 2016, and 2019 versions of Access) that uses conditional formatting to color rows in its child subform control ... a timer control...
  8. BJZeak

    need help with .sql insert statement

    Have a SQL file that is supposed to load configuration data into a database with the following type of statement Insert Into SomeTable(ID,SomeNameField,SomeMediumBlobField) Values('0','SomeName', $FILE{/path/somefile.txt}); I gather the intent is to upload contents of somefile.txt into...
  9. BJZeak

    Looking for some direction with a python project

    Have Python source code in Unix that runs automatically from rc.local at startup which continually - monitors several Analog and Digital inputs - displays any changes based on these inputs Looking to make a rudimentary external CLI interface that would provide virtual inputs in parallel with...
  10. BJZeak

    Looking for direction, preferably Open Source Option, to replace 20+ yr old MS ACCESS Apps

    Hello ... I'm looking for some direction/help/suggestions to find an economical all in one Front End Form builder with similar features to MS ACCESS for use in building front end user interfaces for SQL back ends ... ultimately looking to replace/migrate some aging MS Access Apps built over the...
  11. BJZeak

    MSACCESS VBA object Order

    Several years ago I wrote a generic Start Module which provides user Login/Password, Auto Hide, Remote Shutdown/Lockout and User Level features that could be easily adapted to existing Main Forms ... am using this on several 2003/2016 db application files and allows for nightly orderly shutdowns...
  12. BJZeak

    Unknown action with subform in datasheet mode

    Don't recall seeing this action before ... thought it was due to having the form Key Preview turned on ... does the same thing with Key Preview off ... basically the Parent form has no TabStops ... the Subform, in datasheet mode, is given focus within the Parent's form load routine ... only one...
  13. BJZeak

    Is Dynamic Field Locking possible in datasheet mode?

    Given a Subform controlling a table in datasheet mode ... looking to use a value of another field in the same row to determine if a specific field in this row is locked (not editable) Ndx SomeField LockState 0 A Locked 1 B Locked 2 C Locked 3 D...
  14. BJZeak

    Excel 2003 Form Control Challenge

    Attempting to either add a text box control OR set the TakeFocusOnClick button property on a worksheet in EXCEL 2k3 ... poking around online leaves me to believe that MS broke the ActiveX controls used in Excel 2k3 a few years back with an activeX security update and didn't bother providing a...
  15. BJZeak

    Looking for suggestions for a shared Office Suite Process

    3 W7Pro PCs Peer to Peer with one Shared Folder on the PC with Office 2010 Office 2010 Office 2003 Office 2003 1 MS ACCESS 2003 mdb Application Backend Shared maintains data used in Spreadsheet 1 MS EXCEL 2003 xls Workbook Shared 5 of 6 Sheets Protected ... all 5 automatically get their data...
  16. BJZeak

    SQL Solution?

    Sorry SQL newbie alert May have over complicated this (shot myself in the foot) ... have several tables (Dtl<n>) which are filled automatically from a WebSite Form (XML). These tables have both a common set of fields and unique set of fields. Wanting to unify all tables in one Access Form so...
  17. BJZeak

    Document Merge Task

    Office 2013 Pro with Access/Word/Excel/Outlook Built a Web Form which exports form data as an XML file ... this file is sent via email as an attachment ... Access imports these files directly from Outlook The challenge is getting one of the XML fields which is a dynamic multi-line text field...
  18. BJZeak

    update from Ubuntu 14.04 to 16.04 has broken wyse60 TERMINAL

    It typically takes a while to set up these older style terminal emulators, normally only do it once then just forget about it, forever ... well in my case, that has come back to bite me big time. I have had Progress 11.0 (Character Mode) running perfectly on Ubuntu 14.04 configured for wyse60...
  19. BJZeak

    advanced Balloon usage

    Given a small square control like a button or picture/image that have no image, text or borders, using tooltips on the form and balloons set to true, it seems that some controls are totally blocked by the balloon overlay (associated balloons appear to attach by default to either the lower center...
  20. BJZeak

    Logging issue

    Been running a simple one Form VB EXP 2k8 app for several years which monitors a Serial Port data stream, updates some indicators on the Main Form, and captures specific key entries to forward back to the serial port ... I recently added some Roll over Balloons, a Help Form, and some Data...

Part and Inventory Search

Back
Top