473,385 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Lookup Wizard

MJ
Is there a way to change how a lookup is being stored without deleting
the row and starting over in the design view?

Nov 13 '05 #1
2 1669
Could you be more specific with your question?

"MJ" <je*******@cox.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Is there a way to change how a lookup is being stored without deleting
the row and starting over in the design view?

Nov 13 '05 #2
MacDermott wrote:
Could you be more specific with your question?


Let alone that it is better not to use the lookup feature.

* you get confused as to what is stored
* an extra, unnecessary relation is added to your structure by Access

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jim Stacey | last post by:
Create Lookup field with Visual Basic Can i create a lookup field on the fly? In my table Students i want to create a loookup field TeacherID that looks up teachers by their LastName. Otherwise...
3
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...
3
by: xmp333 | last post by:
Hi, Is there a way to use a 2 column table as a lookup for a combo box, having one field show up on the form, and the other field actually written to the output table? Here's an example: I...
1
by: Splashout | last post by:
I am having a problem with how to get a lookup to work how i want. What i want is the user to be able to use the lookup on a form to select the supplier for that product however there is different...
3
by: Splashout | last post by:
I am having a problem with how to get a lookup to work how i want. What i want is the user to be able to use the lookup on a form to select the supplier for that product however there is different...
3
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...
1
by: James | last post by:
I am used to VB6 but need to develop something in .Net. I need to create several bound combo-boxes which will use lookup tables to get their values. I created a form using the dataform wizard....
4
by: jon f kaminsky | last post by:
Hi- I've seen this problem discussed a jillion times but I cannot seem to implement any advice that makes it work. I am porting a large project from VB6 to .NET. The issue is using the combo box...
5
by: Kevin | last post by:
I was reading on the mvps.org site not to use the lookup wizard in the table design, but rather use a query. I'm confused by this, given that the lookup wizard basically creates a query and uses...
1
by: =?Utf-8?B?bXBy?= | last post by:
In an Access table, I have a field that is a Lookup Wizard. I notice that in the 2007 version, when a lookup is used, the datatype is changed to number. I think this might be my problem. When I...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.