Recent content by sbaud2003

Hello Sir/Madam Please help me to deleting duplicate records records from a Table I tried but it deletes all the recordes with the key, i am trying.

Thanks to all for your advise

yes

I want to find all the missing IDs in a table starting from 1 to the end of the Table. How can i do that and display the missing IDs IDs are Primary and serially numbered. however one missed the seriality in entering.

THANK YOU SIR

Actully I want to mark absent with RED and Present with Blue. (TEXT) so pls help me how to do

Hi Sir's Is there any method where a Text Box color can be changed. I.e if Present then BLUE and if Absent then RED

Yes sir, and its working fine thanks alot, There was a syntex error.

Hello Sir's I have a forn bounded by a Table Master_tbl in which one of the Field in AC_NO i want to find a record from aunbound text box (FINDAC) and the code after event i pu is appended below: but the same is not working Dim rs As DAO.Recordset If Not IsNull(Me![FINDAC]) Then Set rs =...

Hi Sir, How to refresh all tables.

thanks again, output is coming 0, can you help

Thank you sir, its parfectly working Sir, if I put another condition Cnt = DCount("*", "QOCCUPATION", "DepartureDate = #" & Format$(Me!sfrReservations.Form!DepartureDate, "mm/dd/yyyy") & "#" And [Mob] = Form!frmOccupants!TXTMOB) frmOccupans is the Main form and Mob is number field, but error...

Cnt = DCount("Mob", "QOCCUPATION", "DepartureDate = Me!sfrRoomOccupations.Form!DepartureDate")

Can any one help me with the vba code ,if any to send PDF file through watsup, and what are the requirements.

Is it possible to generate a report, in which first all address will be shown and then the all Name and other details from a single table for exampel it should be like this To add1 add 2 add3 ad4 The details are as follws 1. mr david, team leader 2. mr Robin, head reader etc etc