Search results

No I understood what you meant, I wasn't clear on my reply. Let's say the BE is loaded on \\NetworkPath\BE_Folder. So far (knock on wood), my company hasn't been saying "In two months, we are going to change \\NetworkPath\BE_Folder" to a OneDrive file folder. They have been saying things like...

Not quite clear to me below: I gave you bad information earlier. The database uses an AutoExec macro that calls an AutoExec VBA script. The VBA script opens a hidden Down For Maintenance timer form, then it calls an AutoUpdate subroutine that checks if the user is authorized, if the database...

Directly. (Probably via a shortcut after this update, but ...) I possibly where you are coming from and it leads to a good follow-up question: @The_Doc_Man: Currently the database opens, imports an Excel file, checks if the user is authorized, and then checks if it is on the User's Desktop or...

I think I can get there with variations of @theDBguy code. Answering some other questions: @CJ_London - I don't think that we have write-access to C:\Databases. We do have write-access to C:\Users\<username> - and putting it in this subtree ensures that the logged in user is the only one...

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...