Search results

One of my login functions checks for any outstanding sessions still running on another computer. I just realized as time "keeps on slipping, slipping, slipping...into the future..." that my log file will get longer and longer and thus my Dlookup might start taking too long to run...

Now we can ask some questions to @magic_sponge. -You mention using SQL Server and these are remote workers across the internet. Where is the BE hosted? -Since you don't have direct access to these user's computers, it might be difficult to implement some of these ideas. Do you have...

Ok, I've seen a few of these threads cropping up recently (and many more in the past). There are always a wide variety of suggestions on methods and details. However, I've seen very few high level descriptions of the process. This high level description might assist those less familiar to be...

I think (it's been awhile) you could use dropbox but not directly (for the sync reasons you stated). Dropbox would merely be the pipes to get the FE to the local user. You would have some hoops to jump through, but the idea would be to copy the file off of dropbox and manage it that way. In...

That's the more reliable way. Launching the application should usually check for the latest version of the FE as part of its launch parameters. I wonder if it's possible to roll that code into the FE itself, running some code between closing the FE (triggered by the availability of a new FE...

@MajP - Makese sense. A quick aside to wrap this up.... I see in the WHERE portion two criteria. The username field and the active field. Is there a reason why one uses the fieldname directly (UserName=) and the other references the table again (tblUsers.Active=)?

Logically, there shouldn't be any difference in the application itself. Which means any performance issues are only indirectly related to the database app. Meaning, something about the file explorer window is consuming computational resources which are, in turn, affecting the performance of...

@The_Doc_Man - I was about to make a long winded post because I didn't understand your caveats, but after rereading post #6, I think I realize why I caused such a distrubance! So, now, a different long-winded post :ROFLMAO: My original question was meant to be narrow in scope in that I was...

Glad to see I lived up to my subtitle of "Pot-Stirrer" Some clarifications and explanations are in order: 1. I asked this question because my experience crafting SQL statements directly is very light and I didn't want my inexperience or syntax issues to cloud the issue. 2. I also asked because...

I stumbled across the idea of defining certain items as properties instead of functions and I like the idea incorporating intellisense and other things that will keep my brain slightly more organized. However, before I jump fully in I want to make sure that the following is still possible...

I would say this depends upon the individual but I'm sure you have seen a lot of this happen over the years. I would put my only caveat on this that the time it takes to "fix 10 things now" might still be more than the time needed to "fix 100 things later" if one's understanding and experience...

One more tip...the longer a thread goes, the better the "Similar threads" recommendations become. They are usually listed at the bottom of your thread. I've found some really good information looking through some of the threads. Many are quite old and would not normally be found perusing the...

I'll leave the database comments to those much more experienced then I. However, I will comment on this line: My suggestion to you would be to figure out the answers to the following questions: 1. When you say "volunteered to create", is there now an expectation of delivery by your company...

@The_Doc_Man is definitely making a more sensible suggestion than I. I should have clarified that my "nuked" database was simple and in early development. A more robust and aged database would be potentially harder to just nuke completely even with backups. A more measured approach is...

Sometimes it helps to take a bigger picture approach: Why do you REALLY need this functionality? Data entry mistakes get made all of the time. In practical terms you are reducing your "wrong info" percentage from .5% to .1% (made up numbers) because in order to use any type of undo requires...

Definitely sounds like corruption. Had that happen to me as well. One day the whole thing just didn't work right. Using a slightly older version and nuking the offending version and have never had (that) problem since.

I want to second that this particular thread can be VERY useful for those extremely dangerous individuals like the OP and myself who are technically inclined and understand the "basics" of Access the program (or even some of the "advanced" stuff) rather easily but trip on the "basics" of...

@isladogs - We had quite a stretch of my "real" job taking priority. But, the winds have shifted once again so I'm back to try and remember everything I've forgotten since the last stretch of activity.

Logged in after a long break. Nice thing to come back to. Congrats Colin!

That's the one I learned on back in the day. I will say it was easier to understand that version with my knowledge at that time, then it is understanding the current NW with my greater knowledge now. Fancy layouts are nice (I like to learn how to make fancy layouts!) But, if the methodology...