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!

Register Log in
  • Congratulations derfloh 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: TracySHC
  • Content: Threads
  • Order by date
  1. TracySHC

    Rebuilding Index

    I'm new to working with Informix database administration, and I understand from our vendor that we can improve system performance by rebuilding indexes on a couple of tables that are fairly fragmented. I've looked at the list of tables that our vendor recommends and they are not used in...
  2. TracySHC

    Arrow with Diagonal Stripes

    I'm new to Visio 2010, and have two diagrams with a variety of arrows - some arrows are two-way, some arrows are one-way. However, about 7 of the 26 arrows have dark spots on them, as if there's a diagonal stripe going through them. This does not show on the screen, but shows on color and...
  3. TracySHC

    Upgrade 8.5 Crystal reports to XI

    My organization has just purchased Crystal Reports XI Release 2. We are attempting to migrate over our reports written in Crystal Reports 8.5. So far, the links to the files are shown in the Database Expert, but the SQL query for the report does not show the joins between the files. As a...
  4. TracySHC

    Access 2003 Form Error Message

    I am currently building a new form in Microsoft Access 2003 over a table. When the Form Wizard reaches where the background can be selected, I receive the error message "Compile error. in query expression...
  5. TracySHC

    Combo Box concern

    Currently, I have a Microsoft Access 2003 form built over an Access table. For one of the text fields, I need the field on the form to be a combo box. At this point, I cannot populate the combo box's options. Is this due to the text field in the table not being a lookup field? I have tried...
  6. TracySHC

    Access 2003 shuts down when field is added to form

    I'm trying to add a new field to a form. The form is built off of a table. However, when I open the form, change the view to design view, open the list of fields, and add the field to the form, the Access 2003 project shuts down with the error message: "Microsoft Office Access has encountered...
  7. TracySHC

    Best practice for hidden fields on form

    I'm new to designing forms, and need advice on how best to proceed with adding a hidden field to a form. This hidden field is to be populated based on an entry to another field. Also, when the field on the form is populated, it must also populate its corresponding field in a table. (The form...
  8. TracySHC

    Form does not open when new field is added

    I'm relatively new to developing forms in Microsoft Access 2003. I have a project that automatically opens a form for data entry. This form is built over a table. If I add a new row to this table, and then add the new field to the form, the form will not open. What am I doing wrong? Thanks...
  9. TracySHC

    Maximize form and input new record

    I am a newbie to working with Microsoft Access 2003 forms, and need some advice to automate form functions. Is it possible to have a form open and be automatically maximized and ready for a new record? Where is the functionality for these features? Thank you in advance for any and all help and...
  10. TracySHC

    Record-locking with an append query

    I'm new to the record-locking problems in Access, so please let me know if I'm posting this question in the correct forum. I have a form which updates a table. An append query uses this table to update another table. If I have a value entered on the form (so the record is locked for editing)...
  11. TracySHC

    Updating record without exiting record on form

    I have a form which lists multiple records from a table (each record only needs one field updated), and which also contains a control button. If the user enters a value in this one field of a record on the form, then clicks on the control button, the value is not recorded in the underlying...
  12. TracySHC

    The data has been changed. Re-edit the record

    Please let me know if I am in the right forum for this question. I have a Microsoft Access 2003 mdb which calls Form A. Form A collects the criteria for Form B, which displays a list from which the user selects. When the user clicks on the selection field, the error message, "The data has...
  13. TracySHC

    Printing hyperlink photographs

    I have a file in a Microsoft Access 2000 mdb which is a listing of people's names. By the last name and first name columns, there is another column which contains a hyperlink to the person's photograph. Does anyone know of a way (or which software to use) to print out a document which displays...
  14. TracySHC

    Locking original message in Outlook 2003

    I'm trying to send an e-mail in which I would like to have the changes indicated in the replies. Is there some way to lock down the original message so that the repliers are forced to write their replies? Is it also possible to have all changes to the original message be returned in a...
  15. TracySHC

    Locking original message in Outlook 2003

    I'm trying to send an e-mail in which I would like to have the changes indicated in the replies. Is there some way to lock down the original message so that the repliers are forced to write their replies? Is it also possible to have all changes to the original message be returned in a...
  16. TracySHC

    Error 3011 for TransferText

    Please help - I'm using Microsoft Visual Basic 6.0 for Microsoft Access 2000 on Microsoft Windows XP Version 2002 with Service Pack 2. I'm using the following code: DoCmd.TransferText acImportDelim, "", "AccessTableFile", "P:\MainDirectory\SubDirectory\file.csv", 0 When I run this VBA code, I...
  17. TracySHC

    Creating a complete drill-down report

    I am creating a report which is grouped by State, County, City, and Store Number. What the report users would like is to see the State sales totals initially, and be able to drill-down and print out reports for County sales totals, City sales totals, and Store Number totals. With drill-down...
  18. TracySHC

    Command button for VBA module

    I'm new to Access, and I'm not sure how to proceed on this issue. I have written a Visual Basic module, and would like for the users to run the module by clicking on a button. How do you create a command button that will run a module? Thank you for any and all advice, TracySHC
  19. TracySHC

    TransferSpreadsheet order

    I'm trying to import an Excel spreadsheet in its data entry order - just as it currently exists. Whenever I use TransferSpreadsheet, the Access records in the file end up in alphabetic order. How can I transfer in the spreadsheet in its data entry order? Thank you for any and all help, Tracy SHC
  20. TracySHC

    Carriage Return in Access field

    I need to export an Access file into another software package. This other software does not accept blank or null fields very well. However, if a carriage return is entered in the Access field, the field can be exported from Access and imported into this other software without a problem. How...

Part and Inventory Search

Back
Top