Forms :: Value List Values In Form Not Saved In Tables
Feb 11, 2015
I created a form with subforms that are all linked to their own tables. Values that are entered in to the form (i.e. just numbers or names) all save into the tables as I would expect; HOWEVER, all of my value lists (0,1,2 or 1-5) do not. I can change the values in the forms and as long as I am toggling between them they appear in the form but they are not populating the tables.
Other details. They are defined as numbers in the property table, I did change them to a value list in the form properties and did assign values to the property list.
I looked through some other threads that seemed similar but the solutions didn't apply. Because the straight up data entry saves, I feel like it is something specific to me creating those value lists...
View Replies
ADVERTISEMENT
Apr 14, 2014
So I have a combobox in a form that lists the values of a field in a table. The rowsource is this:
Code:
SELECT [Estes Training Modules].[Training Module], [Estes Training Modules].[Period] FROM [Estes Training Modules] ORDER BY [Period];
The problem is that ALL values on that field show up, including repeated values. I only need each different value to show up once. How can I do that?
For example, what I get in the combobox is: Annual, 2-Year, Annual, Annual, 2-Year, 3-Year,...
What I need is: Annual, 2-Year, 3-Year,...
View 10 Replies
View Related
Feb 5, 2015
I am not sure where this thread should be in forms or queries. I have database which has 3 linked tables by ID in each table. I have built a query on the 3 tables, then created the form.
Now when I enter data on the form and save it, when I open up the said form again , the data is not there. Yet the data is in both the table and query
If I only use 1 table, then there is no problem. The record source for the form is the query, and the query uses the 3 tables.
View 14 Replies
View Related
Dec 31, 2013
I want to validate the value of the list in the lookup in the table and create a list of the values that no match the values of the list..
View 3 Replies
View Related
Mar 20, 2008
Hi there.
I downloaded a demo database (attached, Expiry 200 ) witch allows me to distribute my databases in demo mode with the option of registering a full copy.
this works a treat so far. :)
but now i want to modify the code but i cant work out were the values in the frmsetexpiry are saved to (the registry maybe?) IE: max number of times, company name etc.
any help will be much appreciated with this
thanks
rob
View 12 Replies
View Related
Nov 2, 2007
Hi
I am trying to compare data in two different tables and list the data that does not match. Not sure if this is possible. Details below
Table 1
xyz - A1 - Do not use
ABC - A4 - Use
Table 2
123 - A1
The result of the query should show me
A4 (as this does not appear in table 2
I am not too familiar with Null values as there will be many null values that i want to ignore.
Any help will be appreciated.
View 4 Replies
View Related
Jul 26, 2005
Hi Experts,
I am beginner to Ms-access database. I want save value of A(5) - B(3) into C but, when i check the field C, i find 0 instead 2. Please advice me what i need to do to achive the exact value in field C.
Regards,
Saied
View 3 Replies
View Related
Jun 26, 2013
I am using MS Access 2010 to export data into MS Excel 2010 spreadsheets.
I am just wondering: Is there a way to set the Parameter value for the query via VBA?
For example: There are 10 regional managers. When I click a button on a form, 10 sets of data per manager are going to be exported into Excel spreadsheets.
I have created a saved query named [For exporting] with a parameter [Manager Name] for the field [Master Table].[Manager].
The VBA for the button has 2 subs:
1) Sub 1 for the loop for 10 managers
Code:
...
strQuery = "SELECT DISTINCT [Master Table].[Manager] FROM [Master Table] WHERE ((([Master Table].[Manager]) Is Not Null));"
Set rstStores = CurrentDb.OpenRecordset(strQuery)
[Code].....
View 10 Replies
View Related
Jun 19, 2015
I have split database (B/E is in the SharePoint library, F/E has users on a local PCs). Sometimes, when I update/add data (does not matter if it is via form or directly in the table) it looks OK, but when I re-open the database, the data are gone.
Problem is that I cannot catch the moment when data were not saved (sometimes data are saved, sometimes not). I can point out this: if I re-enter the missing data, primary key continues subsequently, it looks like the data have never been entered. I tried to use script
Code:
If Me.Dirty Then Me.Dirty = False
on "On Close" form event, does not work.
B/E is linked by VBA code and it looks OK (no error, Link Manager shows correct path). I suspect interrupted connetion to the SharePoint but I don't know how to check it. I implemented VBA script co keep open connection to the SP but the issue persists.
View 9 Replies
View Related
May 1, 2014
i have 4 supplier tables with identical field names but different databases in sql.I want to have them all in one table and only want the information for reference i do not want to edit any of the data.I need to create a new primary key number for the complete table. The data will need to be refreshed as the data comes from MMS Sage looking at company PLsuppliers.
I have tried a linked SQL union view- but this has no primary key.I need to keep the Primary key consistent as the data saved in other tables will use this field.The overall goal is creating a Purchase order system and this list will be my complete supplier list.
View 2 Replies
View Related
Oct 3, 2013
How can I pass two (2) values to a saved query ? These values are in a form that has a listbox with two (2) columns. The name of the form is 'Previous Evaluation Form'. I'm able to retrieve the values from both columns of the listbox in the form and I've already created the query. Both are working fine, but can figure out how to pass the query's criteria to select records for 'Name' and 'Date' columns of the query. Below is what I had in the 'Criteria:' of the query. What wrong with the code that is placed in the query's 'Criteria:' ?
Forms![Previous Evaluation Form]![Individuals].Column(0)
Forms![Previous Evaluation Form]![Individuals].Column(1)
View 3 Replies
View Related
Mar 26, 2015
I have a list in a form where the user can select multiple values. The list "Projekte" is based on the table "Projekte".
I want to be able after the user selects multiple values from the list to use them in a query to show the respectful records. For example if the user selects Project 1 and Project 2. I want to show the records where there are either Project one or Project 2. Is that possible without VB as I have no knowledge of VB.
View 1 Replies
View Related
Dec 23, 2013
A have a query that selects a multivalue field. The query forms the record source for a subform. The text values in the multivalue field are displayed in the query, but when I save this and view the data in the subform datasheet view the values revert to the primary key values. They are 1,2,3,4 instead of the text values
View 3 Replies
View Related
Aug 6, 2014
In my form's table (tblMain), I've got a lookup field (drop-down list) that lists the primary key field from a different table (tblDiff). tblDiff includes 3 more fields. In my form for tblMain, I want to include 3 more textboxes that get filled up with these 3 fields from tblDiff when the corresponding primary key is selected in the drop-down box.
View 9 Replies
View Related
Feb 11, 2014
I'm trying to set up a saved import, but keep getting the following error message: "You cannot record your changes because a value entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again"
There are a couple hundred fields, and they are all set to text. Is there a way to figure out where the problem is occurring without going through all fields?
View 5 Replies
View Related
Nov 2, 2013
I have a subform in a form that has a Combo Box that is linked (not sure is that is the correct term) to a field called PartID in a table containing a list of Parts. The list show the Name of the Part (PartName) and other fields.
This all works great except that it allows the user to change the text in the Name of the Part (PartName) field directly from the Combo Box!!!! I really don't want this to be able to happen.I have the "Limit to List = Yes" but it still allows the user to change the value...The "Allow Value List Edits = No"...
View 2 Replies
View Related
Oct 8, 2014
The user wants to be able to click a product desription in an access table, and a picture of the product pops up. is this possible and if not, what is best way to implement this functionality?
View 2 Replies
View Related
Jul 15, 2014
I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables....
How to confirm when the user clicks save that the data is actually being saved in the backend tables.
View 10 Replies
View Related
Apr 8, 2013
I have a data base with names, email IDs, phone numbers of 5 types(example quality, security, IT,finance etc) of person from ten different project teams. I created a basic form for the end user to enter values and created fields for each of the person's name, email ID etc based on the personal type( liek quality, IT, finance etc) on each team. The background table contains records of almost 200 people now.
All of these people will be trained for one task and some will be trained for multiple tasks. I know how to make the combo box allow multiple values/selections but, i cannot list out all 200 personal names in the combobox's rowsource/value list. Is it possible to combine all different name fields and list out all personal(of one team), so that the end user can just select multiple names for that team who have been trained and so on. i need to set the rowsource of the combobox to the values of all personal from one team so the team leader can just go select who has been trained and who has not.
View 1 Replies
View Related
Dec 29, 2013
I am trying to use a list-control on a form to let the user select multiple values. I have understood that this requires some VBA-code to step through the selections in the list, since the "multivalue-selection" is set to "Extended".
When I try to execute the code I have (found and have tried to adjust), then I get the error message "Object required". The "ListCount"-paramater always only results in a ZERO-value, when i step through the code:
Function cmdOpenQuery_Click()
On Error GoTo Err_cmdOpenQuery_Click
Dim MyDB As DAO.Database
Dim qdef As DAO.QueryDef
Dim i As Integer
Dim strSQL As String
[code]....
View 9 Replies
View Related
Feb 12, 2015
I am trying to create a saved export on a table i have. However i want to filter so when i do the saved export it exports the table with the filtered result only.However when i filter my table and export it and save the export. The first export comes out with the filtered results but when i go to my list of saved exports and export it again, it doesnt come filtered and its just an export of the whole table.
View 1 Replies
View Related
Sep 17, 2014
I am after creating a list box that will display some of the tables within my database - there are between 10 and 15 tables and the names all follow the same pattern (They all start "tblD10").
View 1 Replies
View Related
Aug 24, 2014
I have 2 Linked forms :
frmINVOICE
frmINSURANCE
Several of the fields in frmINVOICE are supposed to be repeated in frmINSURANCE, example Field name such as [Invoice No], [Invoice Date], [Description] etc. are identical in both forms.
My problem : After update of the fields frmINVOICE, the linked record will not update in frmINSURANCE.
I have manipulated by adding the below controls/commands to the field event and/or current form of both forms but nothing works :
- DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
- Refresh macro
- Requery
- Me.Dirty = False
Nonetheless, I noticed following outcomes :
1) if I tap between the forms twice, the field record from frmINVOICE will be updated automatically in frmINSURANCE
2) when I close and open frmINSURANCE, no change occurs
3) after I manually save frmINVOICE, then the field record from frmINVOICE will be updated in frmINSURANCE
What should I do now ?
View 4 Replies
View Related
Mar 21, 2013
I have three linked tables [Regulator], [RuleBook] and [Rules] (each has a corresponding form for data entry).
In the "Rules" form, when you select name of the regulator, the rule books dropdown down is filtered to show only the rulebooks for that regulator. the code I use is:
Private Sub Regulator_Change()
Me.[Rule Book].RowSource = "SELECT [ID],[Rule Book],[Short Code],[Regulator],[RegName],[Short Form],[Active] FROM" & _
" [RuleBook] WHERE Regulator = " & _
Me.Regulator
Me.[ShortReg] = Me.Regulator.Column(3)
End Sub
Basically, if I select the FSA as the regulator, The Rule Books drop down is filtered to only show the FSA Rule Books. If I pick OFT, I get the OFT list etc. This all works fine.
In the [RuleBook] table, each entry has a yes/no tick box called "Active".
The reason for this being that the regulators change their rule books quite regularly, but from an audit perspective, I can't delete or overwrite the old ones once they are no longer valid.
What I want to do, is further filter the rule book list to those where Active=True so that when I select FSA, I can only choose from their current rule books and not the ones that are no longer relevant.
View 7 Replies
View Related
Aug 8, 2013
I'm working on a "Product Details" form somewhat similar to form in northwind, which the record source in "Products" table. what i'm trying to do is after clicking "save and new" command button to go to new record in form, i would like all text boxes to automatically retrieve the value from last saved record set as default value.
after google searching this subject i found the LastModified Syntax but i just don't understand whether i use it in VB or marco, or even how to implicate this. Should I make macro on each txtbox or should i create module? if i have to create either macro or module.
View 5 Replies
View Related
Aug 11, 2014
I have a trouble to save data from Listbox to table. I can select mutiple data from Listbox, but the data cannot be saved on the table.
Here is the detail infor:
FORM name: Attendance
FORM record source: TBL_Attendance
Listbox Name: ARR_Result
table for Listbox to use: TBL_ARR
I want to these multiple records which come from Listbox (data on the TBL_ARR table)to be saved in table TBL_Attendance.
View 8 Replies
View Related
