Thanks again, Remi

I'll give it a go. 

Paul

Thanks, Remi

I have tried it with each form which has linked SQL tables as the recordsource.  Each form opens with no records and the packets received are between 200 to...

Thanks Everybody.

Rich - I am joining a table and a view (a SQL Server view containing the username of the person logged in) within an Access query, and basing the...

Thanks Rich, Remi

When I have an application which fulfils the requirements of all concerned, I am most certainly attracted to the 'if it ain't broken, don't fix it' school of...

Thanks Rich

I need to weigh as many comments as I can before embarking on what is likely to be a massive change to the mdb I am currently using.  The...

Hi and thanks for your useful comments.  I guess I will be staying with the mdb.

I am used to using Access 2000 (just about to install 2003) with tables linked...

Also, if I can just continue this a moment.  I have been given the following excerpt from a forum discussing a similar issue.  The contributor replying to a question whether...

Thanks,  Noel

I should get a chance later today to try this.  Hope I can get back to you if I get into difficulties.

Thanks again

Paul

Thanks, everybody.

The problem I have been trying to get around is that the obvious (and excellent) idea that you can have a form automatically add a column from a select...

Hi Remi

No, there is definitely no Microsoft Common Tools - or anything like it.  I can't imagine what the problem is.

Thanks for trying - this is very much appreciated.

Paul

Hi Remi

I when I couldn't find Microsoft common controls 6.0, I looked for any reference with 'common' in it - but nothing looked remotely likely - then anything 6.0 - again...

Yes, I even went so far as to restart the machine.....

We are moving over to 2003 in the next few weeks, do you think it may be wise to wait...

Hi Remi

Unfortunately not.  It said the dll was successfully installed, but it is not available in References.

Paul

I have vb 6 installed....

Hi Remi

Apologies for not searching further afield, I thought you were using a different term for a regular Access 2000 feature.

I have checked my References, and there is not one...