Search results

  1. 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.
  2. 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?
  3. MsAccessNL

    Opening Website - looking for error

    Did you check if the page will open when the url string contains an incorrect ref nr?
  4. 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…
  5. 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).
  6. 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.
  7. 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...
  8. MsAccessNL

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

    You gave the solution, thnx, thnx and thnx!
  9. 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?
  10. 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…
  11. MsAccessNL

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

    Thnx for the info, I haven’t and i have made many databases, neverhadyhis problem. Ithink something is corrupt.
  12. MsAccessNL

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

    thnx, george i am an experienced developer, no beginner. Both are number, access 2010 doesn’t has long integer as a seperate type.
  13. MsAccessNL

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

    I get this error when linking PK to Fk with referential integrity , Also with a newly created test db. It looks like my Access is corrupted, or am i missing something. I noticed that that Access started numbering my databases again with nr 1 >> Database1 I am using Access2010
  14. MsAccessNL

    Solved How to make editable query of Contacts linked to table Notes and Table EmailAccounts?

    This is the first time i had the idea to make a seperate notes table, to have an easy overview of all the customer related notes, i really didn’t see this (problem) coming. It has cost me a lot of time, but like always , the learning experience is worth a lot 😃
  15. MsAccessNL

    Solved How to make editable query of Contacts linked to table Notes and Table EmailAccounts?

    Thnx, this brings me closer to the solution. I thought this would be an easy query, how wrong i was...
  16. MsAccessNL

    Solved How to make editable query of Contacts linked to table Notes and Table EmailAccounts?

    I understand your question, but it's one big mess of everything i am trying...Thnx anyway
  17. MsAccessNL

    Solved How to make editable query of Contacts linked to table Notes and Table EmailAccounts?

    It will work when i link T_Contact to T_Note but if I also link to T_EmailAccount it does't.
Back
Top Bottom