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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by psudeke

  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...

Part and Inventory Search

Back
Top