Search results

Hi I would also like the query to also assign any records with the same account number which are outstanding to the same user. Is there a way that this could be done?

Pat, I have worked it out, it works wonders when you look at it in simple terms. Many Thanks for your help. Regards Blue2kuk

Pat, Thank you for your response. I am ok with most of the code, however, having problems with "Select Top 1 RecKey, Trandate, NTLogin. What does this mean as the system will not reconise RecKey Thanks

Hi All I want a user to click a button and then it will assign the oldest record in the table to that particular user, by using their NT login. Anyone got any suggestions? Thanks

I have a form which requires a date to be inputted called "releasedate" and once a date is entered, I would like it to place this date into another field, in a different table called, [Entry], "Compdate". I have searched high and low but cannot get any help or tips?? Please can anyone help...

Hi, Am sorry if this has already been posted, but I cannot find it. I have a form that runs a query before it opens which requires an 9 digital account number to be entered. Once entered it brings up the account details. I would like a msgbox to appear to confirm if there is no match and also...

Hope this helps: http://www.fontstuff.com/access/acctut09.htm Blue2kuk