Search results

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

Yes - all the inner joins are unnecessary if the desired Student Profile records required always contain valid FK references. Any Student Profile records that do not match to the other table on the FK (eg a null FK in Student Profile) are excluded in the result. Using a Left join for these may...

Try this - I do not think you need to use UNSW_Maths table - appears to be trying to retrieve course code twice. The focus is to id the students in the course, that are school leavers and failed the course. SELECT [Student Profile].UNSW_MATHS_COURSE_CODE ,Grade.GRADE_DESCR...

@LarryE - I hope the OP will learn from the help provided here. While the OP may launch into a physical design and may have created some tables and relationships, as the OP recognised, it was incomplete/ flawed and your input may assist. However, without getting into systems design and...

Based on this and your other post you are at the very beginning of your journey to learn not just about MS Access, but about relational databases design and development. First answer some of the questions raised above - what is your intent? Is this database to be used to manage a school you are...

What help do you need? You have posted a database containing tables relating to students and classes, fees and teachers, etc. A school database can be very extensive or limited depending on YOUR needs. Specify what it must do. Research to find what others have done. Concentrate on the...

You can't use a template file when using OutputTo with Excel. From the MSDN documentation:

Note - as you have said, and require, that a Proposal exists and then, when accepted, becomes a Project (and a project can only have one proposal) then you may as well say a Project-Proposal is the one table and the proposal becomes a project when its status is changed to accepted. That may be...

So a contact is associated to a company - so why have the FK to the company in the Proposal table? You can obtain/display that from the contactID FK in Proposal, joined to Contact table then to company via its FK to Company in the display of Company of the form - it would be a read-only, and...

Hi @dalski - I question what you are attempting or expecting to happen here: The "Client Company" combo's purpose is to select a company from the list of all Companies (based on a Companies table query), so that the list of contacts is restricted to those associated to the Company. Do you...

From your responses and discussion, I would agree with @June7 that 1 table for all proposal types would seem appropriate for you. Pat's EAV suggestion could also work for you however you would have to deal with a more abstracted table design and underlying coding. You still need to...