Hi,
I am having issues with my lookup tables. When I display the data in an Excel table, the results in the lookup fields appear as the numeric codes rather than in string. We wish to display the actual string data rather than the numeric codes; how can I change this? We are using Access 2000.
Thanks,
Tonya
PS - I have created the lookups in 2 different ways, so the Row Source Type of the lookups include both Value Lists and Table/Query.
13 1768
You have posted this in the Articles section.
I am moving it to the Access forum.
ADMIN
Apologies - thanks for moving this.
Tonya
NeoPa 32,556
Expert Mod 16PB
Hi,
I am having issues with my lookup tables. When I display the data in an Excel table, the results in the lookup fields appear as the numeric codes rather than in string. We wish to display the actual string data rather than the numeric codes; how can I change this? We are using Access 2000.
Thanks,
Tonya
PS - I have created the lookups in 2 different ways, so the Row Source Type of the lookups include both Value Lists and Table/Query.
Tonya,
You may want to try to explain this a little more clearly.
There's no indication what this all relates to. I presume you're working in a form but that's about as far as I can get.
Tonya,
You may want to try to explain this a little more clearly.
There's no indication what this all relates to. I presume you're working in a form but that's about as far as I can get.
Yup - I created a form into which I've entered data. But when I view the data i've entered in the Lookup Fields in an Excel file, it appears as the numeric codes, rather than the text data (the text used to ID options in the dropdowns of the Lookup fields). Does that help? I'm interested in knowing how to display the data in an Excel file as string rather than as code.
NeoPa 32,556
Expert Mod 16PB
Perhaps you could start by explaining how the data gets into the Excel file.
Giving the MetaData for the table the data is stored in within the database would also be required information.
Here is an example of how to post table MetaData : Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; AutoNumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
I export the Access table as an Excel file to view as Excel file.
As I mentioned, the Lookup table data are in both Table/Query and Field List form (i.e., Metadata for Field #1 are: Transmitter, Text, Table/Query,
and for Field #2:Activity, Text, Field List)
How's that?
NeoPa 32,556
Expert Mod 16PB
Tonya,
There are a number of issues involved here. Excel is particularly difficult when it guesses for you what it thinks you want. For me to determine what Excel is thinking I will need some accurate answers to questions and for you to follow my instructions when I ask you.
It would all be very easy if I were working directly on your database but that isn't how this works. I need a proper set of MetaData for your table. I don't (yet) need any info on your form, but I may well request later, that you post all the code behind your form.
The most important thing I need to know first is the accurate MetaData, from which point I hope to be able to make some progress together.
*edit* If you feel that there are things you don't understand or cannot do then feel free to ask about them. We can generally help there too, if only we know it's required.
Tonya,
There are a number of issues involved here. Excel is particularly difficult when it guesses for you what it thinks you want. For me to determine what Excel is thinking I will need some accurate answers to questions and for you to follow my instructions when I ask you.
It would all be very easy if I were working directly on your database but that isn't how this works. I need a proper set of MetaData for your table. I don't (yet) need any info on your form, but I may well request later, that you post all the code behind your form.
The most important thing I need to know first is the accurate MetaData, from which point I hope to be able to make some progress together.
*edit* If you feel that there are things you don't understand or cannot do then feel free to ask about them. We can generally help there too, if only we know it's required.
So are you insinuating that i haven't followed your instructions when you've asked me? You might want to reconsider your attitude... I guess that I (misunderstood) that your job was to help me, not assume you're helping me. Unlike you, I DO believe in solutions. It's unfortunate that a "Forum Leader" cannot help as well as the others have when I've had Access issues in the past. It shows that, for you, "Computers (really) are easier to understand than people". Don't concern yourself - a coworker of mine has already let me know how I can deal with this issue. FYI: It's a 'ghost' issue, one concerning bound columns.
NeoPa 32,556
Expert Mod 16PB
So are you insinuating that i haven't followed your instructions when you've asked me? You might want to reconsider your attitude... I guess that I (misunderstood) that your job was to help me, not assume you're helping me. Unlike you, I DO believe in solutions. It's unfortunate that a "Forum Leader" cannot help as well as the others have when I've had Access issues in the past. It shows that, for you, "Computers (really) are easier to understand than people". Don't concern yourself - a coworker of mine has already let me know how I can deal with this issue. FYI: It's a 'ghost' issue, one concerning bound columns.
Perhaps I should start by explaining that ALL the moderators and Experts on this site offer their help on a purely voluntary basis.
I was indeed implying that my requests had not been followed. I thought I'd explained quite clearly that (and indeed why) I needed information from you before I could help you. Your response was (again) devoid of the necessary information.
You certainly did misunderstand my 'Job'.
You'll be happy to hear that I will follow your last advice with alacrity (to whit 'Not concern myself').
In conclusion, I'd like to quote a colleague of mine who expressed my understanding of your comments so well :
Complaining about the quality of free help from experts who donate their time to strangers. Some people are clueless.
Perhaps I should start by explaining that ALL the moderators and Experts on this site offer their help on a purely voluntary basis.
I was indeed implying that my requests had not been followed. I thought I'd explained quite clearly that (and indeed why) I needed information from you before I could help you. Your response was (again) devoid of the necessary information.
You certainly did misunderstand my 'Job'.
You'll be happy to hear that I will follow your last advice with alacrity (to whit 'Not concern myself').
In conclusion, I'd like to quote a colleague of mine who expressed my understanding of your comments so well :
Indeed, some folks are clueless, YOU would know from PERSONAL experience. Alas, stick to your day job and away from humans.
Alright that is enough. Offensive or abusive behavior towards the experts who volunteer their time on this site is not tolerated. If you have a legitimate complaint then please send me a PM.
I will not tolerate any repeat of this behavior.
ADMIN
Alright that is enough. Offensive or abusive behavior towards the experts who volunteer their time on this site is not tolerated. If you have a legitimate complaint then please send me a PM.
I will not tolerate any repeat of this behavior.
ADMIN
Hi Admin,
I would suggest that your "expert" is not a "professional", or he would have handled his impatience differently - that is unfortunate. For example, for NeoPa to suggest that he would need, " some accurate answers and for (me) to follow (his) directions when (he) asks (me)" is arrogant and not helpful. No need to be a jerk about what he requires. A better method would have been to politely ask for exactly what he wanted with an example from the beginning rather than lose patience over indecipherable instructions. It's telling to me that a colleague of NeoPa's seemed to understand my comments - you've obviously dealt with similar issues before and maybe that should be considered in the future.
Hi Admin,
I would suggest that your "expert" is not a "professional", or he would have handled his impatience differently - that is unfortunate. For example, for NeoPa to suggest that he would need, " some accurate answers and for (me) to follow (his) directions when (he) asks (me)" is arrogant and not helpful. No need to be a jerk about what he requires. A better method would have been to politely ask for exactly what he wanted with an example from the beginning rather than lose patience over indecipherable instructions. It's telling to me that a colleague of NeoPa's seemed to understand my comments - you've obviously dealt with similar issues before and maybe that should be considered in the future.
If you would like me to address your complaint them please send me a PM. I am not prepared to address it in the technical forum.
ADMIN
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andreas Palm |
last post by:
I have a dataset that has DBNull in certain columns, now when I write
out this one to XML, I only get the columns as elements that do have
data in it. However I do need also the empty colums as...
|
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...
|
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...
|
by: dbuchanan |
last post by:
Hello,
(Windows forms - SQL Server)
I fill my datagrid with a stored procedure that includes relationships
to lookup tables so that users can see the values of the combobox
selections rather...
|
by: Supernaut |
last post by:
Hi,
I have database with a couple of tables. The main table contain foreign
keys from the other tables. I have made look-up columns for them. I
want to select a value from first look-up column and...
|
by: munrrob |
last post by:
MS Access 2002 SP 3
I have two forms, one with a combo box looking at available lookup tables and the other an unbound form which will be used by the user to update lookup values.
The lookup...
|
by: connected |
last post by:
I'm having difficulty with populating a DataGridView control with data
correctly. It works with a single class, for example...
class MyClass
{
private string _propertyOne;
private string...
|
by: Learner |
last post by:
Hello,
I have a situation that I need to be able to identify if there are
any numerical values in a string variable that might have numerics
including charecters.
For instanse Dim strValue as...
|
by: Ken Fine |
last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets
and DataTables should be able to answer fairly easily. The basic question is
how I can efficiently match data from one...
|
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...
|
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...
|
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...
|
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,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| | |