Forms :: How To Save Records To A Table Of Web Database
Mar 5, 2014
I'm using Access 2010 and now trying to save a selected record to another table which I have no clue where to find the "Code Builder" to put my code on after spending hours and hours, I managed to create a form, but couldn't figure out where to save this data.
All I need is to put this line
"INSERT INTO ResultTable (StudentID, CourseID, PaidID, Comments) VALUES (" & cboStudentSelect & ", " & cboCourseSelect & ", " & cboPaymentSelect & ", " & txtComments & ") WHERE StudentID = cboStudentSelect
Perhaps, the new Access 2010 doesn't use this or something new that I couldn't it.
Attached is the file.
View Replies
ADVERTISEMENT
Jun 19, 2013
I've created a macro for saving records, but it's just over write on the previous record, what's the best way to save new records using forms?
View 2 Replies
View Related
Feb 12, 2014
So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
View 2 Replies
View Related
Feb 12, 2012
I am using Access 2003.I have created a Makle Table Query which gives me the invalid argument error because it makes the database balloon to over 2gb. I have two questions:
1. Is it possible to get the make table query to save data in one database until it reaches say 1.9 gb and then begin saving the rest of the data in another database?
2. Is there a wey to pause or stop a make table query to see the results and then let it run again?
View 4 Replies
View Related
Mar 8, 2012
I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).
View 1 Replies
View Related
Jul 22, 2013
I've been working on a database for work for the last few weeks and this forum has been a Godsend many times over, but now I have a problem that I can't find any reference to.
Using Access 2003, I have a form that uses 3 cascading combo boxes in the header to find a unique record, and a command button that brings up the rest of the record into unbound fields in the body of the form.
It works fine for finding records, but whenever I enter/change data on it, the record doesn't save. The navigation buttons at the bottom don't work - the Next/Previous record buttons are disabled, and the First/Last Record buttons do nothing.
Navigation buttons are enabled/activated in the properties.
I tried getting around this by creating a Save Record command button - first using the wizard, then using VBA code DoCmd.RunCommand acSaveRecord as advised by [missinglinq;696351], but this still doesn't save the changes.
View 4 Replies
View Related
Oct 31, 2014
I am working on a web database with a form which is bound to an underlying web table where the submissions occur.My challenge is that the fields on the form get submitted to the table even before the submit button is clicked regardless of whether the form was completely filled.
My request is that I want the form to only submit to the submission table only when the submit button is clicked.When I searched on the net, the only solutions I got are VBA written code but my web database cannot use VBA code.
VBA code:
Option Compare Database
Option Explicit
Private blnGood As Boolean
Private Sub cmdSave_Click()
blnGood = True
Call DoCmd.RunCommand(acCmdSaveRecord)
blnGood = False
End Sub
[code]....
View 1 Replies
View Related
Dec 4, 2014
How can I make certain my user enters records on a subform before attempting to save the main form? Right now they can completely ignore the subform before saving the record.The Main form has business address, etc. on it. the subform is bound to a join table that lists the multiple categories, subcategories and sector the business is listed in for a directory.
I already have my fields set to required at the table level in the join table, and have some existing VBA in both my subform (to update edited date) and my form (to validate empty records where a certain condition is met) but that's not the issue...
How do I focus the user to enter a record on the subform to the point where they are forced to enter something and complete the subform before the record is updated.
View 2 Replies
View Related
Jul 1, 2013
1. I have a Main form (based on a table) with a Subform.
2. The Subform is based on a Query
I want to save the data from the Subform (Salary Field) to my Table, I dont know if VBA will be the best option.
TABLE FIELDS:
ID*
EMPLOYEE_NOS
NAME
SALARY
MAIN FORM FIELDS:
ID*
EMPLOYEE_NOS
NAME
SUBFORM FIELDS:
EMPLOYEE_NOS
SALARY
View 2 Replies
View Related
Mar 2, 2014
I need saving 2 input fields into a table. Here is the situation
tableA
studentID
Name
tableB
studentID
Name
Course
Fee
I have a form with a drop down list, to select studentID from tableA. I selected a dropdown from studentID to display Name, and that I tied to txtName
I then type in txtCourse and txtFee whatever value I want, example:
txtCourse = English
txtFee = 50.00
Now, I'm able to transfer studentID and Name from tableA and save to tableB, and delete the record I just selected in tableA.
The issue is, I can't save the txtCourse, txtFee as I don't know how.
Here is what I have
Private Sub Insert_Click()
Dim strSQL As String
strSQL = "INSERT INTO tableB SELECT studentID, Name FROM tableA WHERE studentID = '" & txtstudentID & "'"
CurrentDb.Execute strSQL
strSQL = "DELETE FROM tableA WHERE studentID = '" & txtstudentID & "'"
CurrentDb.Execute strSQL
End Sub
I'm stuck on how to save txtCourse and txtFee into tableB where I have Course and Fee fields.
View 4 Replies
View Related
Nov 24, 2014
I have a form with a field that has formula for calculation. However, I am unable to link the field to the table since the control source is my formula.How can I that field to a table?
View 5 Replies
View Related
Oct 20, 2014
What I'm trying to do: I have created an unbound field within a subform's footer to calculate the average of the displayed record values. The subform is in datasheet view. The records are returned based on a query with a relationship between two tables. I need the calculated data (which I currently have displayed on the main form) to populate within the master table.
I can't figure out how to automatically do this. I created a simple command to get it there, but I'd like the user not to need a button to display a calculation.
Main form based on TableA; subform based on TableB.
Here's how I have it set up (Btw, I suck at SQL I just figure this is easiest to read):
Query SQL looks like this: SELECT tblB.Field1, tblB.Field2 FROM tblB.Field1 INNER JOIN tblA ON tblB.Field1 = tblA.Field1
Main form: unbound txtbox = [Forms]![frmA]![subfrmA].Form.[txtAvg]
The field that is averaged is tblB.Field2. There are potentially a bunch of records displayed in the subform.
I need that [txtAvg] field to save to TableA. My command button is simply Me.tblA.FieldName = Me.unboundtxtbox. I'd like to do away with that.
I tried to use the on current or on load event for the main form; but the calculated field value is 0 until it calculates it. It seems like there is a short delay before the value shows up on the form at which point the on current or on load events don't pick up the calculated value; just the 0 that is initially there.
View 5 Replies
View Related
Jan 28, 2015
I have a form full of cascading unbound combo boxes which allows me to assign companies and people to a project.I have a save button which writes the selected values to a table.To view the assignments when the record is later viewed I have placed a bound field behind the combo box.
View 7 Replies
View Related
Oct 4, 2013
How to let the user save a preliminary version of a record in a form? I have a table with records representing airplane status. Sometimes, the user wants to save a preliminary version of the status and create some other versions and save all of them for that specific airplane, but this does not happen for all the airplanes. How would I do that? Is it possible at all?
View 1 Replies
View Related
Dec 16, 2013
In my UpdateForm I have 3 fields. PartNumber, Description and SerialNumber. I use 2 tables for these. My MainTable and PartsList Table.
In my PartsList table I have the list of PartNumber in Column (0) and Description in column (1).
In my MainTable I have 4 fields: TransactionID (autoNumber), PartNumber(text), Description(text) and SerialNumber (text).
Now, In my UpdateForm I want the user to just select the PartNumber with a combo box (that also show the "Description" (I created this using the combo box wizard)). But I want to auto populate the field in my "Description" text box every time the user will enter new record and will also update my MainTable with all the values they entered in my UpdateForm.
I tried this codes in the after update of PartNumber combo box (properties):
Description = Partnumber.Column(1)
I tried also:
me.Description.value=me.PartNumber.column(1)
both codes unsuccessful.
View 3 Replies
View Related
Oct 17, 2014
I have a form based on query. On form i am retrieving data from another table using DLookup in a unbound text box. So I want to save the result of DLookup function in another field/table on same form.
View 8 Replies
View Related
Mar 6, 2013
how can i to save the values entered into unbound text boxes to fields in table
View 2 Replies
View Related
Jan 16, 2015
I am using Access 2010 and I currently use a command button on a form to add new records to a table using data that the user has entered into the form using the code below:
Although this is pretty self-explanatory, here is a key for reference:
Me.lstFacilities = ListBox
Me.cboMeasure = ComboBox
Me.cboYesNo = ComboBox
Me.txtTarget = TextBox
Code:
Private Sub cmdAddMet_Click()
Dim DB As DAO.Database
Dim RS As DAO.Recordset
Dim strSQL As String
Dim i As Integer
Set DB = CurrentDb
[Code] .....
This works great but I would like to be able to pull in data from another database based off of Me.lstFacilities.Column(1, i) which is the FACILITY_ID field and is located in the other database's table. I thought about adding in another string variable(strSQL1) and opening up a separate recordset and database:
Code:
Set DB1 = OpenDatabase("serverotherdb.accdb")
strSQL1 = "SELECT [FieldName] FROM [tblOtherDatabase] IN 'serverotherdb.accdb'"
Set RS1 = DB1.OpenRecordset(strSQL1)
However, I'm not sure where to start pulling in the data from the [fieldname] in the [tblOtherDatabase] when I start the loop below:
Code:
For i = 0 To lstFacilities.ListCount - 1
If lstFacilities.Selected(i) = True Then
RS.AddNew
RS!RELATIONSHIP_ID = Me.lstFacilities.Column(0, i)
RS!MEASUREMENT_PERIOD = Me.cboMeasure
[Code] .....
Is it even possible to do this?
View 10 Replies
View Related
Apr 21, 2013
I am using Access 2010 and the web database so having a bit of an issue. I have tried google but no luck really - seems complex and confusing.
Basically I have a table which has column 1 of the unique id and column 2 is the project name.
When you click the drop down on the form, I want it to show column 2 (the project name) and when you click this, on the form I want it to find that record.
View 3 Replies
View Related
May 12, 2005
Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).
Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.
Any ideas.
Thanks,
Adam.
View 3 Replies
View Related
Jan 4, 2008
Hi,
I have two possibly related things that have recently begun happening in nearly all of my databases. (Access 2002, Windows XP)
1. For years I have been using shortcut command lines like the following to open my databases:
"C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" /wrkgrp d:databasesPCAMain97sys.mdw m:pcamainpublicaccess2002frontendsvikchamaster setupwheel.mdb /excl
All of my databases use the same mdw file. Up until recently this command line has always prompted me for my login and password. Now, it doesn't. Not only that, but once I'm in the database, if I go to tools-security-workgroup adminstrator, the indication is that I am NOT joined to the PCAMain97sys.mdw workgroup that I requested.INstead I remain joined to whichever workgroup I was in before; it's like hte /wkrgrp command line option now has no effect.
2. From file-database properties, I try to change the title of the database. But I get error "..unable to save the database properties". Web search shows this is probably db corruption, but... on every one of my databases???
OK, upon reading what I just wrote, it seems likely that my mdw file is corrupted....? Any other ideas?
View 4 Replies
View Related
Feb 26, 2013
I am working on a database. I changed some of the data that was already in the database and it saved without any problems - when I reopened the database, the data was still there. But when I try to input completely new data, none of it will save (it is a database of employees and their information). So, just to make it more understandable, when I change one piece of information, it saves without any problems, but when I want to add a new employee together with their information, save it and reopen the database, it is not there.
View 4 Replies
View Related
May 25, 2011
This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch.
View 8 Replies
View Related
Jun 24, 2014
I am running access 2007 in Win7. I have a time sheet application that I wrote many years ago. Within same I have a button to press to open a new form to enter time sheet data. The data for the form comes from a query that links Employee and the Timesheet history data file.In an effort to upgrade and make the application more portable and available to multiple users, I decided to migrate the data tables to a Microsoft SQL 2012 database. Various Access reports based on the SQL database run ok. But if I try to open a form to add a new record I get the following error message:-
"Run-Time Error '2105' You can't go to the specified record."
If I debug the error it shows:-
Private Sub
Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub
In an effort to make sure the original time sheet form load worked ok on the original tables, I changed the query to feed off tables in the local Access program and have no issues. It works perfectly. Also if I open the Timesheet Query that feeds the form I can add new records.However if I change the Query to look at the same tables on the SQL database I cannot add records. I can search all records from first to last but not add a record into the query. The add record arrow is greyed out on the query results.
View 5 Replies
View Related
Apr 9, 2014
the project I have comprises four seperate databases all linked but kept apart for logic and data reasons. I must have rapidly approaching 300k records across all of them. As a result I am trying to extract on a regular basis (monthly) the dimensions of each database. Specifically, I want to be able to produce for each database;The number of tables (I have two types data and reference, it would be nice to be able to split the result).The number of fields per table.The number of records per tableI am not really interested at this point about other database objects, such as queries or reports.
View 11 Replies
View Related
Nov 21, 2006
I have made a simple form this is my first form in access 2003 and when I go to save record and close out and I open the form again the inputs that I did to the form do not save. Also It wont let me click on the new record button or anything.
Any help thanks
View 3 Replies
View Related
