Recent content by Michelle Michy

Yes. It is hard for me to call the code.

Thanks. I have tried but it is not working. Maybe I am not calling the code as it should be. Please I am humbly requesting you to assist me using attached database. Please I am begging you. Please.

Somebody to help me please. Kindly humbly requesting please

Hello everyone. I have been trying real hard to find xml code which will remove file ribbon or remove backstage. When file ribbon is clicked it should not show anything. Other ribbons to remain the way it is. Look at the attached database. Thanks.

Thanks. Is there a way to lock it? Let's say to lock previous years every 31st December every year

Hello everyone. I am trying to come up with a code to autopopulate years every 1st January every year and make previous years grey as in Lock Previous years. Kindly assist me with the code please. Thanks in advance.

It works perfectly. Instead of End If, it should be End Select. Thanks so much.

Thanks @Mike Krailo and @MarkK Thanks so much. I appreciate.

Hello everyone, Kindly assist me with the following code when executed should not show Microsoft access. It should show something else which I will write. Private sub Form_Open(Cancel As Integer) If StrComp(InputBox("Please enter the Password."), "123", 0) <> 0 Then Cancel= True MsgBox...

The following function works fine in 32 bit. I am requesting for assistance for a function which will work in 64 bit. Thanks. Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String '...

Thanks. Working on it. I like this forum 🙏

Code to check folder but ultimately i need to "GetUsername" Private Sub Command135_Click() MakeDir ("C:\Users\" & GetUserName() & "\Desktop\SCHOOL REPORTS\WHOLE SCHOOL REPORT") Dim fileName As String, fldrPath As String, filePath As String, LValue As String Dim answer As Integer Dim...

When I use the following function to "GetUsername" i get an error to use 64 bit Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen...

Thanks. I found the following code and a function but i get an error "GetUsername" Function FileExist(FileFullPath As String) As Boolean Dim Value As Boolean Value = False If Dir(FileFullPath) <> "" Then Value = True End If FileExist = Value End Function Private Sub...

The users of the database may wish to analyze reports via Excel and Pdf. I would have wished somebody to help me with vba code to export as Excel and Pdf only. Thanks.