If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
table/query
I put in the table under: Display Control - List Box
Row Source Type - Value List Row Source - " X....;"Y.....;"; "Z....." When I go to the query I don't see these: X...., Y....., Z.... in the drop down menu. (Under the Data Type is Text, of course.) I'd appreciate reply. Alex. |
#2
|
|||
|
|||
Alex,
There should normally be no need for this type of functionality in a table or query, as these are not normally used for data entry/edit/manipulation. In any case, as far as I know, you can't have a Listbox in a table or query datasheet. This is applicable to controls on a form. If you set the Row Source Type and Row Source properties of a Listbox (or Combobox for that matter) on a form, to the type of sntries you gave in your example, I think you would get the results you desire. -- Steve Schapel, Microsoft Access MVP alex1 wrote: I put in the table under: Display Control - List Box Row Source Type - Value List Row Source - " X....;"Y.....;"; "Z....." When I go to the query I don't see these: X...., Y....., Z.... in the drop down menu. (Under the Data Type is Text, of course.) I'd appreciate reply. Alex. |
#3
|
|||
|
|||
Steve,
Thank you for reply but my knowledge of Access isn't good enough to understand it. Most of the fields in my Table a Data Type is Text, in Row Source - different values. The Query is exactly parallel to the Table, and in the Query fields I put different values (which is precoded in the Table in Row Source). But for some fields in the Query i can't get even a 'v' - an arrow sign(drop down menu) to put values which are present in Row Source in the Table. And I don't know why. If you think it could help I can Zip my database to you. Alex. "Steve Schapel" wrote: Alex, There should normally be no need for this type of functionality in a table or query, as these are not normally used for data entry/edit/manipulation. In any case, as far as I know, you can't have a Listbox in a table or query datasheet. This is applicable to controls on a form. If you set the Row Source Type and Row Source properties of a Listbox (or Combobox for that matter) on a form, to the type of sntries you gave in your example, I think you would get the results you desire. -- Steve Schapel, Microsoft Access MVP alex1 wrote: I put in the table under: Display Control - List Box Row Source Type - Value List Row Source - " X....;"Y.....;"; "Z....." When I go to the query I don't see these: X...., Y....., Z.... in the drop down menu. (Under the Data Type is Text, of course.) I'd appreciate reply. Alex. |
#4
|
|||
|
|||
Alex,
You appear to be making extensive use of Lookup fields in your table design. And you appear to be trying to use a query datasheet for data entry. Both of these things will cause unnecessary difficulty for you. You need to work out what data you want in your tables, design them by defining the data type of the actual data that will be in each field, forget all about Row Sources, and think of the table as "hands off, data storage area". And for entry/editing/viewing of the data, you need to build a form. And then, if you want to use a combobox or a listbox on the form to facilitate data management, that's good... but that's another topic! It might take a bit of work to get this under your belt, but it will be worth it. -- Steve Schapel, Microsoft Access MVP alex1 wrote: Steve, Thank you for reply but my knowledge of Access isn't good enough to understand it. Most of the fields in my Table a Data Type is Text, in Row Source - different values. The Query is exactly parallel to the Table, and in the Query fields I put different values (which is precoded in the Table in Row Source). But for some fields in the Query i can't get even a 'v' - an arrow sign(drop down menu) to put values which are present in Row Source in the Table. And I don't know why. If you think it could help I can Zip my database to you. Alex. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
In Query Design, No queries in add new table/query dialog box | mike_mike | Running & Setting Up Queries | 3 | May 16th, 2005 05:55 AM |
Basic table/query design | Pete McCosh | New Users | 2 | December 21st, 2004 01:13 PM |
Populating form with values from table/query not bound to form | Jinny M. | Using Forms | 0 | December 2nd, 2004 07:39 AM |
Can a button set the form's table/query source? | JBowler | Using Forms | 2 | June 2nd, 2004 12:20 PM |