Hello everyone,
I'm encountering an issue when exporting data from a Microsoft Access form, which includes subforms, to an Excel file. Specifically, when I attempt to sort the data in the Access form (either ascending or descending) before exporting, the exported Excel file ends up containing...
i fixed it with below code : Thanks you all
Private Sub userName_AfterUpdate()
On Error Resume Next
Dim db As Database
Dim rst As Recordset
Set db = CurrentDb()
Set rst = db.OpenRecordset("Select * from tlogin where userID =" & userName)
If rst!remember = True Then...
Hello evreyone,
How do I prevent other users in internal network To use my username and password if I saved the username and password in the tabel login as remember
My UserName have full accsess , i dont need others user to see it .
Note :- Database was shared internally in internal network...
Option Compare Database
Option Explicit
Private Sub btnCalculator_Click()
Dim calculatorPath As String
calculatorPath = "C:\Windows\System32\calc.exe" ' change the path if necessary
Shell calculatorPath, vbNormalFocus
End Sub
Private Sub btnDemo1_Click()
If IsNull(Me.form1) Then...
Thank you for your response, @The_Doc_Man. I believe I've identified a few key points :
1. i suspect that the issue may be related to the image type used for buttons, and i have noticed that : changing the icon to image type ( ico or bmp ) format resolved the problem after testing it multiple...
Hello evrey one
When i add or Change buttons .icon or images in my databas i see below erorr after it :
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
*There may have been an error evaluating the function, event, or macro*
Note ...
Could you please provide more details? @Pat Hartman Thank you in advance
Editing on VBA codes,
or making regular modifications on data entry in other forms
i have Simple Live chat between users as messages pop Running with timer = 1000 is only 1 seconds. now 😞 should be better to changed to 30 seconds or delete it from the system , Thank you for your advice . i appreciate it @The_Doc_Man
Hello everyone, I'm looking for help .
I need a professional to review the database (codes and the relationships) to ensure it's reliable to avoid future issues. I'm not a professional
I'm willing to pay a small fee if it's allowed her .
Thank you