Bob,
thanks for your response. I am aware of normalisation and 1nf, 2nf etc. as I have been working with databases for twenty years so I can assure you there are sound reasons here for attempting to store a calculated field. I am however pretty new to Access and all its joys. What I am trying...
I am trying to insert multiple rows into a table (table1) based on the contents of another table (table2) including a calculated row which = column4 of table2 x = column9 of table 2, based on the using the following construct;
INSERT INTO Table1 (column1, column2, column3, column4, column5)...
My issue is how I use call and use User defined SQL scalar and table functions from VBA. I hav an acces front end for forms but use SQL as the back-end database engine. I have written a number of functions but cant get them working from my VBA. Could you point me in the right direction to get...
Seems other people are trying to acheive the same thing but from different angles. i also am combining an ADD/Amend form to avoid code duplication etc. I am trying to do it by simply detecting in what mode from the switchboard my form has been opened ADD or EDIT. Anybody any ideas on how you can...
Thanks for your responses. My question really was, is there a definitive list or quick reference anywhere that shows all the properties and their various values as this would be a useful thing to pin up on my wall rather than having to go into VBA/Access to determine.
I guess I will eventually...
I am trying to set the Enabled property to 'no' on a combo box from within a VBA module, to prevent the contents being changed.
I would have thought there would be a reference guide somewhere telling me what the property name is and the values it can take but I have searched for two hours now...