Search results

"Karl-Franz Helmut Markus Heinrich Schmidt-Miller III, Esq. (Bob)" Yep, that is PRECISELY why we always recommend storing each name in its own field. :D

I have to agree with the others - unless there is a documented business need for calculated data to be saved for some reason, you should avoid doing so since it just wastes space. In the example you gave, you have the DOB and you have the date they were entered into the system. With that, you...

DBGuy - I wonder which would run faster, your solution in 3 or mine in 4? The one I gave in 2 kind of sucks.

Actually, even better: Select DISTINCT all records from the table with value greater than 1000. Query should just return the Marker. Let's call it IncludeList. Next, left join that to your main query on the Marker fields. For Include, use this: Include: IIf(IsNull(IncludeList.Marker, "No"...

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