Search results

Your form is similar to a questionaire and you may pick up some designs by searching for samples - plogs proposed arrangement is a valid starting model that follows a similar structure. For the responses to any question your form would probably use an option box control, where you might make the...

Refer back to the db schema provided - note the naming of the primary keys and the joins illustrated. MajP discusses this above. You use the relations/relationship (based upon the keys: Primary Key (PK) / Foreign Key (FK)) to tell you how data is logically associated, and use these to construct...

Most/all of your combos will be driven from the Type tables - using a query of the table to show the displayed value, hiding the stored ID of the particular type. Type table lists should not be arbitrarily edited - you need to avoid multiple terms being used for the same type. However they can...

A UNION query does not merge records, it combines the individual records from each source into one common form/presentation. Hence you have 2 records for those YearMonth. To now get the combined amounts, you write an aggregate query based upon the union query. What would be the rule for...

Access will not allow mixed datatypes, and to a database modeller/designer, those are two different data items (and so normalisation rules apply about atomic data items) - one that accepts/records a specific value such as applicable tax band and another perhaps boolean, which says, say...

That will be a judgement call: it is quite legitimate to have a separate Site table to hold the location details, however really this is only useful to you if you find that the Site information is re-used quite often for different jobs - you did mention that you (sometimes) quote for a number of...

Where there are more than one record satisfying the criteria in DLOOKUP, the first record is returned - not the immediate prior record Or a random value from the field: see DLOOKUP You might need to use some sort of sort, to then get the value from the previous record based upon the sort.

This is a form design problem needing to support your work flow, however I would suggest again that this is likely something like: A New Job (Quote) is to be raised: Prompt -->Existing or new client? if Existing then Prompt --> Present Client Sites to select or New Site btn Queries supporting...

I'll just address this question at this time (gotta get other things done) Site role is the site specific role a contact has for a job: eg the designated architect. However your contacts have a position/ expertise within the company in which they are employed - such a company director /...

The development of database using the relational paradigm requires the application of normalisation techniques to minimize data duplication - redundancy, ensure the data is logically consistent, and data integrity is maintained through the established relationship / rules between the tables in...

strwhere, I expect is going to be used in SQL, or at least as a legitimate SQL experession. You need to make sure you construct the criteria with the appropriate column names - perhaps like strWhere = "Yearcolumnname = " & tempvars("DateLimit") & " AND AccountcolumnIDname = " &...

As a start: Datediff Does not recognise "year" as an input setting: datediff-function As a side issue: you are assigning current members a membership rate for the current year, I think. What it implies, as you keep this info on the members table, is that you keep no history of payment of...

s/ I live in fear of your undoubted wisdom re the scientific method @The_Doc_Man: trembling in awe of your authority /s :oops: ... I was not leaving out the link you described. it was in relation to Pat's statements which were not about what you are discussing. The research conducted by...

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

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.