Novice
Windows 7 64bit 
Access 2010 64bit
Hello. I'm currently working on cinema seating system which have 3 auditoriums using VB. My system will support online booking and walk-in. I'm currently having trouble in preparing Database. Attached are the images.
May I know how to update "Availability" column in Booking Table from available to unavailable when I book seats by clicking the "Book" button in VB?
Thank you in advance.
MVP / VIP
Windows 10 Access 2010 32bit
Crossposted at https://www.access-programmers.co.uk...d.php?t=307824.
Usual link about crossposting added there
Simple table relationships ("faces" to "spaces" to "chairs")
Column sum works in "Detail" but not "Footer"
update query - to replace "name" with paralell info in the next column which is Field
Make "new Record" unavailable but not disabled on form
Posting Permissions
Reply With Quote