Recent content by JeffArcherJr

Its just an example '30002-1003' is just an example to test if the concept works! Now that I know how to do it, the real code is looking up longitude and latitude for any zip+4 code in the state of Georgia and of course gets passed whatever zip+4 I happen to be working with. Since there is...

Quick and dirty solution ... I couldn't quite get my head round the example you gave me, but it did inspire this quick and dirty solution which works great for my purposes! Thanks! Sub TestIndex() Dim Connection As New ADODB.Connection Dim catalog As New ADOX.catalog Dim...

Is this something you could give a brief example of? I have to admit I mostly know what I am doing with VB but know next to nothing about SQL. Is a Query equivalent of my seek something you could demonstrate in a line or two of code? Thanks Jeff

Here's my code Option Compare Database Option Explicit Sub TestIndex() Dim Connection As New ADODB.Connection Dim Catalog As New ADOX.Catalog Dim Zip4DistanceDb As New ADODB.Recordset 'open up files Connection.Open "Provider=SQLOLEDB.1;INITIAL CATALOG=ProspectorSQL;" &...

Can anyone tell me does the Microsoft OLE DB Provider for SQL Server support indexing? If so, could anyone point me to a vb example of how to do it. I keep getting run time error 3251 "Current provider does not support the necessary interface for Index functionality". Thanks

I don't have an old version of access, nor even a version of dbase. In any case, this is an ongoing problem so a one time translation of the dbase file won't do the trick. My third-party viewer will export as a csv, but does so without column headers (!) so I'd have to do some work to get them...

I have a problem linking from access to a dbase file. I'm creating a link to a dbase III file, and access seems to make the link okay, but when I view the file the fields are not mapping across correctly. The first few fields are okay, and the last field is okay, but everything in between is...