Search results for query: *

Hi People, I can not work what i am doing wrong here. I have a subform with on textbox on it. The two forms are linked. The subform it is generated from a query from the main form. I want it to run one macro if their is a value in the subform textbox and to run another macro if the value is...

Thank to all of you this has sorted the problem. Will take on board your coding comments, im trying to follow as many as i can, but its not easy learning as you go. Anyone any good books, i am Currently using "Access 2003 VBA: With the Smart Method" Thanks to you all :-)

My Current codes is as below. The first bits seem fine but i have included it just in case. On the message box If statement it seems to no be returning the vbYes value. As a test i change the vbYes to 6 as i believe that this was the integer it shoudl return but it did not do anything. The...

Thanks for comments guys, My Typing is terrible. I corrected it and im still having the same problem what you mean by "Option Explict". I have only been using access for the last 10 days and am totaly self taught, so am a little out of my depth. I have spent half a day on this now and it is...

Hi Everyone, I have a YesNo message box that keeps jumping to the "Else" clause. I have tried all the elements to this and it all seems to work fine but i just cannot get the message box to work at all. I even tried on a different button just to see wether something else was effecting it. I...

I manage to solve the problem by puting a Repaint command after the Requery of the form. This seemed to work fine. I did this by putting it in a macro. Thanks for your help.

Hi All, Thanks for the help i have managed to get off of here so far from reading other peoples post but i have now hit a road block. I have a Sub-Form(Query List)that I have button to open the record into another form so that it can be edited. I then have an append Query Button to assign the...