User Profile
perrycheng
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Windows 11 File Explorer freezes when renaming files
I have the same problem with Win 11. Explorer is extremely sluggish when renaming files or folders. Why?? I have the latest built, Windows 11 Insider Preview 10.0.22483.1011 (rs_prerelease). This has been going on for months. The same thing as with Office Apps, they are very sluggish at times.44KViews0likes0CommentsRe: MS Access force a popup on top of other windows?? Is this possible?
So, I found a codes below from somewhere, can't remember where. It works! However, it closes all my active forms. I really don't know what this module does for me, so, I don't know how to prevent it from closing my active open forms (it is a module, and then I just call it from an event): Option Compare Database Option Explicit Public Declare Function SetForegroundWindow _ Lib "user32" _ (ByVal hwnd As Long) _ As Long Public Function ActivateAccessApp() As Boolean 'Brings the DB to the front of all open windows Dim appTarget As Access.Application Set appTarget = GetObject(CurrentDb.Name) ActivateAccessApp = _ Not (SetForegroundWindow(appTarget.hWndAccessApp) = 0) Set appTarget = Nothing End Function13KViews0likes1CommentMS Access force a popup on top of other windows?? Is this possible?
I am just wondering if there is a way to have access display a popup form (even just a message saying, "hey you got a new entry by an use!" ON TOP of another window (say, Chrome Explorer, or whatever other windows. Is this possible??13KViews1like4Comments- 1.5KViews0likes1Comment
Help with Query Criteria
So, I have a value (text) in a form, that was generated from multiple selected list. e.g. the text box says, 'AB1' or 'CD2' or 'EF3' I want to pass this value ('AB1' or 'CD2' or 'EF3') to a query field (e.g. customer). Well, I can see that the text can come over, but it is not behaving in the criteria section. I can hand type 'AB1' or 'CD2' or 'EF3' in the criteria and the query will work, but when drawing the value from the form, it will not filter. Why? I did a simple expression, expr1: [Forms]![FormName]![Field] and it display exactly as 'AB1' or 'CD2' or 'EF3' . Why can't it filter in the criteria?? Help!! Thanks in advance. Sincerely, Perry1.5KViews1like4Comments
Recent Blog Articles
No content to show