Recent content by BrynJ

I thought I would give an update to my question - I came up with a solution that works, although it ain't too pretty and I'd be interested in hearing of alternative solutions. The headers in my report are based on a build sequence number, so what I did was split the report query in two - using...

I have a fairly obscure requirement - what I have is a report with a header and a subsequent detail section. At the moment the header and detail sections are sorted in ascending order. What I need to be able to do is alternatively sort the the detail section in ascending then decending order...

Sorry I'm late replying, cheers for the help - I will try it out later :) Bryn.

Thanks for the reply ghudson. What would the VBA look like for the OnOpen event? I'd be greatful if you could give an example :) Bryn.

I've several forms that are based on queries. These are all displayed in a Datasheet view. I want these forms sorted in a certain order by default. I realise I can add these sort orders either in the query or in the OrderBy property in the form. I have tried both and I'm not sure which is...

Thanks for the reply Kevin. I've tried to create the link on all 7 of our network pcs (running WinXP), I (previously) tried to create a link from a new mdb file and I also tried reinstalling Office without success... Strangely though, I tried creating a link in a new mdb today and... it worked...

Quick bump - hope someone has the answer to this one :) Bryn.

Our company runs manufacturing software based on an Access application which links through ODBC to a database running on SQL Server 2000. I've created a new table in the database on the server, I want to create an ODBC link to this through Access (2002). I go to the tables section and I can see...