Search results

  1. Keith

    Use One Form instead of Two

    I defer to you and uncle gizmo and have decided to drop the second table.
  2. Keith

    Use One Form instead of Two

    Tony, It is the db that I phoned you about when you were on holiday. I purchased a reservations Db that used a planner, which I do not need as it is only used for 4 days a year. The planner would not let you have two bookings for the same room at the same time. I am catering for two mates who...
  3. Keith

    Use One Form instead of Two

    I have two buttons to open a form, one to add records the other to edit records. The 'Add New Record' button also writes some of the information to a second table. The 'Edit Record' button only updates a field in the second table if that field has changed. Both forms are identical but with...
  4. Keith

    Adding rows to Multi select list box

    I have taken your advice and used code to set the row source. As you said make sure the rowSourceProperty is set to Table/Query. I had it set to valuelist
  5. Keith

    Adding rows to Multi select list box

    Sorted thanks. The line I had commented out worked but I hadn't set the column width correctly
  6. Keith

    Adding rows to Multi select list box

    June7 I get a compile error with SELECT highlighted
  7. Keith

    Adding rows to Multi select list box

    I am trying to populate a multi select list with options available depending on room type. I can get either the Package or Rate on the list but not both, this indicates my strSQL is ok. I have spent all day on this forum and the web but still have not succeeded so here I am, cap in hand, asking...
  8. Keith

    Lost Data

    The table is not re-loaded by anything else. Delving further it apears that access crashed and the user canceled the mesage asking where to save the db to. Not fat fingers but stupid fingers.
  9. Keith

    Lost Data

    Cj, There is no filter. Doc man, the other 40 tables were un affected. I imported the table from a backup, after a compact & repair that you suggested had no effect, and every thing is ok. I was just puzzled how just the data from one table dissapeared.
  10. Keith

    Lost Data

    Opened my application this morning and all the data has disappeared from one table only but the table structure is still there. Spooky. Anyone else had this problem?
  11. Keith

    Moving from Subform Problem

    They are both using the same source
  12. Keith

    Moving from Subform Problem

    I have a form with an option group to select subforms to be displayed.To save space on the main form I have added a subform (frmSubService) to the option group to display some of the data that was originally on the main form. The subforms data source is the same as that of the main form but only...
  13. Keith

    Complicated Split

    Job done, Thanks for everybodies help.
  14. Keith

    Complicated Split

    vbaInet, I have seperated all the records with no dates an have sucessfuly split them into the destination table. I am now left with those with dates. I have converted those records into comma seperated Field. I am having trouble splitting those record that only have one date My code works if...
  15. Keith

    Complicated Split

    BluIshDan, I get a function Not Defined Error highlighting split_boats
  16. Keith

    Complicated Split

    Syntax error in INSERT INTO statement. I think that I need to capture the array values and put the insert SQL after Next i and before rs.MoveNext
  17. Keith

    Complicated Split

    Mile-O, I can sort out the adding the missing part of the year once I have split the string. My problem is the insertSQL statement which is where I am getting the error. The tblSandboxTo in my previous post is not the result of the code split but one that I made as an example of the result I...
  18. Keith

    Complicated Split

    I have split the records with no dates without any problems. I Have filtered out the data that has dates in and the table is tblSandBoxFrom MemberID Boats 1659 Courageous,1986,1988 1659 Conqueror,1977,1979 1659 Walrus,1977,1977 1659 Valiant,1983,1986 1660 Artemis,55,57 1660 Token,57 The ouput...
  19. Keith

    Complicated Split

    I am trying to reduce the dataset to just those records with dates in. I tried to run a delete query but I get an error 'Could not delete from specified tables'. I have researched this error and tried all suggestiuons found with no luck. The sql for the query is; DELETE DISTINCTROW...
  20. Keith

    Complicated Split

    The Complicated Bit MemberID Boats 1024 H43 (42) H44 (42) L26 (42) Tactician(42-44) Varangian(45) Talent (45-46) Tally-Ho(46-47) 1025 Oberon H44 H50 Spirit Vigorous Thrasher 1027 H43 Subtle Sealion 1042 L26 H44 Thunderbolt Truculent Unruly Ultor 1045 Spur Virulent Venturer U1171 1067 Truculent...
Top Bottom