User Profile
Collapse
-
Bruce Callander replied to Why don't the database relationship fields display correctly in the form?in AccessSueB - I appreciate your apology but I felt pretty bad when I looked again at my contribution, which in retrospect I agree was completely unhelpful. One lives and learns ... -
Bruce Callander replied to Why don't the database relationship fields display correctly in the form?in Accesssueb - I had a quick look at the database. It really needs to be normalised into separate tables. By putting so much into the IUR table you are making it difficult to manage and not gaining the benefits of a relational database. For example there is no need to hard wire a maximum number of three telephone calls against each patient. Make telephone calls a separate table and link them to patients via the unique patient ID. Also, if you ever want to...Leave a comment:
-
Are you using unbound forms (not linked to a particular table or query)? Also, will the data from Form A become a record on its own in the target table, or is the data from Form A to be combined with Form B/Form C before adding to the target table?Leave a comment:
-
Bruce Callander started a topic Dates entered as variables n MS Access give unpredictable results in SQL queriesin Visual BasicDates entered as variables n MS Access give unpredictable results in SQL queries
This article results from a problem I encountered in an Access database.
SQL assumes that dates are in US format: MM/DD/YYYY. Suppose that a date is entered into a MS Access form and then used in an underlying SQL query. If the date is in UK format DD/MM/YYYY then unpredictable results can occur because Access attempts to interpret the date as if it were in US format. If a valid date results then the procedure proceeds with an altered...Last edited by MMcCarthy; Nov 25 '10, 06:28 PM. Reason: Added parameter to function in last statement
No activity results to display
Show More
Leave a comment: