Search results

Hi, how can I trigger an event in a subform? e.g. if I have a hyperlink in the subform, I can access/execute the onclick event in the main form? Thanks

Hi, is it possible to run a Make Table query automatically on opening another query (who takes values from the table created by the Make Table query)? Thanks

Hi, I seem to be able to refer to certain fields in forms by Me.Table_Fields.Value even though they don't seem be part of the controls or recordset.fields collection. What collection is named by access like this since I would like to refer to this data like the controls collection...

Hi, is there a way to refer to form fields (not controls) dynamically through a variable? I am able to make absolute references to fields, i.e. like Me.tblA_Field1, but I need really to be able to make dynamic references like Me.VarContainingTable_VarContainingField. I'm not really sure what...

Thanks, but then how can I avoid lots of redundant fields that apply to people but not companies, vice/versa - e.g. LastName, OtherNames, D.O.B, MobileNumber, HomeNumber, Ethnicity etc

I have a contacts table, tblContacts, containing info on people and companies (e.g. Northwind corp.). However, I plan to create two new tables, tblContactsPersons and tblContactsCompanies, to contain the data that isn't relevant to all contacts (for example, company contacts do not require a...

Hi, I'm having trouble using a lookup field with foreign keys containing formatting that violates the lookup field's data type - I was under the impression that formatting did not affect the underlying data stored. For example, if I have a numerical foreign key with formatting 0000-0000-0000...