Search results

  1. C

    Split Function?

    Sorry forgot to put quotes on before and after strReservedRooms string, correction: MyComboBoxCtl.RowSource = "Select * From RoomsTable WHERE InStr(1, '" & strReservedRooms & "', [Rooms],1)>0"
  2. C

    Split Function?

    Hi Mickmullen... Of course the string to be evaluated could be changes base on the conditions. I give an example of this illustration : dim strReservedRooms as string strReservedRooms = Text01 & ", " & Text02 & ", " & Text03 if you want to make list of the reserved rooms ...
  3. C

    Go To a Record by Primary Key

    You just need couples of vba code in the datasheet form module create function like this Function LinkData2Forms(DataSheetPrimaryCtl As Control, SingleFormName As String, PrimaryFieldName As String) Dim frm As Form, rc As Recordset If Not IsLoaded(SingleFormName) Then Exit Function...
  4. C

    Split Function?

    Yeah... it's better June7, is that mean your problem solved?
  5. C

    Split Function?

    No need to parse the string, just use this sql-where clause: SELECT RoomsTable.* FROM RoomsTable WHERE InStr(1,"Includes: Room 1, Room 2, Room 3,",[Rooms],1) ORDER BY RoomsTable.Rooms [rooms] is the name of the field that contains data: room 1, room 2, room 3 and so on ... hopefully can help :)
  6. C

    Hello from Cahyanto

    Hello, I'm Cahyanto I am an MS Access programmer since 2003 happy to be able to join this forum :)
Top Bottom