Search results

Hi, I have searched the whole forum and internet for hlp but to no avail so I'm posting it here .... I'm currently working in Indonesia so all dates have to be in the Indonesian. I have managed to mail merge dates stored as DD/MM/YY in my Access database and output them as 31 December...

Thanks .... I found a easy way but til now i received syntax or data type error .... Here's the code .... maybe someone can help me ??? the problem lies in where u should put the quotes " " rst.FindFirst "AttendeeID =" & Me!AttendeeID And "EventID = " & Me!EventID It works if I hard code...

Hi all, May I know what is the easiest way to search for records using 2 fields wich are not primary keys? and then return a boolean value whether it is found or not... These 2 fields are of integer type. Recordset.Find can only find record with one field and not two. Is there any...

Thanks, Neil for the advice. I have already created an index on either table to ensure AttendeeID and EventID is not duplicated within the same table. I have 2 tables. Attendees and Absentees table. The 1st table contains a list of participants and the latter contains a list of absentees...

Dear frens, I have successfuly exported a Namelist inside a query Table into an existing excel file but it creates a new worksheet and the data is dumped there. what if I want to export the data to a named worksheet (already in the existing excel file) and the appropriate cells too eg. A3...

Dear all, I would like to seek your help on this problem. I would like to do a search for my records based on 2 different criterias. If found, the function should just return a boolean value so that I can act further based on the boolean value. The reason I'm doing this is that I have 2...