Search results

Many thanks for that, I will give it a try. I could not find out how to make the code show correctly despite many attempts. Having now tried the #, for some reason it does not work possibly because my work IT department has it locked down. The subform displays multiple records each of this...

I am trying to get the properties of enabled and locked set in a continuious subform depending on a yes/no field in each record. I have tried using the answer in thread 160062, (sorry link is not allowed until I have 10 posts) but this only works when it is not a subform (unless I have done...

More like a big thump! :D

Yes, a temp table only. Simple, if only I'd thought of that!!!:banghead: Funny how when you look at something for so long, you can't see the simple things.:rolleyes: Many thanks, now to finish lunch and then try it.

The table in question is a seperate 'import' table which can not break anything within the system. The user finishes their import by closing the table and it is on close of the table that I would like the second macro to run.

Access 2010 I have a macro that opens a table, clears the data and invites the user to paste in new data. The user then closes this table and clicks on a second macro from the ribbon to update this data to various locations. What I would like to be able to do is have the user click on the...

Just joined, probably as most people do, to solve a problem which was dealt with within the hour so great service! Not a pro but got landed with doing some data management about 12 years ago within a financial services company, tried Access and never looked back. Totally self taught so pleanty...

Compacted and repaired it, and it worked!!! Many thanks for the basic thought which solved the problem. At the moment I'm just testing out the various db's that I use in work before we migrate to 2010 and Windows 7 in a few months so thanks again. Chris

First time post here, so hello one and all. I have a problem with vba in a db that I have just converted from 2003 to 2007. The vba will not run in any of the existing event procedures set up in buttons or the likes. Macros run fine and when I recreate the button it is recorded as an embedded...