Search results

Here is some sample VBA code, using ADO, that will do what you want: Public Sub ConnectionTest() Dim cn As ADODB.Connection Dim vError As Variant Dim sErrors As String Set cn = New ADODB.Connection On Error Resume Next cn.Open "Provider=sqloledb;" _ & "Data...

When you attempt to perform a mathematical calculation on one or more expressions, and any one or more of those expressions is null, the calculation will fail. Try: =Nz([Price],0)+Nz([Shipping],0)-Nz([Fees],0)-Nz([Shipping Costs],0)

Why not just use: SELECT CHARTER.CHAR_TRIP, CHARTER.CHAR_PILOT, CHARTER.CHAR_COPILOT FROM CHARTER WHERE (CHARTER.CHAR_PILOT In (105,109) OR CHARTER.CHAR_COPILOT In (105,109)) AND CHARTER.CHAR_PILOT <> CHARTER.CHAR_COPILOT;

The first part of the query is straightforward (as I'm sure you have figured out). If it were simple a case of returning records where the locations do not match, your SQL might look something like this: SELECT IHead.ProductID, IHead.ProductName, IDet.LocationID, iPhone.Location FROM...

Can you list the tables to be queried and the fields in those tables, and maybe provide samples of the data in them, for reference?

On the Vagueness of English The Boss was in a quandary. He had to fire somebody. He had it narrowed down to one of two people, Debra or Jack. It was an impossible decision; they were both super workers. Rather than flip a coin, he decided he would fire the first one who used the water...

When you say "just this once i m asking you guys to help me out", do you mean, "help me understand how to do this" or do you mean "would you do this for me"? jzwp22 has already given you some detailed guidance on your project; you should be able to use this information to complete the...

This is why you need to sit down with your professor and talk with him. Your professor should be able to give you the guidance you need to complete the assignment yourself. "i did the half the work already i just need someone to help me finish it" is not a specific request that is likely to...

So are you saying that you asked your professor for help, and then he gave you some outdated material? A blanket "I need help" statement, in the same post with the word "assignment" typically implies that you are looking for someone to do your homework for you. That is a practice which is...

Have you tried asking your professor for help or guidance on your homework assignment?

Try: UPDATE [TempTable-SovImport] INNER JOIN Advisors ON [TempTable-SovImport].AgentName = Advisors.FirstName AND [TempTable-SovImport].AdvisorLastName = Advisors.LastName SET [TempTable-SovImport].AdvisorID = Advisors.AdvisorID;

If your project uses ADO object references in the code, this will definitely be an issue. In Windows 7, Service Pack 1, Microsoft changed a number of the IID's for ADO Objects. See the following link for details: http://support.microsoft.com/kb/2517589 Even though they say that the Method 2...

A couple of questions for you: 1) What is the error message that you get when attempting to run the ADE on the Windows XP machine? 2) Does the Windows 7 machine have Windows 7 Service Pack 1?

That's interesting. I do not encounter the same error in that scenario. What version of Access and Excel are you running? Can you post the code that you used?

In Excel VBA, you can accomplish this with something like the following example. You should be able to adapt the code for Access. Const xlCellTypeLastCell = 11 Dim R As Range Dim C As Range With ActiveSheet Set C = .Range("A:A") C.NumberFormat = "m/d/yyyy" For Each R In .Range(...

Chr$(2) = ""

Yes, if you go to User CP > Your Control Panel > Your Profile > Edit Profile Picture

Instead of a cartesian join, why not use an inner join? You might try the following change: SELECT a.id , a.name , a.type , b.assign , b.standard FROM meta b INNER JOIN vision a ON b.ID = a.ID WHERE a.status = 'RELEASED' AND a.state = 'Y' AND a.type = 'Template' AND Default = 'YES' AND...

Check out the following link: http://www.google.com/search?hl=en&source=hp&biw=1276&bih=857&q=mysql+visual+basic&btnG=Google+Search&aq=f&aqi=g6g-m1&aql=&oq=&gs_rfai=CZozcsCzrTLCTPIa8igOfm4nkAQAAAKoEBU_QKA1H

namliam, the most you seem to be accomplishing by your continued posts in this thread is that he who has the last word is right. (The best way to prove me wrong is not to respond to this post) That aside, you are correct in that the method you presented provides more of a learning step for the...