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

  1. psudeke

    Embed Word doc in Excel spreadsheet

    You were correct, you want to Insert, Object, Create from File, Select the file, click Display as Icon, just don't check the box for Link to File. Unfortunately, it seems to embed the whole path as part of the file name, I don't think there is an easy way to fix that. But that may have been...
  2. psudeke

    Importing Excel spreadsheet

    What type of data is the field. What access does is base its descision on the data type of the field on the first 24 records of that field. If its picking up a number data type and record 26 has text, it won't be able to import the text value. In excel, text values align left and numeric...
  3. psudeke

    Invalid Web Query

    I have a user in E2k that gets an error "Invalid Web Query" when running a web query. It seems to run fine until he makes another application the active app, and then switches back to excel. I can't find any documentation on this error and was hoping that someone had experienced...
  4. psudeke

    Launching Access from Excel VBA using SHELL

    What error message are you getting, there shouldn't be a problem with spaces in the path name?
  5. psudeke

    restoring PST, contacts do not show up in Address Book

    Have you tried to import the pst file into contacts folder?
  6. psudeke

    Word 2000 Mail Merge with Access 2000

    Show the field codes for the merge field and add '\@ "h:mm am/pm" ' before the last brace } (without the single quotes) that should give you the correct format.
  7. psudeke

    Excel Macro Question

    Is it on the on close event for the workbook?
  8. psudeke

    low on resources

    Try deleting temps, run search for *.tmp, and delete all that appear.
  9. psudeke

    EXCEL 2000 - BLANK LINE BETWEEN GROUPS

    Here's some code you can modify to your needs, just change the range "a1" to your first cell in the list and "a2" to the second, should work fine. Sub InsertRows() Dim x As Integer Do While Not Range("A2").Offset(x) = "" If...
  10. psudeke

    outlook mapi

    I believe its actually part of the security patch. There is a way to disable it thru the security settings (I think, don't have it installed)
  11. psudeke

    disabling the office shortcut bar at startup

    Remove it from the startup folder, in the programs menu, that will disable it.
  12. psudeke

    OL2000 default mapi settings?

    Thanks, yeah that didn't work. Unfortunately I can't uninstall/reinstall ccMail right now. I wish I could just get rid of it, our clients don't use it, we don't use, but hey, thats corperate politics for you. Thanks for your help
  13. psudeke

    OL2000 default mapi settings?

    Thru the Internet Options in the control panel
  14. psudeke

    OL2000 default mapi settings?

    This is kind of a complicated one, basically because of my setup. First of all, on my PC I have Office 97, Office 2000, ccMail 6 and ccMail 8 installed (I think one of these is the culprate, however I could fill this message with all the apps and versions on this PC) running on a Win98 platform...
  15. psudeke

    97' upgrade

    Well, sorry to say, there is no suggestions other than get everybody upgraded as quickly as possible. The ldb (locking database file) that access creates is exactly compatible between the versions. Your only other option would be to create a 2000 version of the database and have those users work...
  16. psudeke

    Animation on Powerpoint

    I assume you're working in PPT97, 97 does not support animated gif files. That feature is available in 2000. Sorry for the info.
  17. psudeke

    Can't find Relative Reference Button for macros in Excel 2000

    ...list. If, for some reason that's still not available, try searching for and renaming your <user>.xlb file. Its the toolbar file for excel. Just run a search for *.xlb and look for one that has your user name as the name. Rename the file and restart excel, it will create a new one. Good luck
  18. psudeke

    Can't find Relative Reference Button for macros in Excel 2000

    When you start recording a macro, a toolbar should appear with the button on it. I'm assuming, because you made this post, that toolbar does not appear. What you need to do after starting the macro recorder, go to View, Toolbars, Macro and the toolbar will appear. You probably want to stop...
  19. psudeke

    Excel time compare

    If I understand you correctly, you can do it with an if statement. Lets say &quot;a1&quot; has your first start date and &quot;b1&quot; your first end date. In C1 put the formula =if(b1>a2,&quot;Error&quot;,&quot;&quot;) and drag it down the column (Where &quot;error&quot; is what ever you want...
  20. psudeke

    trigger event in excel when user clicks Save as

    I would put the code in the On Save event and place an if statement to test to see if the file name that is being saved is the same as the main file.

Part and Inventory Search

Back
Top