Forms :: Displaying Multiple Values In A Textbox?

Jul 30, 2013

I am designing a book collection database where each book can contain multiple authors. I used three tables; tblBooks, tblAuthors, tblBookAuthorJOIN. The tblBookAuthorJOIN allows me to create a subform with drop down combo boxes in the Books form linking multiple authors to each books indexed field. The Author table contains the usual FirstName, LastName, MiddleName fields. I would to be able to display the names of each author in the forms header but I am having difficulty.

For example a book may have two authors such as:

Authors table would contain values such as

Last Name: Grisham
First Name: John

Last Name: Twain
First Name: Mark

Textbox in header would display: John Grisham; Mark Twain

The authors would be displayed in the following format in the same order as listed in the subform datasheet.

Attached is a graphic of the form.

View Replies


ADVERTISEMENT

Forms :: Multiple Column Combo Box - Displaying Values?

Mar 4, 2015

I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly.

1 - Can I display the values from both columns after the selection has been made?

2 - If not, can I choose to display the second column (not the first) after the user has made a selection?

View 3 Replies View Related

Forms :: Change ComboBox Drop Down Menu From Displaying Checkboxes For Multiple Values

Oct 14, 2013

I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.

I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).

I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.

I use a very standard SELECT statement to pull the data for the combo box:

SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName

View 7 Replies View Related

Forms :: DLookup Show Results Values In Textbox On Its Own Line Multiple Columns

Mar 26, 2014

Access 2010 - I would like to use DLookup to show results values from a table and display in a unbound textbox on a form. the results from each column in the table need to be on seperate lines, a break if you may. Here is the code I have so far.

Code: txtKeywords = DLookup("colKeyword", "tblKEYWORDS", "cboCategory = '" & txtcategories & "'")

In colKeyword Column In tblKEYWORDS table match what i select in cboCategory Combo drop down box and populate txtcategories textbox on form

What I would like to do is show All colKeyword results in textbox [txtcategories] and display each result on its own line!

example

entry1
entry2
entry3
entry4

View 7 Replies View Related

Modules & VBA :: Parsing Multiple Values From A Textbox

Jun 5, 2014

I have a form in which the user has the privilege to download some data from the table.the user will paste some of the numbers to the textbox from the excel in order to download the specific data.i need to write a query to parse the textbox using the in condition

View 12 Replies View Related

General :: Multiple Values From Listbox In Textbox On A Report

Jan 17, 2015

Basically what I have is a form where a user has a drop down combo box that he can pick more than one value.

I then want to take what he has inputted e.g. Option1, Option2 and put that on a report in an unbound text box with another field value.

For example
=[Field1] & "/" & Option1/Option2

Those forward slashes are quite important as well, so any solution would need to include those.

View 2 Replies View Related

Query A Table Using Multiple Values In Textbox On A Form - Not Working

Aug 7, 2013

I have a database in Microsoft access 2010. The database has a table that stores prospective customer records, and a form that is used to input a search criteria(s) via textboxes, which then queries prospective customers table and returns the records that contain the inputted search criteria(s).

An Example of Textboxes values on the search criteria form:
Textbox - name: bob
Textbox - address: Left blank
Textbox - category: car,boat,truck

I Have tried creating a query with the following

field: name
criteria: like “*” & name & “*”
field: address
criteria: like “*” & address & “*”
field: category
criteria: like “*” & category & “*”

SQL code:
SELECT customerName ,address,category
FROM prospectiveCustomers
WHERE customerName LIKE “*” & name & “*” AND address LIKE “*” & address& “*” AND category LIKE “*” & category& “*”;

That works, but only for one value in a textbox. Once there is more than one value in a textbox (e.g name: bob,smith), the query returns no records.

I have also tried splitting the values using the comma as a delimmter, then inserting the values into a new table. That is fine until one of the search criteria textboxes has been left blank. So the query I created will run, but returns no records.

SQL CODE:
SELECT prospectiveCustomers.name, prospectiveCustomers.address,prospectiveCustomers. category
FROM prospectiveCustomers, [SearchCriteria-name], [SearchCriteria-address],[SearchCriteria-category]
WHERE prospectiveCustomers.name Like [SearchCriteria-name].name AND prospectiveCustomers.address LIKE [SearchCriteria-address].address AND prospectiveCustomers.category LIKE [SearchCriteria-address].category;

View 2 Replies View Related

Forms :: How To Clear Values In Each Textbox

Mar 3, 2014

Code:
Private Sub Check253_AfterUpdate()
Me.Text255 = Environ("UserName")
If Me.Check253 = -1 Then
Me.Text254 = DLookup("[Lot]", "[tblAutoGen]", "[Inuse] = -1")
Me.Text256 = DLookup("[Exp]", "[tblAutoGen]", "[Inuse] = -1")
Me.Text258 = DLookup("[Lot]", "[tblEthanol]", "[Inuse] = -1")
Me.Text260 = DLookup("[Exp]", "[tblEthanol]", "[Inuse] = -1")
Me.Text262 = DLookup("[Lot]", "[tblDPBS]", "[Inuse] = -1")
Me.Text264 = DLookup("[Exp]", "[tblDPBS]", "[Inuse] = -1")
Me.Text266 = DLookup("[Lot]", "[tblTE]", "[Inuse] = -1")
Me.Text268 = DLookup("[Exp]", "[tblTE]", "[Inuse] = -1")
Me.Text259.Value = Date
End If
End Sub

How do I clear the values in each textbox if check253 = 0 rather then going to each and clearing them?

View 2 Replies View Related

Forms :: Multiple Records From Query Not Displaying On Form

Nov 18, 2013

I have a form that a user will use to search records. Upon selecting a record, there are three buttons that allows the user to look at more detailed information. This information will be on the many side of the relationship. So I will have multiple values. The called form is just a popup form that I use for several other instances, like displaying memo fields from other tables.

The problem I am having is that only one record shows up at a time on the called form. I have read through the postings and have changed the properties for Default View, Filter on Load, Data Entry, etc. Nothing seems to change the outcome. I have run the query in SQL view and have no issues. It returns the correct records and multiple rows when expecting. Why they don't show up on the form. There are no errors, just the first record from the many side of the relationship shows up in the form. I would like all records to show up, just like when I run the query.

Code:

SELECT Capability
FROM Process_Meetings_Capabilities, Process_Meetings
WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID
AND Process_Meetings_Capabilities.Meeting_ID = 2;

Button Code

Code:
Private Sub Capabilities_btn_Click()
strSQL = "SELECT Capability AS Results"
strSQL = strSQL & " FROM Process_Meetings_Capabilities, Process_Meetings"
strSQL = strSQL & " WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID"
strSQL = strSQL & " AND Process_Meetings_Capabilities.Meeting_ID = " & Me!Meeting_cmbo.Column(0)

[Code] .....

View 6 Replies View Related

Forms :: Displaying One Field In Combobox In Multiple Columns

Jul 17, 2013

I have a multiple select combobox which shows up in many forms- SubCategories. The user can pick from a list of 154 SubCategories.

Everything is working properly however it is difficult for the user to scroll through the entire list.

My question: Is there a way to represent this ONE field in multiple columns in the combobox?

I know how to add columns for multiple fields to my combobox, but this is one field.

Maybe there is a better way to represent the data... a subform would have the same issue.

View 6 Replies View Related

Forms :: Comma Separated Values On Form Textbox Into Table?

Mar 22, 2013

If I have a text box (Text1) on my form with comma separated values entered i.e. 100,120,250,300 what would be the easiest way to enter these into a table column with a button click event. I would like to enter these values into my table tb_test under column Values.

View 7 Replies View Related

Forms :: Pulling Top Values Randomly Depending On Value Entered Into Textbox

Dec 8, 2014

I have a textbox & button that when entered & pushed - run a query for the top values randomly depending on the value entered into the textbox.

My code is...

strSQL = "SELECT TOP " & Me.Text140.Value & " [CAN - NAME].Name, [CAN - CPT/VOUCHER].Voucher_Number, " & _
"[CAN - CPT/VOUCHER].Procedure_Code, [CAN - CPT/VOUCHER].Service_Date_From, [CAN - CPT/VOUCHER].Patient_ID, [CAN - CPT/VOUCHER].service_id, Rnd([service_id]) AS RandomNum " & _
"FROM [CAN - CPT/VOUCHER], [CAN - NAME] WHERE [CAN - CPT/VOUCHER].Service_Date_From Between " & Me.StartDate.Value & " And " & Me.EndDate.Value & " ORDER BY Rnd([service_id]) DESC "

It runs like it should but doesn't populate any records...that is until I go into the design view, deselect one of the fields and then reselect the same one - only then does it populate.

Do I need to open the query first and then update/append instead?

View 5 Replies View Related

Displaying Calculated Value In A Textbox

Feb 2, 2006

Hi,

I have a form with a textbox and I want to fill that text box with the calculations from values of other text boxes. However when I put the equation
= Sum (box1 + box2 + box3) into the textbox's control source I don't get any results even though box1, box2 and box3 have values in there.
I also need the result to be saved in a field on my table, but I got no idea how to do it.

Please help!

Thank you
dfuas

View 2 Replies View Related

Forms :: Populate Textbox After MULTIPLE Combobox Selection

Apr 1, 2013

Got a bit stuck in a database. 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)

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)

Combo4 is based on following query:
-column1
Insurance
Total=Group by
Show=yes
-column2
Job
Total=Where
show=no
Criteria [forms]![name].[combo]

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.

If I do this, 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

Displaying Query Results In A Textbox

May 8, 2013

I currently have a search form that when criteria is entered it then opens up a query with matching results. What i would like to have it do is have a macro that runs the query so that it gathers the results and then displays the results into a form with a textbox called search results.

View 2 Replies View Related

Reports :: Report In Which A Textbox Generates Numerical Values And Letter Values

Aug 6, 2014

I have a report in which a textbox generates numerical values and letter values. I want to...On report load - if textbox = numbers then hide otherwise show if it contains letter values.

View 9 Replies View Related

Queries :: Displaying Query Result In Textbox On Form

May 19, 2013

Have a query which looks up an address using the text input into a textbox by the user.

What I'm now struggling with is getting the query result into the textbox.

Am still new to access and am hoping this is something fairly simple.

View 2 Replies View Related

Modules & VBA :: Displaying Count In Unbound Textbox On A Form

Mar 10, 2014

I have a form, which is bound to a table, with an unbound textbox.

I am trying to get the number of months an employee has/had worked.

In the table are two dates, Company Start Date, and Resignation Date.

There are three scenarios in which I need to calculate the months:No Resignation Date

A Resignation Date in the future
A Resignation Date in the Past

See attached PDF

The Employees are under a one-year contract which ends the day before the one-year anniversary.

I originally tried using DateDiff in the Control Source, but the IIF seamed too limited for my needs.

Code:

If [Resignation Date] = "" Then
If Month([Nichii Gakkan Start]) = Month(Date) Then
If Day([Nichii Gakkan Start]) < Day(Date) Then
MIS = DateDiff("m", [Nichii Gakkan Start], Date) - 1

[Code] ....

MIS = The name of the textbox in question.

View 6 Replies View Related

Error 2448 - Displaying Data From One Form On Another Using Textbox

Aug 25, 2015

I'm simply trying to display the data from an open form named frmEventInput fields: [EventName] and [Description] on a new form that includes 2 text boxes with the control sources and names: [txtEventName] and [txtDescription]

It says Error 2448, You can't assign a value to this object!

Private Sub Form_Load()
Dim LResponse As Integer
LResponse = MsgBox("Do you wish to open 'Event Participant Registration Form'?", vbYesNo, "Continue")
If LResponse = vbYes Then
DoCmd.GoToRecord , , acNewRec

[Code] ....

View 1 Replies View Related

General :: Textbox Displaying Result Of Sum Function In Scientific Notation

Apr 3, 2014

I am maintaining an Access 2003 application that is running on Windows 7 64Bit Enterprise OS setup.

I have a form in the application that displays a number of records with each record having a unique id and a field called ClockHrs which is stored as a Number (Long Integer) type.

I have a textbox that displays the sum of the ClockHrs field.

The textbox contains no code behind.

The Control source property of the textbox is set to '= SUM([ClockHrs])'

ClockHrs
10
10
30
15
10
15
25
===
115

The textbox displays the result of the sum 115 in scientific notation as 1.15 +02 .

View 3 Replies View Related

Checking Values Of Textbox With Table Values

Sep 15, 2005

There is a text box in a form that user can enter the value.
How can I check if the value entered by user is already existed in the record of the linked table or not?
If the value (or record) do not exist, that new value/record will be added to
the table.
If the value do exist, just show the msgbox to indicate.

How can I do that ? :confused:

Thanks

View 1 Replies View Related

Forms :: Storing Multiple Values

Apr 29, 2014

In my database (attached), I need to be able to store multiple notes for tasks performed in various cities -- each note has a small description (more on that at the bottom of this post). For the "San Antonio, TX" task, notes "Heartbleed" and "BAT Scan" apply. From what I understand, this is a many-to-many relationship which will require the use of a junction box. My structure is like this:

tbTasks
TaskID (PK - autonumber)
Task

tbNotes
NotesID (PK - autonumber)
Notes
Details

jcttbTaskNotes
TaskID (FK from tbTasks)
NotesID ( FK from tbNotes)

My mainform (fmTasks) is based off the tbTasks table; my subform (subfmTaskNotes -- continous form) is based off the jcttbTaskNotes junction table. The Master/Child link for the subform control is TaskID. In the subform I have a combo box bound to the NotesID field in the junction table that allows me to choose a note.

My problem: I also have a "Details" text box in the subform that I want to be populated with the description of the Note selected in the combobox mentioned above. For example: if I choose the "Heartbleed" note, then I want that "Details" field to be populated with "Mitigate vulnerability associated with CVE-2014-0160". I assume it has to be somehow tied to the "Details" field of the tbNotes table, but how to implement that. How do I get the Details text box to display the details for each note?

View 1 Replies View Related

Forms :: Multiple Default Values In ComboBox?

Aug 21, 2014

how I can set multiple default values in a ComboBox in a form. The ComboBox is based on a table and my main table also uses the ComboBox.

Example:

Main table has a column "Brands". The ComboBox is based on another table which includes the following items (and thus the ComboBox also shows them):

- CocaCola
- Fanta
- Sprite

The form has the same ComboBox which is linked to the main table.

Now, if a user creates a new form entry, all ComboBox items should be preselected (checked). It does work with one item over the standard "Default" property.

View 4 Replies View Related

Forms :: Multiple Values For Drop Down Boxes

Feb 19, 2014

I have created a database that has both English and French forms feeding information into the same table. I'm not concerned if the info stored in the table is stored in French or in English. It all works fine other then the drop down boxes in the forms, here I only seem to be able to either have the English or the French options visible on both the English and the French form. Is there a way to have the English options on the English form and the French options on the French form, both feeding the results into the same field in the table.

View 8 Replies View Related

Forms :: Count Multiple Values In Subform

Feb 4, 2014

I have a form and subform. I need to -

1) show the number of records in the subform on the main form
2) count the number of records in the subform where a value [Public] is True
3) count the number of records in the subform where another value [Analyst] is True.

I can achieve the first two by using the following VBA on the Main form current event -

Quote:

Private Sub Form_Current()
Dim rst As DAO.Recordset
Dim lngCount As Long

[Code]....

when i try to get number 3 done I get the same value as for [Public] (using lngCount for both...not surprising really!)

how i can get a count done for [Analyst] = True in the same event?

View 3 Replies View Related

Forms :: Using Ctrl Key To Select Multiple Values?

Jul 15, 2013

I have created a form that contains data from two tables. Each drop down on the form, for each table, contains multipl values. I want to be able to make multiple selections from each down (usually this is holding down the ctrl key and making multiple selections). However; this method does not work in Access. Is there a way to select multiple values at one time in Access similar to holding down the ctrl key?

View 2 Replies View Related







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