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

    Cause Crystal to print more than one copy

    I would like to print 3 copies of a report, changing the footer information on each copy without having to make a 3 page report. Thanks in advance
  2. jamierobinson

    Formula not calculating unless details band is suppressed

    Crystal 10.0 db is SQL Server 2000 using OLE DB The formula counted items by group and displayed the group totals in the report footer as a summary. The formulas also would appear in the header when the detail was hidden/suppressed. Sorry I don't have more infomation. I didn't save the report...
  3. jamierobinson

    Formula not calculating unless details band is suppressed

    Does anyone know why a running total based on groups won't show in the header unless the detail band is hidden or suppressed?
  4. jamierobinson

    Access Add-ins not saving

    When I try to add the OFFICE.MDA add-in to Access the add-in will not save. Any ideas why this should happen? TIA -jamie
  5. jamierobinson

    Default value in text box

    Is there any way to set the default value in an unbound text box in an Access report? -jamie
  6. jamierobinson

    Folders won't open in same window

    OK... Here is what I have for the CabinetState key in both HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\CabinetState and HK_USERS\<userID>\Software\Microsoft\Windows\CurrentVersion\Explorer\CabinetState The data in Settings, for both keys is: 0c 00 02 00 0b 01 f8 75 60 00 00 00 What...
  7. jamierobinson

    Folders won't open in same window

    Thanks for trying, Dian, but I know all that. I am really looking for the registry setting that controls how a folder opens, and the value that makes it open in the same window. Anyone else have any ideas?
  8. jamierobinson

    Folders won't open in same window

    Dian- Thanks for the reply but I have done that (interface). It doesn't stick. That is why I was looking for a registry edit to acomplish the same thing. -jamie
  9. jamierobinson

    Folders won't open in same window

    Does anyone know where, in the registry, the option to open each folder in the same window is? I can't set this option through the interface. The OS is WinXP Pro SP2 TIA - jamie
  10. jamierobinson

    Converting data in a lookup

    Thanks Geoff... But I also want to convert the array side of the equation. Any ideas? -jamie
  11. jamierobinson

    Converting data in a lookup

    I would like to do a vlookup, or index/match, on data of one type to an array of data of another type. Example: the lookup value is text and the array is numeric. I need to convert both the lookup value and the array to the same type of data without actually having to reinput the data to effect...
  12. jamierobinson

    Extra Personal Folders

    Thanks to all who offered suggestions. Creating a new profile removed the folders from the folders view. -jamie
  13. jamierobinson

    Extra Personal Folders

    Thank you- That removed the files from my computer, but they are still listed in the folder view, in Outlook. Any idea how to remove the listings?
  14. jamierobinson

    Extra Personal Folders

    In Outlook 97 I have created additional Personal Folders, by mistake. How do I delete them, in Outlook? I have tried renaming the .pst file, but the additional Personal Folders still appear in the Outlook folders view.
  15. jamierobinson

    Running code with the enter key

    I have a search form, with a text box for the item to search for, a search button and a quit button. If the user presses the enter key after entering the item to search for (in the text box) I want the search to start. Currently, depressing the enter key just moves the focus to the search...
  16. jamierobinson

    Enable Macros prompt at Excel start up

    I have an Excel spreadsheet with macros. I would like to force the macros to be run, or the workbook closed if the macros are not run, when the workbook opens. Can I make the workbook close if the &quot;disable macros&quot; option is chosen when the workbook opens?
  17. jamierobinson

    Print setup causing error message

    Thank you for your post. Error handling corrects the error when you try to cancel the dialog box, but when you click on the setup button (ion the print dialog box) you still get an error.
  18. jamierobinson

    Print setup causing error message

    I am using the command &quot;DoCmd.RunCommand (acCmdPrint)&quot; to call the print dialog box from a form. When I try to change the printer setup, using the print dialog box &quot;Setup...&quot; button, I get an &quot;action can't be carried out&quot; error message. Any way to get around this...
  19. jamierobinson

    Count of records when no records are returned

    Rolliee- No code... Just a query that asks the user for a search string as a criteria. The search field is a free form text field and I am using: Like &quot;*&quot;&[What do you want to query on?]&&quot;*&quot; to prompt for the search string. A text field, in the resulting form, displays the...
  20. jamierobinson

    Count of records when no records are returned

    I still get a blank field. Could it be the fact that I am running a parameter query? Or could I have the field formatted incorrectly? I have the field in the header of the form. Should it be somewhere else. Everything works as long as there is data returned by the query.

Part and Inventory Search

Back
Top