Search results
-
A
Change to red when Payment is Overdue
I have just looked at the numbers and its right. In my excitment at getting it working i never noticed that the due date is 13-Jan-99 and that would make the 411 right. the due date was over a year ago. I am very sorry Anyway i have to blame you for that, You got me so worked up that i could't... -
A
Change to red when Payment is Overdue
That's perfect. It works better then what i was trying to do. The only thing is, i have one account that i left the check box blank to see what would happen and it gave me a figure of 411 when the due date was 31-Jan-99 how do i get round this. If i can't it's not a problem because i have a... -
A
Change to red when Payment is Overdue
I have Tried this and i get an error message saying that the macro is not excessable. I haven't made a macro, I copyied the information in to the OnCurrent box like you said.This is the expression i used Iif(Me!DueDate<Date(),Me!PastDueLable.Visible = -1,Me!PastDueLabel.Visible = 0) The form... -
A
Change to red when Payment is Overdue
Can anyone help with my small problem. I have a simple form Based on a Query with: Invoice ID Customer Order Date Due Date Paid How do i get a record to apper red when the due date is passed and the order is still marked unpaid. If an order has not reached its due date it should stay black. ???? -
A
Print a single invoice from a form
Thank Carol Every thing is coming out as it should. -
A
Print a single invoice from a form
Why is it so bloody hard to print a single invoice. I have just discovered that if i put one item in the invoice i get a one page invoice. If i put 2/3 or more i get lots of pages. if i have 2 items i get two items, even though i only have one invoice. Is it realy that hard to solve this... -
A
Print a single invoice from a form
I have managed to get it to work Thanks to you. I done as you said Travis and when i clicked the button it asked me for Invoice number. when i typed it in it opened the invoice as a single record. I then changed the text to the following. DoCmd.OpenReport "print invoice", acViewPreview, ... -
A
Print a single invoice from a form
What would go in the [Something]= [LimitData] would that be [Order ID] = [LimitData] -
A
Print a single invoice from a form
I have a field called "Order ID" in the main report and i have "Order ID" in the sub report. I have tried linking the information using this in the Perent/child fields and still no luck. I did manage to get the page to show only the Information for each record but can't get the dam thing out on... -
A
Print a single invoice from a form
Can someone please please help. I am trying to print a report with a subreport But it just wont print. when i try to print it prints ever record. My next option is a size nine boot to the center of the screen.