Recent content by Eugene-LS

Otherwise, forget it. I guess I'm the only Russian here. .... Democracy is a great thing! Come home and give your paycheck to the cockroaches (they have a majority of votes). ;)

Try: vba access DSum

For example: I can't open and listen to the clip: https://www.youtube.com/watch?v=p3j2NYZ8FKs But the same in rutube (!!!): https://rutube.ru/video/751defe1c51409ab3f6e97b4a5c163a9/ ... The iron wall again? That's what I'm talking about.

Everything is allowed, but YouTube is slowed down so that you can't watch the videos (in RF).

This is just a “humorous addition” to my post so that those reading it won't be so sad to read it.

- “The head of the Duma Committee on Information Policy Alexander Khinshtein ...” It's already funny! There is no such word as “information policy”, and there can't be. No one can decide what information I can watch and what I can't. Otherwise I'm a slave. I defiantly don't consider myself one...

One way more (using msoFileDialog): With Application.FileDialog(4) '4 = msoFileDialogFolderPicker .Title = "BrowseForFolder" .InitialFileName = Environ("UserProfile") & "\Documents" .Filters.Clear .Show If .SelectedItems.Count > 0 Then...

If your values luck like "24-008765-T" - you have to take the number from the fourth character, not the second. It should be only 6 characters, not all of them as you have. Mid(StudentNo, 2) <> Mid(StudentNo, 4, 6) ... :) Mid() Function Me.StudentNo = Right(Year(Date), 2) & "-" & _...

Try on AfterUpdate event of SubForm Private Sub Form_AfterUpdate() If FormHasParent(Me) Then Me.Parent.Form.YourUboundTextBox.Requery End If End Sub Private Function FormHasParent(objForm As Form) As Boolean ' Checking that the form, at the moment, is displayed as subform...

First set form properties FilterOnLoad and OrderByOnLoad to = False Try code for OnClose Event: Private Sub Form_Close() 'OnClose Event Me.Filter = "" Me.FilterOnLoad = False Me.OrderBy = "" Me.OrderByOnLoad = False End Sub

If you want - post your application here (without confidential data) - I will check it under MS Access 2021 x64

I agree with you, but most MS Access applications do without it. Reinstalling ODBC and OleDB drivers is a matter of minutes.

If you don't use API functions - it will work properly at once. If API functions are not adapted for x64 - you will have to adapt them.

Maybe the "KPI_qryMain" query outputs the "UserID" field twice Check it out

It occurs on FormLoad procedure ... event when a form is loading