Search results

If you want to print on A4 paper; Make sure that you printer is set to A4 (Which is appears to be) Make sure that the Page size in Access is set to A4. To do this open a report in design view then go to File/Page Setup / Page and change it to A4. Now save the report and test print it.

James, Your most welcome, glad to be able to help.

James, Here it is back and working. The mistake you made was copying my code and not making changes to suit your database. I changed CustomerID to OrderID and I changed the Name of you report to Rpt_Invoice and in my code I changed Rpt_Customer to Rpt_Invoice. Good luck with the rest of...

James, Post if here, so if I can't help you someone else will.

James, What missinglinq posted makes a lot of sense, if you have not "saved" the record before you try to print it you will get an error. If you have a look at the code in my sample behind the "Print Report" button you will see this code; ' it will not have been "saved" so this will do it...

James, Post a copy of your database (with any sensitive data removed) and I or someone will have a look at the problem.

James, Thanks for your nice reply, I'm glad you go it working. Let us know what was the fault in your code? Sometimes, you explaining what the fix was and what was wrong with the original code helps other users with similar problems.

Is "Orders" the name of your report? Is OrderID text or a number? If OrderID is a number then your code look OK if it is text it is incorrect. If it is may I suggest that you name reports with prefix of rpt forms with frm tables with tbl queries with qry. Here is an old sample of mine that...

When you use acSaveNo , that mean that you do not want to save changes to the form and has no relationship to the data on the form. When you close a form the data will be saved to the table. I use DoCmd.Close acForm, Me.Name

So tell us which way did you go?

Brian, If you were replying to my post, I don't understand the bold section.

In Access 2003 this works: Me.Section(acPageFooter).Visible = [Page] = [Pages] The code goes in the OnFormat of the PageFooter

Have a look at the attached sample database, it will do what you want. You will just have to make some changes to suit your database. I have add a table called tblCharges - Query qryCharges and form frmCharges you will see that they have Amount - Discount = ExtTotal , these are based on your...

Glad it helped

To "Organise" the records you do not have to move them to a new table, you just need to flag them as "Waiting List" and then when you open a your FormWaitingList then then will appear. I have attached a quickly put together example that may give you some ideas.

UchihaSake, Gemma asked the question "Why" do you want to move them from 1 table to another. If all you want to do is "Not see them" then that can be done with either a tick (Check Box) or code.

Base your report on the same Query that you based your Form on and then in the query put ExtPrice:[Quanity]*[Unit Price] Now in both your report and your form you will be able to "Sum" the extTotal. Attached is a sample that will show you how (try doing it yourself first) and also show you how...

Put and unbound text box on the main form and put below as the data source and it will work. =SubformName.Form.RecordsetClone.RecordCount If this does not work then most likely you have changed the subfrom name and not changed the name of the control (subform) on the main form. Hope it...

use an Apend Query to add it to the tableB and then a Delete Query to remove it from tableA

To test it put an unbound text box on a form name it txtMyDate and then put this in the control source =Date() now when you open the form today's date will appear. You can change the format by using the format property of the unbound text box. If the control is bound, make sure that the "Data...