Search results

Just so much bull @Pat Hartman. In the particular - they are not the same scientists/people. In general they are - they are scientists they are experts in genetics and molecular biology - unlike you who puts up the straw man argument that they claimed you could not contract COVID. Get real. So...

Just sayin' the crap that you were promoting about RNA altering DNA is BULL. That was ALL I was saying. I did not argue about any other point (altho much more was contentious). I hope you can comprehend. And while you might believe anything you want to, to try and put out a false narrative -...

But is it not the money that you / Trump is interested in - willing to continue the conflict if Ukraine concedes and "sells" its rare earth minerals in exchange for continued support? As I think you concede Russia is not a party to be trusted, so what is the exchange for if it does not include a...

I am not the one to decide for them. You can see how so many in different places in the world now and in the past have held on to their history, their heritage and will not concede.

But that is not the situation is it - while many have died, there are many fighting, many injured, much destruction of property. but they resist and persist. Put yourself in their position - being attacked by aggressor, a dictator, having your family under threat, having lost or injured some...

Both of the suggestions can be used to support a search from a text box across multiple fields. IIRC they also have a sensitivity that can be set to only begin searching after a specified number of characters have been entered. The MajP solution I think is up to v19 btw - not v15 as I linked.

There are any number of solutions to free text search that may be adopted/adapted - @MajP has posted a FAYT - for text search, combo, listbox, .. https://www.access-programmers.co.uk/forums/threads/fayt-for-multi-column-combo-code-from-majp-question.319205/post-1781383 Another I have used from...

que no

@Cotswold - you do realize that what these show does not support the misinformation that I was flagging in your post. Website 1 - is about epigenetics, and in this case mRNA having an effect on the regulation of DNA: ie its suppression or promotion of the genetic code to result in more or less...

That's bull! and again! The basic biology of DNA is that DNA is an instruction set for building various proteins. The instructions are passed from the nuclear DNA to the ribosomes where proteins are built in the cytoplasm via the mRNA. It does not go the other way.

InStr returns the position in a string where the other string is found. You are attempting to filter Collector by the position value. I don't think that is what you want. https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/instr-function

@arnelgp and @The_Doc_Man. Thank you for your assistance. Using the hidden form method is working to save the PrintPreview as a pdf on Close of the PrintPreview (if user responds Yes to save) avoiding the runtime Error 2585. The requirement was to prompt to save the PrintPreview when closing it...

Thank you - I will get back to the relay file concept - busy and away for a few days. Re the KillFile: The code is: Public Function KillFile(filePath As String) As Boolean ' Function to delete a file: ' makes sure its file property is set to vbNormal (use SetAttr function). ' Also verifies...

Yes. Will look at the other suggestion. EDIT/ UPDATE Same error occurs when the call to the public function is made from the on unload event of the report in Print Preview

I am constructing a public function which accepts inputs and prompts to save various reports in a specific folder when called on the close event of the print preview of the report. The relevant code where this error occurs is: sFilename = sRptPath & sFilename & sFileType MsgBox...

This is where you need to use terms very carefully: Trying to tease out TestGroup, TestType and TestResult. From the above: 1 test has multiple "observations" appears to be somewhat ambiguous: each observation is a TestResult, the test result must be the outcome of applying a specific TestType...

Perhaps a technique that could be used is to use an unbound control to accept the pasted value and then apply the sanitizing routine. The value is then pasted into the bound control. This can be done with the unbound control hiding under the bound control (sent to the back), but when focus is...

No syntax errors are reported by Poor SQL (a useful online tool you might use) for the supplied SQL, however I made some adjustments - without change to the inner join clauses - see this code below (now Amended) . Also if you require review of SQL syntax: W3School - SQL - Inner Join Found Admit...

The client specifies, when the batch is supplied, the tests to be applied as one or more test groups? A test group will involve at least one test. However do all tests belong to a test group? Core relationships: A client raises an order requiring the testing of one or more batches. (from...

If I am interpreting this correctly, and in support of suggestions from @plog the table relationships are represented graphically as: Some questions: User has a relationship to Sample - what is the nature of this relationship? Are you interested in knowing who tested a sample? (eg in general a...