Search results

From previous experience you can just use the copy and paste method providing the fields are in the same order etc. Or just copy the code over from the working d/base!! Or you can use the import (not sure you want this version though) which is file, get external data, then import. from here...

Thanks Jon, will update you early next week when I have the time to work on the d/base. Not sure how I'll do on the code, I can only use macro's at the moment. Ian

I have a form with 3 sections/pages (tab controls). I want to run a macro when the 2nd tab control is clicked, how do I do this. I've added a macro to on click, but this nothing at all. Thank you Ian

I have a form which details are added on, on completion you click a macro to return to main menu. Yet if not all fields are completed it causes a macro error (as you would expect) my problem is that the fields that are left blank are option boxes (I know they need to be completed yet it could be...

This may be what you want? 1. create a new macro 2. In ACTION scrool down toe OpenForm 3. In form name Scroll down to form you want to open 4. In data mode set to ADD In next action box box set to runmacro then pick the macro you want. Hope this helps. Ian Can you help me on mine?

I need help URGENT!!! I have a form (students details) and subform (offered accommodation) The O A has the date offer made etc... along with a combo box of who's accommodation has been offered. I need to get a query to show the name and address of both student and accommodation offered. How...

I've used setvalue in a macro to copy data from one filed to another, yet I have other fields that I need to copy over at the same time, how can I do this without having to add the setvalue mutiple times in the one macro (which is what I've done). I've tried a few things yet to no avail. Once...

I've designed a simple database with not very much knowledge of access and now I want to add what is probably a simple function. PLEASE don't bombard me with code, I won't understand, I'm not too bad on macro's (just learning!!). I want to add some buttons (my idea) that will add either...

I know you shouldn't have data twice, but I need it this way. i.e we may only mail to the correspondence address at set dates and the other address more often. Yes I know it's NOT the best set up and until I learn a bit more I have to do it this way. Any help on my original question would be...

I want to add a command button that will copy a field or set of fileds from one section to another. Any help would be welcome i.e. home address1 home address2 (etc) to be copied to Correspondence address1 Correspondence address2