Search results

Hello I'm trying to Rank my column SKU by lowest price. I have set up the query as described below. However for two items with the same price, it returns the wrong rank. Example where two items have the same price, it should be ranked 1, 2 (don't care which one of the two is first). But...

Just posting here to say I figured it out and leaving my code if others need it, both for exporting or importing where you use Transferspreadsheet and filedialog (file dialog). Filedialog for saveas location, code to be put in module: Option Compare Database Public Function FilToSave() Dim...

Hello again, sorry for the slow response, but thank you for the help. I tried copy pasting the code into a Visual Basic Module in Access, but when compiling, I get an error saying it must be updated to x64 bit systems, please review and update declare statements. Any idea how to fix this...

Thanks for the reply. Trying to have a read, but not quite sure I how incorporate it. Trying to build a form with 4 buttons as specified, and copied the code. However I get a compile error "User-defined type not defined" in Dim fso As New FileSystemObject.

Hello I'm trying to Export 2 queries into one Excel file, in two different sheets. I can get this to work, by calling the below code in a macro. Public Function Export2Queries() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Concatenate"...