Search results

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

Jesus!! Didn't think it would be this popular. Stopped programing in Access (moved to Oracle) so haven't been to website in ages. for those of you that still need it, here's a link to the db (not sure how long site will be up so be quick). http://www.anauz.clara.net/access.htm

Hi I have a report which i want to email to people, i have set up a command button that does this. The problem is that when i export the report some words are incomplete and some words do no appear at all. Can anyone help thanx in advance

Thanks Pat, worked fine

Hi All Desperately need some help. I have two tables Company(t1), Fleet(t2) Each company can have n aircrafts. What i want to do is count and total the different types of aircraft each Company has.....can anyone help? Thanx in advance

I had this problem, the way i did it was to write the sql for the combo box. In the GotFocus() event of the "to be autoupdated combobox" ---------------------------- Dim value AS String value = " SELECT Distinct table.[field2]" & _ " FROM table" & _ " WHERE (table.[field1] =...