General :: Combo Box Not Return Description To Table

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 Replies


Queries :: Return Description Value Relating To PO Table Value

Feb 10, 2014

I have 3 tables joined as attached and Im trying to use the PO from the PO_Detail table to display the Description from the Material_Req Table. The two values are linked as the description in the Material_Req Table is for the PO in the PO_Detail table but I just cant get the results to show this.

View 8 Replies View Related

Tables :: Combo Box - How To Get Description To Appear In The Table

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

General :: Access Object Property Description

Dec 14, 2012

I'm working on a query that lists all the queries in an Access database, and I would like the query to show the object description which is displayed when you right-click an object and display the object's properties. For queries, this is a text box just below the query name in the properties window.

So far, all I have is:

SELECT ID, Name FROM mSysObjects;

I would like to have something like:

SELECT ID, Name, Description FROM mSysObjects;

View 3 Replies View Related

General :: Access 2013 - Sort Database Window By Description?

Oct 10, 2013

Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.

Most functionality appears to be working ok...

Many of my database objects, especially queries, were given meaningful descriptions.

For example, a number of queries might have been described as "Accounts Data Validation".

When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.

However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !

Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.

Any way of sorting the database window by description in Access 2013 ?

View 3 Replies View Related

Option Button Description Table

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:
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6

And this is my table containing selected option from the form:

How can I associate description with the selected options?

Many thanks,


View 1 Replies View Related

Tables :: Using Access Table Description Attribute

Feb 18, 2013

I am using Access 2010. I have many tables that are downloaded from SAP into Access.

Within each table structure are the following standard Access attributes: Field Name Data Type Description

When I create a query I add the Field Name from the table nothing earth shattering here. But, in addition or instead of Field Name, I want to use the Description attribute. Mostly because the SAP field names are acromyms in German and are useless to the untrained eye. Please see attachment as an example.

Is there a way either using VBA or some special SQL language in any query I write to show me the Description instead of or in addition to the Field Name?

View 1 Replies View Related

Adding A Prefix To Existing Description In Project Table

Apr 17, 2012

How to add a prefix to an existing description in a project table, generated from the project number. Here's a sample of my data:

01200000 Completed Projects
01601530 Steele Sub

I would like the Descriptions to read:
01200000 MO-20 Completed Projects
01601530 MO-60 Steele Sub

The state, "MO," comes from the first two digits "01" and the coop, "60," comes from the second two digits. I have a table of a thousand or so projects in an Access database that I need to amend the descriptions of to include these prefixes. Is there a simple way to do this in Access or in Excel without writing code?

View 1 Replies View Related

Table Design - Export Field Name, Data Type & Description

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.



View 3 Replies View Related

Queries :: Reference (parent) Description In Hierarchical Data Table

Apr 30, 2015

I have a table I'm trying to query information out of. Key fields are below:

RecNo (Key)

I need to have a "record" in the query show both the description of itself, as well as it's parent. I was hoping to use Dlookup directly in the query design. If there is no other way, I suppose I could create a temp table and look through the recordset in VBA and dump them into the temp table, but like I said; quick and dirty was the hope here, it's for my own use, and the tables aren't large 50-100 records is what I'll be pulling out when I use this.

View 1 Replies View Related

General :: Combo Box Referencing One Table - Inputting Value From Different Table

Jul 11, 2013

I am trying to use a combo box to select the Company in an input record form for my Transactions. In the Transaction table, each record contains the Company ID, but not the company name (I have a relationship with a Company ID primary key in a separate table that has all the companies information).

I would like to be able to select the proper company in the combo box and have the form save the value as the Company ID number with the rest of the input data in a record (it will then refer to the correct company name in the other table if I query it because of the ID key).

View 3 Replies View Related

Combo Box To Return Records In 2nd Combo Box!

Apr 3, 2008

Hi All. I'm Sure this is simple enough, but i just cant seem to figure it out.

I want to use a Combo dropdown box with Codes FC000 - FC900. to return records in a second drop down box that begins with the Letters selected in the first dropdown box.

So When a Record is Selected in ComboBox1 eg: (FC0**), ComboBox2 brings up the record to match (FC000).

ComboBox1: ComboBox2:

I hope i have expressed what i want to do.

Any Help would be greatly appreciated.

View 9 Replies View Related

General :: Populate Combo Box From Table

Nov 9, 2013

So the information that I had to start with was






Mouse Pad

So I've created 3 tables - one for each information group arranged like so. However my problems are - I don't know how to make it so that as soon as all the info for one set of parts is filled another set automatically appears? And in the Design section of the Form I have the following error because I wasn't too sure what to use apart from a text box-

View 7 Replies View Related

General :: Delete Table From Combo Box On A Form

Mar 13, 2013

I am trying to delete the data in a table by selecting the table I want to delete the table in from a combo box on a form. This is what I am using :

Dim strFileName As Variant
strFileName = File_imported
DoCmd.DeleteObject acTable = strFileName

View 3 Replies View Related

Return All Records If Combo Box Is Null

Jul 30, 2007

I have a form that using a combo box to select specific record, sometimes we need to see all records, i would like if the combo box if left empty to return all records. I typed this expression but it returns no records when combo box is empty.


If i use this expression i get the wrong results when a Loan Officer ID is enterd;
LIke([Forms]![FrmReports]![LoanOfficer] & *
Example of wrong results, if Loan officer Id is 1, then it returns loan officers 1,11, 111

Thanks in advance for any help

View 6 Replies View Related

General :: Add New Records To A Table Depending On What Combo Box Displays

Jun 4, 2013

I need to add new records to a table depending on what the cbo box displays. I figure this is the way to do it but I it's not working, I have only writen the first select,

Private Sub Comando6_Click()
Dim dbPalavraChave As DAO.Database
Dim rstchaveCFEPC As DAO.Recordset
Set dbPalavraChave = CurrentDb
Set rstchaveCFEPC = dbPalavraChave.OpenRecordset("chaveCFEPC")


View 9 Replies View Related

General :: Combo Box To Show Name For User But Input ID To Tag Table

Jul 14, 2013

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields:

uid, uname, city, state

The combo box is pulling and displaying a drop down list of uname from the USER table, with this SQL state in the "row source".

SELECT user.uname FROM [user] ORDER BY user.uname;

In the control source of this combo box I have seller, and the form's record source is AUCTION, tagging on the AUCTION table.

The problem is the form is putting the uname into the AUCTION table's seller field, but I want it to input the uid field, however that it should still show the uname list when the user click on the combo box to make a selection.

View 2 Replies View Related

General :: Combo Box - Exclude Data Insert In Table

Oct 19, 2014

I have to combine groups to account, then when account is a group in next time, list or combobox, this group must not to be in that list. what is the solution ? SQL or VB. I append file...

View 6 Replies View Related

General :: Cascading Combo Boxes With Junction Table

Jul 5, 2013

I'm jumping to the forms development and going to try what I need via queries and SQL. I'm trying to do a series of cascading combo boxes which have worked out fine, right till I hit the first junction table.

I will include the VBA code below as well as a screenshot but here's how it goes.

REGION cascades down to COUNTRY cascades down to PORT and then to CARRIER.

This is for a shipping program.

When it gets to PORT and are trying to cascade to the various CARRIER's thats where it hits a junction table of PORT_CARRIER.


Me.cboCountry.RowSource = "SELECT COUNTRY.CNTRY_ID, COUNTRY.COUNTRY FROM COUNTRY " & _ " WHERE REG_ID = " & Nz(Me.cboRegion) & _
Me.cboCountry = Null


" WHERE CNTRY_ID = " & Nz(Me.cboCountry) & _
Me.cboPort = Null


Me.cboCarrier.RowSource = "SELECT PORT_CARR.PORT_ID, PORT_CARR.CARR_ID FROM PORT_CARR " &_ " WHERE PORT_ID = " & Nz(Me.cboPort) & _
Me.cboCarrier = Null

PORT to CARRIER is where the problem is.

It populates the combo box, but with the ID numbers instead of actual CARRIER names.

(the Junction table are two PK fields and are lookups to PORT in PORT table and CARRIER in CARRIER table.)

Is there a magic spell for cascading combo boxes when you hit a junction table?

View 14 Replies View Related

General :: Auto Populate A Table Field From Combo Selection

Jan 17, 2013

I have a Table (tblFPAData) that is being populated with entries from a form I created. There are several fields but if I can get an answer for one relationship then I can repeat it for the others.

In tblFPAData there are the fields MaterialNo and Description.

I am creating another table called tblSchedule and using a form to enter the information. I need the user to select the MaterialNo from a combo (cmbMaterialNo) and the then table auto populates the Description from tblFPAData.

View 3 Replies View Related

General :: String To Return Textbox Sum

Jun 15, 2015

I have a textbox on a subform and I want to get the sum in a string as follows.

Dim s1 As String
s1 = Sum(Forms!CountItem!CountItemLastCount.Form!ThisCount)
MsgBox s1

When I use the above I get an error message saying - Sub or function not defined and it highlights the sum part of the equation.

I have been using the sum criteria in a textbox but if the user doesn't tab of the box then it doesn't see it as being updated.

I have tried me.dirty and everything else that usually works like send keys tab event, requery form and controls, a left mouse click but nothing is working, therefore I thought that code to actually update the textbox may work.

View 8 Replies View Related

General :: Subform Keypress Of Return

Oct 7, 2013

I have a subform when a user presses Return Or Enter it doesnt go to a new record but instead enters a new line in the same records how can i prevent this from happeneing.

View 1 Replies View Related

General :: How To Return A Value Based On Another With Subforms

Mar 14, 2015

I have a form with a field within it called ID number, another table contains the ID number with a person's name next to it. I was wondering how I can make it so that in the form, when the ID number is entered, the name of the person also shows next to it and does so automatically for each different record. I am pretty sure that a subform is needed however it doesn't seem to work for me so I must be doing it wrong. How would I do this?

View 1 Replies View Related

General :: Select Syntax Return Zero

Jan 3, 2014

i have aform which class module where i make 2 queries the first works fine but the other always return values with zero my select syntax is in clsschool and the query is

strSQL = "SELECT tblgrade.Grade, tblClasses.NoOfclasses, tblClasses.NoOfSessions " & _
"FROM tblgrade INNER JOIN tblClasses ON tblgrade.IntGradeId=tblClasses.IntGradeId " & _
"WHERE tblClasses.intschoolinfoid = " & intId

View 10 Replies View Related

General :: Filter A Function Return Value?

Jun 27, 2012

I have a function which I want to return the value of a field.

Public Function fieldValue(tblName As String, fldName As String)
Dim drs As Recordset
Set db = CurrentDb
Set drs = db.OpenRecordset(tblName)
fieldValue = drs.Fields(fldName).Value
Set drs = Nothing
End Function

I need to return the value obtained, for a specified User identified with a numeric variable.What is the best way forward? - Some sort of filter or DLookup and how to code this?

View 14 Replies View Related

General :: Return Current View Of Report

May 23, 2013

if there is a VBA command that returns the current view of the current active report. I am running code the uses the SetFocus Action, which works fin in Report view, but when I try to go to Print Preview view, Access throws an error stating that the command or action is not available in the current view - and the GetFocus action is the culprit.I can skip the GetFocus action if I know the Report is in Print Preview mode.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved