Search results

  1. 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...
  2. 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?
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. amorosik

    Variable defined as Public on a standard module, is not recognized

    I have a project created with Access 2013, 32-bit I normally use this procedure to export the entire project to a text file and archive it (VCS_ImportExport.bas / ExportAllSource) After the last export, I also followed the reverse procedure, and then tried recreating the project from the newly...
  11. amorosik

    There's a system for Access similar to Gemini Code Assist for Visual Studio.

    Using Visual Studio, you can appreciate the ability of external extensions like Gemini Code Assist to support developers in creating new code fragments useful for the current project. For all non-specialized tasks that require specific optimization, the assistant is an excellent tool and allows...
  12. amorosik

    An AI accidentally deleted an entire company database

    https://www.tomshw.it/hardware/piattaforma-ai-cancella-database-aziendale-per-errore-2025-07-21 ...Its automated system deleted an entire company database containing thousands of records, then attempted to cover up the incident with what many called "dishonest behavior." ... It's learning to...
  13. amorosik

    Filter property or sql Where? OrderBy property or sql Order by?

    Which is the best way to select rows in the current recordset? How do you filter the recordset to display on a form/report? Are there any specific reasons for using the first or second method? Personally, I almost always tend to use SQL string selections, which are then passed in their entirety...
  14. amorosik

    If ANY libraries are missing from the references, the date() function won't work.

    I'm referring to a problem I recently encountered Discussing with some colleagues, it seems that the lack of any external references impacts the correct functionality of date-related functions Does anyone know the reason for this strange effect?
  15. amorosik

    Program1 works fine, program2 doesn't, due to a date problem, but code inside are the same

    This is truly incredible (at least for me). Program1.accde becomes program2.accde after some changes to the 'articles' form. Both program1 and program2 work correctly on the development PC, with Win10 with Access 2013 32bit Let's move to user PC2, a Win10 pro pc, where only the Access runtime...
  16. amorosik

    How to read IP Address of 'actually used' lan nic?

    Normallly, using this code, ALL pc ip addresses are returned But wanting to know exactly the address of the wired or wireless network card that pc is using, how to do? I ask this beacuae if the pc has two lan ports on the motherboard, a wifi card, and a virtual lan like those installed by...
  17. amorosik

    How to display a 'running total' on a report preview AND on pdf/print?

    I have a report that needs to display rows composed of a DARE field and a AVERE field, and a third field that I will call SALDO that contains the difference between DARE and AVERE added to the SALDO field of the previous row A basic example is attached There are global variables for the report...
  18. amorosik

    Single project composed of different sections - how supply different versions?

    Let's suppose we have the classic management software to make sales documents, accounting, warehouse, e-commerce, etc... Different 'sections' each with a specific macro task, each section composed of different forms, reports, modules And let's suppose we want to provide gigi with the version...
  19. amorosik

    Differences in date management between Win10 and Win11

    I have a procedure created with Access 2013 ver 32bit that runs on Windows 10 pro It uses data present on Firebird 3.0 and the tables are connected via odbc using the odbc driver version 2.0.3.154 Everything works correctly I pass the same project on a Windows 11, Access same version, Firebird...
  20. amorosik

    How to use a search form by launching it from different forms?

    I have a procedure for administration and therefore the usual screens for articles, prices, invoices, etc. Some search forms can be launched from different forms, for example the form frmArticoliCerca can be launched both from frmFatture and from frmArticoli and from frmClienti I do not know in...
Back
Top Bottom