Hi all
At the moment I have a form which links to a table, one of the columns in the table is called "Description" so the user can input a sentence or two. Basically I when I open this form (in Edit Mode as Im using a Switch Board)it will not allow me to edit a current record.
I can edit a record in the tabel but not in the form.... :eek: .. help
I have a very simple form that is populating fields with records from a number of tables (not queries).
I have found that I cannot edit any of the records from the form. Almost all of these fields are NOT key fields. When I click in the field, it simply selects the text in the field, but does not allow me to alter it (typing does nothing...the cursor just blinks). The same thing happens for blank fields.
I know this is a simple question, but I can't find the answer in help or searching this forum. I know it must be a simple setting (I think) somewhere but I've tried a number of settings in properties/forms.
Just a general query about the best approach to take for an editing form.
I want to have two separate forms, one for adding a new record (have completed this) and one for choosing and then editing a selected record.
I have seen that people use combo boxes to display a list of records with fields. This seems quite difficult to use. Maybe that's the best way though?
How do you apply an edit button to a selected record in this type of situation? I suppose really I need a box that has a list of records with a little edit button next to each one, or can I do something that launches the edit form as soon as you click on a specific record?
I have a large problem which I can't figure out (well 2 actually but the other is less important):
1) I have a form which brings up the results of a search performed by the user (only contains some fields). From this list of results i would like the user to be able to a) see a full report of that Record (which I've done ok) and b) edit the data contained in that Record.
My results form opens the editing form no problems, however, i cannot edit any of the data contained within it. This only occurs when the results form is open as well so i guess it's because there are two instances of those fields open simultaneously. However, I am reluctant to close the results form because the results will be lost.
2) I've tried several methods to open the form at the desired record: - using the WHERE condition argument of the OpenForm function - creating a filter in the editing form that runs in the OnOpen event These two require the creation of a variable (I'm using the Key field) that is inserted into these bits of code. However, all of my attempts thus far have been unsuccessful; every time it asks for the Parameter in a popup. I've defined the variable as a Public variable in a seperate module but don't really understand this aspect partcularly well; I'm obviously missing something. - the form currently opens from it's own query that gets the Key Field Criteria form a hidden control on the results form.
Here is my code for the 'Edit' button:
Public stProjectID As String
'Results form 'Edit' button click: Private Sub btnEdit_Click() stProjectID = txtID2 [Forms]![frmResults].Visible = False DoCmd.OpenForm "frmProjectEdit", acNormal End Sub
'Edit' form open: Private Sub Form_Open(Cancel As Integer) Me.Filter = "ProjectID = stProjectID" FilterOn = True End Sub
Hey guys, Does anyone have any ideas as to how you might go about editing multiple records at once? So maybe have a listbox with checkboxes, so you can select items in your DB, then, using a form, edit/set one field for all the selected items. Any ideas?
I have a question, I'm building a MS ACCESS database and within it i have a table for putting in my program critical parameters. I don't want anyone to change the content of that table. That means not editing the 1 record in it and not adding a new record. Within the program is't a problem but if you make an other blanc database you can import the table, change it and export it back into the program (i know it is far looking but it happens).
How can i lock a table so it cannot change or it cannot be exported or imported???
I've got a master form, which is used to search for records, and display links to them in a list box. When the user selects a record, they get the full details of the record on a subform. At the top of the subform, I have two buttons, an edit button, which allows them to make changes to the record, and a "new" button, which allows them to create a new record.
My problem is, after a new record is created, the subform adds a new page. So instead of having record one of 1, it shows record 2 of 2. So if a new record is saved, and the user tries to access another record, nothing appears because the subform stays on record 2 of 2(which is a blank undirtied record). If you press navigation button back it will show the record they selected.
Maybe I could make the new form a pop up form, and pass it parameters rather than making a new form within the subform.
I've tried putting the command DoCmd.GoToRecord , , acPrevious in the subforms Current() method, but I get an error saying I cannot go to the previous record.
Good morning! I'm building a database for use by four technicians in a call-center type operation. The call records are purely transactional in nature -- once the call has been logged, the record is closed. If the customer calls again, a new record is opened.
The supervisor doesn't want the techs to be able to go back and edit a record once it's entered -- the records are for quality-control purposes and he doesn't want them gaming the system by going back and changing things after the initial call is logged (let's not discuss the issue of employee psychology, motivation, Office Space, etc.). So I'm trying to figure out how to do that; they all have wheel mice, and I can currently see all the records as I scroll back and forward with my mouse wheel, so I'm assuming they'll be able to, as well.
Hi, I have the following situation. I have a switchboard form which has 2 buttons (Add And Edit) I have a patient record form, which has 2 fields, (DateRecCaptured and DateRecUpdated) Both buttons on the switchboard open the Patient Record form (one opens it in Add mode and the other in Edit mode)
This is what should happen. If I click on the add button on the switchboard, the patient record form should open to allow me to add a record. The system date should then automatically be saved in the DateRecCaptured field. If i click on the Edit button and edit a record, the system date should be saved in the DateRecUpdated field. If no updates are made, the field shouldn't be updated. If you scroll among records, the DateRecUpdated field shouldn't be updated. When editing, the DateRecCaptured field should remain unchanged.
I have two unbound multi-select listboxes that saves selection to their respective table. It works just dandy. However, whenever I go back to the same record, the listbox is blank and apparently I have to instruct it to "retrieve" the previous selection from the table using the PK as criteria.This is far as I can get, though this code causes several errors and I'm not sure what I need to put in as an array for "For Each" statement. If anyone can guide me how to retrieve the old selection from the table and displaying on listbox, that would be great.If IsNull(DLookup("[ClientID]", "[tblClientAccommodations]", "[ClientID]=" & Me.ClientID)) = False Then Dim RecCount As Integer Dim Index As Variant RecCount = DCount("[ClientID]", "[tblClientAccommodations]", "[ClientID]=" & Me.ClientID) For Each Index In Me.lstReasAcc Me.lstReasAcc.Selected = (DLookup("CommunicationID", "[tblClientAccommodations]", "[ClientID]=" & Me.ClientID)) Next iThanks in advance.
I want to lock archive records so that they can't be edited, however I want them available to users for viewing. So for example if the file is "closed" the record can not be changed.
I total novice at VBA. I am trying to code a button to modify (the last) record in a subform list and then add a new record based on values in unrelated or unbound fields on the button form.
The following code is based on the first of two YouTube tutorials (this bit on the edit) and looks like it should work. Except that my Access 2010 with Visual Basic for Aplication v7 does not recognise the type definition Database or Recordset
Code: Private Sub ANOwner_Click() Dim cn As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb
I set my form in Design view to Allow Edits but not Additions, and when I switch it to (or open it in) Form view, all the combo and text boxes and buttons disappear (the background color and header are all that's left).
All I want to do is edit existing records through the combo boxes. How can I correct this?
From the mainform "Home" the "Order Details" Form is launched and changed to Design view. Here I cannot edit the "Order Details" form Property Sheet unless the "Home" form is closed.
I have a form to edit records. When I open the form I am not able to change any of the fields until I edit a date field that has a calendar popup on the "on click" event. After that all of the fields are available for editing. Any ideas?? Thanks, Pat
I have a button in a form that needs to change the text in a field named idStatus from "Assigned" to "Returned"
I have tried using an expression like this "[Form]![Field]=12" in the OnClick spot but it returned an error. There is no "custom made" wizard for this and my VB skills are lacking.
Once again, thanks! (I know I post alot but this forum is amazing!)
I created form based on a query of around 7 tables, all the fields are set to enabled and edits are allowed; however, access wont allow me to edit any of the fields in that form! I know that the query is correct because i can flick through the records and the fileds change.. please help:eek:
I have a Form that is used for creating entries to fill a table. On the same Form there is also a list that shows everything in the table and a double click on the list will populate the Form with that data. The problem is that "Save Record" command button will not update the table because it thinks it is creating a new record.
The code to populate the form from the list is
Private Sub EmployeeEntryList_DblClick(Cancel As Integer) Me![Number] = EmployeeEntryList.Column(0) Me![EmployeeNumber] = EmployeeEntryList.Column(1) Me![FirstName] = EmployeeEntryList.Column(2) Me![MiddleInitial] = EmployeeEntryList.Column(3) Me![LastName] = EmployeeEntryList.Column(4) Me![Supervisor] = EmployeeEntryList.Column(5) Me![Group] = EmployeeEntryList.Column(6) Me![Shift] = EmployeeEntryList.Column(7) End Sub
how I can make it populate the form if an entry is double clicked and then be able to save a modified version of that record over top the original.
I am a relative newby to Access, Can someone please offer a solution to my problem.
I have a DB which lists current order references, I also have a linked spreadsheet from a customer which references their Ref number to our S/order no & Item no. I have set up the relationships for the common data between both tables.
if I create a Query from either table individually the data can be edited but when a query is created from both sources the data cannot be edited. this also happens if the spreadsheet is imported to its own DB.
I would really like to create a form which displays both sets of data for editing, marking progress etc.
I have many forms in my database, three of which completely freeze the database if I edit the slightest thing on them. These forms are all the same, and are unique to any other type of form in my database.
An example of one of the forms is the following:
The form is an "Edit Record" form which allows the user to edit a record directly from a form without going into the table. It is only possible to bring up the edit form by going to the main navigation form that consists of various buttons which a user would press, in this case the user would press the "Edit Record" button. This brings up a unique search form that allows a user to search for a record to edit. The user types their search parameter into the form and once the "search" button is pressed it will bring up the record with all the details in a different form.
Note - The search form is linked to the table where the edit record form is linked to a query.
My problem is this:
I have three buttons on the form; Exit, Cancel & Finish Editing.
All I wanted to do was to ammend the code of the buttons so that "Finish Editing" wouldn't close the form onced pressed and that "Cancel" would simply undo the actions of the user instead of undo and then close the form.
I know exactly how to do the ammendments. But, once completed if you return to the main navigation and click on the "edit" button the search form appears and allows you to type in the search parameters, but once the "Search" button is clicked the search form closes and you are returned to the main navigation where you are unable to click anything in access or even close the programme.
I have produced a table, the records from which have to be selected by individuals for auditing purposes.
I created a second table with individuals initials and passwords. This is linked by the initials to the main table. Records on the main table are returned when the query is run.
At first I could not edit fields in the query but changed the recordset type to Dynaset (inconsistent). I am now able to edit the query fields. However, having created a form based on the query, I am unable to edit the fields in the form. This is the basis that the auditors will use to score so is vital. Have I missed any other switches or techniques?