Recent content by sharonng

A Ahhh, I finally found it. It has a different name other than the one in Microsoft's documentation, that's why I couldn't find it. Thanks a lot!

I am already in the VBA but the reference option is just not in the Tools section.

Access 2016

Thank you for your help but there is not a Reference option in my Tools Menu in the VBA.

I see Macro, Access Options, Database1 Utilities, Digital Signature. (Sorry if there is not an exact match of the wordings - I translated them from another language.)

I cannot find the Reference option. Do I need to click something beforehand?

Hello, I have tried your code and it worked. However, that is not the case in my file. Compile error: User-defined type not defined appeared on the line Dim fd As Office.FileDialog. How to resolve it?

Hello, I meant they pick it each time.

My supervisor asked me that whether an access table can be exported to their wanted directory. Currently, I am using outputFileName = CurrentProject.Path & "\Report002_" & tb_Year.Value & cmb_Quarter.Value & ".xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

I have tried it and it showed a new error: error 7874 (Microsoft Access can't find the object). I edited DoCmd.OpenTable ("Normal") to DoCmd.OpenTable ("dbo_RPS_STRATUM_002") and this error popped up, but I am sure that "dbo_RPS_STRATUM_002" exists, just that it has been closed in the above...

Hello, I have encountered a problem when trying to export an xls file in Access VBA. My code is as follows: Private Sub btn_exportnormal_Click() Dim outputFileName As String Dim nrange1, nrange2 As Integer If tb_Year <> "" And cmb_Quarter <> "" Then Select Case...