Recent content by Breezer

I use at work an Access form to write out fax headers. Currently I have to print the form and then put the paper into the fax. Is there a way to send the form straight to the fax from the pc?

It's ok I got it to work Thanks Private Sub Check72_Click() If Me.Check72.Value = True Then Me.Final_date_of_payment.Visible = False Me.DaysSinceOrder.Visible = False Me.Days_Overdue.Visible = False Else Me.Final_date_of_payment.Visible = True...

I have started a code which Closes a text box when a check box has been checked. I would like another 2 checkboxes to close also (DaysSinceOrder and Days_Overdue) but cannot complete the code It starts... Private Sub Check72_Click() If Me.Check72.Value = True Then...

I meant to add that the bold line is the one highlighted after debugging:o

Hi Fizzo Thanks for the prompt reply. I done it it code but one line is obviously wrong.. Private Sub PaidCheckBox_Click() If Form_OrderForm.PaidCheckBox = True Then Form_OrderForm.FinalDateOfPayment = Null Form_OrderForm.DaysSinceOrder = Null Form_OrderForm.DaysOverdue =...

On an Invoice order form, when the 'Paid' check box is clicked I would like certain textboxes (i.e 'Final date of payment' 'Days since order' and 'Days Overdue' to be deleted. I expect this can be done with a Macro, but have had no luck so far Thanks for any replies

Great, got it to work...thanks alot Mile-O-Phile

Perhaps try File>>Get external data>>Import select MS Excel in the 'types of file' and select your spreadsheet. That will send the data over but it will need some alterations once opened in Access

wow!, that was quick! okay, so the database would have to open and run as a query each time?

I am designing a database that shows a table of customers who get the products on tab. After 30 days they should have paid, but most do not and this drags on for 45 - 60 days. How would I best design the database to show the customers who have expired the 30 day limit so they could be chased...