Recent content by moagli

thanks i've got it all sorted now its looking realli good!!

i got it to work now thanks and have used it for other text boxes on the form, just wondering is there any way i can reduce this amount of coding: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.ScanL = "Scan" Then Me.ScanL.Visible = True Else: Me.ScanL.Visible =...

There is a sample database i set up to detail my problem.

At the minute from a query ScanL text box is entered into a report but i want to have it so that when the report loads if it says 'No Scan' then its doesnt show that text box. I tried the second section of code and it turned the label off but then when i changed it to the first it didn't seem to...

Thanks very much got that sorted.

that was what i tried first but for some reason it doesn't work is it becasue there is an imput mask on the text box? or am i doing something else wrong??

I have a sub form that contains a text box with an input mask on it, and when i entered the following code on the text boxes dbl click command it didn't work is there something simple that i'm missing? The text box is called date, and the input mask is the following:00/00/00;0;_ Thanks in...

Your are right it is a text box and i put that if statement in the detail format section as shown below but it doesnt seem to work: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.ScanL = "no Scan" Then Me.ScanL.Visible = False Else: Me.ScanL.Visible = True End If End...

I have a report that contains a label with either 'scan' or 'no scan' written in it and i want the if statement If Me.ScanL = "no Scan" Then Me.ScanL.Visible = False Else: Me.ScanL.Visible = True to run in a report when it is loaded or is there another why or achieveing the same result so that...

I have a report that is an invoice, so in the header section is the company logo, and then below that is the Nameheader because the report is sorted by name and the customers address is here. In the detail section is all the stock that customer has bought and so contains a list of information...

I have a database with a form in it, i dont want to use the automatic buttons to go back and forth through records because i need it to run an if statement even time it is pushed, the problem is i need to include provision for errors with the button. This is the code i have so far: Private Sub...

I have a table that contains a pricing list of two columns, one with the name and the other with the price, i have locked the name so it can not be changed therefore only letting the user change the price. Is there any way that you also stop the user sdding any more records to the form and...

That still does not work, im not sure if this makes a difference but type_of_care comes from one table and appointment type another, so i am unsure as how to link link tblappointment to tblpricing??

I have some simple sql code: SELECT tblappointment.Appointment_type, tblpatient.Type_of_care, tblappointment.price, [type_of_care] & " " & [appointment_type] AS total, Switch([total]=tblpricing.price) AS Price FROM tblappointment; However i think it is all wrong, i want it to take this...

I have three tables, one containing patient information, one containing their appointment details and another containing the pricing. I have made a calculated field in a query using the patient type and the type of appointment ('other first appointment'), i have then linked this query to the...