Search results

Hi mstef. That is another problem i am facing right now. I am a self-learner in access and i dont know how to find duplicate records. I also dont know how to use the append query. Can you please send me some example for this? many thanks in advance...:)

Thanks Stopher and SOS! Everything looks ok now after importing and then re-applying the codes again. Thanks so much...

any help for this?

Ok sorry. Please see attached...

Please see attached. the one is when i close the form, and the other one is showing the vb code window...

This is my code under "On Close" event in the vba window and it is functioning ok until just now when i close the form that error appears.:( Private Sub Form_Close() DoCmd.OpenForm "Switchboard1" End Sub

I am working on my database and they are working fine until all of a sudden my "on close" function on my form doesnt work! I got an error as attached here. Please help what are the possible error on my db.

Hi, please see attached image when i tried to change the "index" value of "work_Order" from "No" to "yes(no duplicate)".

Hi, sorry but honestly i am a newbie in access and i just learn it by myself. Can you please give me example on how to use dlookup function for this? Thank in advance..:confused:

Hello. I tried your suggestion but i got an error saying, "The changes you requested to the table were not succesful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicated data, or redefine the index...

I am preventing my co-workers to input data twice, based on job order. Any way i will try your suggestions when i get back to work tomorrow as my db is at my office' computer. Mayber i will follow up questions tomorrow.....:)thanks

Thanks for reply. But i want to elaborate my inquiry: Sample: ID | Job order | Time | Name (autonumber)| 123456 | 11:00 | Peter The example above shows field for specific data. How can i make it that the job order cannot entered twice. If i already entered that data and my...

Please help me.. I have a current database and i want to sort duplicate records in a query. Example: I want to show all records having the same job order. Is this possible? And is it also possible to restrict a specific field for a specific data ( no duplicates ).

Thank you very much. I will try this today, hope this work..

please help anyone?...

Please help me. I have a database with monitoring of hours work and i want a report to count total hours of work with graph, example: -worked greater than 16hrs = ? - worked between 8 to 16 hrs = ? - worked between 4 to 8 hours = ? - worked between 2 to 4 hours = ? - worked between 1 to 2...