Search results for query: *

Duane, Thanks again for the update. With some fiddling around, I was eventually able to figure this one out. I wasn't selecting the right ODBC driver when prompted to as it turned out. Unfortunately I did not have access to the database to provide you a screenshot of where the problem was and...

Duane, Thanks for your reply. I have a few ODBC tables already linked in my db. I'm merely trying to update those links. To do that, I select the ODBC table I'm trying to update, right-click and then select Linked Table Manager. This then prompts me to enter the DSN and etc... This is where I...

Hi All, I'm new to MS Access and have been trying to update the links to the ODBC tables in my database. I'm trying to do this using the Linked Table Manager option by right-clicking on the ODBC table I want to update. I'm then prompted for choosing a DSN and then a data source. Can anyone...

Thanks for your response, but an example would clarify things better. I'm not sure I followed your suggestion. Please specify the code if you can. cheers!

Hi, I've been trying to accomplish the following in MS Access: From the following table, I'm trying to filter out any duplicate 'Column B' values. For the unique 'Column B' values, I want my query to return the corresponding 'Column C' values. Column A Column B Column C 1 abcd stuv 2...

Hi, Thanks for your responses I have a couple questions: 1) In Remou's reponse, I notice you have used two tables (t1 and t2) but my data is all in just one table. Perhaps, I'm missing something. More clarifications are appreciated. 2) In BigRed1212's response, I notice in the FROM...

Hi, I'm trying to compare two columns in one particular table. To be more specific, I have 3 columns as shown below: Column 1 Column2 Column3 1 abcd efgh 2 efgh mnop 3 ijkl abcd 4...

Thanks PHV and Karja, I checked PHV's method again and it just so happened that I had overlooked something. Both your suggestions worked perfectly fine for me! cheers, Shilpa

Thanks PHV for your reply. I did try out your suggestion but unfortunately it doesn't seem to be filtering out the duplicates in the 'Name' column. Any more ideas perhaps??? Thanks again! Shilpa

Hi all, I've been trying to accomplish the filtering out of duplicate data in the following table. ID Name Code 1 x Pink 2 y Red 3 z Orange 4 z Orange From the table above, I'm trying to filter out duplicate 'Name' fields and obtain only unique 'Name' fields with...

Hi all, Here's the linker error I'm presented with in my Borland project. Any ideas what the file in the error message is? [Linker Error]Unable to open file 'PROCONST.R32' Thanks for your help in advance cheers, Shilpa

Hi all, I’m trying to create an array of a string object whose contents I need to access later. To be more specific: string data[] = {“10”,”11”, “12”}; Using a for loop I want to access the first, second and third element of the array above. As I understand it, the above declaration is...

Hi there, I'm sorry I should have been more specific. The predefined array is just a 1-d 8 element array and the contents of the text file have spaces between the numbers. For eg, the contents are: R [40] [45] [56] R [10] [12] [13] [14] Please note each line like the above lines are...

Hi all, I’m trying to read the contents of a text file and attempting to compare each content with a particular number in a pre-defined array. I’m unable to proceed as I’m stuck with how I can read contents that are specified in various formats. For eg: below is a sample of how the contents of...

Hi, Thanks for your reply. Yes, I'm definitely interested. Better ideas are always welcome. It would be great if you had some tips on how i can do this using streams. Thanks again! Shilpa

Hi all, A little background on what I'm trying to do. I've created a file with 5 lines, 3 numbers on each line. I intend to read only the second number of every line and then jump to the newline. For eg: Line 1: 1 2 3 Line 2: 4 5 6 Line 3: 7 8 9 Line 4: 1 2 3...

Hi 2ffat, Thanks for the prompt reply. Actually, just placing radio buttons on the form doesn't facilitate multiple selection. BCB says that it will allow multiple selects ONLY if the buttons are placed in different containers (eg. groupboxes). Unfortunately, doing that defeats the purpose of...

Hi All, As i understand it, it is not possible to select more than one option in a TRadioButton component. Any ideas on what I need to use to be able to select more than one option at the same time in a RadioButton component. If it's not possible to achieve this with a RadioButton, can you...

Hi all, I need some pointers on file handling in Borland. I’m trying to create a button that will open a file in my default text editor. Not sure if there is a BCB function that can handle this. The file to be opened is created using the OpenDialog control. Thanks in advance for your...

Hi all, I'm trying to create 'mouse over events' that will pop-up a 'help' menu describing the function of the control that the mouse is pointing to on my form but not sure how i can go about it. Can anyone please give me some direction/ideas? Thanks in advance for the help! cheers, Shilpa