try and edit this you should get what you want
Private Sub cmdSearch_Click()
Dim strStudentRef As String
Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first.
If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then
MsgBox "Please enter a value!"...
i used this code to blink the colour of my label but its not working please can somebody show me where i'm wrong
Private Sub Form_Timer()
With Me!label1
.ForeColor = IIf(.ForeColor) = vbblack, vbblue, vbred)
End With
End Sub
i designed my application with a wide screened laptop but if i run it on a desktop with a small screen some part of it always cut off.
please how can i make my application adjust to any screen size and resolution automatically
any help will do thanks
I’m having problems with writing codes for this:
I have this object
1st 2nd 3rd
1-10% 5 8 8
11-20% 6 9 9
21-30% 7 2 10
The issue here is that:
I have 3 people
1) If either of the 3 people scores between...
thanks for that, but even after formating that way dates like 6/7/2010 would read 7/6/2010 and when user query a report they dont seem to get what they want.
please i want my date to read dd/mmm/yyyy so that users can enter their date into access in that format and retrieve it in that format too without access changing it into mmm/dd/yyyy
i need help cause its frustrating
thanks
even with this
THEQUERY2 = "delete from [NEW PAYMENTS] WHERE [TAG] = -1"
the query still executes.
it is the check box that i cant seem to get to do what i want i.e when i check it the code should do this
THEQUERY = "INSERT INTO [NEW PAYMENTS3] SELECT * FROM [NEW PAYMENTS] WHERE TAG = -1"
but...
thanks for that it actually dis some work, but not as i want
1) if you check one it might say you are appending 2 or 0 records
2) if you check two it might say you are appending 1 record etc.
so its not actually following the check option
thanks for your help