Search results

My English teacher had a poster on the wall that said:

They certainly should be cumulative, but my preference for these sorts of things is to visit Microsoft Update (Windows Update's big brother) and let it sort out what patches and service packs are appropriate for my Office and other Microsoft applications (as well as Windows itself).

Thanks - yeah, I think it's got to be something like that - I'll look into it. Best solution would be if I could get Access 2007 on it (we have the licensing, but there is another third party access db on the machine that won't work in Access 2007)

Concur. I realise that's not the answer the OP wants, but if it's truly that big and important an operation/db, trying to fumble your lonesome way through it is too risky a plan for any of us to recommend.

To expand on that as my preference - it means you're only maintaining one set of functions and forms, one set of reports, one set of linked table references - maintenance of multiple different front ends for the same application can become quite a burden.

This is a good suggestion and worked well on another board I used to frequent - a bunch of users were set up as 'spam police' and given rights to hide posts or whole threads. As long as the board software records who dealt with each incident, the system is reasonably immune to abuse - if an...

I've got an Access 2000 format front end that I am maintaining using Access 2007 - this generally works OK, except for having to mess about with VBA references when rolling out a new version, depending on the client Access version. However, there are a number of text boxes on one form that are...

I could work out most of it, but how does 'ff' translate to 'a minute'?

You have to pass the parameters to DLookup as strings, so: DLookup("Price", "Fruit", "description='banana'") Would return the value from the price column, in a table or query called 'fruit', for a row that has the term 'banana' in a column named 'description' So I think yours would be...

Too true. Whenever I do them now, I create a template first (in Notepad) with placeholder values, then paste in the real variable or field names once I've built the framework. If the OP's query is going to be used more than once in the future, a better approach would be to create a lookup...

I don't really understand what you're trying to achieve in general, but for grabbing a single field value from a table, I think DLookup will serve you better.

I agree - product attributes are product attributes, product codes do not need to contain all the attribute information. They can either be meaningless autonumbers (if their purpose is to relate records together in your db. Or they can be structured codes that are designed for humans to find...

If the tables are all the same structure, writing the union query should involve not much more than a session of copying and pasting (with a tiny bit of editing to change table names). Then run a make-table query based on the union query's results, then use that freshly-made table forevermore...

Does this mean you're storing full address fields at that table level?

I thought No such word as can't was just an exhortation not to give up easily.

No reason why you can't - just link the relevant tables into a new empty db and create a bunch of new forms. But that might not be the best solution - you could just incorporate it all into one FE and switch on/off the relevant bits depending on who is logged in.

It sounds like you need to build a cross-reference junction table, containing your customer IDs in one column and their corresponding unique reference that is used in the incoming CSV file in another - you can then use this table to bridge the gap between the two different sets of data.

Is the string originating as the contents of a memo field? If so, this might help: http://allenbrowne.com/ser-63.html

That's a serious database, to be sure, but I still can't help thinking its physical size on disk and performance in conjunction with SQL Server might indicate some design issues.

My router died halfway through downloading the torrent, so I only managed to finish downloading it last night... I've not really had much chance to evaluate everything, but the administration and preferences forms seem a bit more functional and consistent now, and wireless networking is pretty...