Forms :: Adding Records Only?
Apr 3, 2014How do I configure a form so it can only add records. I don't want users to see what is currently stored in the table, just add records to it.
View Replies
ADVERTISEMENT
Adding Records In Forms
Jul 27, 2006Hopefully I have provided enough info as I have tried to keep it concise...
I am adding records to both a parent table and a child table using a form (for the parent db) and a subform (for the child db). When enterring data into the subform, I would like all previous records enterred into the subform (for a given entry in the main form) to remain visible as new records are entered (rather than simply having the view switch from one record to the next). A follow-up question would be...how do I get a unique identifier variable to increment one unit every time I add a new record into the subform, e.g.
ID var1
1 a
2 b
3 c
4 d
. .
. .
Many thanks - Zach
Forms :: Why Form Adding Records On Its Own
Apr 10, 2015I start with a table of UserIDs, names and roles (tblUserIDList). I have a simple query off that which lists them in alpha order by UserID. Next I have a simple form with a combo box which uses that query to select the User and binds the UserID field to use.
There is a button which triggers a macro which opens the 2nd form using a query which filters using that UserID. There is another point in that form in which that UserID is again used as a filter for other data. The 2nd form is a data input form. All works fine up to that point.
However, when the 2 forms are closed, for some reason the UserID is re-added to the tblUserIDList. I've never had this happen before.
Help Me With Code For Adding And Editing Records Using Forms.
Jan 29, 2006Hi,
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.
Thanx
Forms :: Adding Additional Records On Condition
Jun 29, 2013What I am trying to create is a Despatch database for our warehouse.
Records in table:
Date ()
Customer
Invoice #
Qty of parcels sent
Courier used
consignment number
In most cases we will send one invoice per consignment number (database works fine for this) But on occasion we may send multiple invoices. What I want to be able to do is have a list box to select the number of invoices, this will make available additional fields for Invoice # and Qty of parcels sent. The idea is to get away from keying in the other records for each invoice going to the same place.
Forms :: Adding New Records To A Linked Table
Sep 24, 2014Is it possible to add new records to a linked table ? i tried it out but new records is not possible, is there a workaround for this.
View 8 Replies View RelatedForms :: Unbound Form - Adding Records To Two Tables?
Apr 22, 2013i have an unbound form with the following code which works as it should
Code:
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("tbl_Courses", dbOpenDynaset)
With rst
.AddNew
rst!DateCreated = DateCreated
rst!Originator = Originator
[code]....
I also need to add other text fields from the unbound form to another table but can't seem to work out how to do it.
Forms :: Adding Records - Tabbed Subforms Not Updating
Oct 10, 2014I have a form with a tabbed area, each tab containing a subform. One of these subforms adds records to a table. Another subform shows the totals from that table.
But when I add records, the totals tab is not updated with the new quantities unless I close the form completely and go back in. I tried adding Me.Dirty = False to the subform that adds the records but that makes no difference.
It seems as though the 'totals' subform gets those values as the form is loaded and does not change, even when records are added and then that tab is selected.
How can I get the totals subform to show the updated totals?
Forms :: Listbox Multiselect - Adding Records To Junction Table
Apr 21, 2014I would like to use a listbox set to multiselect to add records to a junction table. I've been using code to accomplish this with checkboxes (love how it looks and works) but after moving my tables to Office 365 as the backend, linkedto a local frontend, sql does not like this particular set up, and I do not have the time or knowledge to sort out why. So what I need is a step by step to look at the many, in this case possible roles a contact can have, and choose one or more, which then creates a record in the junction table with the contact id and role id.
I would prefer to not use a combobox on a continuous form because every time a user goes to select roles he would have to scroll through all the choices for each separate role.
Forms :: Text Field Auto Update When Adding New Records
Jul 22, 2014I have 2 tables Master table (Jobs) containing the primary key ("Job Reference") and 2nd table (Candidates) with the foreign key ("Job Reference")
2 Forms
frmJobs Form to view job details
frmCandidates form to view Candates information
I have placed add new candidate button on the frmJobs form which opens the candidate form in the add mode as a blank form. This is fine but I'm looking to add a record where it picks up the "Job Reference" text field value from the main frmJobs and update it in the "Job Refernce" text field on the frmCandidate when I click add new candidate.
How can I achieve this? I'm fairly new to access/vba
Forms :: Adding Multiple Records To A Table Using Main Form And Not A Subform
Sep 12, 2013I have an existing Main form that has a sub form that the user uses to enter multiple records into a table....it works fine EXCEPT that I need to make it even easier and more intuitive and add a lot of labels. Basically the user selects items from a drop down list that adds items to a Work Order. I need to add some labels to the form to make it more descriptive for the user.
So, what I want to add multiple records using a single main form.
Is is possible to?:
1. simply turn the subform into a single main form? Can this be done by using a Command button or something similar?
2. copy all of the controls etc from the sub form into a new main form and have it all work nicely?
Forms :: Subforms Randomly Adding Blank Records Not Clearing Fields
Sep 18, 2013My subforms are randomly adding blank records and one subform I would like to stay blank repopulates with data, though not necessarily the most recently added record. Both of these seem to happen when I navigate to other main records in the database and then return to this page.Using Access 2013, I have a large form with 10 pages. On one of the pages, I have two subforms. This is set up to gather many-to-one data. The top subform is my data entry form with three fields (two combo and a text) and a command button. The bottom subform is a datasheet displaying the three fields.
The two combo boxes are cascading, and they work great. The text box is there to collect additional info for each selection.
The command button works to
1) save the record,
2) requery both subforms in order to display the new data on the datasheet,
3) clear the combo and text boxes, and 4) set focus back to the initial combo box. It all works!
But then when I leave that main record, the horror begins: blank records (from the "many" table) show up on the datasheet and the data entry fields do not stay blank. I suspect my problem is in the command button. I added this code to the OnClick for the command button:
Code:
Private Sub addMinistryItems_Click()
'save record
If Me.Dirty Then Me.Dirty = False
'requery both subforms
Forms![BCD MAIN 2013]!Child572.Form.Requery
Forms![BCD MAIN 2013]!Ministries1.Form.Requery
[code]....
Adding Records
Oct 10, 2005This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks
Adding New Records
Oct 28, 2005I have am building a program that requires a staff person to enter a daily activity report on employee activity. It's initiated by adding a new record
that will allow the selection of an employees name and ID number from a drop box into respective first name, last name and ID fields. The staff person would then go on to complete the daily report by adding information in several other fields.
My form is based on a relational query built from two tables; tblClient and tbldailyreport.
Any help would be appreciated.
Regards
Timber
Adding New Records
Feb 22, 2005I have set up a form which is linked to a table. When the form is opened from a menu it goes straight into a new record which is what I want.
However by using the wheel on the mouse the user is able to scroll through all records in the table.
All I want the user to do is simply add a new record and not be able to amend the old records (this is done elsewhere in the database)
how do I do this?
cheers
Adding New Records
May 5, 2005Hi,
I am having a problem with a form in that I can no longer add new records to it!
The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message when I try to add a new record, just the windows error bleep. Properties for the form are exactly as they were last time it worked properly.
I have made changes to the database since - but not to this form specifically.
Any ideas of what I might have inadvertently done?
Many thanks
Adding New Records
May 6, 2005Hi,
I am having a problem with a form in that I can no longer add new records to it!
The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message when I try to add a new record, just the windows error bleep. Properties for the form are exactly as they were last time it worked properly.
I have made changes to the database since - but not to this form specifically.
Any ideas of what I might have inadvertently done?
Many thanks
Adding Images To Records
Jul 31, 2006Hi there,
I got myself pretty much backed into a corner here. I am trying to add images to records. For example, in my database there will be certificates scanned and put on each specific record. I have been searching high and low and found that the OLE object tool will allow me to do this. However, the only method I've found was to right click right in the table and selecting add object. I'm trying to find a more userfriendly method. I was hoping someone can point me in the right direction.
Thanks in advance!
Adding Records To Table
Feb 9, 2005Hope someone can help!
I was wondering if is possible to add a series of records that are in serquence to a table by just entering the first and last numbers. For example a string of numbers starting at TP11000 and ending at TP11100, the prefix TP doesn't change. Currently I have to enter every one manually, so any help would be much appreciated!
Adding Old Records To New Database
Jun 6, 2007Hi there,
I have a bit of a dilemma here.
I have an old database, which is very comprehensive, filled with client names, addresses, and other information.
I have been given a new database, which is more relational and effectient, which splits the client addresses into a seperate table.
I need to add the old data to the new database - so is there a way of doing this whilst maintaining the links between the old addresses and the rest of the old data? What I don't want to have to do is end up going through 3000+ entries sorting out what new CompanyID I should assign...
Any thoughts?
Cheers
Hob
Adding Same Data In Different Records
Sep 10, 2007Dear All
I want a help in adding data to a table w/o writing the whole word.
e.g. if a word like " Medical " need to be repeated in many records, how can i add it w/ just typing the letter "M" and the whole word will show up? like what’s happening in ms excel.
Please help me :)
Need Help With Adding Multiple Records
Jul 5, 2005I believe this can be done with a query, but am having problems with it.
What i have is a db with a table for employee another table for training items and a third table to tie them both together. These employees are divided into several "teams" (team 1, team 2 etc ...) The training items are assigned to some or all of the teams. ( i know that this is a many to many relationship and i believe that is where i get confused ) Now the problem. What i would like to do is have a form that will allow the user to assign a new training item to teams 4, 5 and 6 and have access automatically create a record in the table. Now that the 20 or so employees that are assigned these training items will have a record that the user can simply fill in a date when the training has been completed by the employee.
I believe what i am looking for is an append query. Is that right?? Have been playing with this one for awhile and have no luck so i would appreciate any help i can get on this one
thanks again
Ricky
Adding Records With Realtions DB's...
Mar 7, 2005OK, this is the database I have so far. When a new customer is added, the user can enter up to 5 items in the tbldesweight table.
I currently have tblorder as a subform in a simple form for adding customer details. When a new record is added for the customer, it adds the same custid value into the tblorder table, but the orderid (which is set as an autonumber) dosen't get added, thus stopping the tblcust relating to data in the tbldesweight table.
Any pointers on how to get this to work?
Lewis :D
Automated Adding Of Records
Apr 6, 2005Hi All. I hope this is in the right forum.
This is an example of the sort of thing that I am trying to acheive.
I am building a database to connect rooms. i.e (Building1, Floor1, Room1) connected to (Building2, Floor2, Room2)
I have 2 forms (frmBuilding) to add building names and (frmFloor) to add floor numbers.
On the other form (frmConnect) , I have the current location (Building and Floor) and I have a subform in datasheet view. I have 2 combo box's (both with a query as the source), one to pick a building I added in frm building, and the other to pick a floor I added in frmfloor. I also have a text box, where I add the room number.
This is would like to do if possible.
Try and automate the adding of records, so, for example, if I am adding records of (Building1, Floor1, Room1), (Building1, Floor1, Room2), (Building1, Floor1, Room3) to the subform, it will ask me how many rooms I want to connect, in this case 3, and then add them, keeping the building and floor numbers the same.
(I think I am explaining this more complicated than it is, sorry!!)
Can someone point me in the right direction? I have been playing about with queries.....is this correct?
Any help is greatly appreciated.
Many Thanks.
Frank.
Adding Records To A Combo Box
May 17, 2005Hi all,
I have a data entry screen that requires the user to select a assessment type from a combo box that gets its values from a separate table. So far i have 3 Assessment types, these are Quality, Manufacturing and Technical.
If the assessment type they want is not is the combo box list. I want them to be able to type in the assessement type in the combo box and have it saved to the assessment type list so that in future it will be availible directly from the combo box.
Any ideas on how i can do this as it's giving me a head ache....
Many thanks in advance.
El Cid
Adding Records Through A Form
Aug 31, 2005I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables.
This is an attendance database with tables for each month. So when a new member of staff joins and there record is added for that particular month I would like it to be added to all subsequent tables as well. Is there a way of doing this. It would also be beneficial if a similar thing could be done for deleting staff (i.e. a staff member is deleted from one table and subsequently is removed from the other tables)
Any help with this would be greatly appreciated