Filtering With 2 Combo Boxes And Then Populating Text/memo Fields
I have two questions.
I have a form with 2 combo boxes. The first pulls from a simple list. Once you make a choice, the second combo box is then filtered by the first. This works correct, except that once a choice is made in the first, the filter is locked. If you change the first combo box's value a second time it does not effect the second box. The query that I am using for the second combo box has two columns that pull the first 50 characters of a pair of memo fields. Quote: SELECT MSSS.SS_ID, Left([Application_Name],50) AS Expr1, Left([Description],50) AS Expr2, MSSS.Site_Code
FROM MSSS
WHERE (((MSSS.Site_Code)=[Forms]![Edit or Delete Requests]![Combo6])); These fields are then used to populate 2 text fields using an event procedure. Quote: Private Sub Combo10_AfterUpdate()
' Display Partial Application Name and Description based on choice
Me!txtApplication_Name = Me!Combo10.Column(1)
Me!txtDescription = Me!Combo10.Column(2)
End Sub This is working fine, but it starts the next problem.
I need to change the form to include the entire memo field into a text box. I was using the columns of the second combo box to fill them in. Since the combo box is limited to only 50 characters, i could only grab part of it. I am guessing there is a much better way to accomplish what I need, but I am too inexperienced with forms and vb to come up with it. Below are the fields I need from table MSSS
Business_Name
Application_Name
Description
Acronym
Level_1_Support
Level_2_Support
Escalation_process
Troubleshooting
Priority
Links
Modified
Disabled
Thanks in advance to any help!
View Complete Forum Thread with Replies
Related Forum Messages:
Combo Box Populating Text Fields
Hi All Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box. I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the requirements (memo). I have put in the after update code: Private Sub CustName_AfterUpdate() Me!CustReq = Me![CustName].Column(2) End Sub Can anyone please shed light on what I'm doing wrong? Thanks
View Replies !
Populating Text Boxes
I have a list box and three text boxes on a form. the list box contains data about an individual. I want to be able to select a certai individual and populate the text boxes with info from the list box any ideas on how i go about doing this?
View Replies !
Populating Text Boxes
I have text boxes in a form displayed in a continous form with rows and columns. For ex. I populated textbox in column1, then edit some textboxes in column1. Once I go the column2 to populated textbox in column2, textbox1 is default to its orginal data, it doesn't hold the data I made changed to.
View Replies !
Populating Text Boxes
I have a text box that I'd like to update from a table like a combo box. I text box is for a order type depending on the order type there can be a sub order type. How I would like to handle this is to have the list box with the primary order types and after the user chooses a primary they can type a semicolon and are given a list of sub order types. Is this possible?
View Replies !
Filtering On Combo Boxes
I have a question about filtering on combo boxes. I was able to set up a form with 2 sub-forms, but it's more than what I need. What I want it to do, is when the user makes the selection on the first combo box, I want it to filter on that selection and then drop that into the 2nd combo box. When the user makes the selection on teh 2nd combo box, then it should filter the results to a sub-form. Any help? I have the relationships, and can get it to work when I have 1 form, and 2 sub-forms, but I really want just 1 form, with 1 subform.
View Replies !
Filtering Out Items In Combo Boxes
Need some help here.... I am designing a database to keep track of workers for a haunted house. I have a Roster table, a table of all the nights we are open, a table of Spots in the house, and a table to record who works what nights and what spot they are in. This table has a Room combo box and a Spot combo box. The Room combo has a Row Source of SELECT DISTINCT SpotsAll.Room FROM SpotsAll ORDER BY SpotsAll.Room; The Spot combo is then populated with VB code all the Spots that are in that room. That works fine. This is what I'm trying to accomplish: When a Spot is assigned to a Worker for that night, I want that spot to no longer be available in that list FOR THAT PARTICULAR NIGHT. So, lets say Joe Somebody works in Spot 1 (out of 4 lets say) of the Library Room, when we assign another person to the Library room, I don't want Spot 1 in the Spot list. Can this be done with a query or VB code? If I'm not making sense, please let me know. I can also upload the Database I am creating so that you can play around with it and see what I mean. (I have attached a word doc. that shows the table relationships.) Thanks a lot ahead of time!! ScrmingWhisprs
View Replies !
Filtering Combo Boxes Within A Form
I have a form that we are creating to issue project numbers. We have about 80 different clients. I have set up a combo box for the client name, where we can choose the client from the drop down menu. We want the form to filter according to the client name that you choose. For example, if you pick Lawrence as the client name, the next combo box is the project name and I want it to only show the project names that have been assigned to Lawrence in the past. Can someone please help me on how to do this and if it is even possible at all? Thank you so much for your help!! I have been wrestling with this for about a week and a half now.
View Replies !
Memo Fields/boxes
I have a memo field on a form that I only want 800 characters. (text fields don't seen to work). I'm looking for a piece of code that monitors the typing into a memo field and alerts the user that they are overe quota for that field when 800 characters are passed. Any ideas are appreciated.
View Replies !
Populating An Underlying Table When Using Cascading Combo Boxes In A Form
Hello everyone I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails). I am at a loss as to how to correct this as you can see from the example I need the customer and description field to be populated with the correct data rather than the fields I am using to make the cascading combo boxes work. Any help would be greatly appreciated Regards Adrian
View Replies !
Combo Boxes Filtering Or Populting Same Records
Anyone help I have 2 combo boxes cd group and cd name when I select CD group the records only associated yo that cd name display with that group. Anyway, also the name of songs form works too,. So then now when I go from record to record the records display right with the songs and not with the cd group and name when I select Mormon Tabernacle Chior and name God Bless Ammerica it disaplys for all the records any help. Why is it the relationships. Thanks, Nike Van der stad mikevds@optonline.net
View Replies !
Help Needed Filtering A Form Using Combo Boxes
Please help. My inability to achieve this is very frustrating. I have a tabular form based on a query, which returns a large number of records. I need users to be able to filter the records to display data relating to what they have entered in a number of combo boxes. For example I have fields showing Product ID, Manufacturer ID, Purchase Order number and due date. Each of these fields has a corresponding unbound combo box where users can select values that appear in the table. I need to be able to filter the form based on what is in these combo boxes. I.e. Filler for a product ID to show all purchase orders numbers and due dates relating to that product ID or filter for a manufacturer ID and due date to show all Product IDs and purchase orders relating to that a manufacturer and date. Ideally this would be achieved by pressing a command button. The query, table and combo boxes are all built and work fine but I am unable to get the filter to work, I am using Access 97 and am not very familiar with visual basic. Any help would be appreciated. Thanks.
View Replies !
Please Help. Question About Filtering On Reports With Combo Boxes, Many Linked Tables
Hello, I hope someone can help me. I am working on a Marketing Database to centralise information about our customers so that field sales can search customers that would fit a similar sales situation, by vertical market, by product sold, by competitive products etc. I have created many tables and linked them together: The main table is Customer Accounts (tblAccounts) and contains information such as: AcntID (AutoNumber) AcntName (text, Primary Key) NAMID (number), relates to Account Manager table (tblNAMs) SalesRegionID (number), relates to Sales region table (tblRegion) PartnerID (number) relates to Partner table (tblPartners) AcntCustomerSince (number) tblNAMs contains: NAMID (AutoNumber) NAMName (Text, Primary Key) tblPartners contains: PartnerID (AutoNumber) PartnerName (text, Primary Key) tblRegion contains: RegionID (AutoNumber) RegionName (text, Primary Key) Those last 3 table relate to the tblAcnt by intermediate relationships I have also the following tables: tblVendor contains: VendorID (AutoNumber) VendorName (Text) tblProducts contains: ProductID (autoNumber) ProductName (text) VendorID (Number) tblToolsBfr contains: ToolsBfrID (AutoNumber) AcntID (Number, Primary Key) VendorID (Number, Primary Key) ProductID (Number, Primary Key) tblToolsSold contains: ToolsSoldID (AutoNumber) AcntID (Number, Primary Key) VendorID (Number, Primary Key) tblToolsAftr contains: ToolsAftrID (AutoNumber) AcntID (Number, Primary Key) VendorID (Number, Primary Key) tblVendors and tblProducts are linked to tblToolsSold, tblToolsBfr, tblToolsAftr. Those last 3 tables are linked to the tblAcnt via the AcntID link I have created a report that can show all this information on one page, per account. I have also created a filter using combo boxes to allow me to drill down to Sales Region and/or Account Manager and/or Partner. I am struggling with the rest of the filter as I would like to also filter what can be found in the tblToolsBfr, tblToolsSold and tblToolsAftr but because Vendors and Products are located in two different tables, I do not know what I should put in Row Source or as an event procedure or query. Please can you help me, perhaps there is an example I could use? I really hope someone can help as I am completely stuck on this for the past 3 days. Valibal
View Replies !
Combo Selection Populating A Text Box
Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this? Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well. Any ideas? Thanks!
View Replies !
Populating A Text Box Using Combo Box Filter
Hello, This is my first time posting here and I hope someone can help me. I am not experienced with coding in access and only recently started using forms. I am trying to create a text box that automaticly fills in once a selection is made in a combo box. There are only 2 tables and 1 form I am working with. Table 1 has columns "code" and "bu". The second table has several columns, all blank, that the form fills in. The combo box is working correctly, it displays all the "code"s. Once the code is selected I would like a text box to display the "bu" column. Any suggestions are much appreciated.
View Replies !
Populating A Text Field From A Combo Box Selection.
I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column. This combo is part of an orders subform and the user is selecting a product from the list which displays the product_name and the product_id. The problem is that the product_id is not filled in and access returns the following error: Run-time error ‘3101’: The Microsoft Jet database cannot find a record in the table ‘product_table’ with key matching field(s) product_id. This is the VB code that populates the list : [code] Private Sub comboCatagory_ID_AfterUpdate() Dim sProd_description As String sProd_description = "SELECT products_table.product_id, products_table.prod_description " & _ "FROM products_table " & _ "WHERE products_table.prod_catagoryID = " & "'" & Me.comboCatagory_ID.Column(0) Me.comboProd_description.RowSource = sProd_description Me.comboProd_description.Requery End Sub [end code] What am I doing wrong? Thx Kev.
View Replies !
Populating The Text Box’s That Relate To The Chosen Combo Box’s With The Sum Of A Cal
Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation. In other words if X combo box is chosen (There are many combo boxes to choose from) populate xx text box with the sum of a calculation. Refer to the print screen example of my program: http://www.roofmart.net/Rest.asp Notice under the label felts the 15lb 36” felt combo box is chosen and it displays the value of 11 and next to the combo box is a text box that displays the value of 25 The calculation will be (11*25) = 275 this value of 275 must be added to the text box values that are being shown in the forms header under 30yr where it reads $4,606.80 and 40 yr $6002.80 only, this is because the 30yr comp and the 40 yr comp combo boxes are the only chosen roof types under the label roof types above the felt label. Hopefully this makes sense. Thanks -- Any help with be greatly appreciated.
View Replies !
Filtering On Combo Text
Aaaargh! It's a couple of years since I got my hands dirty in Access and I seem to have forgotten more than I thought! :( I have a simple database which includes tables STOPS (stopID, stop name, routeID, Cost band), JOURNEY(CustID, routeID, stopID), and ROUTES (routeID, Route name, Bus co). I have a main form with the customer number on linking to a sub-form on which the user will select the route from a combo box and then the stop from a combo box. All works fine but I want to filter the stop combo box to show only stops on the route already chosen. I've done similar before but I have tried all sorts and failed to get anything to work. Any help appreciated.
View Replies !
Combo Boxes / Text Boxes
Hi guys, I have a related databes with about 20 tables. My main table stores the data linking with most of the other tables. This main table stores football match records with player line ups. Initially I had a problem linking the 11 player fields in the main table to the player table, Icould only do it with 1, so someone at work suggested to link it using the lookup function. This worked brilliantly. However, now I am designing a GUI with forms but the forms have combo boxes where the lookup function was used and when i change these to text boxes, the players names are replaced with their ID numbers. Is there any way of creating the form without the unsightly combo boxes, as they won't be needed, the GUI will be read-only. I look forward to your help!!
View Replies !
Combo Boxes And Text Boxes
I have a table that has client names and addresses. I have designed a form to be able to invoice these clients and everything is fine however what I'd like to do is have the address of the client appear automatically. I have set the client names in a combo box and would like their address to appear in either a text box or sunken label automatically from the table. Is this possible and how do I do it. Please keep in mind that I've done basic programming so please be kind to this newbie :D
View Replies !
Memo Fields: Rich Text??
Hi all, Have been having many problems with memo fields truncating after about 512 characters. Having surfed for a while, a lot of the problem seems to stem from formatting characters residing in the memo text. For example, if you create a text box in a form, any thing you type into that box will be formatted in set size, font, etc. When you run an update query to update the memo filed in the relevant record, it appears to transfer the data from the text box, including formatiing (Rich text). Hence, when you call this info back, it is truncated because memo fields can't deal with fromatting characters. Is there anyway you can prevent a text box from being formatted? Or can you make an update query only transfer plain text? Or is there some code that I can first strip the formatting out of the rich text (converting it to plain text) and then pass the data to the table? Or is there something else I should do? Cheers, Matt
View Replies !
Using Text Files Instaed Of Memo Fields
I have a large Db Which contains A Couple of Memo fields which due to the amount of data being stored in the Memo fields is starting to show signs of slowing down.One table contains 75,000, with all memo fields above 255.I wont have a problem with adding the extra code but was wondering if there is anything that may cause me a problem or if there's any reason(s) why I shouldn't follow this path.Many ThanksMickP.S. One Option would be to create 1-1 Tables and move the memo fields into the new tables that way I would still have an easy way of serching but it would reduce the size of the main table also none of the memo fields are included in any of the querys used, the problem with speed seems to be adding data I have checked the indexs which seem OK I can't remove any indexes Otherwise it slows down searching ACT.A copy Of the DB Is available here but it is an 11Mb Download should anybody wish to take a look at the tables structure and be able to advise on any imporvments that would be great please remember it's designed to store very large amounts of data.http://chartheaven.9.forumer.com/index.php?showtopic=107best wishesmick
View Replies !
Combo Box / Fill Text Boxes
May I start by saying Hi and that im just embarking on understanding Access 2003. I do know a little about DB as I have built programs in VB6 using databases. But now onto my problem which seems a simple one. I have a Db called delivery. With columns as below. Mtno being the key. Mtno Orderno Description Quantity Customer I populate a combo box with Mtno, but on the click event of the combo box i wish to populate textboxs from the other columns. Code used. Private Sub Combo0_Click() Me!text2 = Combo0.Column(1) Me!text3 = Combo0.Column(2) End Sub text2 gets populated and updates on the click event of the combo box but text3 doesnt. Niether do the other text boxes when I put the code in. Help me understand this please. kind Regards Tony
View Replies !
I Need A Combo Box To Fill Text Boxes.
Hello I hope someone can help me on this one. This is something I am not getting an understanding on and need some help. I made a form that holds all information for our customers. I want to make the Company Name box into a combo box so when I change the Company Name in the combo box it populates all the text boxes on the form with the correct data. I for the life of me do not know where/how to even start to do this. I would attach my database but I cant seem to get the file small enough. I have deleted the large table and it is still 7megs. How do I get it small enough to attach it? Thanks for the help.
View Replies !
Linking A Combo Box With Text Boxes
I am creating an orders form based of a query that has joined an orders query and a customer query. What I want is in the order form when a Customer is selected then the address & contact information is automaticly populated in following text boxes. Thanks - a noob
View Replies !
Use Combo Boxes Or Include Actual Fields
I am using a datasheet to show company info - I have a field countyID which is a code field and a lookup table County I want to show the text for county on the datasheet, should I base the datasheet on just the company table and use a combo to get the county text - or should I have query that brings in the county text. Could the experts tell me the "correct" way of doing this? What are the performance issues of the two methods. Is which method I choose dependent on how many records are in the lookup table? Thanks Paul
View Replies !
Multiple Query Fields & Combo Boxes
Hi all, Im trying to do the following query work. I have a form, with combos , text fields which are filled in with parameters. The query I want to make is complex. For example we shall use field1, field2, combo1 , combo2 for explanation. I want the field1 param AND the field2 AND combo1 AND combo2 to be evaluated for a result. At the same time, I want the user to fill in only field1 and combo1 or like that and the result to be right. Is there any possibility to make them all work at the same time, individually, or in combinations ? Sounds too Complicated ? I ve managed to make it work only by filling in individually the fields or combos and have the right results. The other ways didnt. Desperately need your helpppp. :rolleyes: THNK U
View Replies !
Autofill Text Boxes Based On Combo Box
:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:
View Replies !
Multi-Column Combo-box Won't Bresk Down In Text Boxes
My form's 10 column combo-box (based on a query) won't break into text cells. Some of the columns contain numbers, some test, some phone #s. All columns show when I click the Combo-box in Form View. Access Help File said to put: =Forms!Customers!CompanyName.Column(1) in the ControlSource for the text cell. Tried that and was returned #Name? for any of the fields in which I tried it. My expression was: =frmSpartanStudentBehaviorLog!Last_FirstUC.Column (3) The other properties in combo-box are set correctly: ColumnCount=10, Column Widths are correct. I also tried the expression: =Last_FirstUC.Column(2) but got the same result #Name? I'm baffled. As a very new user, I'll appreciate any assistance. Thanks.
View Replies !
Update Date Text Field From Several Combo Boxes
I've searched for this everywhere but I haven't yet found a solution, even though I'm sure it should be pretty simple. I have 2 combo boxes: cboMonth, cboDay and a text field: txtYear cboMonth has values: Jan-Dec cboDay has values: 1-31 After selecting the combo boxes and entering the year, I want the result to be displayed in a text box, with the format of Long Date. How is this accomplished? Thanks for any help!
View Replies !
Text Boxes Showing Information From A Row In A Form Corresponding From A Combo Box
Hi, I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes. For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box. Thanks a bunch!
View Replies !
|
TRACKER
