Search results

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]...

The problem is the excel data is imported from an external company's document control system - we have no control over it's content - we're importing it in order to keep track of dates (and more importantly, what state each of the flurry of documents bouncing back and forth between vendors and...

Nae luck! When it gets appended to the main table, it just adds it on with a new index regardless of the presence of already-existing data. The problem is there is no data that uniquely identifies a given part that is imported - the contract number and Purchase Order (PO) number is the same...

Sounds like a plan! I even have a temporary table already in use to add a couple of columns on and sanitise some data Will that still work if access is adding a primary key to the main table? In fact, I'll try it just now and find out!

Good morning folks! I am currently developing a database that will be used to keep track of procedures and specifications for an engineering plant. One of the features requested is the ability to import excel tables for a particular job, containing a list of the required procedures and...

Nailed it! Took some experimenting, but eventaully got it with: UPDATE Table1 INNER JOIN Table2 ON Table1.column1 = table2.column1 SET Table1.column2 =table2.column2 Thanks! :D