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

    Trapping USERIDs

    HTML or JAVA or ...? I wonder if there is a simple way to trap "visitor's" userids and save them to a file, behind the scenes? A client of mine is curious at to who is "dropping by" her site ... this has nothing to do with wanting to get back to the browsing individual...
  2. sjpistolesi

    Passing a Value to Next Group

    ACCESS 2000 Report ---- Think I'm getting old ... just cannot wrap my brain around this one. Slightly different challenge. Reporting monthly transactions with previous month's totals as a starting point and summing each month's transactions is working OK .... but there are months without...
  3. sjpistolesi

    INDEX ON .... COMPACT FOR EMPTY(varname)

    Need help understanding the subject command. What would be the result when using "INDEX ON" .... "COMPACT ON EMPTY(varname)" combined in the same statement/command?? Trying to comprehend the meaning of this legacy code. Thanks, Sandy
  4. sjpistolesi

    listbox disabled

    [ACCESS2000] For some reason, a listbox I developed is not allowing the mouse clicks inside the listbox. It is set for [RowSourceType] = Table/Query and I'm using an SQL SELECT statement for the [RowSource]. Yes, it is enabled. I've tried using the [Multi Select] "single" as well...
  5. sjpistolesi

    XL97: Display 2-columns in list box field

    I have a user form, which displays only the 1st of 2 columns once item(s) is selected. How can I display the values from both cells in the range selected? Thanks, Sandy
  6. sjpistolesi

    "A program is trying to [execute ] / [access] "

    Outlook 2000; latest security patch effect I created a function that assisted my users in forwarding inbound messages and setting specific options, to save them steps. Along comes the SysAdmin types installing the latest security patch and now the users are getting the following dialog message...
  7. sjpistolesi

    Private Toolbar?? (Excel 2000 version)

    Excel 2000: I have a spreadsheet with protected regions ... to prevent user errors and preserve "roll up" integrity when I get them back. I'm establishing simple editing tools for me to use here ... unprotecting and protecting with an embedded password. But, when I send out the...
  8. sjpistolesi

    Scroll "button" for Workbooks

    A client of mine complained the other day that, after upgrading to Office 2000, she lost her scroll button that she had on the bottom which assisted her in scrolling from worksheet to worksheet in an active workbook. I don't recall seeing such a critter before ... anyone know about this? Sandy
  9. sjpistolesi

    Outlook VBA: Forward Selected Inbox Msg

    Env: Outlook 2000 / Windows 2000 I've figured out how to generate a "new" message and modify it for my user, to save her repeated/redundant steps of establing specific option criteria in a new message she wishes to send multiple times in a single workday. Now, she asks me to do...
  10. sjpistolesi

    xl2000 Get Table Date from ACCESS2000

    In ACCESS2000, I wrote a function that obtains a table date, "last modified." Now, I want to perform the same function from EXCEL2000, extracting the same ACCESS table's "last modified" date. How do I do that from Excel? Thanks, Sandy Pistolesi
  11. sjpistolesi

    xl2000: 3-D Linking

    I have a large detailed inventory and multiple customers. The inventory is grouped by type of course. When I change a detail in a specific inventory line item row (within a group), how can I use a master spreadsheet or workbook to immediately update that item's change? Instead of [painful...
  12. sjpistolesi

    xl2000: Locate/delete Links

    How do I locate all links in a workbook and then delete them? Sandy
  13. sjpistolesi

    xl2000 SAVE AS ".dbf" not Backward Compatible

    xl2000 to (dBASE III) .dbf: Environment: Office and Windows 2000. Cannot save as dBASE III format and have the resulting file be readable by dBASE or CLIPPER. Before you get into "why not upgrade," please know that we are reengineering the legacy systems ... but until they are...
  14. sjpistolesi

    Here's a Challenge

    ACCESS2000: Number of items in a control box will vary when gathered by a query. Would like to resize the control list box to shrink if just one or two items and grow if the number of items in the list are equal to 6 or greater to display the first 6. Silly, I know when a user can scroll...
  15. sjpistolesi

    Modify Vote Button

    Version: Outlook2000 I need to add a third selection to the default voting and tracking button: Change "Approve;Reject" to "Approve;Reject;Return" Where do I make this change, to prevent my user from always having to type it in?? Sandy
  16. sjpistolesi

    Import from Development to Production Woes

    [newly upgraded to ACC2000; Windows2000] I am having serious problems importing into [existing] production version of an application, new/revised forms and their modules from the [different network location] development area. Why??? Symptoms I've observed: [1] When using import from the...
  17. sjpistolesi

    Cannot Archive

    Outlook 2000; Windows 2000: I keep getting the following error when attempting to archive. "Error while archiving folder "InBox" in store "[my mailbox]." Some items could not be copied. They were either moved or deleted, or access was denied." FYI, our network...
  18. sjpistolesi

    Twist on Table [Last Modified] Date

    [Access2000] I need to add to my report the date a table in a database was last modified. When looking at a list of Tables, you can see the column "Modified." But, researching all my available reference materials and TechNet cannot discern how to extract that date for use in my...
  19. sjpistolesi

    EXCEL 2000 (It was suggest I pos

    EXCEL 2000 (It was suggest I post this question to the Office Forum) I keep running into the following error. Regression Error: Inputs must be continguous reference. I've check the Microsoft site and books for information; but to no avail. Have tried deleting the row and re-entering...
  20. sjpistolesi

    Report Challenging

    ACCESS 2000: I'm moving a DOS programmed [old Fox-Pro and previously CLIPPER] legacy system to ACCESS 2000. I'm trying to group by a specific of ACCTID, but not in ascending order, which appears to be the only selectable criteria. [1] Must first group by ACCTID and ACCTCODE(ascending the...

Part and Inventory Search

Back
Top