Search results

  1. MsAccessNL

    Preventing end users from using copies of your front end - the solution

    I fully agree with you and I want to complement you with your design. It looks very slick and modern. Well done!
  2. MsAccessNL

    Preventing end users from using copies of your front end - the solution

    I think this should work. I am always a bit scary to use timer code,especially every second. Vba doesn't run asynchronoustly so i wonder if this Doesn't slow down other processes in Access? Do the experts have an educated point about that? (Don't forget that an experienced developer could get...
  3. MsAccessNL

    VBE custom code colors (syntax highlighting)

    My attention is drawn by the SaveBeforRun setting. Sometimes when I edit my code (without saving) and i run it with an error, the changes are gone, could this be an option that the code is automatically saved before running the code?
  4. MsAccessNL

    Sample Clothing Inventory Database

    Would be great to have a page on this forum with a library of this kind of (older) applications, it would be a great learning page for Access starters and users. May be you have quite a bit more on your shelf.
  5. MsAccessNL

    VBE custom code colors (syntax highlighting)

    Thx for the infoI have been experimenting with the gallaux code to. I am currently using a QHD screen and i want to make the font size in the nav pane and in the vbe explorer pane bigger, do you know a hack to do this?
  6. MsAccessNL

    Presentacion y aportes.

    Hola, quires un Cola? (I know you may shoot me.. estoy un poco aburrido)
  7. MsAccessNL

    Solved A block of HTML code as the Default Value in a Long Text field

    I have a lot of experience with Html in Access. I have working html menu’s and html tables inside access. I store html, css and js in a long text field, don’t enable the rich text option. I need some more info about what you are trying to accomplish...
  8. MsAccessNL

    Method to copy small files as quickly as possible?

    May be the copy folder api from Colin wiil be faster? https://isladogs.co.uk/api-file-copy/index.html
  9. MsAccessNL

    Solved Edit Records from outside the Access DB

    Save your data to a textfile on a shared folder (one drive) let Access check (on timer or other event) if this folder containsa file and import the data, move the file to an archive folder after update. I made a db this way wich checks for updates every second.
  10. MsAccessNL

    Can I set the font size of Ribbon or Nav Pane?

    I am working on a so called QHD (2550*1440) 24 " monitor. The font of the ribbon and the nav pane are very small. Making the font larger in the Windows settings, doesn't have any (or much) effect. Is there a way to adjust the font size?
  11. MsAccessNL

    Opening Website - looking for error

    Did you check if the page will open when the url string contains an incorrect ref nr?
  12. MsAccessNL

    Solved Virtual link between variable declared as field and recordset field?

    Funny, I had to think about the exactly the same post. Two minds with the same…
  13. MsAccessNL

    CSV or XLSX Bank Statement to Access module (need to import via VBA and then write back to Excel with imported flag)

    I would import all the data into a table, you can also try TransferSpreadSheet, and after import i would move the excel file to a different folder called “Imported”. How do you want to prevent that the same bank statement isn’t imported twice (your flag system will not work for this).
  14. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    This is the project I am working on. When you drop an email in the dropbox it will connect to the task or make a new task if you want with the subject as taske and the email connected, attachments will also be saved and connected if you want. When you drop a file the same options are available.
  15. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    Sorry guys, i have to appologize a thousend times. When i create a new table in Access, i select the number field as foreign key ( I have done this many many times), but in this db i encountered a lot of linking problems. I made a test db and encountered the same error. My mind was jumping to...
  16. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    You gave the solution, thnx, thnx and thnx!
  17. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    I am afraid of loosing all mysettings and addins. Nobody encountered the same problem?
  18. MsAccessNL

    Solved Relationship must be on the same number of fields and data type Error?

    I didn’t see that one, definitely some kind of corruption, mineis showing autonumber and number…
Back
Top Bottom