Search results

Hi there. Thanks for coming back! No, I'm afraid what you describe is way outside my comfort zone! As usual, the client was insisting on instant results, so I had to go with a much less efficient solution. Appreciate the help, though. At least I know now it wasn't completely my fault! Cheers.

Evening all. I'm having a very frustrating problem with some Excel arrays, and as this forum has solved all my Access problems to date, I thought I'd turn to you now. The purpose of the model is to take accruals data submitted in a spreadsheet, look up various fields from another source...

OK, thanks very much. This is my first attempt at working directly with recordsets in VBA, so I'm not too sure where to start! I'll give it a go, and see how far I get. Thanks, I appreciate the help. P

Thanks for the prompt reply.:) I'm glad to see that I wasn't too far away myself. I have a sheet of A4 with various filters and calculations for the methods for choosing the record! My problem centres around the VBA necessary to acually transfer the details of one recordset to the other. I can...

Afternoon all. I have a problem that I've been getting nowhere with for a while, and would appreciate your help. I have a table in Access 2003 which holds details of projects (dates, budget, descriptions, etc). I need to end up with a results table that shows the budgeted cost spread over...

Hi there. Sorry for the delay - as usual trying to do too many things at once. As Bob says, if the data is inconsistent, then automation is impossible. However, from the small sample you gave, and from your second comment, it would seem that there are repeating patterns within the data which...

Hi There Perhaps I'm missing the point, but can't you use the space between the data as the delimiter? I just tried it on the sample supplied, and apart from the formatting, it is just about there. Hope this helps. Paul

Thanks for coming back. Vassago: Yeah, wrong tool for the job, eh? I'm compacting and repairing virtually after every test run. Unfortunately archiving isn't an option as all the data is "live", and the client is reluctant to talk about SQL Server just yet (but I'm working on it)...

Evening All I have a query which, when run as a select query, takes around 1 minute to run, and returns a recordset on screen which looks correct. When, however, the same query is run as an Append query, it takes - well so far it's at four hours, and it isn't even halfway yet. Some details...