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!

  • Congratulations bkrike 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: jsimes
  • Content: Threads
  • Order by date
  1. jsimes

    CONCAT giving wacky results

    I have a query like this: SELECT P.PageID,P.PageSUB, CONCAT("L1=" , P.PageID, "&sub=", P.PageSUB) AS thePath FROM Pages P What I want thePath to look like is: L1=12&sub=res what I get is: [B@7857a5 It looks like it is Concatenating the field reference or something...
  2. jsimes

    Join problem

    I have a Contacts table and a Notes table, I would like to make a query that gets all of the fields from the Contacts table and also gets the multiple records for that contact from the notes table. The contacts can have many notes there is a contactID in the notes table to join it to the...
  3. jsimes

    InsertFromFile method in Powerpoint loses formatting

    Hello all, I am using the InsertFromFile method to copy single slides from one Powerpoint presentation to a blank presentation. I open a blank presentation then I loop through a list of ppt files like this: mySlides = objPresentation.Slides; for(i=1; i LTE formQTY; i=i+1){ theSlide = docPath...
  4. jsimes

    Internet based PowerPoint Presentation builder

    There is a web site: http://www.lipidsonline.org/slides/ that takes PowerPoint slides and displays them individually. You are allowed to select slides from all of the presentations into your own little cart (or tray as this site calles it). When you are finished collecting your individual...
  5. jsimes

    Import routine that only grabs new records

    Hello, I ave a bit of a dilemma. I ahve a client that wants PeachTree data in an Access database. I had the client export the appropriate data from PeachTree (Customers and Inventory). It is quite a simple list of items the customer export has only the customer ID and the Customer Name and the...

Part and Inventory Search

Back
Top