Search results for query: *

What your trying to do is tricky as the gal, I don't believe is indexed so depending on how large the gal is, it could take quite a while. The agency I work at has a gal thats over 30,000 address, so what we did was to write a service that runs every night and pull the information we want out...

Nimarii, I assuming by looking at your query that the information in the array are strings. The problem is the sql statement in incorrectly formatted. It should be like this example. Dim strSQL As String strSQL = "Insert into table(field1, field2) Values ('" & varRecords(x, Y) & "', '" &...

Dear ClulessChris, You have to the sql statement joining the tables. Here's an example. SELECT tbl_Volunteers.Prefix, tbl_Volunteers.LNAME, tbl_Volunteers.FNAME, tbl_Volunteers.Suffix, Table1.Address FROM tbl_Volunteers INNER JOIN Table1 ON tbl_Volunteers.VolunteerID = Table1.VolID;

Yes, they are expensive and sometimes very complicated to use. If you know what files you require to product a setup, I use a free Setup program that is so good even Microsoft has used it. It's call Inno Setup and can be downloaded at http://www.jrsoftware.org/. Be aware though that runtimes...

miho1 Sound like the first person in is opening the database in exclusive mode. Check Access on the various machines to insure they are set to shared use. Tools/Options, Select Advanced tab and make sure the default open mode is shared. Mark

www.fmsinc.com has a scheduler for access databases called Total Visual Agent. It's a little pricy, but it just what your looking for.

You get the error because it can't find the parent node. Code for child would be as follows: tvRelocatee.Nodes.Add "A" & CStr(nID), tvwChild, Childs Key, "Family Details", "Family" assumption is that "Family" referances an icon.

Hi, To build on Ken's idea of using e-mail. You could also have the one database, upon an order being updated, e-mail the information to the shipping person and have his database parse incoming e-mail and update his database. We are currently doing this with an app and it works quite well. We...