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 Mike Lewis 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. chrisjohns

    How to populate a Videosoft Flexarray controller? (97)

    Hi, Im hoping someone knows how to populate the cells in a Videosoft Flexarray control? To this point ive been populating a table with a recordset but im now trying to avoid copying data into a table by using this method. My current code receives data from an SQL statement and populates a...
  2. chrisjohns

    Code to import .xls document and keeping the headers?

    Hi all, I can currently import an excel document into my tool using the below command DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "AnnualData", strFile, True However, this doesnt include the column headings, instead filling the headings with a cell value. On the import it...
  3. chrisjohns

    Import XML String into Access table

    Hi, I have an XML document im trying to read into Access, i can import it in as a string but then i dont kno how to 'chop it up' into the fields i want. e.g <Date>2009-03-17</Date><Name>JOHNSON</Name><Position></Position><Age>21</Age> Into the Columns for: Date Name Position Age Many Thanks
  4. chrisjohns

    Cannot load image in Microsoft Office Document Imaging

    Hi, thanks for the reply but i could never get preview class 1.0 to work, something about OLE connection (theres actually a topic about it on this forum XD)
  5. chrisjohns

    Cannot load image in Microsoft Office Document Imaging

    sorry, mistype, i AM on XP
  6. chrisjohns

    Cannot load image in Microsoft Office Document Imaging

    Hi, I was formerly using Kodak Image Viewer to view images in a form but im not on XP which doesnt use it so im trying to use Microsoft Office Document Imaging to view the image (.tif). However the code doesnt want to take the code i found on the MS website. the code im trying is...
  7. chrisjohns

    Display TIF image in Image control on form (XP)

    Hi! i have been wanting to place an image on my form using code when a certain value is selected in a table., However that only works with single images, not TIF's. Does anyone know how? This is in the XP OS with Access 2000. Ive not been able to use Image and Fax viewer in the code. A...
  8. chrisjohns

    Windows Image and Fax Viewer (Preview 1.0)

    Just tried a few more times and to no success, trying to find if theres an OCX to it as shimgvw.dll is the only thing i think is registered. I get the error (when checking in properties) A problem occured while db1 was communicating with the OLE server or ActiveX control. Close the OLE server...
  9. chrisjohns

    Windows Image and Fax Viewer (Preview 1.0)

    i was using the path of an image stored in my documents, path shouldnt be an issue but thanks for the notion
  10. chrisjohns

    Windows Image and Fax Viewer (Preview 1.0)

    Hi all, im trying to use thi but it doesnt seem to want to work for me. I added the control (shimgvw.dll) but when i use the command everyones been suggesting on other posts Preview1.ShowFile "<file path>", 1 I just get the error of 'Object Required' The properties in the control (of which...
  11. chrisjohns

    Query issue (where cell populated aswell as any of the other listed ce

    Hi, I have a query im wanting to run on a table but i cant get the syntax to work with it. Im trying to get it to display records where "DateJoined" is populated, and any of the other cells listed in the query are populated (be that 1, 5 or all). E.g Date ="01/01/01" Name = "" Surname = ""...

Part and Inventory Search

Back
Top