Record selector symbols
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Q1: Instead of relying on the Lock.Indicator in the Rec.Selector, is there any VBA function that can return this state?
Q2: Is there some code to block other users from editing a particular same record
The user can select the record by clicking on the record selector and pressing their delete key (on the keyboard) to delete that record. I'm havingtrouble coming up with any ideas on how I can firstly capture the event of selecting a record via the record selector (for which I then want to log the fields as they are) and secondly thatthey have pressed the delete key (for which I then want to log the deletion)
It's an unintuitive and annoying extra click; I'm not sure exactly why it's happening and haven't found any simple operation to mimic clicking the record selector.
I want to create a form for end users to enter notes for a record. Some users will be look up the record by ID and some will want to use Name.
Is there a way to link separate controls together, so that if I select the value I want in one, it will pull up the notes field for that record AND update the other selector to reflect the correct value?
If I pick ID 1234, I will see John Smith in the Name selector and John Smith's Notes field. If then decide I want to look at/edit Jane Doe's notes, I can select her name from theName selector and her ID 9876 will update on the ID selector.
I've been able to get 2 separate combo boxes to control the same notes field on the form, but I can't figure out how to connect the values in the combo boxes.
I want separate combo boxes so that the user can search by typing either the ID or the name (the lists are pretty long) and if I include both the ID and the name in the same combo box, Ican only type in which ever field is first.
Private Sub Reference_Number_Click()
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmProjects"
stLinkCriteria = "[Reference Number]=" & "'" & Me![Reference Number] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem that I have is that after the form opens, when I click on the record selector on the bottom of the form it just shows one record and if you click forward it comes up with a blank form waiting to be filled in. If I click on "Filtered" right next to the record selector and make it unfiltered then it works fine and I can click through all my other records.
Question: Is there anything I can add to the code above that will open the form "Unfiltered" and by the way I would also like to disable the add new record next to the selector
In design view (form), form selector, under data - record source, I changed to Product List table, Under the Format tab - changed to Product List. saved.
Went into form now getting error code: Under all fields #Name?
Went back into form selector - changed format - record source, back to Products. Still getting the same error:
Sometimes I need to assign more than one 30 minute appointment to the same person. Taking a specific example I would like to assign 10:00, 10:30 and 11:00 to the same person.
Once I enter the name in the 10:00 slot, I would ideally like to click on the record selector to the left of the 10:00 slot and drag the cursor to the 11:00 record selector and have the name replicated in all 3 time slots.
I tried using MouseDown. This can identify the name value in the 10:00 slot. I dragged the cursor and hoped that MouseUp would identify the value in the 11:00 slot. It did not. It identified the value in the 10:00 slot.
Any ideas on how to perform this multiple record selection and manipulation
The problem is.If a type in the record number in the record selector or navigate with the record selector arrows, the dynamic caption reflects the current record count, etc. and it all works. But if I navigate to the record with the Split Form, the dynamic caption doesn't change. I thought the OnCurrent event always fires when you change records, but it apparantly isn't working when navigating with a split form. Anybody know of a workaround