Search results

Thank you both. Now I understand what you are saying.

Thank you for your help. However, the problem I am having is that the [end date] field is visible or hidden for all five rows simultaneously instead of the one just the one where the checkbox is changed.

I have a continuous form and want to hide or display another field depending on the value. The problem is it changes for all records in the form instead of just the current record. I am using the following code. Private Sub Check23_Click() Me.[end date].Visible = Me.Check23 End Sub I...

Thanks to both of you - makes much more sense to put it on the before update event. Wasn't thinking it through properly and it fooled me by working before I removed the filter. Assistance much appreciated.

I have the following code that checks a recordset for duplicate records - Ihave not yet written the code to handle them - they will be allowed under certain circumstances. All I need at the moment is for the new record to be undone if it is a duplicate. The code works fine if I comment out...

Unfortunately I can't find the article again but if it helps at all here is my query based on what I learned in the article. It resolved my issue. SELECT register.classID FROM register WHERE ((([register]![ClassID]=[Forms]![Statt]![cboclass] Or [Forms]![Statt]![cboclass] Is Null)=True));

Thank you - I just retyped it and it worked. Don't know why it didn't before.

I have 8 labels on a form that I want to be able to loop through changing properties such as visible and forecolor. I tried naming them lbl(1), lbl(2) ... and refering to them as me.label(i).visible=true but that didn't work then I tried naming them lbl1, lbl2 ... and referring to them as...

Thanks everyone for the help. Brian, I have used the solution you proposed. It all works now and I understand what it does so much appreciated. Will look forward to seeing the tutorial if and when it is available.

Thanks - this looks like a great solution. Just have to read it again to understand it properly.

I tried that but now it returns an error if I do not put in a value. says expression is typed incorrectly or is too complex. Do you have any other ideas?

Can you help, I am trying to use the following criteria in a query IIf([Forms]![StudentAttendance]![Combo0]<>0,[Forms]![StudentAttendance]![Combo0],Like "*") I have a form with a combo box giving the user the option to select a value, otherwise I want to show all records. the bit that...

Thank you so much. This is exactly the problem - I can now enjoy my weekend! Hope you do too.

Please can anyone help. I'm running the following query to find records either 1 week or four weeks earlier. I set the value of i to 7 or 28 accordingly. It runs ok but does not return any results even strsql = "SELECT registerDate, " & _ "sessionID, RegisterID FROM RegisterHeader " &...

Thanks for taking time on this one. The problem is that I do attempt to move the focus to the next control but the dropdown seems to interrupt it - and cover the next control as well. Perhaps I will redesign my form!

Here is the subroutine and the function that it calls. Private Sub ComboClass_NotInList(NewData As String, Response As Integer) Response = NewListItem("Class", "comboClass", NewData, "class", Response, True) If Response = vbYes Then Me.[Class] = NewData...

I would be very grateful if anyone can help me. I have an unbound combo box on a form. Users are allowed to add new items. Limit to list is set to true and auto expand is false. When the not in list event is triggered I have vb code that allows the user to add a new item and then requeries...

Many thanks Paul, a great solution. Jill

I have a report based on a query which has 7 fields set to true or false. I want to show ticks on my report where the field is true and nothing where it is false. I know I could use checkboxes but I want big green ticks so am using an image. I thought I could set the image.visible property to...

This is a great tool - thank you. I am thinking, if I store the delete order in a table in each database, I can then run this to reset everything without having to think about the order more than once! (as long as I exclude the delete order table from the list). I really appreciate your help.