Record selector symbols
Record Locks checking by VB6
As we know, once a form's Record Locks is set to Edited Record (2), if user1 starts editing of a record, it will show the Locked Indicator state in the Record Selector when user2 edit the same record.
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
Capture event - record selector
I have a main form and subform for which I need an audit log. I.e. log changes etc. All is fine on the main form, works fine, but I have a query regarding the sub form. The sub form is a continuous form with record selectors.
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)
New record not staying selected
My code grabs some information from the current record and passes it to a new record, then hides and shows some buttons and instruction labels. The strange thing is that when it is done I can't edit any fields until I click on the record selector button, which I don't even want on the form.
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.
Multiple Linked Selectors on a form?
I don't have a lot of time to devote to learning Access Forms for this project so I'm hoping someone has a quick and dirty solution for me. I have a table with a number of fields. Most importantly, ID, Name and Notes.
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.
Change form property with VBA
When I click in a text box on one form it opens another form using the following code:
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
Changing the record source in a form
I have a form that is tied into a table. I have imported a new table that I want to connect this form to. Both tables are the same, the new one is updated info that needs to be changed. This is what I have done.
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:
Form multiple record selection/manipulation
In its simplest format assume a form that shows the available appointments for a specific day. Assume two bound fields (date, name), and for the specific day 10 available records at 30 minute intervals, say beginning at 09:00, 09:30, 10:00 . ending at 13:30.
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
OnCurrent Event not firing when using Split Form
I have a form that contains a tab control. I want the tab control caption to include the number of records in the datasheet within that tab. I coded this in the OnCurrent property on the form, so that the "dynamic caption" changes based on the current record on the main form. This all works.
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
Clicking on label opens up new record
The first form of my DB is a record selector where you select from text boxes different criteria. But for some reason, whenever I click any of the label headings for each of the txt boxes, it creates a new record
system color selector question
I'm using API to open the system color selector
Is it possible to open it in the middle of the screen? now it opens on top-left corner?
Clicking on Form Background Adds New Record?
I have a form that is a record selector with different text boxes that the user can use to select and open a specific record. For some reason whenever a click on the outside edges of each of the text boxes, it adds a new record.
Disable listbox selector
I have a listbox that I would like to use as an information only box. Is there a way to turn off the selector/highlighter in the box when someone clicks on it?
I've searched through the forum but didn't find any answers. Found a lot of other goodies that I've bookmarked in my brain for future reference though
Make "new Record" unavailable but not disabled on form
What line of code can I use to make the new record selector unavailable (invisable) on my form but not disable it? I want users to add a new record from a different switch board form
show all record in form
I have form "FrmLap" but that showing just only one record if I want to see all record what I should do?
I have main form "FrmMain" in that there is subform "SubLap" that is in datasheet view where I can see all record
and when user click in record selector on any record I can open just that specific record in "FrmLap" form but I want to see all record and when "FrmLap" open it should display that record.
suppose in my datasheet there 10 record if I click on record number 5 , I want that form should open with all 10 record but it should display record number 5 and if I click on next recordit should also show me record 6 like that.
Clicking on label adds new record?
So I have a "record selector" type form as my main screen where you can click combinations of random fields. But above each of the fields is a label (e.g. Status) that the user can select as one of the possible combinations.
But whenever I click that label, it opens up a new record? Does anyone know why or how to fix it? There is nothing in the code, is this a bug?
Subform creating orphan records?
I have a MainForm and a SubForm. I select the new record selector on the MainForm to begin creating a new record. If I then enter data ONLY in the SubForm and navigate away from the MainForm an orphan record is being created from the data entered into the subform.
I do not see how this can be since I have referential integrity set in the relationship field. Can someone please help here
How to identify which record in a continuous form was clicked on?
I have a continuous form with an image and a text box on it. When the image is clicked, some text should appear in a text box. The problem is that the text appears in the text box of the incorrect record.
Suppose the first record is the 'current' record (i.e., having the record selector to its left), and the user clicks on the image in the third record. Then the text appears in the first record, not the third.
Is there a way to find out which of the records was clicked on? Or, can I change the current record to be the one whose image was clicked on
Automatically correct spelling and insert text and symbols by using words in a list
You can use the AutoCorrect feature to correct typos and misspelled words, as well as to insert symbols and other pieces of text. AutoCorrect is set up by default with a list of typical misspellings and symbols, but you can modify the list that AutoCorrect uses.
What do you want to do?
* Understand the AutoCorrect list
* Add a text entry to the AutoCorrect list
* Add a text entry to the AutoCorrect list during a spelling check
* Change the contents of a text entry in the AutoCorrect list
* Rename a text entry in the AutoCorrect list
* Use AutoCorrect in InfoPath
Primary Key and form
I have a (pre record selector) form with one text box to enter a primary key to then open the main form to the specific record.
[CODE][Private Sub CmdSearch_Click()
DoCmd.OpenForm "Internal Survey Form", , , "Propref = '" & Me.txtPropref & "'"
It still opens to a blank form if there is no record matching. How can I prevent the main form opening and have a message saying no record found?
Filter on a control
I have a created a macro that should filter based on a keyword in the control "mot cls" from the table "Banque Jurisprudence Transport". The code is as follows:
On Error GoTo FilterKeyword_Err
DoCmd.ApplyFilter "[Banque Jurisprudence Transport]![MOTS CLS]", "[contains]", ""
I do get a dialog box with the word contains that lets me enter the keyword I am looking for, however, although the record selector shows the form as being filtered, it is not since I know that there are 5 instances but the record selector shows 72 which is all the records.
Basically, I am trying to create a macro that would reproduce the following steps:
- click in the control "mot cls" (French version of keyword)
- Text filters
- I then get a box entitled Custom Filter with the title MOTS CLS contains letting me enter the keyword I am looking for