Replies

Thanks Hans – I now have a much better understanding of Excle startup – thank you.
PS – do you ever sleep?

Hi Hans, excel knows to try and load that document because it’s in the xlstart directory C:Program FilesMicrosoft OfficeOFFICE11XLSTART and it opens hidden.
I would have assumed from the message that all the workstations are trying to open the same copy but this doesn’t seem to be the case.

How would you normally create a macro to used by all excel documents and where would it be stored?

Thanks Hans.

Sorry that’s not what I’m after. In the solution I used a few years ago did not use a union query.

The unbound form supplying the criteria was allowed to provide a null value and the query returned all records when supplied with a null.
after much fluffing around I got it –
WHERE (((tblRunner.Runner_Name)=[Forms]![frmCriteria]![cboRunner])) OR ((([Forms]![frmCriteria]![cboRunner]) Is Null))

I’m trying to convince them to move to the DAO procedures I have written with your help.
thanks again

Thanks Hans – I’ll go to plan B – 3 Separate reports passing the page numbers from one to the next.

It’s pretty easy –
step 1 Put a text box on the main form, this does not need to be visible. set its control source to be the field on the first subform. eg – =Subform1.Form!SupplierID
step 2 use this textbox as the Link Master Field on the second subforms.

That makes sense – thankyou

Wow! something so simple and yet so difficult. mmm sendkeys,

my mother always told me that using SendKeys would send me straight to hell.

thanks Hans – it did the job.

OK, so does anyone know how to move the the last page of a report when it’s opened?

Thankyou

That did it – Thanks Hans, yet again.

I didn’t have the syntax quite right either.
DoCmd.TransferDatabase acExport, “Microsoft Access”, strExternalDataBase, acReport, strObjectName, strObjectName works.of course it only needs the path to the other database.
Lot easier to work out when I got rid of the superfluous comma.
Thanks.

That is so easy once you know.

Thanks Hans

as long as your database is in 2002 format it will work. If it isn’t then goto Tools>Database Utilities>Convert database. The only issue is going to be if you have used functionality that didn’t exist in the XP version of Access.
Distribution in 2003 is a pain, but the next version (2007) will have the runtime and distribution tools available FREEE.