Recent content by moi

Thank you, it sorted out by bob fitz.

Thanks bob fitz..

Hello all, How to filter (date field) blank/no value of a query.. "IsNotNull" is not working.. I wanted to show only records with value (date). Thank you.

Thank you manage to get work on "mailmerge".

Dear all, Thank you all for sharing your time helping me.. I sorted thank you.

DoCmd.OutputTo acOutputQuery, "qrypayment", acFormatXLSX, "c:\users\james\onedrive\desktop\qrypayment.xlsx", , , , acExportQualityPrint I tried the above but same error pops up.

Sorry pat, i don't get your suggestion.. here is the code for immediate ref. ------ Dim filepath As String Dim FileName As String filepath = Environ("userprofile") & "\Desktop\qryCrosstab_Payment" FileName = filepath & "as of" & Format(Date, "mm.dd.yy") & ".xlsx" DoCmd.OutputTo...

Hello CJ_London, My appologies sir.. and i am not ignoring the suggested check.. but some i can't do it as i don't know how to do it. the query has no parameters, it is opening and shows the records.. Thank you,

Hi all, Is it possible to make a template "certificate" and fill the blanks, like name and other details of a buyer when i print the template certificate? Any help would be appreciated.. Thank you.

Hi theDBguy, To where should i insert "\".. Thank you.

H I pat, Can you please help me, i can't get it work.. Thank you.

Hi gpgeorge, I tried your suggestion, but gives me same error.. Any other suggestion sir.. Thank you.

Many thanks sir.. i learned a lot of do's and don'ts from you.. slowly i am learning..

Hi, yes i used Data Entry = False.. thank you..

Hello everyone, I would like to export my query to excel, and I grab the below code, sorry i don't remember the owner.. ------- Dim filepath As String Dim FileName As String filepath = Environ("userprofile") & "\Desktop\qryCrosstab_Payment" FileName = filepath & "as of" &...