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

    Combo box resizing on drop button click

    thread707-1606291 My first attempt at VBA includes a combo box that starting today has the text within the box getting smaller and smaller everytime it is selected. I have tried changing the Autotsize properties from Tur to Fals with no change. Here is the code: Private Sub...
  2. paulcedarhill

    New mail set up error "Outlook must be online"

    Issue: Cannot set up new e-mail profile for Outlook 2010 Windows 7 operating system on hosted Outlook Exchange 2007 server at GoDaddy.com. I enter all the parameters exactly as described by the GoDaddy support team, but the error always comes up "Outlook must be online to connect". The supprt...
  3. paulcedarhill

    Outlook 2003 Exchange Shared tasks

    We are just starting to use shared tasks for our project managmente teams. Can't seem to be able to add notes to the body of a shared task. We have given author permissions to all share parties by name.
  4. paulcedarhill

    adp connection to SQL

    We lost a terminal server and had it rebuilt by someone unfamiliar with the active directory. terminal server is windows 2000 SP 4 sql server is on an NT 4.0 Access 2002 SP 3 SQL 6.0 We now cannot get an ADP project, existing or new to connect to our sql server. We are able to locate the...
  5. paulcedarhill

    excel macro write reserve

    I am a novice programmer trying to write a macro to save a write protected fil. The macro is activiated through a control box, after the file has been opened with read/write priviledge. I get an error saying file is write reserved. Here is tha code for the save, that was recorded through...
  6. paulcedarhill

    filtering unique records within subtotal

    I have a bid list that may list multiple entries for the same project. bid date project $ contractor 5/12 a 100 abc const 5/12 a 100 bcd const 5/14 b 300 abc const 5/16 c 100 bcd const I need to know the total number of unique...
  7. paulcedarhill

    Exclusive use of file

    We share on the network an excel 2000 version 9.0 file that uses MS Query within the workbook. We have protected write permissions using the tools/options/password to modify command. When ever a user has the file open with the password to modify only the file creator can access the file. All...
  8. paulcedarhill

    Mixed Excel data in MS Query

    I have mixed data in a field that is queried from a excel 2000 table. Even after formating the cells as text, the cells that are inputted as numbers do not display in the query results. Only after I insert the ' prefix in the data field do they display. Is there a setting somwhere to modify this?
  9. paulcedarhill

    ODBC Query permission error

    We share on the network an excel 2000 version 9.0 file that uses MS Query within the workbook. We have protected write permissions using the tools/options/password to modify command. When ever a user has the file open with the password to modify only the file creator can access the file. All...
  10. paulcedarhill

    Microsoft Query in Excel 2000

    Is there a way to bring spreadsheet cell formatting back to an excel spreadsheet through a query? We use shading to reflect shipping status and I am trying to build queries that will develop a shipping calendar. Having the graphical indication of project status is key.
  11. paulcedarhill

    Change sales order

    I run a small construction company, many times we get changes to our sales orders months after the initial order. Rather than change accounting periods in order to make a change to the initial order, how are others answering this problem? I have to be able to tie the costs back into the initial...
  12. paulcedarhill

    Explorer image preview

    Is there a way to turn off the image preview function in wondows explorer? I have to access folders with multiple GIF files in them and the auto generate preview really bogs down my processor when I open the folder. I cannot open a file until all the thumbnails have been generated.
  13. paulcedarhill

    Linking by formula field

    Using Crystal 10 with a sql database in ODBC I need to be able to link to a table using a formula field. I need to be able to print a sales rep's name from table.users that is read from one of 2 fields in table.contacts, contingent on the value of a different field for product line in...
  14. paulcedarhill

    Limiting data access

    We have a sql database run with an Access ADP project for all our sales reps contact info. Within those we have multiple levels of permissions so that reps only see their contacts and managers can see everything. Is there a way to push those permissions into Crystal Pro ver 9.2? Just having...
  15. paulcedarhill

    Multiple detail

    My problem, I need seperate, multiple lines of data from 2 different tables, selected by 3 teirs of groups. basically: Group 1= Region id Group2 = sales rep id Group3 = project id detail a = all records in table.activities detail b = all records in table.specifications right now the report...
  16. paulcedarhill

    ODBC Link to Navision 3.6

    I have a problem with an ODBC link to a navision360.dsn data file. I am able to make the connection, poll the tables for fields and establish table links. When I try to preview the data, the cpu spikes to 100 % usage and crystal becomes unresponsive.
  17. paulcedarhill

    Changing File extensions

    ACT 2005 premium for workgroup just grabbed all my crystal report files and changed the association. I can open them with the "file open with" option but the "always use" and "advanced" buttons are greyed out. Any ideas how to re-claim these as Crystal? Best software of ACT fame does not have...
  18. paulcedarhill

    CR 9 Using Date as group header

    I am trying to build a back order report where the records are grouped by ship date, which is a time date stamp in Navision. when I preview the report it automatically groups the ship dates by week and only prints the Sunday date of the week. How can I group by individual ship dates? The...
  19. paulcedarhill

    Moving formula fields to a differnt report

    I am linking to a sql database where the original programmer stored phone numbers as strings and an input mask to make the screen view look right. I have just finished writing all the formulas to make them look like phone numbers in crystal but now I need to transfer these formulas to about 50...

Part and Inventory Search

Back
Top