Search results

You misunderstood. I have a function called GetUserName, which basically does that. Let's say my user name is "12345". I want the database to open if the database is located in: C:\Users\12345\Access Database C:\Users\12345\B C:\Users\12345\C etc. But not in: C:\Program Files\Access Database...

I have code to basically only allow my FrontEnd to open from the users desktop. Skeleton code looks like this: Location1 = "c:\users\" & GetUserName & "\desktop" If LCase(CurrentProject.Path) = Location1 Then ' Do nothing Else ' Close Database with message End If Our company is getting...

THANK YOU!!!! - Ecount2 works perfectly!

@Josef P. added more info ... As I see it, I'm still at the three options shown at the end of Reply #6: Keep using Dcount and ignore Ecount in this instance. I have tested and Ecount seems quite a bit faster than Dcount, but it doesn't work. Abandon Dcount/Ecount and use ELookup - which would...

@Josef P. and @MajP - I didn't quite follow the replies ... No, not exactly. The query works fine as written as long as I use DCount. ECount fails with it if I try to use it. I was trying to revise the query SQL to get DCount to work and that was failing. I want the query filtered. I am...

Good thought. Works for the query, but still gives me the Too Few Parameters Error with Ecount, and then the Invalid Use of Null Error. I also tried: And with that, the query didn't show any results.

I have a query that extracts records from a table that match a field in the current record on a form. I use Dcount to tell if the query has any results, like this, and it works fine, but I would prefer to use Ecount: If DCount("EVENT", "qryAuditLog") = 0 Then Ecount works with other queries...

Solved - this was a Citrix settings issue: If I change Preferences>Display from "Best Size (Recommended)" to "Actual Size", the issue goes away.

This will be hard to explain and I know the workaround, so I could just live with it. My database forms have a background image. The settings for the image are: The issue is that if I open the Citrix desktop in windowed mode, then open Access, then switch the desktop to full screen mode, the...

I'm still standing by what I learned in school. If I steal someone else's work, it is plagiarism. If I create the exact same wording as someone else without their work to go from, it is coincidence. The online plagiarism checkers came about primarily b/c it was impossible for teachers and...

Makes sense - the link is in this thread and if you ever close your website, you have given permission in the code and in this thread for the code to be re-posted.

I am US-based, but please do NOT take any of my comments as representative of US Copyright law. As I said before, IANAL. I thought so too until I read it carefully. MY interpretation was that plagiarism was KNOWINGLY taking someone else's work (words, specifically) and claiming it was your...

We are getting into semantics and somewhat off topic, but ... From the link you posted: "Plagiarism is the act of taking a person’s original work and presenting it as if it was one’s own." In the hypothetical I posted, I never took another person's original work - more semantics - I never...

Negative. IANAL, btw. If I create a 5,000 word thesis freely as my own work and it matches word-for-word what someone else wrote 5-years ago, which I never read and was not aware of, it is not plagiarism. (Now the odds of that happening and the odds of my being able to defend my claim in court...

Concur - although there should be a rough correlation. I thought a saw a duration setting, but I don't see it now - I thought it was in the original AllApi code and not the code you posted. However, there is: .uCount - the number of times to flash the window. dwtimeout - The rate at which the...

@sonic8 - Good catch. Technically, per the documentation: uCount As Long ' The number of times to flash the window. So it doesn't say .uCount affects the taskbar, other than higher values make the taskbar flash more times than lower values. Not consistently. For Colin, it is flashing...

Works great - I like it!!! (in 64-bit). I imported your module and then I added: Sub FlashIcon() FlashWindow (Application.hWndAccessApp) End Sub One thing odd is that .uCount seems to be a bit off. You had it set to 10 and it seemed to flash 8 times for me. I set it to 12 and it flashed 10...

@sonic8 - Appreciate it. Unfortunately, there were several non-working attempts and I deleted them after I got the FlashWindow non-EX working. Documentation showing the duration is here: http://allapi.mentalis.org/apilist/354B35E13B1AEE7522455E5478278369.html The main thing I attempted was the...

Appreciate it - it works the way I posted it, but probably not always reliably. For completeness, in case the other thread dies, for 32-bit it is: Declare Function FlashWindow Lib "user32" (ByVal hWnd As Long, ByVal bInvert As Long) As Long I think I know why ... It is supposed to flash the...

Concur, depending on your purpose. In my case, I'm using it for an idle timeout if someone leaves the database up and walks away and/or walks away with the computer running. Without the flashing the database gained focus AFTER the pop-up to cancel the form closing appeared. Another recommended...