Solved

id_data_dictionary purpose or function

Posted on 2014-03-21
6
138 Views
Last Modified: 2014-03-24
Hello,
Could someone tell me what this line of code is doing? Escpecially the "id_dictionary_data" part.

rsdata.Filter = "id_dictionary_data = " & Trim(Str(CboHeaderFields.ItemData(CboHeaderFields.ListIndex)))
0
Comment
Question by:tesla764
  • 3
  • 2
6 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 250 total points
ID: 39946077
Its filtering the recordset to only show values where the "id_dictionary_data" column's value is equal to whatever value is in the CboHeaderFields.ListIndex variable. See http://msdn.microsoft.com/en-us/library/ee275540(v=bts.10).aspx for more info.
0
 

Author Comment

by:tesla764
ID: 39946099
Do you know where I can get more info on the id_dictionary_data?
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 250 total points
ID: 39946370
more info on the id_dictionary_data?
id_dictionary_data is a field in the rsdata record source.  You are filtering records.

Correction on the kaufmed comment...you are looking at the CboHeaderFields.ItemData value of the currently selected item in the combobox.  ItemData is a long integer value, so I would expect that id_dictionary_data is a long integer data type.  Also, this statement does not add any delimiters around the value, so it isn't expecting a string or date data type.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39946405
It's just a column name, so I would start with the query that populates the recordset.
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39946442
@aikimark

Thanks for the catch. A bit too fast on the copy there  = )
0
 

Author Closing Comment

by:tesla764
ID: 39950691
Thanks, that is very helpful.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This video teaches viewers about errors in exception handling.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question