Recent content by Keith

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

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

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

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

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

June7 I get a compile error with SELECT highlighted

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

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.

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.

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?

They are both using the same source

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

Job done, Thanks for everybodies help.

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

BluIshDan, I get a function Not Defined Error highlighting split_boats