Search results

A little background Im trying to Export a Query to Excel. One of the field in the query has a criteria that is use to filter the data in the query. Im pretty new to VBA that is why I have no idea how to solve this. Here is the code Im using. On Error GoTo SubError Dim xlApp As...

Good day everyone. I need help on this matter. Im using this code to import a Table from a different Access database. DoCmd.SetWarnings False DoCmd.TransferDatabase acImport, "Microsoft Access", selectFile, acTable, "Tbl_InvDV_28-01-2016", "Temp_DV", False DoCmd.SetWarnings True Im sorry...

As the title suggest the Detail Section on MS Access report keeps on repeating. Im quite new to Access so I have no idea whats going on and how to solve this. See attached for reference. Background on my report. -All the text boxes are unbound -I got the data using the Dsum function...

I have this really weird problem and I dont know how to solve this. Im pretty new to Access and VBA so please bear with me on this and I apologize if this is a stupid thing to ask but I really have no idea how to solve this. As the thread title suggest my label's font keeps on changing. On the...

Good day everyone, Im pretty new when it comes to VBA and Access so please bear with me. I have this code that I found in the internet and modified it to fit my needs but it doesnt seem to work properly. It does import the excel spreadsheet to the "ImportTable" but it wont INSERT INTO the...