Search results

WHOOPS! Posted the wrong code! Private Sub Command14_Click() On Error GoTo Err_Command14_Click Dim stDocName As String DoCmd.RunMacro "Search" stDocName = "Search1" DoCmd.OpenReport stDocName, acPreview Exit_Command14_Click: Exit Sub Err_Command14_Click: MsgBox...

Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim stDocName As String Dim stLinkCriteria As String Me.Visible = False stDocName = "Search" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command11_Click: Exit Sub Err_Command11_Click...

:eek: Ok, how, please. Ive got so used to doing searches by using a querry Im a bit lost!

:rolleyes: Hmmmm! Not really, early learning centre for me I'm afraid!

Yes I am! Does that make a difference?

I have created a search form made up of a number of different boxes. In my querry for the search I am using the following statement: Like "*" & [Forms]![Search]![ExerciseName] & "*" I a have a number of theses all saying similar things. At present I have to put something in each of the...

OK so ive got my search form working. But I need to refine my querry, at present it reads Like "*" & [Forms]![Search]![Box No] & "*" So if I put in E1 it will return E1, E11, E12, E13 i.e anything with E and 1 in it. Can it be refined to only give what I ask i.e if I ask for E1 then all I...

Thank you! :)

Is there a way that I can say If Me. TextBox1 = "Any Value" Then Me.checkbox1 = True I was trying to do this in a querry but the problem is the same. I'm sure theres a way, but!

I belive I have done this before but I cant remember how! I have a continuos form with two text boxes on it and a check box. I am trying to say if text box1 = "1" then text box 2 is visible if text box 1 = 2 then text box 2 is invisible. I am doing this on a tick box (for other reasons) so...

No its not a continuous form. I need to count the number of records that have a true in the tick box. I know I need to use one of the count functions just not sure which one as i belive there are a few.

I have a number of forms and on each form there are a number of check boxes. I want to be able to add up how many check boxes read true. i.e if check1 = true then total = 1, if check2 = true then total now = two. Can I achive this?

I have a text box on a form that holds a grid reference, (2 letters and 6 numbers). I have set the box up with an input mask, (>LL000000;0;_). Is there a way that when the user clicks in the box that the cursor will go to the start of the box. At present it goes wherever they click in the...

I have created a macro to export data that works on a button, no problem. Is their a way that I can change th design to allow the user to choose which record(s) he/she wants to export?

Can you explain a little more, please?

On aform I have 3 controls, 2 x check boxes and a combo box. depending on what is selected from the combo box will determine which of the two check boxes are visible. I want to reflect this on a report. i.e I only want to show the checkbox which has got a true reading. Is it possible to do...

Thank you!

I have two buttons on a form, one of them adds default information to three boxes, the other clears the info. I want to be able to hide one o the buttons depending on what is in the box. I know I need to change the focus away from the control in order to hide it, but how do I do it please? I...

Sorry, I dont understand, the numbers are from a value list and they are a text field

Can someone please tell me why this piece of code dosent work. Im sure im missing something really obvious! The problem is that it only works one way. i.e. on the top part of thr code. Private Sub Unit_Name_AfterUpdate() If Me.Unit_Name = "114" Or "115" Or "213" Or "214" Or "215" Or "564" Or...