Search results

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...

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...

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...