Table Stores Id Instead Of Text With Combobox

Sep 18, 2005

Hella all,

I'm new to this forum :) so I say hello to all of you :)

I have a little problem..

I have a table wich stores information wich comes from a combobox.
The problem is that it saves the combobox ID instead of the text.

This is the row source of the combobox

SELECT rapporteur.ID, rapporteur.rapporteur FROM rapporteur;

Could somebody tell me how I can store the rapporteur.rapporteur in a other table instead of the rapporteur.ID?

thx a ton in advance

View Replies


ADVERTISEMENT

Table Stores Id Instead Of Text With Combobox

Sep 18, 2005

Hi, I'm new here also. I'm afraid I can't help with your question, but I have 2 questions of my own.

1) how do you start a new thread (as you have done?)

2) in my database I have thousands of contacts. How can I add an alphabetical index tab along the right edge such as in Outlook for one-click access to different parts of the database?

Thanks and I hope you can help!

Gary

View 2 Replies View Related

Option Stores Numbers, Need Text

May 23, 2006

Hi,

I am using group options and they store a number instead of the vaules you typed in, is there anyway of making a group option that will store values and not numbers?

View 9 Replies View Related

Help With Linking Excel Into A Stores Database

Oct 9, 2006

first time poster, please be kind.
I am currently updating our supply stores database in work. When an item becomes unserviceable we need to attach a form to the item before sending it away. i would like the data entered into the 'unserviceable' table within my database to be transposed onto an excel spreadsheet (see attachment) and then automatically printed out with the data in the relevant boxes. Can anyone tell me how this is done please? My knowledge of access is rather limited and I am teaching myself as I go along.

View 1 Replies View Related

Form Stores Data When Closed??

Oct 6, 2006

I have a form which is associated with a table. When I put some values in the fields which are connected to the database and try to close the form, it gives me an error that "Can't insert record the primary key might be duplicated"...! and then it closes.

Does the form store a record in the table while closing??

If so is there a way to prevent it??
Please reply..

View 3 Replies View Related

Creating A Variable That Stores A Whole Subquery

Oct 7, 2013

Does access have WITH subquery, For example creating a variable that stores a whole subquery such as:

Code:
WITH variableTEST (a, b, c, d, e) as
(SELECT a1, a2, a3, max(ab), count(*) as nbids
FROM A x natural join B y
WHERE x.something > y.something
GROUP by a1, a2, a3)

WITH variableTWO (f, g, h, i, j, k, j) as
(SELECT A.bidder, W.a, W.b, W.c, W.d, W.e, A.something
FROM variableTEST W natural join B A
WHERE W.sprice = B.bidprice)

SELECT h FROM variableTWO WHERE now - j <7

Can it do something like this, if not what alternative do they have to do something similar? Using WITH and subquery and variable, and storing variables and then later use it again in another subquery, can it do something like this in access SQL?

View 5 Replies View Related

Option Group Stores Multiple Values

May 24, 2006

Hi,
im after a option group that stores multiple values, the only way, long winded as it will be is to create a table with all the values then have tickboxes for all of them.

Is there a simpler cleaner way?

View 1 Replies View Related

Queries :: CountIF - How Many Plans A Retail Chain Has Over Its Stores

Dec 2, 2013

I am trying to count how many plans a retail chain has over its stores.

So
WeekNo | StoreNo | Product |PlanNo
1 | 10001 | Dog | A
1 | 10001 | Cat | B
1 | 20008 | Dog | B
1 | 30005 | Dog | B

Query/report to show
Product | PlanNo A | PlanNo B
Dog | 1 | 2
Cat | 0 | 1

Numbers in Query/report are a count of Stores selling the product

One of the issues is that the data is duplicated over the weeks, I'm thinking to use max on week number so It only looks at the last available data. And how to write the query.

Currently I'm doing this
PlanA: Sum(IIf([PlanNo]="A",1,0)
PlanB: Sum(IIf([PlanNo]="B",1,0)
.
.
.

But it looks at the whole of the table for all the weeks...

View 14 Replies View Related

Combobox To Display Result In A Text Field

Apr 12, 2006

Hi All, I hope someone can help with this, I have 2 tables, 1 main table that holds all my part data ( ie part num, description, etc) and a second table with vendor info. On my Form I have all my fields that display the record. I placed a combo box on my form that I need the user to be able to select a vendor, which is working but I need the form to show the vendors part number in a field. The main table has a manufactures part number, and I have 3 fields that have my 3 vendors part numbers for that part in it. I have the combo box so that it shows the vendor name but how do I get it to look at a certain field for the vendor part number. Im still really new to Access and am clueless any help would be greatly appreciated. I know I have not explained this every well so I am attaching a sample of the DB so you can see that I have Thanks again

Thanks everyone..

View 4 Replies View Related

Text Field And Combobox Issue And Tutorials

Feb 7, 2006

What is going on, when I have a text field in a form and the control source is =[CorFullName]&""&[name] and all I get is the ID Number is that assoiciated with the name in the combo box

Properties of the text field
Text Field
Control Source =" xyz Name"

Properties of the ComboBox
ComboBox
Row Source SELECT TblCORFullName.ID, TblCORFullName.CORFullName FROM TblCORFullName ORDER BY [CORFullName];

I think I explain this correct.

I have found a great site for access tuitorials

http://www.datapigtechnologies.com/AccessMain.htm

View 2 Replies View Related

Forms :: Combobox With Restriction For Inputting Text

Nov 4, 2014

I have a question about for combobox. I have a field from my tables that a text only then I make in the look up property field to become combobox then row "source type is a value list" then,"Allow value list edits, I make it Yes". then in the form its possible for me now to add value list in the combobox. but I want that what ever I input to become a value list, that's all they can select for the value of that field. if they can type or add not listed in the value list I input, it will not possible & there's a msgbox will appear mentioning the "the value you input is not in the list..

View 2 Replies View Related

Forms :: Text ForeColor Of ComboBox Fields

Aug 27, 2013

I am working on a database project using Access 2010 and encounter some ComboBox text color problem,

The form has a ComboBox that displays the Supplier Name. The Combo's source control is Supplier ID in the Products table which joints the Supplier Table containing the Supplier Name. To display the Supplier Name only, I use a column count of 2 (for VendorID and VendorName) and column width of 0";2" so as to hide the SupplierID.

VBA is used to dynamically change the ForeColor and BackColor (via the Control Property ".ForeColor" etc) of the text in the ComboBox and TextBox. This works well for all TextBoxes and the ComboBoxes with direct data from the Products Table. However, for the ComboBox of VendorName, the BackColor can change but the ForeColor always remains as black. I have tried using the Format query such as "[White];@;[White];@" which works on the TextBox and other ComboBox (with direct field data from table), but the situation remains the same on this ComboBox which uses join-table reference via the VendorID.

View 3 Replies View Related

Filled Text Boxes Based On Combobox Choice

Oct 20, 2005

Hi
I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me.
I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields.
I have tried =DLookUp("[PropertyAddress]","tblProperty","[Property]") in the address textbox which will only bring up the first recod's address from the table, if I change the name in the combobox the address doesn't change.
What am I doing wrong, I have designing databases in Access for a total of 7 days now and have been going fairly well with some tips and code snippets from this forum but this has got me stumped.

Cheers
optidisk

View 2 Replies View Related

Pass Value From Text Box To Combobox Force AfterUpdate Event

Aug 17, 2006

Hi,
I'm new here and I thought I had already posted this but i couldn't find it so I am posting again... sorry if I've posted twice

When I pass a value from MyTextBox to MyComboBox using:

Me.MyTextBox = Me.MyComboBox


It does Not trigger the AfterUpdate Event of the ComboBox


I need it to! Any Suggestions??


I have tried: copy and pasting by but that creates a problem


Me.MyTextBox = BarCodeData$ 'passes the variable value to MyTextBox
Me.MyTextBox .SetFocus
Me.MyTextBox .SelStart = 0
Me.MyTextBox .SelLength = Len(Me.MyTextBox ) + 1
SendKeys "^c" 'copies the value of of MyTextBox


as soon as I add the below line, it no longer copies the value in
MyTextBox
Me.MyComboBox.SetFocus


The onEnter Event of MyComboBox has the following code that works fine.


Private Sub cboLookupPart_Enter()


Me.MyComboBox.SetFocus
Me.MyComboBox.SelStart = 0
Me.MyComboBox.SelLength = Len(Me.MyComboBox.Text)
SendKeys "^v"


End Sub


If I ran all the code above, all works but the "Copy" and thus anything
that may be in the clipboard is pasted into MyComboBox, and the
AfterUpDate of MyComboBox triggers.


I know that there are compelling reason NOT to use the SendKeys but I
was just trying something


What I'd really like to do is eliminate MyTextBox and pass the Variable
directly to MyComboBox:


Me.MyComboBox= BarCodeData$


And have it force the AfterUpdate Event of MyComboBox


Eagerly awaiting suggestions!


Thank you,
Robert Bloomfield

View 6 Replies View Related

Forms :: Populate Text Box After MULTIPLE Combobox Selection

Apr 1, 2013

I have a form based on a query.On the form I have 4 comboboxes.The combo boxes filter eachother without a problem (based on custom select query).Now I want after the fourth combobox value is selected, I want to populate a text field with a value from a different column from the master query (after the 4 selections only 1 value should be possible)I try to say this easy.Master query contains 5 columns:

- group
- type
- job
- insurance
- charge

combo1 selects group (and filters records)
combo2 selects type (from remaining records and filters again)
combo3 selects job (from remaining records and filters again)
combo4 selects insurance (from remaining records and filters again)

[code]....

This works great and the dropbox only shows 1 OF EACH DIFFERENT record...If I add a text box and want to see the "charge" value, that I thought I could use the ME.text-code. But in order to do this, I have to add the charge column into the query of Combo4.the dropbox for insurance gives me multiple values that are the same. Is there any way to make this work?

View 1 Replies View Related

Forms :: Unbound Text Box Not Holding Information From ComboBox?

Jul 15, 2014

In a Form I have a ComboBox set with a Control Source and Row Source.

I have several Unbound Text Boxes set to autopopulate based on the ComboBox selection.

I have two related (I think) issues:

One: Every time I open the form the Text Boxes are blank until I select an option from the Combo Box.

Two: If I make a selection in one record then move to another record, the information from the original record is still showing.

View 7 Replies View Related

General :: Can Result Of Combobox Be Used In Text In AfterUpdate Event

Sep 4, 2013

Can the result of a combo-box be used in text in an AfterUpdate event?

Example, the combo-box (Result) can be negative or positive. If it is negative a textbox is populated with the test is (combo-box here)?

View 3 Replies View Related

Forms :: Retrieve Combobox Text In Email Body Of Outlook?

Apr 26, 2015

I am trying to fetch combobox dropdown text (in the networks label ) into the email body but in vain.

Me.cmb_Network_1_data.Text is giving the RowID instead of the text inside the combobox.

Whichever networks are selected in the six dropdowns should go to email body as you can find in the attachement

Code:
Sub update()
Dim oOutlook As Outlook.Application
Dim oEmailitem As MailItem

[Code]....

View 2 Replies View Related

Forms :: Combobox Selection - Fill In ID And Name In Correct Text Boxes

Oct 19, 2013

I have a combobox on an unbound form. After making a selection, I click a command button which opens a bound form to a new record. What I need to code next or add into the macro, is for the selection of the combobox to fill in the contact id, and contact name in the correct text boxes.

The combobox row source is: SELECT qryPBS.ConID, qryPBS.PBSName FROM qryPBS; bound column 1.

View 1 Replies View Related

Modules & VBA :: Changing Combobox Text Based On Listbox Selection

Jul 26, 2013

I have a listbox with several options.

When the user selects one of these items, i want a combo box's text to be changed to the selected item in the list box.

The listbox is named : D_OutputLsb
The combobox is named : D_ComponentNameCmb

View 4 Replies View Related

Modules & VBA :: Fetch Combobox Text In Email Body Of Outlook?

Apr 25, 2015

I am trying to fetch combobox dropdown text (in the networks label ) into the email body but in vain.

Whichever networks are selected in the six dropdowns should go to email body as you can find in the attachment ...

View 1 Replies View Related

Forms :: Allow User To Enter In Text Into Combobox So That It Saves To That Record?

Aug 5, 2014

How do I allow a user the ability to enter in text into a combo-box so that it saves to that record?

View 6 Replies View Related

General :: Using Combobox Selection In IF Statement To Make Another Text Box Visible

Aug 28, 2012

I have a combobox [CBreason] that reads from a table to show me why someone is gaining access to the building.

One of the options is "Incident".

When incident is selected I want a textbox [TBIncidentNo] and a button[BIncidentDup] control I made to appear.

I thought that the code:

If Me.CBReason.Value = "Incident" Then
Me.CBIncidentNo.Visible = True
Me.BIncidentDup.Visible = True
Else
Me.CBIncidentNo.Visible = False
Me.BIncidentDup.Visible = False
End If

Placed in the after update action of the CBReason box would sufice but it doesnt work

I'm guessing the value is not recognised fro some reason but i cant work out why. There is no error message or issus, it makes the box dissapear when there is no entry but no change for selecting incident.

View 3 Replies View Related

Modules & VBA :: Exporting Query With Combobox Text Values Into Excel File

Sep 17, 2013

I a trying to search some product from a search button and two combo boxes text values ,and on serch the vba code is :

Code:

Private Sub Command4_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim varRecords As Variant

[code]...

I just dont know,the fuile is created on click of button but with headers only,dtaa is not coming but wheni debug ,in immediate window,data is oming but just not coming in excel file.

View 4 Replies View Related

General :: Lookup Combobox - Field Show Number Instead Of Text In Listbox

Jul 7, 2014

I have a field in a table where it is a lookup is a combo box. So this makes the data type of the field a number when in reality it is a text. When I have this field show in a list box it shows the number instead of the text.

View 5 Replies View Related

Forms :: Get Information From Text Box On Double Click To Populate Combobox On Another Form

Dec 8, 2014

Trying to pull information from a text box on double click to populate a combobox on another form...

keeps coming up "type mismatch"

I call lngAccount as recognised on mouseover... ("Business Account" is the value I want)

I can't get it to work!

For info, the form I'm calling from is a subform located FrmMainMenu/FrmAccountsMainMenu and the control source is [Account]

the form I wish to populate in on FrmTransactions (it is a main form only) and the combobox is cboaccountselect - **I've seen the obvious mistake with no reference to this whatsoever, corrected it, and still not working**

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved