Search results

  1. amorosik

    Microsoft Access into Web Apps ???

    Has anyone used MRC-SYSTEM this system to port Access applications to a web browser format?
  2. amorosik

    Sub vs Function - who win?

    Premise: an entire program could be composed exclusively of Functions, with absolutely no Subs With a Function, you achieve the same result of a Sub, and furthermore, should you ever need to return values, the code is already ready; just insert the type of value to return at the end of the first...
  3. amorosik

    How to refactoring an Access project with AI - for example with LM Studio ?

    I'm testing LM Studio and the various available templates LM Studio also offers the ability to be controlled externally via API, and I believe this opens the door to a wide range of uses Suppose we wanted to run an analysis to identify any errors or areas for improvement for a large project, say...
  4. amorosik

    Windows server like workstation o.s. - any advantage?

    I read that some developers utilize Windows Server like o.s. for the main working station Wich advantages could this choice bring versus the classic Win10/Win11 pro/ent?
  5. amorosik

    How do i limit the number of connectable clients?

    How can I check that X workstations are connected to the database server and block the X+1 workstation that tries to connect?
  6. amorosik

    How to interface to Ebay ecommerce system?

    How can I automatically communicate with an Access-based management system and e-commerce systems, such as eBay, from a seller's perspective? By 'communicate,' I mean: - create sales listings - receive purchase order notifications - manage tracking messages for shipped items
  7. amorosik

    How can I create an Access extension for editing code following a particular key combination?

    I use MZ-tools, and one of the features I use most frequently is adding error routines, line numbering, and line de-numbering Many forum users will surely be familiar with Mz-Tools, as it's a truly useful tool How can I achieve the same effect (inserting a few lines of code with variables taken...
  8. amorosik

    What pc hardware/software to speed up Microsoft Access?

    What PC hardware/software is needed to run Microsoft Access quickly? Suppose Access is the only application running on a computer What hardware, operating system, and configuration is recommended to maximize the performance of the running application?
  9. amorosik

    How Sql Server can interact with Microsoft Access (or other application) ?

    How can SQL Server send a "message" to an Access procedure when a certain condition occurs in the data? For example, suppose we have an ARTICLES table that, in addition to other fields, also has ARTICLES_ID as the primary key Suppose the condition is "any change to a record" Suppose the article...
  10. amorosik

    How to query db with memory array data?

    Sometimes it might be useful to 'interlock' two different structures to execute a query and feed a recordset For example, a physical database table called ARTICOLI and an in-memory string array ARTICOLI_CODICI containing only the item codes to be displayed could essentially be 100-200 strings...
  11. amorosik

    Socket tcp communication for Access 64bit - what we can do?

    What's the best way to implement TCP socket communication for 64-bit Access? The winsck.ocx library works fine in a 32-bit development environment, but what can I do to use 64-bit Access? I saw this code on Spiceworks Have any of you used it with good results?
  12. amorosik

    How do I create an Access/Excel add-in AI powered, to recommend/optimize vba code?

    I see that specific add-ins for Access already exist that allow you, , by leveraging the capabilities of ChatGpt or other similar systems, to both create code based on a text query and optimize/verify existing code The question is: how are these tools built? I mean, if you want to build a tool...
  13. amorosik

    Has anyone integrated n8n.io automation with an Access project?

    I see that n8n also has connectors for Microsoft Sql Server, so connecting to an Access project could start with the data Has anyone experimented with n8n and offer some advice?
  14. amorosik

    How to register library/reference from vba code?

    I have an Access procedure that searches for newer versions upon startup If available, downloads them to the root program directory and creates a new icon on the desktop to launch them Sometimes, newer versions require an additional library in the references; otherwise, the code won't work...
  15. amorosik

    Recordset field not readable after update

    Why the row InserisciRecordPrincipale = rs("ID_FERICEVUTE") not recognize rs("ID_FERICEVUTE")? When RS.UPDATE is invoked, rs("ID_FERICEVUTE") lost his value Going step by step, you can see that the rs("id_fericevute") is correctly readable up to the rs.update line Without Close, or...
  16. amorosik

    How can I read newly received invoice files without having to re-read the old ones?

    Rather than access code, it's a matter of how to perform a file copy and read procedure without having to reread the files already read These are XML invoices; they normally arrive in the directory c:\fatture and remain there forever When the operator decides to acquire them into the...
  17. amorosik

    Access to the web - DaDaBik - have you ever used it?

    Has anyone ever used DaDaBik? It's a project designed to create forms and reports connected to a database, accessible via the web with a simple browser Essentially, it prepares HTML/PHP/CSS code that is then executed on a local/public web server I personally tried this program many years ago and...
  18. amorosik

    How do I integrate an Access program with a Fritz Box router?

    Ask ChatGpt, and it seems it's possible to connect to the router's TCP port 1012, which is what their Call Monitor program does But I can't find any information on which commands can be received from the router to the PC and vice versa wich command to send from pc to FritzBox to strat a call, to...
  19. amorosik

    Adapting automatically Access code from 32-bit to 32/64-bit

    Is there an automatic system for converting Access code from 32-bit to 32/64-bit? I'm asking this because, after manually adapting some parts, I see that it essentially involves duplicating the definitions of functions called from external libraries and adapting the code by replacing the Long...
  20. amorosik

    How to update current application and maintain the current version?

    I have a procedure that I'll call procedure10.accde, which is normally launched from a desktop icon whose properties contain the path and name of Procedure10.accde Procedure10.accde (and possibly subsequent versions) are connected to data on a database server via an ODBC driver A function within...
Back
Top Bottom