Recent content by dadrew

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?