How can you update a Lookup List after it is created. It is not tied
to any table. I have tried adding the new data at the table level, but
when I go to the Form to input, it isn't on the list. Any suggestions? 10 2199
MJ wrote: How can you update a Lookup List after it is created. It is not tied to any table. I have tried adding the new data at the table level, but when I go to the Form to input, it isn't on the list. Any suggestions?
I'm guessing you have to also add it to the form.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
I did that--added it to the form and it did pick up the new
information, but now I can't change the label--it says "Combo 18" and I
wanted it to say "Component"
I entered the list using the Wizard Lookup feature. I entered the
values myself. I tried entering the new item in the Row Source
matching the format.
I have successfully added the field to the form, but the label is
showing "Combo 18" even though that isn't anywhere in the Design View.
I went to the Table and input the caption as Component and in Design
View that shows correctly, but when I go to Form View it still says
"Combo 18"
MJ wrote: I entered the list using the Wizard Lookup feature. I entered the values myself. I tried entering the new item in the Row Source matching the format.
I have successfully added the field to the form, but the label is showing "Combo 18" even though that isn't anywhere in the Design View.
I went to the Table and input the caption as Component and in Design View that shows correctly, but when I go to Form View it still says "Combo 18"
When you type the values yourself you are creating a ValueList as the RowSource
for the list. You didn't need to create a new ComboBox on the form. All you
needed to do was add the new entry to the ValueList for the existing one.
Did you delete the original ComboBox?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
I made a copy of the database before I tried changing things.
Originally the table shows this Lookup as:
Display Control: Combo Box
Row Source Type: Value List
Row Source : "TruHeat"; etc., etc.
I added the new component with quotes around it in the Row Source with
a semicolon in front--just list it showed, but when I went to the form
to select the new item, it wasn't there.
MJ wrote: I made a copy of the database before I tried changing things. Originally the table shows this Lookup as:
Display Control: Combo Box Row Source Type: Value List Row Source : "TruHeat"; etc., etc.
I added the new component with quotes around it in the Row Source with a semicolon in front--just list it showed, but when I went to the form to select the new item, it wasn't there.
See if it is still there in design view. Often if you enter a property
incorrectly it will silently drop your changes as soon as you tab out of the
property.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Yeah! I figured it out. I was going back to the table to make the
change. I tried clicking Field on the form in Design View and went to
Properties and added it there. That is just what it needed. Maybe I
could have just added it there and not at the Table, but it doesn't
matter--it works!!!!!! Thank you so much! I have sooooo much t learn.
Thank you for your time and patience!!!!!
MJ wrote: Yeah! I figured it out. I was going back to the table to make the change. I tried clicking Field on the form in Design View and went to Properties and added it there. That is just what it needed. Maybe I could have just added it there and not at the Table, but it doesn't matter--it works!!!!!! Thank you so much! I have sooooo much t learn. Thank you for your time and patience!!!!!
Start here... http://www.mvps.org/access/tencommandments.htm
....paying particular attention to comandment number 2.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
I just read the 10 Commandments and #2 was good to read. I had always
thought Lookups were great--cutting down on keyboarding errors. I am
finding out the hard way they aren't all they could be.
I am taking on-line classes and learning as fast as I can. This
project has taken over my life almost. I don't think I will ever be as
talented as most of the people responding to the questions. It is nice
to see those who have the knowledge, sharing it. Have a great new
year!
Rick Brandt wrote: MJ wrote: Yeah! I figured it out. I was going back to the table to make the change. I tried clicking Field on the form in Design View and went
to Properties and added it there. That is just what it needed. Maybe
I could have just added it there and not at the Table, but it doesn't matter--it works!!!!!! Thank you so much! I have sooooo much t learn. Thank you for your time and patience!!!!!
Start here...
http://www.mvps.org/access/tencommandments.htm
...paying particular attention to comandment number 2.
-- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Mudd |
last post by:
I must be missing something here. It's clearly faster to lookup an item
directly in a dictionary than to scan through a list. So when I have a
large lookup table I always load it in the form of a dictionary. But it
seems a waste. I end up having to assign an artificial value to the
dictionary entry. Below I assign the value "None" to each dictionary
entry.
Is there a better way? I feel like I'm misusing the dictionary.
|
by: Neal D. Becker |
last post by:
I need a fairly small lookup table, and I'm wondering which data python data
structure would be fastest. I could use a list, tuple, dictionary, numeric
array, or maybe plain python array. The table would be indexed by simple
integers and would be dense (filled).
|
by: Koen |
last post by:
Hi all,
My application uses a lot of lookup tables.
I've splitted the frontend (forms, reports, etc) from the backend (data).
The database has around 10 different users.
The values in the lookup tables are not likely to change.
Question 1: Should I include them in the backend (with rest of data) or the
frontend?
|
by: gerry |
last post by:
I want to populate list boxes in an ASP page from ms access lookup
lists, (lists only not separate tables). I don't want to create
separate tables for these lists, as they are only 'headings' and won't
be changed. How do you do this with ASP?
|
by: my-wings |
last post by:
I've been reading about how evil Lookup fields in tables are, but I've got
to be missing something really basic. I know this subject has been covered
before, because I've just spent an hour or two reading about it on google,
but there is something I still don't understand, and I'm hoping someone will
be willing to explain it to me in small words.
Let's say I have a table for addresses, and it includes a field for state.
What I would...
| |
by: MJ |
last post by:
Here is another Lookup List question. The Lookup List isn't tied to
any table--I input the data. However, I want to update the list and
although I input it at the table level, when I go to the form, the new
data isn't showing up on the list. Any suggestions?
|
by: google |
last post by:
I have a database with four table. In one of the tables, I use about
five lookup fields to get populate their dropdown list. I have read
that lookup fields are really bad and may cause problems that are hard
to find. The main problem I am having right now is that I have a report
that is sorted by one of these lookup fields and it only displays the
record's ID number. When I add the source table to the query it makes
several records...
|
by: Robert |
last post by:
I am trying to create a db for service providers by county. I'm relatively
new to db programming, but I have done quite a bit of programming ranging
from the old basic days up to doing some programming in the HotDocs
software. I've kind of accomplished my goal in access, but I'm not quite
there yet and figure I've really screwed something up.
The db consists of 5 tables I believe. T1 is the main contact info, with an
autonumber ID...
|
by: David Pratt |
last post by:
Hi. I like working with lists of dictionaries since order is preserved
in a list when I want order and the dictionaries make it explicit what
I have got inside them. I find this combination very useful for storing
constants especially. Generally I find myself either needing to
retrieve the values of constants in an iterative way (as in my
contrived example below). Perhaps even more frequent is given one value
is to look up the matching...
|
by: samdev |
last post by:
I have set up a table with a few fields that are set to
required....all work fine except the fields that are Lookup from
another table.
What am I forgetting to set?
Thanks!!
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |