Search results

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

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

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

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

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

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

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

Can someone help please. I have built and tested my database and now need to delete all the data and reset all autonumbers. Is there an quick way to do this without having to create and run lots of delete queries?

I have a form where the user enters a day. There is a tabbed form below where each tab contains the same subform. The tabs show the names of classes running on that day. The subforms are populated by a query that selects all students enrolled on classes running that day. What I want to do is...

I have two unbound combo boxes on a form that allow user to find a record on the form. The user chooses which to use depending on whether they want to search by customer name or number. Both work fine. However, if they choose to select by number, I want the second combo to display the...