Adding A New Record
May 1, 2008
heya
I'll start with the general question ... I am using code to grab a file name from a local drive and waat to create a record with the detail of the file. what code will enable me to grab the file name from a loop function and stuff the value in a table. i have tried
[code] DoCmd.GoToRecord , , acNewRec
it does not add the file name store in a variable MyName in the table tblFiles in the field txtFileName i have designated nor does the code create a new record. what am I missing - is there a good reference for this?
thanks!
View Replies
ADVERTISEMENT
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
Jan 5, 2006
Hi,
I've a quick question. In Access, I have a form that allows user to add new record into a table. Is there anyway of finding whether the new record has successfully been inserted or added?
So i think it may be wise to have a message to notify us of whether it's inserted successfully or not.
Hope this explain clear
Thank you very much in advance for your help
View 1 Replies
View Related
Feb 5, 2005
Can someone please tell me why I might be adding a record everytime I open my database. I have to forms that work from querys if I open the main form all is well , if I open the other oone first and then the main form I find a record has been added. Most annoying! :(
View 1 Replies
View Related
Feb 23, 2005
This may seem basic but I need some help.
I have a table of vacinations and need to add a new record every time an animal is vacinated. I have created a form with all the fields in the table in it. But when I open it it takes me to the first record. I have had to add a button to the form to add a new record. This button then takes me to a blank form where i can input data. This is very messy and not very user friendly. Any suggestions on how i can tidy this up would be appreciated greatly.
View 3 Replies
View Related
Jun 15, 2006
I have looked on here for hours and cannot find anything, perhaps someone can help.
I have just converted from 97 to 2003 and now I cannot add new records to my forms. I have checked that the allowAddtions property is set to Yes but the New record icon and menu option is grayed out. I have looked through all the form settings and I can't see what it might be.
View 3 Replies
View Related
Oct 5, 2006
Hi,
I have a form that has a list of textboxes linked to table properties, and a subform linked to the same table. I used the command button wizard to create an add record command, but when i click on it it comes up with:
You cant go to the specified record
You may be at the end of a record set
i have checked the properties on the forms and querys and set all data entry to yes
What should i do?
Thanks for your time
,Leon
View 9 Replies
View Related
Nov 8, 2006
I have a form that has a list box with events in it. On the same form I have two combo boxes, each with the same information; officials names. I added a subform to form1 and I want this form to store and display the information that is chosen(officials and events). How do I make this happen? It seems easy, but I just can't wrap my finger around it.
View 2 Replies
View Related
Apr 11, 2005
Hi all
When adding a new record via a form, how do you make the 'new' record become a 'proper' record? I.e., add the record to the table? I know it is added when you exit that particular record on the form but I would like to update the table with the details of the new record without exiting the record on the form. I had always assumed this was done with the save command but this does not work.
Any help would be appreciated.
Many thanks.
View 3 Replies
View Related
Mar 12, 2008
What is the form event for adding of new records?
I want to make some fields disappear to prevent user input when the user enter a new record.
View 2 Replies
View Related
Sep 5, 2005
I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created.
tbl[Staff] has the following fields StaffID,Name,Team,Job Title
tbl[Absence] has the following fields StaffID, abStartDate,abEndDate,abIssue
I can set up the query to find the member of staff by name but I want to be able to use this form to add new records to the Absence table for each individual. eg I use the query to search for "Joe Bloggs" and the form shows the details from staff table and then use the form to add details to the Absence table.
Any help would be greatly appreciated
View 2 Replies
View Related
Jun 25, 2006
Hi to all!
I face the following problem: I cannot add amounts per line!
I have one table consisting of many different columns (fields), some of them having amounts. I want to update this table by doing the following:
let's say I have the following records:
1/6/2006 A 12
1/5/2006 B 20
15/6/2006 C 21
22/6/2006 D 17
25/6/2006 E 30.
I want to use a filter (e.g. the date being between 1/6/2006-30/6/2006), sort the records descending according to the amounts and then add in another field of the table A, B or C, according to whether the total amount including the specific record is above 70% of the total or above 90% of the total. In the specific example I want the following result:
25/6/2006 E 30 A
15/6/2006 C 21 A
22/6/2006 D 17 B
1/6/2006 A 12 C
Their total amount is 30+21+17+12=80 and the percentage of each record is: E:0.375 , C:0.2625 , D:0.2125 and A:0.15. Their adding percentage is
E:0.375 , E+C:0.6375 , E+C+D:0.85 and E+C+D+A:1.
How can I do that? I calculate the percentage of each record in a query, but how can I calculate their adding percentage, so that I can use an if-clause in an appending query?
Please help!!
Thanks in advance for your time
Panagiotis
View 4 Replies
View Related
Mar 4, 2005
I have two related tables - one is study information and one is person information. For each study, a person is assigned. On my form, I have a combo box to choose a person to add to a study. This works fine when the person exists already. To add a new person, I have an "add" command button that brings up a form to add a new person to the table. Problem is when I close the form, I'd have to find the person in the combo box to add them to the study. Is there a way to add a "person record" to the person table and when I return to the study form, have that new person already associated with the study? I don't allow users to edit the person info from the study form (the same person may be associated with different studies). Any ideas to help? Thank you.
View 2 Replies
View Related
Sep 5, 2005
I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created.
tbl[Staff] has the following fields StaffID,Name,Team,Job Title
tbl[Absence] has the following fields StaffID, abStartDate,abEndDate,abIssue
I can set up the query to find the member of staff by name but I want to be able to use this form to add new records to the Absence table for each individual. eg I use the query to search for "Joe Bloggs" and the form shows the details from staff table and then use the form to add details to the Absence table.
Any help would be greatly appreciated
View 2 Replies
View Related
Mar 7, 2006
Hi, I'm fairly new to access but have some vb experience. Here's my situation.
I have 1 combo box and 1 textbox. The combo box selection determines the textbox value. I made an if statment that determines what the value of the text box will be according the the combo box selection in the afterupdate of the combo box. The problem is when I want to view another record the textbox value equals whatever the last record was. So basically the combobox selection changes all the records. Like I said I am new to access and I find this odd. Any help would be greatly appreciated.Thank you
View 2 Replies
View Related
Jan 15, 2005
I'd like to create a combo box that is not limited to the list of records from a table, but allows the user to add to the table by typing into the combo box. I believe I write this code in the "after Update" event, but I'm not sure of the syntax. Can someone help?
The combo box is simply displaying the records from another table...so the code would add a record.
Thanks much!
View 7 Replies
View Related
Jun 15, 2007
am using VB to check for an id if it is a new record. i have a message that pops up.
If IsNull(Form_myform![ID].Value) Then
response = MsgBox("You have not entered your ID. Do you intend for this to be a record?", vbYesNoCancel, "id check")
but how do i get it to not enter the record into the table if no or cancel is clicked?
View 2 Replies
View Related
Dec 19, 2011
I am creating a form to add records to my database. I have created a primary key that is not autonumber. When adding a new record, I want the form to put a primary key default value of the next number in sequence. How do I do this?
View 2 Replies
View Related
Mar 13, 2013
I would like to add a value that i choose from a combo box to a table by clicking a button after selecting it from the combo box, and i do not know how to do it?
View 11 Replies
View Related
Jul 17, 2005
Hi,
Is it possible to add a new record thorough VBA (for a command button) with the AllowAdditions property set to false?
I only want new records created if this command button is pressed.
TIA!
View 8 Replies
View Related
Mar 8, 2008
Hi Guys, sorry to bother you but I'm really stumped. I've looked through some similar sounding old posts on here but they don't seem to answer my problem...
I've got a report, which is grouped, in the footer of each group a SUM label should add the contents of the pricce column, however strangely it only adds the first record of each group as a running total. I've tried both the "Over all" and "Over group" attributes of the running sum property, but they make no difference.
Any help would really save my day. Cheers!
View 11 Replies
View Related
Sep 12, 2005
Hi,
I get an error message when I add a new record to my database. It occurs when I open my form and use the [arrowright*]-button and when I use the switchboard button to add a new record using a form.
An error message is displayed, but when I dismiss the error (click OK), then everything seems to be normal and the record is added normally with the entered info. It is a bit annoying, though.
Since I have the dutch version, I'll try to translate the message:
"You can not add/append a value to this object
* The object possibly is a control-element in a read-only form
* The object is part of a form that is opened in the design view
* The value is too large for this field"
The error occurs right after I have typed the first character into a field on the form. The form consists of a few subforms. And I don't think any of the by access suggested errors have anything to do with this...
Any help is appreciated,
Thanks in advance,
MuFfiNimal
View 14 Replies
View Related
Jul 26, 2006
I have inherited a partially completed membership Access database which I
understand was originally generated from a load of linked FoxPro tables.
There is a form which uses multiple tabs, the first tab contains general
membership data (ie name, age etc) and this pulls data through from the
'Main' table in the database. Each of the other tabs includes a subform which
shows data held in a number of different tables linked to the 'Main' table
(eg, first tab - general data from 'Main table', 2nd tab - home addreses
from 'Home Address' table, 3rd tab - business addresses from 'Business
Address' table). All tables are linked to the 'Main' table through a common
'RegisterID' field. When I open the form I can query on any of the records
and amend and items of data on the various tabs them without any problem.
However if I add a new record using the >* option from the record navigation
I can add data to the first tab (ie. into the 'Main' table) but if I move to
the 2nd or 3rd tab I am unable to edit/add data to the fields on those tabs.
But if I save the record after completing the fields on the first tab and
then close the form and reopen it I can then edit the 2nd and 3rd tabs, can
you suggest how I can change the setup to allow editing/adding data to the
2nd and 3rd tabs without having to close the form and reopen it please. I
have checked the subforms and they are set to AllowEdit and there are NoLocks.
View 3 Replies
View Related
Oct 11, 2006
I have a form which allows an individual to add a cylinder record, i would like to validate the form in the sense that if the cylinder has already been added into the table it cannot be added again. So once the cylindernumber has been typed within the text field and the add button is clicked, the cylinder number typed is checked against the table if it has already been added a meesage should appear not allowing the user to enter a clyinder that is already added. I ahve tried this with the following code (the coding in red was already generated by adding a command button "add" to the form. The message i am recieving when the cylinder number in the textbox matches the cylinder number within the table is "you cant go to the specific record". I think my coding must be in the wrong order and IDEAS!!!!!
MyCode:
Private Sub Command39_Click()
On Error GoTo Err_Command39_Click
DoCmd.GoToRecord , , acNewRec
Exit_Command39_Click:
Exit Sub
Err_Command39_Click:
MsgBox Err.Description
Resume Exit_Command39_Click
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim StrSQl As String
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * From tbl_CylinderMaster Where [Cylinder Serial Number] = '" & Me![Cylinder Serial Number] & "'")
If Me![Cylinder Serial Number] = [Cylinder Serial Number] Then
MsgBox ("This Cylinder Number has already been added please add another")
End If
End Sub
View 2 Replies
View Related
Sep 24, 2004
Hi,
I have create a button for adding new record to certain table. I use docmd.runsql
to insert the new record into the table, with a autonumber ID. But the form always just display the
blank ID after clicking the button. The new record already inserted into the table, just the form
always display the blank record. How to make the form go to the newly added record? I have tried
"DoCmd.GoToRecord , , acNewRec" but failed....
Thanks!
View 6 Replies
View Related
Nov 14, 2004
Hello
I 've created a report that uses a query to show some specific records of a table. I'd like to use a text box that has a nuber for each filtered record shown.For example:
Number Name Surname Age
1 Jim Powell 27
2 John Doe 30
etc
Thank in advance
View 3 Replies
View Related
