Anonymous
My feedback
-
20 votes
An error occurred while saving the comment -
6 votes
Anonymous supported this idea ·
-
81 votes8 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
We are well aware of this issue and are working closely with the Windows team on resolving it. Although we believe we have a solution to the problem, it introduces some new issues that we need to investigate and resolve before we can deploy the fix.
Regards,
Access EngineeringAnonymous supported this idea ·
-
56 votes
Anonymous supported this idea ·
-
8 votes
Anonymous supported this idea ·
-
46 votes
An error occurred while saving the comment Anonymous commented
Public Declare Sub keybd_event Lib "user32.dll" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
keybd_event vbKeyF2, 0, 0, 0
-
413 votes
Thank you for your feedback. The Access team is currently looking into resizing Access applications, starting with forms. We will provide you with a notification when this is available, and will continue to work on additional resizing/zoom support within different areas of the product at a later time.
Anonymous supported this idea ·
to test the problem, run the function with an open table
then with others ...
Public Function MaxOpenDatabase(Optional plngLevel As Integer = 1) As Integer
Dim db As DAO.Database
On Error GoTo ErrorHandler
Set db = CurrentDb()
' Appel récursif
plngLevel = MaxOpenDatabase(plngLevel + 1)
' Sort de récursivité
EndSub:
Set db = Nothing
MaxOpenDatabase = plngLevel
Exit Function
ErrorHandler:
If Err.Number = 3048 Then
' Cannot open any more databases.
ElseIf Err.Number = 3014 Then
' Cannot open any more tables.
End If
GoTo EndSub
End Function