Search results

  1. E

    Should I Learn MS Access in the AI Era?

    That list was generated based on the following survey question: The list we'd like Access to appear in is Other frameworks and libraries, but Access isn't even there, sadly. The lists are attached. By the way, the survey includes enough data to make an informed decision about AI and how it's...
  2. E

    Solved OpenArgs From SubF.CurrentRecord[FieldName]

    Try this Private Sub btnInSubF_Click() DoCmd.OpenForm "ChildFName", , , "FieldName_FK=" & Me.Parent.FieldName_FK End Sub Make sure the FieldName_FK field exists in the parent form.
  3. E

    Should I Learn MS Access in the AI Era?

    Hear me out. The forum owner recently mentioned that traffic has increased, but as someone who enjoys a good challenge, I haven't seen that many challenges here lately. Could it be that more people have adopted Access thanks to the AI? And therefore, since the AI helps solve issues, they don't...
  4. E

    Pasar datos de un formulario a otro

    Qué tal, David No está muy clara tu pregunta. ¿En tu segundo formulario YA APARECE el número de empleado, nombre y otros campos? O ¿En tu segundo formulario QUIERES QUE APAREZCA el número de empleado, nombre y otros campos? Cualquiera que sea tu respuesta, ¿Qué quieres hacer una vez que...
  5. E

    Text with shadow in Access Form.

    Pues sí, en efecto, un misterio. Abrí el archivo varias veces y abrí el formulario varias veces también. No pude reproducir el efecto sombra que te está saliendo a tí en tu aplicación. Veamos si alguien lo puede reproducir. En esta versión que subiste, ¿Sigues teniendo el mismo problema...
  6. E

    Text with shadow in Access Form.

    Bueno, como no podemos ver tu archivo, agrega este procedimiento a tu formulario o un módulo Private Sub EncontrarControles() Dim ctl As Control Dim t As String For Each ctl In Me.Controls If TypeName(ctl) = "Textbox" Then t = t & "Txt " & ctl.Name & ": " &...
  7. E

    Text with shadow in Access Form.

    Leyendo las notas que parecen ser pendientes de desarrollo, supongo que hablas español. Como podrás ver, estamos haciendo conjeturas de lo que te está pasando, la más lógica es que tengas una etiqueta (o control de texto) sobrepuesta(o) sobre otra(o) con fuentes ligeramente distintas. La única...
  8. E

    Solved How to Create Tile-Style Buttons on MS Access Forms?

    If they have direct access to the guts of the app, yes. But I've always distributed the apps with linked images via a self extracting executable that installs itself in a folder that users typically don't go to. My choices are always %HOMEDRIVE% and %USERPROFILE% Other programs also also use...
  9. E

    Solved How to Create Tile-Style Buttons on MS Access Forms?

    What do you mean not portable and prone for deletion of the images? Mind elaborating with some examples? I'm attaching a sample database with linked images. I added some simple code so that the path is always reset on load. I may not be considering your scenarios.
  10. E

    Solved How to Create Tile-Style Buttons on MS Access Forms?

    I'm getting confused by this thread. For a button to use external images with a caption, you would set the following properties: 1. Picture Type: Linked 2. Picture: browse for the image 3. Picture Caption Arrangement: Anything except the "No picture caption" 4. Caption: Your caption 5. Theme...
  11. E

    After update event triggered by changing tab

    Those events were triggered before your user entered the subform if the main form was already dirty. The main form can not trigger the After Update or After Insert events exiting a subform. As for the tab control, the thing to watch out for is the auto focus. Clicking on a tab shifts focus to...
  12. E

    Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist

    Yes and the appearance can be replicated with the browser control.
  13. E

    Solved Best way to protect VBA code in Excel

    I don't recommend it. When I tried it, the software crashed a lot and when it "worked", the work wasn't protected anyway. I don't know if they fixed the multiple issues it had. I've had success making an Add-In with VSTO. The distribution of the solution is convenient and it protects your work...
  14. E

    Automating browser operations from MS Access

    Fair point. I was going to recommend tools in other languages that you can trigger from your Access UI, but if you want to stick to VBA, here's the deal: 1. If IE is working fine for you, that's great! is it making you uncomfortable that it's such an old browser? OK, you still have...
  15. E

    Important Security Guidelines

    Authentication is only one part of the puzzle, or challenge, depending on who you ask. Security strategies are changing everyday, and it's best not to trust too much. Nothing happens, people say, until something happens. For reference, this website lets you check whether your email has been...
  16. E

    Dynamic/reusable forms

    Neat, I can understand despite the language differences, so thank you for clarifying. That is a nice framework indeed, and I can see how it would benefit you in creating new applications. There must be quite a lot of work behind so kudos for that. There really is no problem in you...
  17. E

    Dynamic/reusable forms

    Let's suppose you want to build a contacts list. I suppose the first step for you is to open a blank file with the framework prepared, right? The framework items in your file has some code modules, tables for the metadata and forms to define the fields. All is well here, right? The second...
  18. E

    Dynamic/reusable forms

    After 100+ posts, the conversation seems to be going in circles, so... like, show a "To Do" app generated by your framework maybe? no idea why forum members think it's impossible to do what you say you did, but you also don't seem to have a clear intent with this thread and it has been alive for...
  19. E

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    All right, since you're using Python, I had DeepSeek write a WebSocket for me and it came up with this code: Now all you have to do is run it, I'm already attaching it to this post, though. BUT the idea is to integrate it into MS Access. For that, the first thing you need to do is enable...
  20. E

    Automatically Refresh a form when table data changes externally, table macro perhaps?

    WebSockets are servers that need to be deployed somewhere. You can write your own, or let ChatGPT do it for you. Since you're already using Python, you could potentially add the WebSocket feature to the server that is currently managing your calls. I write mine with NodeJS, but there is an easy...
Back
Top Bottom