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

    Which runs faster DoCmd.RunSQL or db.Execute?

    Dear Friends, Which runs faster DoCmd.RunSQL or db.Execute? I prefer db.Execute because I use strSQL to load a tracer log file, a screen tracer text box. Not that you can do it also with DoCmd.RunSql, but I ran into a Access version bug with docmd and I tend to avoid it. What's the...
  2. m6

    Export Excel to HTML Web Page Width

    Dear All, I have a task that exports a range to an HTML page. In Excel the range is auto sized to fit standard paper for printing. When I open the HTML page in the browser and print, it covers 2 pages (just a bit too wide). Is there any way to modify the HTML page to fit better? or add...
  3. m6

    Excel 2000, VBA, Option Button Error 1004... Not grouped

    Here is the scenerio... 3 option buttons on an a sheet. Not grouped! No forms. Nothing fancy. Being green on the XL VBA code, I recorded the action as a macro, then converted it to the option button. Upon the click of the button, it simply copy's and pastes on another sheet. The code is...
  4. m6

    SQL Delete matching fields with 2 tables - simple but evading me.

    Yup, it's eluding me for some reason. 2 tables, the first table (tblData) contains 2 fields, txtField1 and Data. The second table (tblMatch) just txtField1. I want to delete all the records in the first that are matched in the second. txtField1 is the common between the two tables. my query...
  5. m6

    Excel 2000 VBA not passing class reqests to Brio

    I am using Brio Explorer 5.5 and Excel 2000. I have added the brioaddn.xla to the proper library and have added it in. The Excel toolbar indicates that Brio is active. When we execute a line of VBA code to open a query it chokes. The line is: OpenBrioQuery stFilename:="Test.qry&quot...
  6. m6

    Access Tables Max Column Field Resizing

    Here it goes... The Census dept of our lovely gov't dropped another installment on news agencies yesterday. Usually we get to test other states, but I am in NY and we got released first this time. The text files are 180 meg. compressed thus estimated exploded over 3 gig. They give us an...

Part and Inventory Search

Back
Top