Recent content by Pooh

Can you advise me how to check this out or direct me to somewhere where it might explain about the VBA as I don't understand what I have done wrong. I was not aware that I changed anything that would affect everything on the form, just thought it would affect the button I was trying to copy...

compile error sorry, very new to this, how would I do that and if it is an error would it affect every button on the form?

I have a button on a form that has an 'on click' expression to bring up a query. I copied and pasted this button and edited the expression to create another button that would bring up a different query. Since then ANY button I press on the form (not only the one I copied) gives me the message...

Thanks, you said enough to point me in the right direction - doh! all seems so obvious now. :)

Hi I select a name from a drop down list that looks like this: Lockley & Smith Ltd When the query runs it does not return the Lockley & Smith Ltd records. It does not return any records and changes the name I have filtered to 'Lockley' & 'Smith' - how can I get it to look for Lockley & Smith...

Thanks Bob, that does sound like something even I can manage! Many thanks :D

Ok, not sure how I would do that (I am a real novice) but that certainly gives me something to look up. Many thanks for your help :)

Hi, I have this same problem only mine causes a great deal of grief. I have a simple database set up to monitor quotes into and out of our office. When we get this problem it throws everyone out and all hell lets loose (ok not the end of the world but you know what I mean). They all get angry...

Thanks, I will try this tomorrow and report back. Really appreciate you trying to help. :)

Outlook is open. I found something on Microsoft which says it could be because I installed an old version of access after installing a new version. My computer is new and this is what happened. Problem is I still need to use both the old and the new access. It tells me to delete a...

I use Access to e-mail advice reports to my project managers. I have done this for many months using a macro "sendobject". For some reason this week I get the message "Can't Open Mail Session". When I look at the help note it says there might not be enough memory, close other applications but...