Search results

I've successfully used, as an example, the following: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _ "MyTable","C:\MyFile.xls", True, "A1:B2" However what I really need is to be able to prompt the user to find the file rather than specifying it in the code. Really what I'm...

I understand the following query setup: SELECT * FROM tbl1 WHERE field1 = (SELECT field1 FROM tbl2 WHERE field2 = x) Essentially the nested select statement is executed and returns a value for field1 which is then used in the 'main' select statement. What I don't understand is the...

Can someone give me the strategy for doing this rather than the code (if it's possible)? I can code a fair bit of VBA in excel but I'm not too sure about what I'm doing in Access.

Slightly embarrassed to be asking this question but if I've got a table open and I want to see it in a pivot table, shouldn't it just be a case of selecting View > Pivot Table view? I don't have any option there for pivot table or for pivot chart, have I toggled these off somehow?

Each member of our team in the office uses their own individual excel file to store their 'work in progress' which all use the same template. I've recently fed these into Access via linking the excel files and then wrote a query that is a union of each of these links, so that we have a...