Search results

Thanks guys for the reply. I'm using a Access 2003 (has an ADP) connected to SQL Server 2005. I've tried the SQL string, query and nothing works.

Hi everyone, I'm new to access, so i'm sorry if i don't get things ate first time. I have a form with a lot of fields which the user will choose which ones will be part of the "select". The result of this select i would like to export to an excel file. Can anyone tell me how can i do this...

Like i said i really newbie in Access. What I suggest you do is to create a macro to do what you want and point it to your view named test. Save the marco and run it. If it works then go to Tools > Macros > convert macro to visual basic. I've already did this. My macro points to a view that...

Sorry but my access version is in Portuguese. Is a "query" the same as a view? I created a view, called "test", so i tried this line DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, test, strFullPath & "Test.xls", False but it gives me an error: it says he needs a argument "table...

Hi DCrake, You said: "It must be a stored table or query." I understand the table, but what do you mean a query? How can i make a "query"? "You would need to change the sql of the query with QueryDefs prior to transfer" ---How do i do this?

Hi DCrake, Thanks for the reply. I tried what you said, and i got an error. It's says: "Microsoft Office Access doesn't find the object ' ID, NomeCandidato, DataEntrada FROM FichaCandidatura'.

Hi everyone, I'm kind of a newbie, when programming in VB so i'm having a little bit of trouble exporting a simple query result to a excel file. I've found this code that works fine when i use a table: Const FILE_PATH As String = "C:\My Documents\" Dim FULLPath As String...