Forms :: How To Add Description Of A Field In Form
Jul 7, 2014
I am new to Access but I worked with data and database before (but not with Access...). I am currenty trying to set up a database where multiple users will have to enter the data.
What I am struggling with is how to customize the form. I would like to make the form as easy as possible so that other users can easily enter the data. For example, how can I add the Description of the field in the form? Suppose the FieldName is Country, the Data Type numeric and the description is "List countries the study was conducted in" how can I make sure this appears in the form?I have used textbox under Form>Format but it does not seem to work: the textbox remains empty!
View Replies
ADVERTISEMENT
Aug 8, 2014
I have a split form on my database where I have my combo boxes bound to a primary key but they display the description field so it's much easier to understand. Is there a way to do this with option groups? In other words, I would like the datasheet part to display the option group labels rather than the values so it is easier to understand.
View 1 Replies
View Related
Mar 19, 2015
I have a split form, populated with my DVD movies, with the datasheet on the left. On the right I have 3 fields. Title Movie Type and Movie Description. All are enabled. But, today I was unable to select the Description field. I would click in it but the cursor would not enter to field. I needed to select another field and the then I was able to select Description. I was able to select the field programmatically. I needed to find a form from a backup and replace it.
View 12 Replies
View Related
Dec 18, 2013
Basically, some clever soul has used coded fieldnames but then added a description telling you what the field contains, and I need to return this description.
View 5 Replies
View Related
Apr 26, 2013
When editing a record in Access 2003, the status bar would show the value of each field's description from the table design grid. Is there a way to get Access 2010 to do the same?
View 1 Replies
View Related
Feb 9, 2005
I was wondering if there is a way to export the Table Design Structure:
1) Field Name
2) Data Type
3) Description
Into a Spreadsheet.
I was able to do this a long time ago, but can't seem to remember. I'm using Access 2000.
Thanks!
Joe
View 3 Replies
View Related
Oct 18, 2012
I keep getting the "Property Value is too large" when I add a description to a field in an existing table.
The same error was resolved on another table by cutting four fields then saving then pasting them back into the table and saving again.
I tried importing the entire DB into a new file, this I still get the error message "Property Value is too large" ...
View 1 Replies
View Related
May 31, 2006
Could someone please give me a link or place to find a descreption of all the "More Tools" that you can use when building a form. If I had a list I could pick what is best for my database and explain things better to management...thanks.
View 3 Replies
View Related
Jul 31, 2013
I'm trying to extract information from Err.Description within a form's Error event. Alas, Err.Description does not seem to be available from there.I have a form that normally displays in DataSheet view. If a trigger on the Oracle back-end raises an error, I want my Access app to be able to parse out Err.Description and deliver a more user-friendly message than ODBC's message. I want to get the info about the message from the error coming back from Oracle, not by matching up error codes.
If I change the form to Single-Form view and put a Save button on it, I can capture Err.Description in the command button's Clicked() event, and then parse out what I need.So if I must display this form in Datasheet view, where can I trap the ODBC error and display my user-friendly message?
View 5 Replies
View Related
Apr 2, 2008
I was contacted today by a staffing agency and was told that I looked like a good fit for a Data Analyst position. The agency and wanted some more information about my resume and wanted me to email them my references. Next step I would assume would be an interview.
I did want to post the responsibilities of the job and see if other DBAs thought it looked like entry level work. The only thing I know about the company is that they are automotive and pay is under 40K. I have been trying to break into IT for the past few months and this looks like a great opportunity. :) I appreciate your comments.
-Jon
Scope of Work:
Provide analysis support for the following: reduction of engine warranty costs, improvement of field reliability, identification of root causes, and development of new data systems. Position also monitors and reports effectiveness of actions taken.
Perform data analyses in support of problem-solving teams and management decisions, to include identification of root causes, determination of population(s) affected, failure rate estimates and projections, and estimated warranty impact.
Play a supporting role in the development of new custom-built data systems aimed at informational support of warranty analysis and reducing the time and cost of doing business.
Maintain SQL Server and Access databases of supporting information for reliability analysis to include: warranty claim information, failure modes, product improvements.
Support maintenance of custom warranty analysis software (RAS); includes troubleshooting data issues, updating information tables, and checking validity of system data.
Other Projects as assigned.
View 7 Replies
View Related
Dec 11, 2006
I have a scheduling unit that associates a number to a particular name.
In this example Break=66 and Lunch=76.
What I would like to do is setup something that will tell me "which break". Like "Break 1" and "Break 2"
Here is what I have to work with:
Emp# ID# Code StartMin Desc
6666 5555 66 870 Break
6666 5555 76 1005 Lunch
6666 5555 66 1150 Break
I tried this thinking it might designate it based on the StartMin:
Desc: IIf([Code]=66 And First([StMin]),"Break 1",IIf([Code]=66 And Last([StMin]),"Break 2","Lunch"))
However this still just shows each as "Break 1". Any ideas would be great. Thanks.
View 1 Replies
View Related
Feb 16, 2007
I am wondering if it is possible to use a wildcard in an update query. I would like to add text (the same word) to the end of the line item description where the starting text values are different.
example:
want to add Quantum
beginning value is:Trendsetter II -> new output value would be "Trendsetter II Quantum"
Lotem 800 -> Lotem 800 Quantum
8up -> 8up Quantum
View 2 Replies
View Related
Feb 10, 2005
I was wondering if it would be possible to type in a description eg.(Days, nights, O.T.,ect.) and have excell automatically insert the rate I specify into another cell.
View 1 Replies
View Related
Nov 19, 2012
I am new to access and I am trying to build an inventory management in access.
I have a table with all the inventory and has the following form:
Item ID - Description - Quantity
Item Id is used and in other tables (which are linked to basic inventory table), and I want to add and the column "description".
But I would like when I am typing item Id to autoshow the description. Is it possible?
View 2 Replies
View Related
Jul 18, 2013
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
View 10 Replies
View Related
Nov 13, 2007
Option Button Description table
I would like to create a table containing description value of my option button group.
This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6
And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552
How can I associate description with the selected options?
Many thanks,
Debbie
View 1 Replies
View Related
Jul 5, 2005
I have list box of reports in a form and when selected i want to write the reports description propterty to a textbox.
I modified an example i found posted someplace (can't recall where) and it worked great - just like this (see below).
Then I put it into another database (exact same tables, form and and queries) and if there is a description in the query property it will always give me the error "Type mismatch".
Why?
The only difference I can see is that the working example db had the following References selected:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Oject Library
... in that order.
My database where it is not working has selected:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library
Is there a better way to fetch this property?
Or is there a setting I need to change - keeping in mind that changing these settings may cause the rest of my db to fail now...
Thanks A lot for any help you can give.
Function ReportDescription(ReportName As Variant) As String
On Error GoTo Err_ReportDescription
Dim db As Database
Dim con As Container
Dim doc As Document
Dim prp As Property
Set db = CurrentDb()
Set con = db.Containers("Reports")
Set doc = con.Documents(ReportName)
Set prp = doc.Properties("description")
ReportDescription = prp.Value
Exit_ReportDescription:
Exit Function
Err_ReportDescription:
If Err.Number = 3270 Then
ReportDescription = "There is no description for this Report"
Resume Exit_ReportDescription
Else
MsgBox Err.Description
Resume Exit_ReportDescription
End If
End Function
Private Sub lstReports_Click()
Me!txtReportDesc = ReportDescription("rpt" & Me!lstReports)
'Me!txtReportDesc = ReportDescription(Me!lstReports)
End Sub
View 1 Replies
View Related
Sep 9, 2013
I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?
View 3 Replies
View Related
Jun 7, 2014
I have a form that has a combobox and a field text. If i select any value in combobox i want to update the txtBox but not with the ID of the selection. I need to get the description of the combobox selection which is essentially the Column 2.
View 3 Replies
View Related
Aug 19, 2015
I am currently stuck on set focus property. I have a main from with nested subform. I am trying to move the focus from last field of the subform to another field on the main form.
Customers(mfrm)....>Addresses(sfrm)...>Orders(sfrm Add)......>OrdDetails(sfrmOrders)
Now I have a field name [Securedesign] in frmOrderdetails and I want the tab order to navigate to field [CustomerID] in frmAddresses which is a subform to frmCustomers.
View 2 Replies
View Related
Jun 30, 2015
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
View 5 Replies
View Related
Apr 17, 2014
I have a form where I would like to validate (restrict) choices in subsequent fields.
Example
Combobox choices are Air, Fire, Water, Earth, Space
In the form I have 4 fields = Material1, Material2, Material3, Material4. (all in same record on my table)
Basically I need the validation to not allow duplicates across the 4 fields.
something like....
[Material1] <> [Material2] or [Material3]or [Material4]
I am not sure of the proper syntax for the validation field in the Form Properties. Or if I am even putting it in the right place.
View 3 Replies
View Related
Feb 5, 2014
I am creating a training database and first I have tables in relationship to the courses:
tbl_Courses
Course ID (Primary Key)
Course Title
Objectives
Instructors (lookup field allowing multiple instructors to be selected, meaning they are skilled to teach the course)
tbl_Instructors
Instructor ID (Primary Key
Last Name
First Name
Full Name (Caluclated to put Last Name, First Name)
[code]....
What I am trying to do on a form to create a new event is once the user selects the Course from the Course ID combo box, then I need the Instructor combo box to only display the instructors who are skilled to teach the course which are selected in the tbl_Courses.
I can get all Instructor ID's, but not the names and the class that has multiple instructors show on one line.Should I have not put the Instructors field in the tbl_Courses? Do I need another table for instructor skills or something?
View 1 Replies
View Related
Aug 27, 2014
What is the best way to move from the last field on the last page of a form to a new record field on the first page?
View 5 Replies
View Related
Jun 4, 2013
I am making a very simple 'registration' database for a children's event in a couple of weeks.I the table/form there is a checkbox field called 'consent' which, if checked, indicates that a child can leave the event without parental consent.
There is a report printed on each child (a registration page which the leaders get a copy of). I would like on this report a 'red box' to appear if the child cannot leave without permission (i.e. the consent box is not checked). I would also like this 'red box' to appear on the form. I had thought of doing it this way - but I'm not sure if it's the best, or if it's possible:
Have a field in my table called 'consentindicator'. When the 'consent' box is checked, there is a period ('.') placed into the 'consentindicator' field. It is set to turn red when a period is present. That way, when the consent box is checked, a get a red 'box'.
View 12 Replies
View Related
Feb 20, 2015
My combo boxes are not returning the actual combo box values back to my table, instead in the table it is displaying the combo box data list number i.e 1,2,3,1,5,1 etc where it should be displaying a property address.
View 2 Replies
View Related
