Recent content by stoolpigeon

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 took the second piece of code from a website (apparently can't paste websites here otherwise I'd give you a direct link!). It's essentially trying to calculate the nth highest salary and the website explains it as working in the following way: "The query above can be quite confusing if you...

I don't have a specific requirement in mind, I'm just trying to learn some higher end SQL and saw this online: ..index.php/database-sql/find-nth-highest-salary-sql at programmerinterview.com and am consequently trying to get my head around what it's doing :)

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.

I've just read that they've been discontinued with access 2013. Can anyone tell me why?

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?

Thanks for your help on this. Rather than including the VBA code in Access I had each workbook create a copy on save and had that copy linked to Access. Simple when I thought about it. Thanks again.

I understand how to link the two but if I'm creating copies of the files in question then how can I automate copying and then linking to Access? Do I have to predetermine the name of the copy? And then cause the VBA to trigger on db open?

Thanks for your reply. I can write the code to locate the files in their respective directories, to copy them, draw the data and then close and delete the copies, but how do I 'attach' this to a query? I need this to work with an existing query, as opposed to creating a new one each time, as...

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

Stang - I'm having the same problem. I'm reasonably profficient at excel VBA but wouldn't have the first clue where to start with programming that in Access vba. Can I get a copy of your code?