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

    Err Msg: "MS Jet database could not find object..."

    Met up with the same problem from a db table created from a third party software. Foxpro 2.5 had no problem. Access choked. Thanks for the quick and accurate answer to my problem.
  2. m6

    Computer keeps rebooting after SP2

    Much thanks for the info also. Co worker's kids plowed their XP SP2 and system went completely nuts. Took a while to get around Dell's boot, but you info put it right back on track. The floppy boot for recovery bites though. Was there a boot cd method (for next time)? Tx, m6
  3. 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...
  4. m6

    Cannot remove module HELP!

    Dear zinja, I had a similar problem about 4 yrs ago, finally resorted to rebuilding the Access database by importing all by that one item. Seems there is an object reference in the hidden structure of Access that remembers there used to be a module attached to the report. Even building a...
  5. 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...
  6. m6

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

    Dear Zanthras, I learned the point was to Activate the worksheet where the work is being done. I couldn't find this anywhere. Thanks for the help, it worked like plug and play. I was trying use to option button from the report page to copy/paste on the Math Page then return focus back to the...
  7. 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...
  8. m6

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

    scriverb and ajdesalvo, Logically, since the data to be deleted is worthless, then changing field data to indicate "DELETE" is valid. Then the delete is within the single table and should be much faster. Again, thanks for the help and understanding. PS I may submit this for a FAQ...
  9. m6

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

    Much thanks, that was the rub, just too many other problems to concentrate! m6
  10. 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...
  11. m6

    Specifying Defaults in an SQL statement

    Sure, just put it in a string and concat in the beginning and ending date. Be sure to use # to tell jet it is a date field (if that is what it is). ex.strSQL = "SELECT Funds.Date, Funds.Trak FROM Funds WHERE (((Funds.Date) Between #" & BegginingDate & "# And #" & EndingDate...
  12. m6

    Automation with Adobe Acrobat Writer

    Robert, Although this is not the direct answer, I had my intern work on a similar project with Postage statements (I fill out about 30 per week). She mentioned that simple math is easy, but any other work had to be done in Java. We were considering tying the pdf's to a mdb for an effective...
  13. m6

    Need Your Advise

    What kind of connection to your data are you using, ODBC, ADO, RDO, DAO....?
  14. m6

    Circular Reference ?

    Dear essnvr, Try putting the table name in front of you select field names. Insert Into [Inventory Physical Count] Select [Physical Count Temp]![Batch Number] ,[Physical Count Temp]![Page Number],[Physical Count Temp]![Line Number], [Physical Count Temp]![Item Number],[Physical Count...
  15. m6

    How do select a file using the a dialog box.

    Many have asked this so here it is from several contributors, thanks to all whom have replied to this repetttttative question. Writing your own using the toolbox items is just not necessary. There are many threads, but this works well. I will start including others later. Bear in mind...
  16. m6

    how do i remove quotes and double quotes

    Dear wheels27, Yes, an update query and there is a 2 fold problem to the find and replace depending on what version of Access your on. 97 doesn't have and one of cohorts here has a great one as a function in a module. 2000 has a replace function. Tx, m6
  17. m6

    SQL in VBA Problem. Semantics?

    Dear Karrasik, Looks like you have a set of single quotes near the parens.(). Give it a shot. Tx, M6
  18. 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...
  19. 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...
  20. m6

    FoxPro 2.5:using mouse under windows 2000

    rgbean and others - THANK YOU!! But be sure to change the properties of the open Foxpro window, not the shortcut or direct file. I never got the Quick Edit button on just straight properties and thus I relearned the keyboard. Tx, m6

Part and Inventory Search

Back
Top