Recent content by Anauz

no i haven't. Will this prevent it from printing blank pages if one of the subreports has no data?

Hi I have a report which is populated from several queries. The report is constructed off a main report with 3 subreports inside it. The problem is that in some cases one of the subreports is empty...and when i print, it prints out blank pages. Is there a way i can prevent access from printing...

Hayley The statement determines your development resolution. As you have worked out now Call adhScaleForm(Me, 800, 581, 96, 96, rctOriginal) means you are working on 800x600 resoultion. I may have missed a step in my readme note, what you need to have done was run form frmScreenInfo in the...

Macro Call adhScaleForm(Me, 800, 547, 96, 96, rctOriginal). is a procedure within module basFormScale. Try compiling the code.

thx v much

Hi I am using a textbox to read in passwords. I have masked the password, but i want to limit the chars to 6. Can anyone tell me how to do this. thx Anauz

for any one else that is looking.. http://www.anauz.clara.co.uk/access.htm

the font i used wasn't particularily good. You need to use TRUE type fonts for resizing.

Access97 version now available.

Try the following link The sample db contains a module which resizes froms by measuring the screen dmensions. No need to restart the PC or anything. http://www.anauz.clara.net/access.htm readme file tells you how to apply it to your own database.

Hi I have a query where the user needs to enter their thier userid. I was wondering if we could use getuserid() in the where filed of a query. I tried this but nothing happens. the query just won't run....no error messages or anything. Can anyone help? Anauz

Sorry Looks like the server ftp server went crazy. Happens to me as well...even though there is no password on the database. I try and have it fixed

I think I have replicated your problem. Here is what you need to do. On the field you get Name# error Change the data source to MaxOf(name of your field)

I'm not sure exactly what you want.. i think the Name# error means it did not recognise the field. Here is what i think you should do. 1. Build a query that accepts the name of the customer you want to look at. 2. Make sure it returns the right result. 3. Build a form that passes the name...

group by Min or Max