Recent content by chrisms

Guys, This is where I think you may have a snigger at me. I have setup a database from a single table, and split this up into a number of one-many relationships using the Table Analyser wizard. This has given me all the functionality i need to be able to generate the outcomes I need. However I...

Ken, thanks for all the help. got it working now here's how: vntDest = "c:\" & Forms![Front End].[Combo6] & "_basic.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Export", vntDest, True That works fine, so thanks for the help again Chris

No, can use any form of Excel, could use word as well, but don't know if that is the issue. Have got it working in the export with a static file name now, so not sure whether it allows this dynamic filenaming or not Chris

Thanks for that, changed the join and fixed it

Looks like we could have been barking up the wrong tree. That fixes the | issue, but now a: Object doesn't support this property or method error appears. Does this mean we can't play around with the filename or is it something else?

Ken, Thanks, well spotted. That gets rid of the strange | (yep, found it) error. I can then export data if i type the destination in completely, but using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Results", "c:\" & Forms.[Front End].[Cost Code] & ".xls", True Gives me a...

Unfortunately can't post the data. However I know the query runs fine, because it opens fine and filters perfectly when asked to. Therefore the field referred to should be within VBA, but the error occurs within Access, rather as a VBA debug. I will try to give you as much info as poss...

Ken, Again thanks for all the help, much appreciated. The same error is occuring, no idea what it means really... If you have no ideas thanks for all your help anyway, has been very useful to me. Chris

Thats correct, Front End is the form and Cost Code is a list box, where the code is selected

Ken, Private Sub Command19_Click() On Error GoTo Err_Command19_Click DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, [Results], "c:\" & [Front End].[Cost Code], True Exit_Command19_Click: Exit Sub Err_Command19_Click: MsgBox Err.Description Resume...

Seems to get me somewhere but returns an error(yes i put the handling in): Access can't find the field the field '!' referred to in you expression. For the ! please read a vertical bar, I just can't find the symbol. Does this mean the code has an error or the query? The query runs fine just...

I have 2 queries that are identical, except one returns the value where Affected = Y and the other where Affected = N. I then tie these two together in another query by relating them using a Region field. However when I run the tie in query I get a problem when the affected = N query returns...

Currently: Private Sub Export_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, [Results], "c:\" & [Cost Code].Value & "", True End Sub I am only a beginner, so please don't laugh too loudly at the lack of error handling etc! Cheers Chris

Guys, I have a from where i select some values(including a code) and then produce a query filtered by these values. From this i need to save the filtered query as an Excel spreadsheet with filename = code. TransferSpreadsheet seems to eb the answer but I can't get it to modify the filename by...

g, sorted that issue as well now, much thanks for the swift and accurate help! Chris