Search results

Hi Friends, I am creating a room booking system in Access 2007. Bookingdate is the primary key and indexed. How do I use the Datepicker to retrieve any bookings already been booked. For Example when a date is selected from the Datepicker if there is any booking the it should load...

Hi Paul, Thank you for your help, it worked. Kind regards Nathan

Hi Paul, I just realised my form fields "Client Name", "Location" and "post Code" are bound Do I have them as Unbound? Thank you Nathan.

Hi Paul, I have selected all the table fields in the "Select" statement. Is there anything else i am doing wrong? Thank you Nathan.

Hi Paul, this is what I have written on the combo Box afterUpdate event: Me.Client_Name = Me!Combo69.Column(1) Me.Location = Me!Combo69.Column(2) Me.Post_Code = Me!Combo69.Column(3) When I press the "save" button it save all the form fields except "Location" and " Post...

Hi Paul, Thank you for your reply. I already written these lines in the afterUpdate event. My problem is I can auto populate unbound fields on the staff_diary_entry form using the combo box. But i am not been able to save those data back to the staff table. I am using a "save" button on the...

Hi All, I have a table called staff, the table has following fields: Date, Staff name, Dept, Client Name, Location, Post code, Time In, Time Out. I am trying to create a simple diary system for each staff with clients they see. I have a form called Staff Diary, where I enter above details...

Hi All, I have just joined the forum, My background is Cisco Network but after long career break, I have just got into a job involves various tasks. I am new to Access, presently am developing a DB in Access 2007 which is why I registered myself on this site. I have number of hobbies...