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

  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

    Does anyone know why a running total based on groups won't show in the header unless the detail band is hidden or suppressed?
  3. 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
  4. 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
  5. 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
  6. 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...
  7. 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.
  8. 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...
  9. 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 "disable macros" option is chosen when the workbook opens?
  10. jamierobinson

    Print setup causing error message

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

    Count of records when no records are returned

    I am trying to have a field, on my form, display "No records found" when no records are found and the number of records when records are found. I have a query that asks for input from the operator and I have a field that counts [count(*)] the records returned, but when no records are...
  12. jamierobinson

    Link to SQL tables slows parent application

    I am linking access 97 to MSSQL7 data tables. While I am working on a form that accesses the data in the SQL tables, the parent application is unable to access the SQL data. Is there a way to make the data available to both applications, at the same time, without conflicts? Thanks in advanced...
  13. jamierobinson

    Sort order of groups

    Is there a way to change the default sort order for groups to desending instead of ascending? I am using Crystal 7.
  14. jamierobinson

    Win2000 Pro maps additional drives

    My new Win2000 Pro Sp3 computer maps additional drives on its own. The mapping isn't persistent. They will disapear on reboot. This goes on until there are no more letters to map to. These are repeats of the shares that I configured drive mapping to. Any ideas how to stop this? Thanks, -jamie
  15. jamierobinson

    Excel footer font size

    I have the following macro that inserts the filename into the left footer of an excel spread sheet. How do I change the font size to 8 point? Sub InsertFooter() Dim myString As String myString = ActiveWorkbook.FullName & "\" & "&a" & " - " _...

Part and Inventory Search

Back
Top