Search results

  1. 2

    How to delete selected record in MS Access (VBA) table within a form

    I have a view bookings page where once customers make a booking it shows their list of all bookings they have made. The issue that I am getting is it doesn't allow me to delete a selected record and only keeps deleting the record which is on the top despite selecting another record. I...
  2. 2

    How to show all booking records on form

    This is for VBA Access Option Compare Database Private Sub btn_Search() Dim strsearch As String Dim strText As String strText = Me.txtSearch.Value strsearch = "SELECT * from tblBookings where ((MemberID like ""*" & strText & "*"") Or (BookingID Like ""*" & strText & "*""))" Me.RecordSource =...
  3. 2

    How to hide an option in combo box in MS Access VBA

    I have two forms; a register form and an update details form. I have a drop down on my membership type which is found on both of these forms that has an option as cancelled. I only want the cancel option to appear on the update form and want to hide it from the register form. How do I do this...
  4. 2

    Making a fitness class booking after logging in as a user

    On my booking page, I have a member ID field, Class type field as a dropdown (swimming, circuit etc) and a date field. The issue I am having is that when I log in as a user, how do I automatically populate the memberID field on the booking page updated to that user's member ID (logged in...
Back
Top Bottom