Forms :: Adding To Same Record With Several Forms

Feb 18, 2014

I'm creating a database that has a registration form for new employees, but depending on the skills each employee has, a separate "skills form" will open. (there's one main form and when they get to the skills part of registration the main form hides and the selected skills form opens).My problem is when the second form opens, Access adds that data onto the next line of the table, but I want it to continue adding to the record that the main form is using.

My thinking is there must be a way of retrieving the primary key from the first form and applying that to the second one, but I can't figure out how to do this even after spending most of yesterday playing with it .

My other option is to create another table just for skills and have it added straight there, but I'm not sure if that will just make more work for me later on when writing queries and such (plus I feel like that would be cheating).

View Replies


ADVERTISEMENT

Forms :: Open A Form For Adding Child Record Related To Highlighted Record In Subform

Oct 2, 2013

Is it possible to open a form to add a child record related to the highlighted record in the subform?

View 2 Replies View Related

Forms :: Adding New Record To Subform?

Jul 4, 2013

I have a form with a subform (in continuous) I have on the main form a few unbound text boxes which once im happy with the results i press a command button on mainform which adds the unbound text boxes to a new record on subform im struggling with this one. I have done similar before but that was with the unbound text boxes in header of the actual form i was adding record too.

View 3 Replies View Related

Forms :: Adding New Record To A Form

Jan 25, 2015

I am new to Access and I was trying to create database for chemical inventory handling.I have two tables. one of my tables (chemical info) has information on chemical properties. I used "Cas NO" as primary key. I have another fields such as "chemical name", 'product number" and etc.

In Second table (chemical inventory) i have "ID" field as primary key and I used lookup wizard in order to fill "Chemical Name" field. I thought it will be easy to pick up name rather than typing it because the names were complicated.After I created two forms. one form is chemicals info form based on chemical info table and other one is LAb_inventory based on chemical inventory table.

I set up Lab inventory form as main form and Chemicals info form as subform. Linking field is chemical name. So that when I chose chemical name from combo box i can see inventory data in main form and chemical properties information in subform. Now i have two problems..One of them is when I add new record to my subform I cant see this new record in main form. I suppose it is because chemicals names of each form is derived from different tables. furthermore in main form instead of chemicals name i see "my primary key CAS NO".

What i want to achieve is add new record to chemicals info form and fill up all chemical information save and in the main form to add new record choose new chemical name which i just added and fill up inventory information.

View 1 Replies View Related

Forms :: Adding New Record To A Form

Jan 25, 2015

I am new to Access and I was trying to create database for chemical inventory handling...I have two tables. one of my tables (chemical info) has information on chemical properties. I used "Cas NO" as primary key. I have another fields such as "chemical name", 'product number" and etc.

In Second table (chemical inventory) i have "ID" field as primary key and I used lookup wizard in order to fill "Chemical Name" field. I thought it will be easy to pick up name rather than typing it because the names were complicated.After I created two forms. one form is chemicals info form based on chemical info table and other one is LAb_inventory based on chemical inventory table.

I set up Lab inventory form as main form and Chemicals info form as subform. Linking field is chemical name. So that when I chose chemical name from combo box i can see inventory data in main form and chemical properties information in subform. Now i have two problems

One of them is when I add new record to my subform I cant see this new record in main form. I suppose it is because chemicals names of each form is derived from different tables. furthermore in main form instead of chemicals name i see "my primary key CAS NO". What i want to achieve is add new record to chemicals info form and fill up all chemical information save and in the main form to add new record choose new chemical name which i just added and fill up inventory information.

View 6 Replies View Related

Forms :: Adding People To A Record

May 3, 2013

I am building a database for running a shoot. I want to be able to add Firers, Beaters and Picker Ups to each day. All of those people are held in a [Contacts] form and have a checkbox to designate them as Shooters, Beaters or Picker Ups or a combination of them

I have a form where I can create the shoot date and timings etc. Now I want to add people to the form.

My idea is to have a seperate form with a list of all the Shoot Dates, on the same form will be three more lists showing Shoot Date and ID, List of all Guns, List of All Beaters, List of all Picker Ups in the Database.

You would then select the shoot date from the first list which would highlight, then go each of the other three lists and select a checkbox next to each person that you wanted to attend that day.

I know what I want to do but dont know how to do it!

I have attached a picture....

View 5 Replies View Related

General :: Adding Record Into Database Via Forms

Aug 9, 2013

I want to send out my database to a client so they can add records into it via the forms i've created, but I don't want them to be able to change the coding etc. But I also want to be able to update my database and send it back out to them but obviously the records they've entered need to remain. Do i convert it to an accde and then back to an accdb, make my changes then convert again to accde?

View 1 Replies View Related

Forms :: Adding Record To A Table From A Form

Nov 6, 2013

I have limited experience in Access, but I have managed to create a user form, where items are selected from comboboxes (Test results; when, who, outcome, etc)

At the end I have built in a command button that should add a record to an existing table, but so far no luck. I have used the following VB code for this:

Private Sub Save_test_results_KeyPress(KeyAscii As Integer)
Dim dbsICT_Test_Management As DAO.Database
Dim rstActual_test_results As DAO.Recordset
Set dbsICT_Test_Management = CurrentDb
Set rstActual_test_results = dbsICT_Test_Management.OpenRecordset("Actual_test_ results")

rstActual_test_results.AddNew
rstActual_test_results.Update
End Sub

View 6 Replies View Related

Forms :: Adding New Record To A Table With A Form

May 22, 2013

Whenever I add a new record to a table with a form I created, it records the "ID autonumber" that it's associated with instead of the text. For instance, if I selected "Kevin" from a combobox list and had the form record it, it will show up as "1" in the table under the field name "Names".

View 3 Replies View Related

Forms :: Adding New Record - Field Cannot Be Updated

Aug 31, 2013

I have a form based on a mysql table. There is a button in the footer to add a new record.

The pertinent vba code: DoCmd.GoToRecord , , acNewRec

It adds the new record and properly places the cursor in the first field. Immediately after the first letter is typed, the error message "Field cannot be updated" pops up. I can click ok and the message goes away and I am able to continue filling in the fields. The same thing happens if I add the record by use of the record selectors.

View 14 Replies View Related

Forms :: Adding Windows Username In New Record?

Nov 1, 2013

I am having a difficult time figuring out how to have a table add a new record that includes the Windows username of the user that clicks the button on my form. The function is in place that pulls the Windows username:

Code:
Public Function getWinUser() As String
getWinUser = Environ("UserName")
End Function

I then call the function during the button click by simply adding getWinUser. Unfortunately, all that occurs is that the same record gets updated instead of creating a new record.

View 14 Replies View Related

Forms :: Adding New Record Using Popup Form?

Oct 25, 2013

I'm working on a database that has a subform which pulls its data from a table and I'm trying to use a popup form to enter the data in the sub form. For example the table is called student debts. The form is called student debt. The pop up form is called student debt entry from. I want the inform that's in the student debt entry form to be recorded in the student debt form which is a subform on the main form. I know i have to create a add new records button to do it but not sure of the code.

View 4 Replies View Related

Forms :: Automatic Population Of Field In Adding A New Record

Aug 1, 2013

how to automatically populate a certain field. To add some context, I have a form which registers the details of a contact with standard information of contact details. There is a subform which shows the different products that the client from the main form is interested in. This is a actually a data sheet which returns the results of a query (selecting from the relevant table the client in question and the products he/she wants).

I have added a button which opens up another form and allows a product (and hence a new record) to be added for that particular client. I would like that the form automatically populates one of the fields in the form that is the client id. Given that the subform is opened from a form which already identifies the client, how do I do this?

View 14 Replies View Related

Forms :: Runtime Error When Adding A New Record From A Subform?

May 12, 2014

I have a main form with several subforms in tabs. From one of the subforms I list linked records to the main form (Clients) within that subform (Bank account details). I list the records and have a button to add new records.

Where the Client has one or more records in the subform the add button works perfectly.

When the subform has no records the add new records button produces the following error "Run-time error '2498' An expression you entered is the wrong data type for one of the arguments"

The add button has

Private Sub Command52_Click()
DoCmd.OpenForm "AddClientBankDetailsFrm", acNormal, , , , acFormAdd, OpenArgs:=Me!ClientId
End Sub

the "AddClientBankDetailsFrm" popup form has

Private Sub Form_Load()
If IsNull(Me.OpenArgs) = False Then
MsgBox "Form was opened with ClientID = " & Me.OpenArgs
Me!ClientId = Me.OpenArgs
Else
MsgBox "No ClientID was passed."
End If
End Sub

ClientId is the primary key of the main form and the secondary key in the new record.

View 14 Replies View Related

Forms :: Adding A Record To Table From Input Form

May 29, 2014

I have a table with 2 fields in it - Type and Pallet_Case - using a form the user enters the name of the Type and then from a combo box selects either Pallet or Case. There is a button on the form that is to save the new record to the table. (code below) The strangeness that is happening is that when the new record is added to the table, whatever is the first existing record alphabetically in the table is changed to the same Pallet_Case selection that was made for the new record.

I have a list box that displays on the form that is updated after a new record is added to show what records exist in the table (this is done by a query of the table and sorts on the type), so I can see this happening without having to open the table. It doesn't matter what sort order I put the list box in nor the table it still changes the first record alphabetically. And it is only change the Pallet-Case field. I even changed the first record to something else and it still did this.

Dim dbs As DAO.Database, strSql As String
Set dbs = CurrentDb
strSql = "Insert into [PP Type TBL] ([Prepack Type],[Pallet Case]) Values ('" & Me.Type & "','" & Me.Pallet_Case & "' )"
dbs.Execute strSql, dbFailOnError

View 5 Replies View Related

Forms :: All Fields Doesn't Clear When Adding New Record

Oct 27, 2014

Created a button through button wizard that is supposed to open a form to add a new record, but all of the fields don't clear out. Only some fields clear and other fields actually populate data from another record.

Snip1 shows my form with a record selected. When I click the 'New Waste' button, you can see that the record ID goes to '(New)', but the fields actually populate data from another record.

This even happens if I set 'Data Entry' to yes for the form.

here's the code behind my button:

Code:
Private Sub btnNewWaste_Click()
DoCmd.GoToRecord , , acNewRec
End Sub

I even commented out my code for duplicating my record just in case but that didn't make a different.

Code:

Private Sub btnDuplicateRecord_Click()
Dim ctrl As Control
For Each ctrl In Me.Form.Controls
If ctrl.Tag = "DefaultMe" Then
ctrl.DefaultValue = """" & ctrl & """"
End If

[Code]....

edit: this problem persists in a backup database that only contains one test record. The button pre-populates data that doesn't exist in the back-up database.

View 10 Replies View Related

Forms :: Prevent Adding New Record But After Period Of Date?

Dec 13, 2014

I want code with message that can prevent user to adding a new record for an employee within specific of date through a form in the Ms Access database, but after a period of date i can, For example (after two months of the last record on the main table i can add the new record, otherwise the message will popup tell the user that this employee didn't complete tow months of last adding)

View 8 Replies View Related

Forms :: Adding Sequential Alphanumeric Record To A Table?

May 18, 2015

I have an Access table with records that have a two letter, two number alphanumeric identifier (AA01, AA02 etc)

I am trying to create a form whereby, when the user types in the first two letters, the next sequential number from the table is generated.

The letters can be totally random and selected by the user, but the numbers do need to be sequential.

View 1 Replies View Related

Forms :: Error On 2nd Combo When Adding A Duplicate Record?

Jun 7, 2015

error message I am getting when I click on my Duplicate Record button (created through the wizard).

I have two combo boxes on the main form that populates data when the user makes a selection from the combo box. First combo box populates project data and the second combo box populates equipment data. The form is working well with the two combo boxes populating the data into the main table.

Now I would like to add a duplicate record button to copy a record and paste the data as a new record. So, I added a duplicate record button using the wizard and I am receiving the following AfterUpdate error.

Run-time error 3020: Update or CancelUpdate without AddNew or Edit.

This is the code I am using to copy and paste a duplicate record:

Private Sub InputForm_DupRec_Button_Click()
On Error GoTo Err_InputForm_DupRec_Click
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Exit_InputForm_DupRec_Click:
Exit Sub
Err_InputForm_DupRec_Click:
MsgBox Err.Description
Resume Exit_InputForm_DupRec_Click

It seems to be duplicating the data from the first combo box, but not the second one where it errors out.

View 1 Replies View Related

Forms :: Adding New Record Line In A Subform After Pressing Add Button

Apr 9, 2014

How can I add a new line of record below a previous record after pressing the add button? I have attached a picture of my project.

View 3 Replies View Related

Forms :: Adding Duplicate Record To A Number Of Employees At Same Time

May 8, 2014

Currently if an employee attends a mandatory training session the details are entered individually into in a single table which contains all the employees' attendances to training, this is achieved via a bound form.

Works Fine.

My question is, if the training is carried out by a number of employees can this attendance be recorded on one form and assigned to each of the employees who attended?

Using Access 2003

View 3 Replies View Related

Forms :: Adding Value Of Combobox To Hidden Column When User Enters A New Record

Aug 14, 2013

I'm very new to access so I'm not sure about the correct way to go about this. I have a table with a 'category' column, a form which hides the category column, and a combobox to filter the category, let's say R, C, and F.

What I want accomplish is to have the value of the comobox applied to the hidden 'category' column when a user enters a new record into the form.

Is there I way I can get an instance to the record as it's being entered and modify the data using VB? Or would I have to write a sort of pop() function and have it run afterInsert and then modify it that way? Can I even alter the table using VB like this?

View 4 Replies View Related

Forms :: Adding Field To A Form Breaks Entire Database Record Source?

Sep 26, 2014

I am building a database where one Form displays records from 14 different tables. For some reason, when I recently try to add a field on to a form from a new table, the ENTIRE form loses the record source, and every single field that is already on the form gets that green dot in the corner with errors surrounding a record source that cannot be found. What am I doing wrong? Am I exceeding some limitations with forms?

View 4 Replies View Related

Forms :: Access 2007 - Staying On The Same Record ID When Switching Forms?

Nov 26, 2013

Two forms have matching fields (ContractID), and each form has different data displayed from different tables (SQL views, actually).

I want Access 2007 to stay on the same ContractID when the user switches to a different form.

View 4 Replies View Related

Forms :: How To Switch To Correct Record When Switching Forms

May 7, 2013

I have a form called "Customer Details", on that form i have child forms, including one that has a schedule on.. so far everything seems fine, am able to get it to pull data correctly to the correct fields.. etc

I'm using 1 main table for all of this called "Cases"

Now the problem is, when i i click a button to print (this works so far), it opens another form and then fills in all the textbox's, however this is where i've got the problem, as it always seems to pull the data from the first record, not the record that i'm currently on..

so for example, if in the customer details, someone looks up "joe Blogs" using the navigation search and then wants to print it, by hitting the print button .. it should open another form, fill in the boxs and print "Joe Blogs", however it's always doing "Joe adams" - 1st Record

View 2 Replies View Related

Forms :: DCount In Forms To Avoid Duplicate Record

May 31, 2014

How can I prevent duplicate records from being added from a form, the dcount in the text field property, trigged before update is where this should be used is what I know but having trouble with the syntax.

I've got the table tblInvnetoryDetail with InvID(AutoNumber), and SerialNumber. The form text field is txtSerialNumber. I've managed this far with the expression

DCount([InvID],"tblinventoryDetail","[txtSerialNumber]=&"'") but this did not work.

How can I get the expression to avoid duplicates.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved