Thanks for all the replies and suggestions. as it stands the table structure does reveal different AccountNames when queried on different columns (AccountID, CustomerID). And yes, that seems redundant because for case of one record having unique set of AccountID, CustomerID, and AccountName it is obvious. For case of many records with mixed combinations of those 3 columns, I am not guaranteed the AccountName is what I want. I think I'm only concerned if AccountName is not NULL. Thanks!

Thanks! the first link you provided as a reference looks exactly like the setup i am using. I also updated my post under one of the first replys - the < and > brackets may have corrupted my original question. JJM

I would migrate to .net and make it DB agnostic using DBProviderFactories[^]. Then you can choose your poison in the app.config section. Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions

john john mackey wrote: Yes, the MS site had some good suggestions. Thank you. My pleasure :) ..and yes, there are some good arguments in there. Bastard Programmer from Hell :suss:

john john mackey wrote: Can I get some feedback/opinions on the pros and cons of each - C++ and C# ? That isn't logical. You can't make a technological decision wildly. It needs to be based on your business needs. Some possible considerations. - You have a team of 10 C++ senior developers with no C# experience. And the application meets all of the current business needs. And the C++ developers want do continue using C++. So the ONLY decision is to keep using C++. - You have a team of 10 C++ developers with varying experience levels in C++ and C#. The application meets all of the current business needs. But 5 developers with the most business knowledge are threatening to quit unless you start using C#. So the only decision is to use C#. - Your largest customer produces 80% of your business income and insists that you use either C++ or C#. So that is what you use. - Your largest customer produces 80% of your business income and insists that you implement a feature that can only be implemented in either C++ or C#. So that is what you use. (This is probably a stretch scenario.) - Your business plan calls for you selling the company to Microsoft. Then use C#. - Your business plan calls for you selling the company to Oracle. Then use C++. Or Java. Regardless re-write to use Oracle instead of SQL Server. - Your application is 1000% slower than it should be. You have a design/architecture/requirements problem. It has NOTHING to do with language choice. - etc, etc, etc...

I think it means that it should concatenate the fields, and search for that. MSDN[^] states: If you need to specify a value for more than one field, use the VBA Array function to pass those values to the KeyValues argument of the Seek method. If you only need to specify one value, it is not necessary to use the Array function. Bastard Programmer from Hell :suss:

The logic seems reasonable. I'd start writing because you'll probably spend just as much effort to find something that does it for you. A guide to posting questions on CodeProject[^] Dave Kreskowiak

Even though it may look nicer to have columns sorted in a particular order, sooner or later you will have no influence on the order any more. For as far as I know it is not possible to insert a column inbetween to existing columns without dropping the entire table and recreating it, which in most large live systems is a big no no as it cost way to much time to do.

You'd probably want to find a forum dedicated to Access to ask this question. Everything you're asking is very specific to the behavior of Access and not how to interact with it using VB/VB.NET. A guide to posting questions on CodeProject[^] Dave Kreskowiak

Yes, that's the one to get.

I hate it when someone univotes a post with no explanation. You error is that this is a database forum and you are asking a question that requires VBA, I know you think you are using a database - Access but that is because Access should no longer be called a database, abomination maybe but not a database. You will get a much better response in the VB forum. You should also mention that you are using spit MS Access and the version as there are differences that may be critical. A possible answer - define some global variables representing the data, load them from the dataset/recordset or make the dataset/recordset a global. Sorry have not used Access for more than a decade. Never underestimate the power of human stupidity RAH

Yes, just disable the wireless network adapter. ▬▬▬▬▬▬▬▬▬▬▬▬

Ah ha. I think I see what you are doing. How about this ... When you are building your dataset with a query, add a column where you can calculate a value you want displayed. For example: SELECT Payroll.WKNum, IIf([wkNum] Mod 2=0,"Even","Odd") AS OddEven FROM Payroll; This query displays the Payroll Week Number and a Text value of "Even or Odd" This would free the DataSheet View from having to do any logic processing on the dataset, it would just display it. If you need more complex logic, maybe you could extend this by manipulate a temporary table, then display that contents. Give it a shot. :cool:

The ExecuteReader() function of a command can receive a CommandBehavior parameter. Why not use CommandBehavior.SchemaOnly or CommandBehavior.KeyInfo? E.g. SqlCommand cmd = new SqlCommand("SELECT \* FROM MyTable"); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);

Whehe, cool collegue! :cool: I are Troll :suss:

If I ever 'get busy' with her, I will be sure to do so. ___________________________________________ .\\axxx (That's an 'M')

The movie you are most likely talking about is, "Cheaper by the Dozen" it is towards the end when they find the boy that ran away. However, I think there is a much better movie with a nearly identical scene but I cannot remember the name of it. Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane

Hi, on CodeProject users are not expected to remove anything. The forums can and will be searched by many others, who will be happy to find what they need. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.