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 wOOdy-Soft 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: *

  • Users: jpa
  • Content: Threads
  • Order by date
  1. jpa

    Dynamic export to Access (DTS best?)

    Our SQL server has some tables that we need to pivot (with transact SQL statements) then export to Access. We have some ASP that creats the dynamic SQL to view the results on the web page, so that's not our issue. Question is: what is the best way to get the resulting data to an Access database...
  2. jpa

    Select Query to merge two identacal tables

    I have two tables with identical structures, both linked to different sources that are updated frequently. I would like to write a query that would show all of the data from the two tables as a single unified table with the same fields as the original table. e.g. Table1: name, phone Table2...
  3. jpa

    Flexible Checklist Scheme

    Hi, I'm trying to put together a checklist that is flexible enough to have varying datatypes for the results of each checklist item. For example, I'd like a table structure that would allow me to create an editable query that might allow: Went to the Store: yes/no Bought Bread: yes/no Cost of...
  4. jpa

    Forwarding to outside internet address

    What I need to do sounds simple enough, I just can't get it to work as expected: I need to set up a forwarding alias on our exchange server, say newperson@ourcompany.com, so that all mail to this address is forwarded to another internet e-mail address (and is not stored on the exchange server)...
  5. jpa

    Permissions for Import/Export

    I have a front/back-end database. In the front-end, users can read/write/delete data in most of the tables in the linked back-end. How do I keep these same users from Importing the back-end tables (structure mainly) into a separate new Access database? Is there a way to set permissions on...
  6. jpa

    Web Project Wizard not creating web a project

    I have some web pages and a database on my local machine that were written by another developer that I'm trying to edit. I'm stepping through the Web Project Wizard to try to create a new Project that points at these pages (or just a blank project that I can add the existing pages to). I get all...
  7. jpa

    Access processes start but do not end

    Hi-- I have a website that generates .rtf documents via MS Access, thereby creating a background MS Access process. The ASP code has the following segment that does this: ------------------ var access = new ActiveXObject('Access.Application'); var basefilename = reportName +...

Part and Inventory Search

Back
Top