Search results

Hello All I have searched the db but haven't been able to find the info I need. I am looking for a way to import data from a CSV file in to a table. Simple enough. However, The csv file only contains data for some fields on the table. I would like to ensure that all the fields are completed...

PS The subform does provide me with a breakdown of the categories, but it does not seem to use the 'filter' portion of the query and shows me all categories rather than a subset, as I would expect.

I have tried linking the child master fields, but this doesn't give me what I want. Basically, the main reports lists records, categorised by Status. I use the subreport to summarise the above information, so it list the categories and totals of those categories. This works fine, if the report...

I have searched for an answer but haven't had much success. I am producing a report from a series of combo boxes which set a filter against a query. This works well and the report is what I want to see. However, I now have a subreport that should summarise the main report. It refers to the same...

Kodo, Unfortunately, I am using the built in "Analyze it with MS Excel" button, so I can't add the error trap. If you have an alternative method for exporting to excel, I would appreciate it. Thanks for your help. Dev

As there isn't much information available, I thought I would post what I have found out so far... This is, apparantly, an acknowledged Microsoft Bug in Access, that existed until SR1. I believe it has been subsequently fixed but cannot confirm this as our software is restricted and we are...

Hello I am trying to export a report to Excel but get the "Subscript out of range" error. I haven't been able to find a reason or solution for this error.There are similar posts in this forum, but none have any replies. Can anyone help, please? I would appreciate it very much.