Recent content by IRedsell

I would like to use some of my already created and tested offline queries in my Access MDB that links to that MYSQL database already, I have MYSQL queries that have sequential queries delimited with a semi-colon ";" to terminate a query properly. It seems I can't use this in Pass Throughs, also...

Just for the sake of a white knight riding over the hill here is my code [proposal subform] sits inside newproposal_form, boy I wish I had put that underscore in at the definition stage!!! Here is the code ' Select the fields from the form to write out to the database for the component_number...

SeeThru Thats great information, my challenge with the additional fields is caused by me electing to use a datasheet and so all the redundant fields are at the end and as far as I can see they cannot be made invisible. The rst.edit bit is the bit I can't see the wood for the trees over though...

I have a number of calculated fields in a subform that are coded into controls for the sake of speed and because they are always recalculated when their parents change. I want to write these back into the table in unbound fields - why because I want to track what data was used at the time of...

Ok perhaps I should make myself more clear supposing I had a table with income, sex,age and I wanted to combine it with a table showing region,job etc and I wanted to create a field for salary expectation by combinig the fields ie. x*y*z/k how would you do it? Would you do it in VB or in a...

Firstly I am a self taught AccessVB Programmer This means that I have probably missed something, but I have been through all the FAQs and trawled the web and cannot find out if what I am trying to do is just stupid or possible. What I am trying to do is populate a subform with a number of...