Search results

You'll need to create a function that accepts a marker value, pulls the value for each allele, and goes through that recordset and eventually returns yes or no based on your criteria. The easiest way would probably just be to pull up any records with value greater than 1000, and return yes if...

You absolutely can do the whole list in one shot, as plog pointed out. There's absolutely no need to type out every individual name. UPDATE TableName SET FieldName = Trim([FieldName]), FieldName2 = Trim([FieldName2]); Just be DAMNED sure you use the same field name on both sides of each...

Welcome to my life. IT has a 'No Access ever under any circumstances' rule for everything it does. All the assorted departments, on the other hand, keep dedicated Access developers on-hand for all the department-level Access applications. And we are not a 'small business' in any sense of the...

If you have a user-level security system built in, you can use the AutoKeys macro to run code that toggles the NavPane if the user is a developer, and cancels the F11 if they aren't.

I've seen them online in a number of places, so I can't attribute them. One location you can pull them from is https://en.wikibooks.org/wiki/Visual_Basic_for_Applications/String_Hashing_in_VBA. I'm providing the link instead of just copying and pasting the code because there's other useful...

You're not deleting them. You're moving them into the front end, that's all. Just keep a backup copy someplace, and update it as you update your app. It's just as accurate to say you're deleting the tables and creating them in a new file as it is to say you're deleting the forms. The reality...

I should have been clearer. What, if anything, do you have the application run (via the AutoExec macro) when you start the application normally? Although the fact that you get different reference library locations if you load directly rather than if you load Access, then open the app seems a...

Out of curiosity, what, if anything, do you have running at startup?

Yep, what he said. Your DBA has tools available to tell him what the process is waiting for, what is blocking it (if anything is), etc. Him telling you 'your application is suspending and locking the server' is much like a doctor telling you 'Yep, you're sick.'. If you know which queries this...

Yep, Public is the default.

Curses, beaten again!!!

Cancel simply cancels the event that was triggered. To undo the change that was done, you need to use the Undo event: txtStartDate.Undo

I've never considered bundling it all into an execute query function - whenever I've had to run a query with form references built into it, I've just added this part to the code (with appropriate declarations up top) For Each prm In qdf.Parameters prm.Value = Eval(prm.Name) Next qdf.Execute...

The net neutrality repeal doesn't result in Netflix raising prices - it results in carriers deliberately blocking or slowing access to competitors and political opponents, and to internet plans that look like this:

Or you could do what I did and give up TV entirely. That's what I did back in 95. Even then, the TV news seemed to be only about body counts and disasters (and their body counts). The important stuff I could get online even then, and the shows available weren't enough to keep my attention on...

https://www.youtube.com/watch?v=a1Y73sPHKxw

Hopefully they won't kill you they way they did my father. He spent six months gasping for air due to his inoperable lung cancer, then one night drowned in his own blood. I've had two grandparents die of lung cancer as well, both, like my father, life-long smokers. Possibly three, but I was...

OR in JOIN clauses are perfectly valid, although it's far more common to see in a WHERE clause. It's most commonly done when you want to restrict the records being pulled in to the temporary table being created behind the scenes, as opposed to after the table is created. In theory, OR in the...

If you look closely, it also gives an example of aliasing. That's something you don't usually have to deal with in Access, since most queries are handled through the QBE grid, but if you ever start working with SQL Server, it's a godsend.

You know, that is an amazing graphic to have when explaining joins. I'm totally ganking that thing.