Recent content by 2k7mmurtaza

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

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

I'm new to access so not sure how to do it either way. Can you give me an example please?

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

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