Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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