Search results

Make sure you set your subrepot's can shrink and grow properties correctly. Also make sure you don't have extra spaces on the side and the bottom of your report. Reports are very tricky. It took me along time to get the hang of it with just experimentation! By the way, this was a different...

If you want to do this in a table, you have to go to the design of your table and click on the input mask and the wizard will take you thruogh the steps. Or you can put this in the field where it says input mask: 000-00-0000;0;_ this will do it too:)

Go to options/View and put a checkmark by the System Objects and see what tables you see.

Go to the query behinde your list box. Run the query and print it! I just don't understand why you want to print the list box:confused:

Go to the query behind your report and put : Is Not Null in your field that you are talking about. That should get rid of the null values :)

You can make a query through the wizred to find duplicates and then make a delete query out of the duplicate query. :)

Did you make a copy of your old database that was 12MB? If you did, try to delete the report you are trying to open in your new database and import the same report from the old one to the new one. Is it possible that you lost a module? You didn't explain what features you got rid of either to...

Alexandre, I looked at the code very carefully this morning and I still don't get it. Can you help me please :confused: Thank you

Alexandre Thank you for you reply. I looked at the PrtDevMode and the example, but it's way over my head. Where am I suppose to put that code? Do I specify the size in Metric or English. I certainly need help. :confused:

Don't blame you, you need sleep! Thanks for your reply. I will try it and see if it works. There are butt loads that I still don't know about Access, but I am learning! Thanks again :)

What happend to you Rich? Did you give up on me! I am still waiting for an answer to solve my problem, if there is one! Thank you :confused:

Yes, I am using my default printer and no, it does not support the post card size. You mean it has to do with my printer!

Rich, The Autocorrect is off :(

Hello all, I have to make postcards to send to customers from my Access database. Unfourtunatly, there is not much flexibility with acces as far as sizing the report. first I made a report thruough the lable wizard and custom made the size of my post card (4.25 by 6.25), but when I go to...

Yes, it is possible! Do this in the control source of a text box on your main report [Reports]![YourSubreportName].[YourFieldonSubreport] This should bring the value over from your subreport :)

Use the Nz function on all of your subreports and that should solve your problem

You can do all of those calculations in you query and name the fields they way they make sense to you and just call them on your report just like any other field. For example: BalanceAdjusted: ([total_charges]-[third_party_Payments]-[patient_payment] Now if you put this in your query it...

Go to File/Page setup and the tab column and change the column to 2 or 3 and just play around with the width, hight and row spacing to get it to work. I hope this helps :)

Put this code behind your button: Me.Parent![Your Subform].Requery :)

Put this code in the On No Date behinde the reports design: Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report..." Cancel = -1 End Sub :)