Recent content by SteveM

Hi, I think the criteria field in the query needs to read something like this:- Forms![frmName]![Process Name] HTH Steve

You could try using a standard select query first to filter the products, and then base the cross-tab on this select query. Not an ideal solution but it should work. Hope this Helps. Steve

Hi, The solution I would use for this particular problem would be to base the report on a Cross-Tab Query. Access has a wizard for creating Cross-Tabs. Steve

Hi, I have a simple report which i would like to tranfer to a file called report.txt This is not a problem using the transfertext method. My only problem is that the file produced includes numerous random blank lines. Any help would be much appreciated. Steve

Aziz, I use the following code to minimise the db Window. I have never used it for maximise but it should work. '************ Code Start ********** Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 Private Declare...

Anton, Thanks for that code, i did not realise this could be automated. It will prove very useful to me. Thanks Again Steve

Anton, I have just experimented in Excel and the following appears to work. On the top menu Select format, columns, AutoFit Selection. hth Steve

Hi, I think the following link should lead you in the right direction. I have used this code in a number of databases. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=4930&highlight=link+auto Steve

Hi Stephen, I have done this on many an occasion by doing exactly as you say, ie Creating a new Db and importing all. Steve

The only way I can think of achieving this is to do the calculation in an underlying query.

The only problem with purchasing a network kit is that the network card contained within the kit will be PCI. This option is not suitable for laptops. You will need to buy either a PCMCIA Network Adaptor or a USB Network Adaptor.