I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?
I came across this: http://groups.google.com/group/comp....0bced904cccbfa
The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?
Thanks. 4 38613
Hi,
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?
I came across this: http://groups.google.com/group/comp....0bced904cccbfa
The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?
Even though you could use lookup fields in a table, it's highly recommended
not to use them, as you can read here: http://www.mvps.org/access/lookupfields.htm
So use a form to avoid any problems...
Regards
Jens ja*******@instr uction.com wrote:
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?
I came across this: http://groups.google.com/group/comp....0bced904cccbfa
The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?
Thanks.
Yes, you can create a dropdown. When you add a field in the table,
you'll see a General tab and a Lookup tab, Select lookup.
Others may supply you with the pros/cons of doing so.
Salad <oi*@vinegar.co mwrote in
news:13******** *****@corp.supe rnews.com: ja*******@instr uction.com wrote:
>I have a table that I am manipulating as a table, not as a form. Is it possible to have a drop down list in a table?
I came across this: http://groups.google.com/group/comp.databases.ms-
access/browse
>_thread/thread/509fbf44455ab35 d/2e0bced904cccbf a?
lnk=gst&q=Dro
>p+down+list+ta ble&rnum=4&hl=e n#2e0bced904ccc bfa
The person answering the question seems to imply that a form should be used if a drop down list is needed. Am I correct in thinking that a form should be used?
Thanks.
Yes, you can create a dropdown. When you add a field in the
table, you'll see a General tab and a Lookup tab, Select
lookup.
Others may supply you with the pros/cons of doing so.
Pro: nothing
Con: too many to list, including: failed searches, failed
filters, all sort of problems with queries, forms and reports.
Besides, manipulating a table, without using a form can be
difficult as you cannot control many aspects of accidental
change, automation, etc. --
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
On Wed, 08 Aug 2007 06:54:43 -0000, ja*******@instr uction.com wrote:
I have a table that I am manipulating as a table, not as a form. Is it
possible to have a drop down list in a table?
I came across this: http://groups.google.com/group/comp....0bced904cccbfa
The person answering the question seems to imply that a form should be
used if a drop down list is needed. Am I correct in thinking that a
form should be used?
Thanks.
I haven't read your specific google link, but ....
yes, a form should be used for data entry, data editing, etc.
A table should be used for data storage.
You haven't said what you are 'manipulating' so there is nothing else
I can suggest, other than if you want the 'View' of a table, setting a
form to Datasheet View, if that will help.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dec |
last post by:
Ok to simplify things I'll just give an example.
This is pretty much what I want to do (minus the postcode):
http://www.perrys.co.uk/usedcar?ID=F5J9BNNBMVK00DF
I have relatively little experience with databases (hate being a n00b)
but I'm currently attempting to put myself through some sort of crash
course..
How far have I got?
Ok so using MS access 2003. I have a table (table1) with data with a
|
by: kmnotes04 |
last post by:
Is it possible to link one drop-down box to another? For example, if a
name is chosen from a drop-down list, can another drop-down list then
automatically display the person's office as a result of the choice
made in the first drop-down list? If so, how can that be done? I am
working with 'Teach Yourself Microsoft Access' and I didn't see it
discussed in that book (if it's even possible to do). Or would I just
have to create linked tables...
|
by: Big E |
last post by:
I'm using ASP.Net and SQL Server.
I have a drop down list that populates from a table.
When the form opens the drop down list is full of data. I would like the
drop down list to not show a default value which is usually the first text
depending on the sort order in my table.
I would like my drop down list to show no values until the user selects the
drop down list.
Thanks.
|
by: Leszek Taratuta |
last post by:
Hello,
I have several drop-down lists on my ASP.NET page. I need to keep data
sources of these lists in Session State.
What would be the most effective method to serialize this kind of data
structures?
Thanks for any hints,
Leszek Taratuta
|
by: Yoshitha |
last post by:
hi
I have 2 drop down lists in my application.1st list ontains itmes like
java,jsp,swings,vb.net etc.2nd list contains percentage i.e it conatains the
items like 50,60,70,80,90,100.
i will select any skill in 1st drop down list then i'll select % of this
skill in the 2nd list box , based on the percentage i've selected in the 2nd
list box it has to display
2 sets of drop down list boxes at run time one for selecting skill and
| |
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
|
by: thebison |
last post by:
Hi all,
I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.
My question is simple, on my Projects form I have a 'search' button,
which when clicked re-binds a datagrid with a RowFilter based on a
number of user-input parameters. Two of these parameters are drop-down
|
by: Brad Isaacs |
last post by:
ASP.NET 2.0 / SQL Server 2000 db / Visual Basic Code behind
On my .aspx page I have added an SQL Datasource that contains the SQL query
to retrieve the list for my Drop Down List Box.
Using this SQLDataSource I can retrieve my drop down list data.
SELECT DISTINCT responsibleMinister
FROM responsibleMinister
WHERE languageID = @languageID
|
by: yosri2005 |
last post by:
Hello,
I'm sure many of you have seen the error message in the subject. I
found quiet a few posts on the web regarding this issue, but the ones
I saw mainly tackle this issue when you have a drop-down list
depending on another drop-down list within a form view. This is not
what I'm trying to do, so I didn't know how to apply the solutions I
found to my problem.
I have a formview which inserts items into a database table via an
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |