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

    Password on Linked Workbook

    I have created an excel workbook (A) that uses data from another, password protected, workbook (B). At the moment I need to open B, with the password, and then open A for it to be able to refresh. Can anyone help me with some VBA code so I don't have to open B, either by (i) asking for B's...
  2. TimPittaway

    Excel Conditional Formatting with More Than Three Conditions

    Is there any way the above code can be modified to do the conditional formatting using wildcards? eg. If the first few letters of a cell match in the case, something like what the # could do below: Select Case oCell.Value Case Is = "ARL###"...
  3. TimPittaway

    Merge access query with Word

    Just wondering if anyone has any code to automate the merging of an access query with a Word template? I know it can be done manually using the Office links functionality, but I'm sure it can be automated. I would like it to use the current database (as the same database may be re-used and...
  4. TimPittaway

    Replicate backend database

    Paul That sounds exactly like what I'm after. Would be ideal if the frontend was able to check for the network and, if not present, use the local backend, otherwise connect to the network backend and synch the local backend. I might run into problems in specifying which backend to connect to...
  5. TimPittaway

    Replicate backend database

    Thanks Paul, that does sound like what I need. The reason I have local backends is for users to work on laptops without network access, then replicate to the master backend when they return to the office and login to the network. Does yours replicate to the server each time a user logs in to...
  6. TimPittaway

    Replicate backend database

    I've created a frontend/backend system and want to be able to replicate local versions of the backend to the network version. Is there an easy way to enable replication of the backend through the frontend application, or does the backend have to be manually replicated?

Part and Inventory Search

Back
Top