Search results

  1. RonPaii

    Menu System

    Attached is a sample database of my Access menu system. The main form is SYS which uses the menu system to show Forms and Reports with the option to change access level and module. Only 3 of the forms on the menu are included Accounts Receivable, Job: Master and Parts: Detail. The beMenu table...
  2. RonPaii

    Access FE connection to SQL server failed

    I was having a periodic connection problem between an Access 365 FE and SQL server BE. The ODBC connections would lock requiring restarting the SQL server service for the database. The log indicated "I/O is frozen on database #####" followed by a backup. then "I/O was resumed on database #####"...
  3. RonPaii

    Outlook365 Classic is broke

    Has anyone else seen a problem with Outlook365 classic not able to connect and flashing a empty box. I asked Google "Did Microsoft break Outlook365 classic today" Yes, as of March 17, 2026, Microsoft reported that a previous build of Outlook 365 Classic is broken for users who have the...
  4. RonPaii

    Laptop slow to a crawl.

    A little reminder to those using laptops. They are very sensitive to the compacity of the power supply. For example, I setup a laptop connected to a dock though a USB-c cable that should power and charge the computer and it worked well. A week later the computer was a complete dog with the CPU...
  5. RonPaii

    Lookup Form

    This is a sample lookup input form. The calling functions takes the same type of input as a combo box. The sample form has 3 buttons opening the form with 2 column value list, a single column query string and a single column saved query. The query list all the reports. The 3 reports are empty. I...
  6. RonPaii

    XML Comments

    I have been adding XML style comments to my procedure headers for a more structured comment system. It would be great if MS could enhance VBA, to use them in intellisence like in .NET. ''' <summary> ''' Check if user is member of an Active Directory group ''' </summary> ''' <param...
  7. RonPaii

    Multi-value field (MVF) using tree control

    Attached is a sample database that emulates MVF using MS common control Tree Control "MVF_Control_Tree". It works in both x32 and x64 bit Access. It has the added benefit of supporting multiple levels of grouping of the available selections. The sample "frmUsers" opens when you open the...
  8. RonPaii

    Another Input Box replacement

    This is my version of an input box form and function to replace the built-in InputBox. Features RTF prompt with resizing to fit provided text. Typed return value (Text, RTF, Integer, Long, Double). Customizable button captions. 3rd button (Other). Direct fill of text box control on calling...
  9. RonPaii

    Solved Tab in RTF control

    I am displaying static text in an un-bound RTF control on a message box form. Is there anyway to imbed tabs in that text built up with VPN?
  10. RonPaii

    Hello All

    I graduated from UW Oshkosh with a computer science degree in 1985. Since then, I have been working in the family business handling ID, mechanical and electrical engineering and compliance. My professional experience started with DOS based programs using C, and AutoLisp to automate AutoCAD, then...
Back
Top Bottom