Recent content by carlmack

Pat, Thanks for the advice. Like the idea to automate a save locally. Google found somebody with the same problem who had written a routine to loop round and try again with a short delay when it failed. I am trying that for now but will take the spreadsheets local if that doesn't solve it...

Hi Pat thanks for the reply. Yes the users are using a shared (in the sense that it sits on a server) but read only Excel client. Can you explain how this could be an issue. Excel sharing functionality is not switched on. It would be easy to deploy the Excel on the local PCs but it would make...

I cooked up an Access db some years ago for a small department of 4 users to display summarised stock and sales data through Excel front ends. The size and no. of users have increased over time and it now has 20+ read users and 3 write users (that poke data in from Excel using ADO). The problem...

Many thanks for the replies. FoFa, Thanks alot I will give that a go. Modest, Do you mean use a table instead of a recordset ? Unfortunately I have quite a bit of manipulation to do on the recordset so wouldn't this be slower ? Regards Carl

Does anybody know a way to bulk insert from a recordset to a table (assuming the same structure). I can loop round the recordset using an INSERT INTO SQL execute but I have many records and it is slow. Is this possible using ADO or DAO ? Carl

I am working on a financial integration system that receives lists of financial journal transactions from several accounting packages. I import and sumarise the transactions and end up with a transactions table like the one below. I now want to produce an Accounts summary (by period) table. I...

Graham, I added the Excel median function into an Access module. Actually I just copied this from somebody else. I inserted a module and pasted the following. Public Function getMedian(ParamArray aNum()) getMedian = WorksheetFunction.median(aNum) End Function Whilst in the VB window I...

Hi all, I trying to use the Excel Trend function in Access. I found some code that works for the Median function Public Function getMedian(ParamArray aNum()) getMedian = WorksheetFunction.median(aNum) End Function The getmedian then works with commas between the values. The trend...

Pat/anybody, Thanks for the direction. I have set out down the ADO path using code found on previous posts but I could do with a little more advice. I am working sequentially through the products in the stock table and need to dive into the forecast table and purchase order table to get data...

Pat, Sorry I will try and explain better. This is for fast moving consumer goods. The idea is that I will use the latest forecast data and the latest stock data to look into the future and see if products are going to run out of stock (or have too much stock). I want this to be displayed...

Hi All, I am relatively new to Access having created my first database a few months ago. I have hit a problem and I am not sure if I can solve this with queries or I need to move to Visual Basic. I want to create a table containing the stock a product for each day for the next sixty days. I...