Search results

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

g, That works pretty much perfectly. I changed the search to field to " " for DurHr and DurMin which worked well, as before generated an Error, however now I only get the first digit of the Minutes field, is it the new search to field or is it a virtue of the CInt thing, presuming that just...

g, Sorry may not have been clear initially. the data as posted is all in one field as a text string. What I need to do is work out a way of getting the digits out into seperate table. For example: Currently - Duration = 0 Day(s) 1 Hr 40 Min target is : DurDay = 0...

Guys, I have a table with a field in which the data is of the form: 0 Day(s) 0 Hr 2 Min which is formatted as a text string. I need to turn this into number values so that i can perform calculations on the data. How can I do this so I can run a query where I sum the values of the field...

Guys, I have a table with a field in which the data is of the form: 0 Day(s) 0 Hr 2 Min which is formatted as a text string. I need to turn this into number values so that i can perform calculations on the data. How can I do this so I can run a query where I sum the values of the field...

I have a table where records are entered and one of the fields contains a date/time in the form 27/04/2004 13:51:00. I need to create a query where the results are filtered by month, the month having been chosen by the user from a form in the step before. How do I get the filter to connect the...