I've got a table (called table1), which a select query (called qryTable1) read it and is referenced in a form (called frmTable1).
So now my form display fields of the query of the table.
On the form, below the text boxs for data entry, there is a subform that displays the entire table - table1.
I've done this so I can see some fields of the old data, that helps me to enter new ones. Hope u follow so far...
---
This where I'm stuck. When I was half way entering data in the top section of the form (ie using text boxes), if I go to the subform below to copy some values from a field, ACCESS then either adds a new or edit the record. I'm wondering if there is a way to stop ACCESS automatically doing this? I want to be able to add a record when THE add record button is depressed, and that's the only way to add record.
I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin "allow edit list items" feature of Access 2007 but the form always opens on the first record of the form on which they are to add the new item. Is there a way to specify that it should open in Data Entry view apart from using VBA?
I have a subform where records can be added or edited. There are two fields: firstname and lastname. I want a message box to appear when a first or last name is edited. I do not want that message box to appear when a new name is being added. I use this code:
[CODE]....
Now I want to also prevent the user from leaving a record before both fields have data (first and last name are required). My efforts to do this seem to conflict with my message box issues.
Can anyone see what I'm doing wrong or how to do this?
I have a form which saves to a database correctly. It has a key field name called "code".
I can recall the data into a copy of the first form to edit by using the key field "code".
All works well, however, when I click save data from the edit form it does not alter the original data but creates another form but with the same key field called code.
I have the main form open up where the Data entry is set to YES so it opens in New Field. I created a button to change the value of form's Data Entry to NO. It works. Changed the form so I can navigate through entered fields. I have created a drop down to filter a specific field "Claim#" and it will open that entry.
The drop down only works if I set the default form's Data Entry to NO. Dropdown works and I can select Claim#. But if I open the form with DataEntry set to Yes, and I click on the button to change the value to NO, the form changes but the drop down field does not pull up the proper information. The button code is.
Private Sub EditButton_Click() Form_MainForm.Form.DataEntry = False End Sub
The Claim drop down has this event after update
Private Sub ClaimSearch_AfterUpdate() Me.Requery End Sub
I'm missing something. Like I said, it works without having the button change the value.
I have a database I am using to record financial transactions. I have a transaction edit/entry form that uses combo box lists to select the different segments of my 32 digit account numbers. The issue I am running into is that when I enter a value value in the first box/field the form jumps to the very first record.I then can use the navigation buttons to get back to the last record, and all the subsequent boxes/fields work fine without jumping to a different record.
I have a table and i use as the datasource for a Subform that is arranged as (1.) column of editboxes and (2.) a column of comboboxes.Each pair of those corresponds to one record in my little table.Now i want to automatically update something when the combobox is used, but i need the entry of the corresponding edit for that.How can I get that entry ?
Is there a way to do that by addressing the editbox or should one better use the table itself ? But how can i use the table itself ? ... i do not have an index of the edited combobox or s.th..I am using VBA to try that, but maybe one can define a link between the controls in the access-properties or something ?
I have a simple data base with 2 tables. One table is the pertinent Employee data. That includes a EmployeeID that I contrived myself with the first 4 letters of the FIRST NAME and the first 3 letters of the LAST NAME.
how to make the program do that automatically when I enter the employee's first and last name.I have a form that sits overtop this table to populate the data. It's got some test date in it now c/w hand and manually calculated EmployeeID.
So now I figured out how to make the program do that calculation automatically. So why when I cruse over the records and tab through the fields and the form shows the new EmployeeID, it doesn't update the table for that field?
I am trying to create a duplicate of a certain record in a table so that the user can then edit the new record - or old record even as it doesn't matter - as long as one of them is original. The idea is that any revisions / changes are stored the user may of made.
I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)
I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.
I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.
I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.
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.
My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.
i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.
What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.
This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!
I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button. How can I do this?
I need to design a query using fields from two tables, from which I am creating an autoform for data entry purposes. I have done this before with no problem. Now though, I cannot enter data - the option for new record is greyed out. Is there something simple I am not doing? Please help!
And I have a table with those same fields: Name, Date, Description
How can I code a button to add a new row (record) from the form using the textboxes after they have been filled in?
I am familiar with the basic data entry mode, but for my purposes, it'd be best if I could do this without forcing the form to use the table as a Record Source.
Hi, need some assistance as a access beginner. First I’m not sure if I will need two related tables to do what I want (if so a brief description of how would be appreciated). I would like to create a data entry form (Material Requisition) where the body of the form contains basic information about the request (including a “Next Number” com. button, that will assign the next number using “Dmax” + 1, I think I can figure this out myself) and then have a sub-form where multiple items can be entered (requested) on the same “Requisition Number” as line items (if the line numbers will need to be identified as I’m sure they will, I would like this to happen automatically. I can/ have made basic databases with simple queries, reports and entry forms but this seems a little advanced for me right now. I would then like to generate a report grouped by the requisition number with their associated "line items". Any help or suggestions would be greatly appreciated. Thanks
My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?
I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :(
What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record.
I have Tables A and B in a 1-to-many relationship and I need to be able to bring up a blank form which has:
1. a combo box, allowing me to select the relevant record from the parent (table A), and ... 2. blank fields (from the child - table B) to fill in with new data.
I can set this up using a standard setup, where all records are shown, but this is confusing to a dumb user, who really only wants to see relevant boxes for them to fill in without the distractions of data in fields they are not concerned with or with other records they do not want to know about.
Is anyone there who can show me a db sample of unbound data entry form. I want to control the builtin auto save of Access, because sometimes I don't want to save the data of my form..
Hi Can any one help me with a quickey. I have a form which shows short details of a building ie name town postcode etc. I have another form with 3 subforms to be able to enter new details of a building, the new client and the new agreement. This works well and is feeding the new data into the correct tables. When I reopen the short detail form it doesnot display the new records. I have a short piece of vba which allows ne to see the full details of a site when I click on the site name. A quick reply would be much appreciated. Thanks ChrisD
Can I use subforms to create ONE form that will do data entry to more than 3 tables at once in a relational db? How can I do this? Do I have to use Javascript, etc?
HI How can exit from an "DataEntry=True" and "AllowAdditions=True" Form without add a new record to the table ??
Any help please!!!!! Thanks Ps: i only can do that if i press 'esc' in the 'textbox', but that doesn't suits me. the form only have a 'textbox' and a 'commandbutton'
