Search results

Thanks, for help. But how to get exported the title (Label) of the report in 1st row of excel file

Dear Sir/Madam, I have a report to transfer in excel format, but the heading of the report is not taken, is there any method to get the title of the report in the 1st rown of excel sheet. MY VBA CODE is Private Sub CMDFB_Click() Dim strReportName As String Dim strPathUser As String Dim...

i need to put some values in diiferent line as statistics. For eg in one Field I need to put details of attendance serially

Is it possible to put text in a text box in two three diiferent line/coloumn with same allignment

THANKS

THA NKS

I wan to fetch the Pic of an attcahment to another table, is it possible

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")