Recent content by tweetysamm

Everyone, I need some help here. currently i have table : customer primary key : account number button : New Record embedded with this code DoCmd.GoToRecord , , acNewRec when i try to insert the same account number and click the New Record button it give me this error : Run-time error...

Insist ~ But my superior do not want to use this step instead he insist want to have everything in a table! Actually i dont know what he thinking also..Any other idea where we can use the count function ?

Everyone, can i know how to write a SQL query that can draw out how many duplicate data in one field?

Everyone, Im facing some problem here. Currently im working with a table consist of : name - text id - text buffer - text 1. I will put number '1' into buffer field when the person is coming to work. So my intention is to count how many people is coming to work (whoever with number '1' in...

Problem is ~~ But my problem is to search "Account Number" which consists of few hundreds thousand of entries therefore is not feasible to use combo box to perform the search function.. 1. i need a text box to capture the input search detail 2. perform the search in the database 3. display all...

Everyone, Im new in Microsoft Access, please give me some advice on this : 1. Im currently using Access 2002 2. I got a table with field (AccNo,IC) 3. I need to build up a form to search for the IC whenever i input the AccNo the problem is i don't know how to do it ? I find all the reference...