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.
My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.
My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....
As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.
Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID Customer Name
ProductID is a combo box.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want it to lookup that ID from tableProduct. However, how can I do this when everything is already bound to tableData?
Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID Customer Name
ProductID is a combo box on the form.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want a separate textbox to lookup that ID from tableProduct and display the ProductName.
I am coding in VBA and use Microsoft Access as the front end. My question is : I have a table(tblStudent) which has two fields Student Name and Gender.
I want to add multiple records in this table through a form at a button click....(Say I want to add least 5 students at a time) So, I have 5 textboxes for student name, 5 textboxes for Gender and an Add button. How do I so this programmatically?
In my database I have 4 tables for a small painting and decorating business.
These are: tblCustomers, tblOrders, tblStock, tblPayments.
I have a form based on tblOrders to add new orders when they come in from customers.
In this form there are 3 important fields: "CustomerID" (Lookup to tblCustomers), "StockID" (Lookup to tblStock) and Quantity (Entered by user).
However, I want a calculated field that will be worked out automatically when the user is entering these details. The calculated field should go to tblStock and grab the "Cost" field.
However the main problem is specifying what price it will grab from the table. I want it to get the "Cost" where "StockID" = (the stock ID selected in the lookup). I then want to multiply the price by the quantity which the user has entered.
The control source should be worded something like: = ([tblStock]![Cost] where [StockID] = StockID)*Quantity
but that isn't valid.
Could anyone point me to a piece of VBA or some way to get around my problem? Many thanks for any help, Stephen
Trying to create a simple data entry form to get information and populate fields from another table. i.e. type in info in one field and the other fields are displayed in the form with information from another table.
I have a simple data entry form based on a table. However I have a few fields that I do a lookup in a field on the form from a query, and yes I know I should not have a lookup in the control source however, this is the way that I will be doing it on this occasion.
=DLookUp("[Salary]","[Salary Query]")
How I get the value from this unbound field to enter into the actual field in the table. Do I bring the actual field into the form and hide, and do some sort of after update, as I have tried and it does not work.
I have called the unbound field with lookup "Salary Level Base" and the actual field in the table is "Salary Base".
I Work for an NHS organization. A department here orders prescriptions and sends them out to Gp Surgeries. I have been tasked in designing a database to make this easier for them.
Prescriptions arrive on a Pallet. Each pallet has 100 Boxes of prescriptions on it. Each box Contains 2000 Individual prescriptions. I have a table which contains the following:
Box Number Serial Start Number Serial End Number
When the user enters the first box number and the serial start number, i need it to calculate the serial end number and insert another 99 rows into the table and also calculate the serial start and end numbers for these other 99 records.
I am creating a form for data entry into my main table. It shows all the fields including a name, date, id number etc.
I am trying to put a subform on the form containing a query. The query has two filter parameters fed from two unbound boxes on the main form (date and name). Their purpose is to filter records on the query to just show those for one person on one day. It also calculates a duration based on a start and end time. The query results are ok.
I can't get the query to display properly in the subform.
Subform Properties/data/source object is set to the query name. I'm told i have to link the master fields and child fields but when I try I get the error 'can't build a link between unbound forms'. I thought all that was necessary to bind forms was for there to be a common field between the form and query? Both contain fields from the main table including date, name, start time and end time etc.
I am using a form with command buttons to allow an administrator with limited Access knowledge to update certain tables. This is usually done by opening a form that is linked to the table and allow for changes. For one particular table, I would like the Administrator to be able to make the changes directly in the table. I would like for them to access the table with a command button. Here is the code I am using to update the table through the form. How do I need to change it to open the table and not the form. I tried changing the DoCmd to OpenTable and changed the stDocName to "tblStaff" but I received a compile error.
Your help is appreciated.
Private Sub cmdPermission_Click() On Error GoTo Err_cmdPermission_Click
Dim stDocName As String Dim stLinkCriteria As String
I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.
Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table
I hope I can explain this: I have a database with a table "Itinerary" it has two fields "Date of Visit" and "Agency Number" I have a second table that is linked from a different database "Agent Info"
I created a form based on the "Itinerary" Table then I put in a sub form to show the "Agent Name" and "Market Rep" from the "Agent Info" table.
The relationship is on Agent number in both tables. The user then adds the agent number on the form and the Agent name and Market rep automatically come in.
The problem is the user wants to be able to occasionally modify the info in the Agent Name and Market Rep fields. But does not want the new info to be changed on the original "Agent Info" table.
What I am trying to do is create a data entry form to an "order table" using 2 cascading combo boxes. I have created a data entry form based on a query. I can't get the cascading combo boxes to work properly.Here is the code:
Private Sub Combo0_AfterUpdate() Combo2.RowSource = "SELECT L2_ID,L4_Element_name,L5_Category FROM qry_ord WHERE L3_ID = Combo0.Value;" Combo2.DefaultValue = [Combo2].[ItemData](0) Command4.SetFocus End Sub
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'm creating an application and I want the users to be able to view a table and filter it, however; they won't be able to edit it. Like I said, seems simple enough, but since I'm new to Access I'm not sure how to approach this.
I have a table which is linked to a form which has been working fine for over a year now but yesterday the table "locked" for editing. I can now only copy data from the table. The editing functions delete, cut, new etc are not working, we can still filter the data.If we enter data on the form it creates a new line on the table but we cannot edit directly from the table.
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?
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.
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
