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 derfloh 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: pa2
  • Content: Threads
  • Order by date
  1. pa2

    MS Access Insert Records Using Record Row Value

    Hello, This is my data in a table named Tablke1: RefID Date Date2 LineNo Des Num Months 4345 21/03/2005 28/06/2010 1 4 3 M 4345 21/03/2005 28/06/2010 2 4 3 M 4345 21/03/2005 28/06/2010 3 4 3 M 4345 21/03/2005 28/06/2010 4 4 3 M 62633 20/06/2007 18/03/2009 1 2 6 M 62633 20/06/2007 18/03/2009 2 2...
  2. pa2

    I need db with the What’s This btn working with ContextID help topics

    Hi All, I am trying to use the What's This button on an Access Form to return ContextID PopUp help topics when you click the What’s This button and then click on a Control on the Form. I have created the html .chm help file and it contains the necessary popup topics which have an ID number...
  3. pa2

    How can I get the What's This button to work on an Access Form

    Hi All, I am trying to use the What's This button on an Access Form to return ContextID help topics when you click the button and then click on a Control on the Form. I have created the html .chm help file and it contains the necessary popup topics which have an ID number. However when I set...
  4. pa2

    Link To .xls XML Spreadsheet in Access

    How can I link an MS Access database to an “XML Spreadsheet” which bears the excel icon and .xls file extension. Access links fine to “Microsoft Excel Workbook” but it won’t read files saved as “XML Spreadsheet” .xls? How can I link to the data in Access? Or does someone know the code I would...
  5. pa2

    Create a “Microsoft Excel Workbook” from Oracle

    Can anyone tell me if Oracle can produce a true “Microsoft Excel Workbook” instead of a “XML Spreadsheet” which bears the excel icon and .xls file extension but applications such as MS Access won’t link to because it needs to be a “Microsoft Excel Workbook”? And if so how?
  6. pa2

    Export Query Using "OutputTo" In Macro

    Hi, I have a query (complex and lengthy but perfectly OK) which I need to export as a .csv or .txt file using a macro, which I have set up. It must run from a macro so I can easily set up an auto macro to run. When I run the macro the .csv or .txt (I have tried both) is not generated free of...
  7. pa2

    Developing In Access

    Currently I develop in Access systems to suit the business. I use master and replica and synchronise them and the users access them through Server and Citrix. For best results and the direction to move in for the future should I: - 1. Change to Visual Studio and redevelop my existing db's in...
  8. pa2

    Excel Formula

    I need an Excel formula to perform the following: - row columnA columnB columnC columnD 1 243EB5012 243EB5001 243EB6000 2 2 69XY6018 69XY6001 69XY7000 1 3 243EB5432 69XY7001 69XY8000 3 4 83TU6574 5...

Part and Inventory Search

Back
Top