Search results

  1. R

    Structured data

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

    Validation Rule - Letters only

    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
    • Rupa
    • Thread
    • Replies: 1
    • Forum: Forms
  3. R

    Print current record as report from form

    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...
    • Rupa
    • Thread
    • Replies: 6
    • Forum: Forms
  4. R

    Problem with combo box

    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...
    • Rupa
    • Thread
    • Replies: 4
    • Forum: Forms
  5. R

    Update query

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

    Getting values from a column A that has same values in column B and C

    Hey all I have three fields as follows: Group, RD, Schedule 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 I would like to get all the groups that are exactly...
Back
Top Bottom