Search results

Hi Davenport Why do you use query object especially if you assign strSQL to recordSource property? Did you test your Sql query before assigning it to the recordsource?

I find more efficient to inform users that no value is selected in combobox and the process is cancelled The link here https://msdn.microsoft.com/en-us/library/office/aa172193(v=office.11).aspx

Hi, You don't need Nz command see microsoft support : https://msdn.microsoft.com/en-us/library/office/aa172193(v=office.11).aspx But add a test on cbx selected value

Hi Tophan, Could you, Please, show your logical data model or better still your conceptual data model?

Hi Try with "[TM_and_ID]= '" & [cbxTM] & "'" if TM_and_ID is a string i.e. wrap combobox value with single quote "[TM_and_ID]= " & [cbxTM] if TM_and_ID is a numeric i.e. without single quote

You wrote in your post So if a natural key is compound of 5 fields, you have to call 5 times this function and then? With Access , on which event, do you call this function? How do you treat the multiple return values to decide if it's a duplicated natural key?

Tanks for this information but I don't understand how it works. Could you explain me when you call this fonction?

If you have well read my last post, unique index for customer entity is not based on adresse. To submit to a customer loyalty programm, we need to present an identity card on which we collect different information about birth. An other example, more relevant, for obtaining a mortgage.. And...

Hi splreece, Could you upload your db?

Hi scottxe, Are there empty value for some lines? In this case, add in your query for the field on error this code: Select.., IIf(IsNumeric([fieldName]),fiedName,0) AS FieldName....

Hi Galaxiom Of course, the perfection is not in our world but we try to approach on it. And I saw so many db system with dirty data (duplicated data) due to absence of a unique index with the use of a technical primary key only that I disagree with idea to not use an unique index. And the...

Hi Galaxiom On Wikipedia here, we can read : A surrogate key may also be called a synthetic key, an entity identifier, a system-generated key, a database sequence number, a factless key, a technical key, or an arbitrary unique identifier. Some of these terms describe the way of generating new...

Hi Jdraw You can contact JMerise developer on Facebook here I visited the CA ER/Win website and the modelling software does't propose to build a coceptual data model And for me it's eliminatory because build directly a logical data Doesn't allow to well understand fonctionnally your...

I totally agree with your last comments, The Doc Man. Tanks for your precisions

hi Galaxiom Could you be more explivite?

Hi emmorel As Plog mentioned it,it's only possible via the form. You need to set the field properties Enabled or Locked to false.

Hi, w.key1980 For modelling correctly a db you must : Build a conceptual data model (CDM). The Logical data model is generated from it by applying rules on cardinalities. And with dedicated tools, the LDM is automatically built as well as the SQL script for creating the DB (See files...

Hi The_Doc_Man Thanks for these clarifications and as you mentioned it And for this reason, I systematize the use of PKT instead of PKF. But as ever, there is no universal rules and at the end, the choice between PKT and PKF is at discretion of the database modeler

Hi jr007, Could you upload your physical data model (PDM) or better still the conceptual data model (CDM)?

As Plog rightly notes, calculated field don't respect the Normal Forms About merging between staffpay and payadjustment tables, it depends on the number of adjustments possible. Only one adjustment per tuple (dateID/staffId) -> merge More than one per tuple (dateID/staffId) -> modify as...