Recent content by snoopydoopy

Hi Guys. I'm designing a massive a database with a multitude of tables, the employee number is >60,000 say. Now - from my understanding as this is to be imported for Oracle later, I should stay away from Access specific functions - i.e. Lookups importantly. I understand comboboxes are ok? as...

Pls see below. It's opening up the file but it's not running the macro which is on another file quoting error 1004 - saying macro may not exist or similar (it does). It also opens up the file as read only.. so instead of running a macro - how do I copy the sub of the macro in this instead...

HI, I have 30+ columns each table I need to change into sum of.. but its default is group by, and need to change multiple columns to sum - rather than manually each one.. any ideas??

Headings are: SUPPLIER NAME, DEPOT, RETAIL LINE,NSL,NSL DESCRIPTION,CASE SIZE,Retail Life,DOD,<>,19/09/2014, 20/09/2014,21/09/201422/09/201423/09/201424/09/201425/09/2014 as I said the dates change by one each day... and I need to identify each upload..for analysis later..

Yeah its one forecast daily from now, but I started this week so have 50+ forecasts for the last 50 days..

Daily forecasting is still done in excel (by separate BI department) but will be needed to added to access continuously...

Append issue: How do I auto populate a sep column created which is blank at present, with the table name of the table I append/join to table with a query - to uniquely identify all these rows..from each table..?

Let me emphasise however. I have 20,000 products or rows in each excel file and it'll end up being a gig excel file which would be inefficient if not impossible. Hence I need access database. So as you can imagine I have 50 days of forecasts; each done daily. So first few column headings are the...

hi. Say you have multiple excel sheets where forecasting is done daily. For example, sheet one headings: Depot, department, location, 01/09/10, 02/09,10, 03/09/10 and then second sheet is similar but: Depot, department, location, 02/09/10, 03/09/10, 04,09, 10 - as you can see each day the...