Recent content by ramsay18

okay i added "ordinal" to my table and made it a long. i created the update query, the problem i am having is getting the DCOUNT() work to be honost i was following the direction provided by the Microsoft and i have no clue on how it works it would be a great help if you could just explain what...

DocMan would you just be able to send me an email i am kindof on time constrants and it would be easier to talk to you directly since you know exactly what i am attempting to accomplish

That didnt work. i used that coding and it still performed the UNDO capabilities but didnt close the form

Question just a question if i should change anything on this DCount([TABLE]![UIC],[TABLE],[TABLE]![UIC]) which criteria does this go into along with what do i update?

Is it possible to have a command button that UNDO's the informations filled out on a form and closes the form?

Doc_Man thankyou that is exactly what i was looking for i wanted to count records in a delete query but it wouldnt work Thanks

I want to retain the last two records of each UIC on file in my table. That way if they want to view the past two it is possible. I only need those two records anything else can be deleted or I can just overwrite those two records. Memory will be a problem because it is going to be operated...

I am attempting to right program for work and here is my problem. Every Unit in the Army has a Unit Identification Code and my boss wants two records of each UIC stored. But when you add a new record for that UIC he wants the oldest one purged, so he only wants 2 records on file in order to...