Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. baderms

    Validating an email field using the GAL

    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...
  2. baderms

    using an array for the values in a sql insert statement?

    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) & "', '" &...
  3. baderms

    Edit Access tables

    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;
  4. baderms

    Do you recommend these products for developers?...

    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...
  5. baderms

    Database not worked in a network.

    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
  6. baderms

    Schedule compact & repair for Front-end DB

    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.
  7. baderms

    add a child node

    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.
  8. baderms

    Database for two offices

    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...

Part and Inventory Search

Back
Top