Search results

  1. 5

    How to avoid records missing in database

    Maybe check if they're replicating to another database and the replication is correctly setup.
  2. 5

    How do I bypass "Cannot find the referenced form frm_FromName" without opening the form hidden?

    Navigation controls open one form at a time. The setup you describe should work as expected if the first/default form in your navigation control frm_Main is frm_Members and if the first/default form in frm_Members is frm_UserList. If they are not, then either make them first/default or make sure...
  3. 5

    Load Web Calendar into an access form

    Absolutely, and I suspect your best bet would be using vanilla javascript, no frameworks, something that is compatible with IE, because you may have (or not) the most up-to-date version of the browser control, which runs Edge, but I think most people will have the IE compatible version...
  4. 5

    Gta 5

    I'm getting real good identifying chatgpt text
  5. 5

    Tables - Multiple Instance - Why do this?

    The instances allow you to create the relationship within the editor when you have two foreign key columns pointing to the same table, but you can also do this within VBA like this: Sub CreateTableWithRelationship() Dim db As DAO.Database Set db = CurrentDb ' Create parent...
  6. 5

    How to assign the data contained in a recordset in memory to a report?

    I've said it in the past and I will say it again. You have issues, and they're not related to Access.
  7. 5

    Solved Subtract hours

    Oh, I've never modeled a calendar view in Access, maybe there's stuff I haven't considered. I modeled one in JS populated by an object to which you could push arrays of timestamps with icons and descriptions. No tables were bound to the calendar itself, only its timestamps. I guess something...
  8. 5

    Solved Subtract hours

    I understand you want to get work time vs break time. Your TRegistros table is modeled in a strange way, you have a column for Inicio and a column for Final, and you also have a record for Inicio and a record for Final for each type. Option1 If you're going to record the 6 events, then you only...
  9. 5

    How to assign the data contained in a recordset in memory to a report?

    I would check what else can be used, maybe HTML or bare txt file.
  10. 5

    How to assign the data contained in a recordset in memory to a report?

    A custom function that creates Word or Excel documents based on a template. Depending on the context of what I want to return. I would not use mail merge either, it sucks.
  11. 5

    Database setup for school objects

    If I understood correctly, you want your teachers to create a list of the objects their pupils will need. Like teacher 1 wants erasers and pencils for course a teacher 2 wants notebooks for course b teacher 3 wants rulers for course c If a student happens to have courses b and c, you want to be...
  12. 5

    How to assign the data contained in a recordset in memory to a report?

    As if I needed another reason not to use reports.
  13. 5

    Convert Access FE to web app

    That's only if they want to output a Word or Excel format. If what they want to do is generate printable documents, HTML is way more stable and customizable than Word, and PDF files can be generated from it. Same for Excel tables and documents. But if you wanted the .docx or .xlsx file, then...
  14. 5

    Convert Access FE to web app

    I've always considered the best way to get into web development is by creating an app that you're genuinely interested in using. Not only will this keep you motivated, but it will also help you understand the effort required to bring it to life. Project-based learning will give you hands-on...
  15. 5

    Convert Access FE to web app

    I have experience with React/Antd for the UI and Node/MySQL/Express for the backend, you write your code in JavaScript. You can setup a server within your intranet in a matter of minutes with these. As for the UI, the Antd library of components is excellent to modernize your Access App. If you...
  16. 5

    BCrypt

    That's pretty useful. Bcrypt is standard in web dev, it would be nice if more developers adopted that in Access.
  17. 5

    Type mismatch for date. Cannot query via direct window

    What list does intellisense provide you with if you type another dot after Datefield like Me.Datefield. ? That should tell you what is interpreting as Me.Datefield. You can also expand your Me variable in the locals window. You will get your answers there.
  18. 5

    search by what you select in combo box

    Podrías subir aquí una copia de tu base de datos. Asegúrate de quitarle cualquier información sensible. Sólo es necesario ver cómo está estructurada tu base de datos para poder ayudarte. También podrías explicar qué tablas tienes y qué campos tienen.
  19. 5

    Is it possible to learn House Building on our own?

    Dear prabha, Learning House Building is not too difficult. I advice you to involve yourself in construction sites if you want to learn the proper way. Then you can ask the workers, architects and engineers, which will be very valuable as they have hands-on experience on what you want to do. I do...
  20. 5

    search by what you select in combo box

    Claro que se puede hacer, pero necesitamos saber cómo está relacionada tu información. A como lo veo yo, tus tablas deberían estar acomodadas así: tabla_socios (tal vez tabla_padres?) -SocioID o PadreID -NombreSocio -ApellidoSocio tabla_hijos (tal vez tabla_jugadores?) - HijoID o JugadorID o...
Back
Top Bottom