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

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

    Copy jpg file from source to destination folder

    Hi, From a form, I want to copy a photo (jpg) from a user's source directory and put it onto the database's server. I set up a common dialog so the user can "browse..." for the source photo. But now how can I save the photo into the destination folder? Are there VBA commands to do this? I...
  2. ITlori

    Add details to aggregate query...

    Hi, I have a report that displays summary information, summing prices for all records for a RoomID meeting certain criteria, and printing the roomID and sum on a detail line. Now I want to add lookup-table info onto the detail line. The report’s query determines what items are missing for a...
  3. ITlori

    store photos on db - SQL server back end, access FE

    Hi, I need to add photos to my database. Back End is on MS SQL Server (I believe 2000), and Front End is on MS Access. I have read about storing the photos as BLOBS, but I am not sure how to do this with SQL Server. Does this mean store the photo as OLE image, but do something else to it to...
  4. ITlori

    Query on Query - use result on report

    Hi, I have a report displaying items that are missing from a room. I created 2 queries, the first getting the items IN the room, and the second being an "unmatched" query that references the first query where Item is Null. I use a subreport for the details, and the results display correctly...

Part and Inventory Search

Back
Top