Recent content by Rupa

Hello all, I have a table with the following columns: Location, Time, Alert Type Value 1 08:00, Start time Value 1 21:00, End Time Value 2 09:00 Start time Value 2 15:00 End Time Value 2 08:00 Start Time Value 2 21:00 End Time I would like to organise it in...

Got it. For anyone who may want to know. It's: "IsNull" Or Not Like "*[!a-z OR "" ""]*" Thank you anyway, Rupa

Hey all I know this might be really simple for some of the geniuses on this forum. How can I set a validation rule to allow the user to enter letters (A-Z) only please. Any help will be highly appreciated. Many thanks, Rupa

I worked it out!! The values on the report were coming from the table and not the form. It works perfectly now. Thank you for your help anyway :-) Much appreciated. Rupa

DoCmd.OpenReport stDocName, acNormal, , "StNo = '" & Me.StNo & "'" They are both called StNo Thanks, Rupa

Thanks PBaldy I tried that before as well but it prints a blank one. Any ideas? Many thanks, Rupa

Hey all I am trying to print a record that I have just inserted on my form. My code: Private Sub PrintTempSlip_Click() On Error GoTo Err_PrintTempSlip_Click If (IsNull(StNo.Value) = True) And (IsNull(Forename.Value) = True) And (IsNull(Surname.Value) = True) Then MsgBox ("Please enter...

I have just created a new form and it works! Thanks for your help anyway :-) Regards, Rupa

I tried something, without the requery, it lets me type in the combo box but doesn't otherwise. I have a same type of combo box on another form which lets me type in but this one doesn't when it has the same 'on change' event. Thanks, Rupa

Thanks for your response. I have got an 'on change' event that requeries a subform but nothing else. No timer either. Any ideas? Regards, Rupa

Hey all I have a combo box that picks up contact names from a field of a table. So it's basically: Select ContactName FROM tbl_clients The problem is that it won't let me type in it. As soon as I hit any letter, it display the name that begins with that letter and then highlights the...

LOL..Your suggested solutions worked so it looks like you are paying attention :-) Thanks again, Rupa

Thank you LPurvis. I didn't need the FROM temp either so this worked: UPDATE temp SET temp.Magstripe = (IIf(Len([temp].[Magstripe])>10,Right([temp].[Magstripe],9),Right([temp].[Magstripe],6))) Many, many thanks, Rupa

Thanks for the reply. I've now got: UPDATE temp SET temp.Magstripe = (IIf(Len([temp].[Magstripe])>10,Right([temp].[Magstripe],9),Right([temp].[Magstripe],6)) AS Expr1 FROM temp) And it gives me the following error: Syntax error (missing operator) in query expression...

Hey all I am trying to update a column in a table with this: SELECT IIf(Len([temp].[Magstripe])>10,Right([temp].[Magstripe],9),Right([temp].[Magstripe],6)) AS Expr1 FROM temp How would I do this? I tried: UPDATE temp SET temp.Magstripe = (SELECT...