Search results

I don't know if this will help, but I have found that when you have fields that can grow, you need to ensure that the top of the controls are exactly aligned, (use format, align, top) or the slightly lower control will be moved down when the other control grows. Sue Powell

Could you declare a public variable, eg EmptyReport and set this to true in the nodata event of the report. You could then test this with an if statement in your print event and only call the print command if emptyrreport is false. You would need to set emptyreport to false before callling the...

Thanks for this Pat, I've tried it and it works, with just a bit of tweeking to make it look the way I want. I was trying to treat the report like a form, and create my own values for the controls, but I now realise this is not possible. Thanks again Sue Powell.

Hi This is a source of frustration rather than a stop the job question. When using the query grid in Access 97 , any changes to the layout of the tables was saved, so when you went back to the query everything was a syou left it. With access 2000 and 2002, everytime I close the query, or...

Hi, I have a report that will print out a list of serials numbers against a job number. Because fo compatability with existing reports, and space considerations I would like to format the serial number control as serial1, serial2, serial3, rather than have 1 serial number on each line of the...

Thanks Nouba That seems to be the answer, I can't do it! Sue

Hi I have put a calander control onto a form, and when the user clicks on a date, that date is put into a control on the form. This works fine, but when I open the form, the control always shows the date Iput the control on the form (13th june 2003) rather than today or even this month. This...

One of the simpliest ways to do this without any work is to put your cursor in the company name combo box and then use the find wizard (binocular icon on the toolbar) This lets you type in the company name (or part of it), then you hit the find button and your there. It isn't particulary...

Hi Due to all sorts of reasons I have a system with an access97 backend, with Access97 and Access2000 front ends. This is due to old pc's, but I need the 2000 front end as I need to use some functionality for the master user that is not on 97. This user would like to work at home, so I...

As I have had no replys I will post the same mesage to the tables forum, as it is tables I am having trouble with. If you have an answer could you post it there cos I don't want to get into trouble for multiple posts. Sue

Hi Due to all sorts of reasons I have a system with an access97 backend, with Access97 and Access2000 front ends. This is due to old pc's, but I need the 2000 front end as I need to use some functionality for the master user that is not on 97. This user would like to work at home, so I need...

Hi I think you want something like this = IIf (([pack] > 1),(iif([CasePirce]=[BottlePrice]),[CasePrice],"") ,"") in the record source of the list_case field, or if you want to put it in code use this: If ([pack] > 1) and ([CasePrice] = [BottlePrice], then [LIST_CASE] =...

Hi Yes you can do this in the query, something like total: fieldname1 + fieldname2 + fieldname3 in the top line of a new column then put total into your report. As a thought, are the fields you are trying to sum actually on the report, or just in the field list? The fields have to...

Hi I have created a dummy database with 1 form containing a text box to define how many copies of the entire report are required, and a button to print the reports. The database also contains 3 reports with just a text box. the code behind the button on the form is: Dim counter As Integer...

Hi, I have downloaded your database and think I have solved your problems. I attach the amended database for you to see. Basically I put the expression =Sum(IIf(([Professional]=Yes),[dollars],0))+Sum(IIf(([Professional2]=Yes),[Dollars2],0)) in the text box for professional payments...

Hi Neal Yes the zipped file worked fine. This is a difficult one. I think that you will need to set up some sort of input routine to read the word paragraph character by character, recognise the formatting characters, and replace them with ones that access can recognise. I.m afraid this is...

Hi If I understand you correctly, you want to print several reports in a particular order to give 1 printed output. To do this I would put a button on a form to call the first report for printing, then edit the code behind the button to call each of the reports in the correct order. This...

Hi, Ive had a look at your forms and reports, but I can't see anythink obvoiusly wrong. If your database is too big to zip could you just export the form and report, and the tables that feed them to a dummy database and zip that. If you don't want to export sensitive data, just export the...

Neal, yes you can send a PM to my e-mail, but did you know that you have to zip the database to post it, you can't post a database in mdb format. Sue

Which version of Access are you using? I have been using 2000 and XP and the characters seems to work with them. When I do this in access 97 I just put a carriage return in the expression and it works OK. If you are using 97 you may need to put shift return to put a new line in the text box...