Search results

  1. A

    Solved Access not displaying properly

    Maybe it is in a wrong position because of some display metrics? Do you have a different monitor or resolution as before? Or did you change the scaling? Or did you use a second monitor in the last time and now it isn't connected any more? Just guessing because it seems to be so weird...
  2. A

    How many connection from Access front-end on pc1 to db server on pcX ?

    @arnelgp : Out of curiosity, where did you get this information ("while your SQL Server can have 255 connections") from? I would like to read it's context.
  3. A

    Delete event triggers for moving files

    What is wrong with my suggestion? Did you try it? It also handles the deletion of multiple records in the form.
  4. A

    Dcount with miltiply criteria

    If 'rejected' and 'new' are fix string literals (so no variables or controls) then you can use this: =Nz(DCount("Field1";"Form";"status1='rejected' and status2='new'");0) Edit: Please try to use code blocks in your postings. This makes code much more readable for us (see my code above).
  5. A

    Delete event triggers for moving files

    How about that: It assumes that you have a control named 'uxFilePath' in your form. The module collection variable 'filePathsToDelete' will hold the file paths to be deleted and is filled by the 'Delete' event. Then later the 'AfterDelConfirm' event procedure checks if the user commited the...
  6. A

    What is wrong in the Code

    Your criteria Me!sfrRoomOccupations.Form!DepartureDate is part of the string, you have to concatenate it. And take care to provide the correct format (#). See here: Date and time criteria from a control on a form
  7. A

    List of methods of a class in intellisense - 2

    @MarkK: Thanks for pointing this out. I had only included 'TypeOf' and 'Typename' in my example database and did not explicitly mention them in the thread. (y)
  8. A

    List of methods of a class in intellisense - 2

    It's great that you've recognized the advantages of the approach and can use them for yourself. That's how it should be. :-)
  9. A

    Sending Email SMTP setting

    Sending mails via SMTP from VBA is a tricky thing regarding ports and protocols. To get a deep insight I would suggest to read Philipps article well. Additionally I would expect that all this belongs to the servers setting an not to the clients. So I wonder why there is a difference in...
  10. A

    List of methods of a class in intellisense - 2

    Thats correct, it's not you doing something wrong. Because mySpecialForm is of type IMySpecialFormInterfaceClass, intellisense only has/shows the members of IMySpecialFormInterfaceClass in this context. That is why I exemplary casted mySpecialForm to the type Form (variable myForm), to show...
  11. A

    List of methods of a class in intellisense - 2

    I would suggest to use a custom interface which provides your necessities and let your forms implement it. Then you can cast your forms in code as you need and have full intellisense and type safety. See my example here. Best approach is to step through the code and read my comments. Start with...
  12. A

    List of methods of a class in intellisense - 2

    I guess a decompile/compact would have helped to get your 'corrupted' database back on track.
  13. A

    Solved Multiple instances of accde file

    If it is possible for you to let your users open the database via a link (or maybe a batch file) you could use the Microsoft Access command line switch "/excl". This will open the Access database for exclusive access. Once the database is opened in this way a user can't open it a second time, no...
  14. A

    Any way to load a ribbon stored in an add-in?

    I didn't claim that either. ;-)
  15. A

    Any way to load a ribbon stored in an add-in?

    Well, there is also "Application.LoadCustomUI"...
  16. A

    Using a Windows 10/11 client computer as a 'quasi server' for other client computers.

    @Shimon : Thank you for your contribution. Of course, the SQL server does not limit this, as the article you mentioned too states. But the client operating system maybe does. That is what I would like to clarify.
  17. A

    Using a Windows 10/11 client computer as a 'quasi server' for other client computers.

    Thanks Doc. Ok, the current state of knowledge seems to be that Microsoft Access opens/holds several database connections at the same time, but it is not possible to say/calculate exactly how many. And with regard to my initial question as to whether a Windows client operating system limits...
  18. A

    Solved There isn't enough memory to perform this operation... (Access 2013, 64-bit on Windows 11)

    Ok, the fact that you have already converted api functions from 32 to 64 bit suggests that the problem could well be that something was not converted properly. I would set breakpoints in the code and debug to find out exactly where the error lies.
  19. A

    Using a Windows 10/11 client computer as a 'quasi server' for other client computers.

    I'm not sure about that, for example. I have in mind that Access establishes several, if not many, simultaneous database connections. For example, when several forms are open. I think I have also read in the past that each ComboBox, for example, establishes its own connection.
  20. A

    Solved There isn't enough memory to perform this operation... (Access 2013, 64-bit on Windows 11)

    Just some ideas: - First make a backup of the file. - When you're in the VBE (Code): - Can you compile it without errors? - Are there some unusual/non-standard references in the database? - If it is a MDB, try to convert it to ACCDB. - Try to decompile/compact it.
View older results
Back
Top Bottom