Search results

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" &...

Thanks The-Doc-Man.. Got your point sir.. Now what are those common stuff need to hide and how to do it. I have now the idea of "toolbaryes/no", and those on Access Option what else do i need to know.. Thank you for your kind help.

Thanks theDBguy, I found this "acCmdOptions" Now, is this the correct way to use it?. "DoCmd.RunCommand acCmdOptions" I tried it and it opens "Access Option" form.. is there a recommended way to use it.

Hello all, I have set on opening of the my db to hide the navigation pane and the shortcut menu bar.. How can i open the Access Option dialog/form to change the setting of navigation pane, shortcut menu bar from a button? Thank you

Thanks CJ_London, I will check the link and see if i get to work.

Hi Pat, Would you please expand, as a beginner, my knowledge is very limited.. Where is the "OnNoData" event, and the error "2501". Appreciate your kind help on both of these.. Any link where i can get a good demo/sample, please. Thank you.

Hi, So between "ShowAllRecords" vs "DataEntry"=False which one is recommendable to use?. Thank you.

I need help of my report, I based my report to a query, and i wanted if no record to display, a message popup "no records to display", close the msgbox, focus will go back to "printmgr" form control where my selection starts.. thank you for any help..