Search results

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

Some data is sensitive. I'll see what I can do. I'll try and filter it. Thank you for all your help. Much appreciated. Rupa

I've just tried that data and it worked but doesn't work for the bulk data that I have. This is bizarre! I'll see if I can attach some of the original data. Thanks, Rupa

Could you please feed this into a table: AD, LRC1, Mon-Fri 07:30-17:00 AD, LRC2, Mon-Fri 07:30-13:00 FM, LRC1, Mon-Fri 07:30-17:00 FM, LRC2, Mon-Fri 07:30-13:00 JK, LRC1, Weekdays JK, LRC2, All day JK, Main1, All day And see if you are able to get AD and FM?? I might be doing something wrong...

I just want the group names to appear. So if I select just the group name then it should show: AD FM and not JK or any others. Don't know if I'm making sense. Here's what I've written: SELECT ACG_All.Groups FROM ACG_All INNER JOIN ACG_All AS ACG_All_1 ON (ACG_All.RD = ACG_All_1.RD) AND...

Tried it again and am still getting 3568 rows. Any suggestions? Thanks, Rupa