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