Recent content by cprobertson1

Thanks for the help folks! Very much appreciated :) @jleach - aye, it just occured to me how much text 10GB actually is - in fact, I've generated text files containing billions of figures (raw results from simulations of ecosystems at uni) and they were only a few GB each - and this database...

Hmm - I think that might have been what I was intending I'm afraid - any given site would need access to the comments from other sites - but, as I mentioned, I'm unfamiliar with the territory; what sort of layout of database files would/should I be looking at here? That was actually the...

Good Morning folks! I've got a project here - quite a simple one actually. It's just a system for aggregating comments about the running of business (like "need better control of welding materials" or "purchasing need to get their bottoms in gear") from various users and allows administration...

Perfect - worked like a charm :) Many thanks!

Good morning, I thought I had an easy project - but I've hit a bit of a wall in terms of how to best do this. I'm developing a scheduler application, and ultimately need to be able to swap two rows in the schedule - literally just shifting them up or down - simple stuff... except I've suddenly...

Phwhaha - whoops! It's been a looooooong day :cool: Aw-dear - that's it, no more computers for me ;) ::double checks I've not written that twice:: ::confirmed::

Just rolled it out there for testing a few moments ago - and the query is running in under 5 seconds - excellent. Just one last thing to do... I need to add a new column that groups the 40-odd different work centre names under larger department names... There's no such field in any of the...

Righty-ho - I've managed to get it running off the live tables at a decent speed (15-20 seconds) using "only" 15 tables involving only one subquery and 16 joins. Sheesh. That was way more trouble than it was worth! Thank you very much for your help! Very much appreciated :D Glad to have...

There is so much spaghetti in that code that lady and the tramp got bored halfway through ;) I'm afraid I have very limited access to the server itself - read-only access to the back-end and that's it I'm afraid! Almost all the tables are needed I'm afraid :( - most of them are being pulled to...

Good Morning folks! I'm using Access as the front end for an SQL server (I'm unsure of the underlying configuration/architecture of that server - I just know it's address and how to pull data off of it) In this front end I have a monstrous abomination of a query - 18 tables, 30 joins involving...

Oops! Sorry, should have specified! The rest of the database is all standardised and normalised - this messy part is just for a report. We're needing a list of rejected documents from our suppliers: each document applies to single part, BUT multiple contracts may have that part (for instance...

I have recently had an issue grouping with a memo field and removing something other extraneous data - but today the specificaiton has changed! (Again(after spending most of last week working on that problem)) - and now I need to add the contract number that corresponds to each rejection...

FIGURED IT OUT Had to do some messy SQL to get it to work: INSERT INTO table_CORE SELECT * FROM table_IMPORT WHERE not exists( SELECT * FROM table_CORE WHERE ( NZ(table_CORE.[FMC Project Name],"EMPTY") = NZ(table_IMPORT.[FMC Project Name],"EMPTY") AND...

Haha! Whoops! Sorry, the parameters being asked for are the field names from table_CORE field names between table_CORE and table_IMPORT are the same, except CORE has an extra ID field (primary key) - explicitly naming each field insteaed of using "*" gave the same result

I'm nearly there! Having a slight problem with the SQL side of things now: for some reason it's not pulling the values through from table_CORE properly - access asks me to put the parameters in. I reckon I'm missing something! Any ideas? :banghead: (VBA) sql_str = "INSERT INTO [table_CORE]...