Search results

  1. M

    Mail Merge Field Names

    I have documents created though a mail merge that are saved on an intra-net. When I open the documents everything looks fine. When I print the documents everything looks fine. My issue is when someone else opens or prints the documents, the last mail merge field does not show the data but...
  2. M

    Conditional Format over the Intranet

    We have an excel spreadsheet that has conditional formatting on it. When a date exceeds a certain # of days, the cells change color. It works great on one computer. On other computers, the conditional formatting does not work. It is saved on the intranet within the company. What is wrong?
  3. M

    Query Doubles Quantity

    I'm sure that this issue is simply. I've done it before, but for some reason I'm having problems today. :confused: I have 4 tables in one database as follows: 1) Sort Table = Sort # Sort Date Qty Sorted Qty...
  4. M

    Mass Change on hyperlink

    I have several thousand hyperlinks that need to be changed due to our network server being changed. I have tried to change the hyperlink field to a text field and do a find and replace. (See mandaman post 3/13/06) The problem that I have is that all the hyperlinked fields have a different text...
  5. M

    Query not finding all the correct unmatched records

    I have several tables that I am trying to get information from: Clock Number Table with fields: Clock #, Name, Title, Dept, Term, HireDate, & TransDate. Completed Training with fields: Clock #, Data Completed, Doc # & Rev Level Linked Table, Controlled Documents with fields: Doc #, Title...
  6. M

    Create an Exception Report

    I have a database that contains several tables relating to training. One table contains associate names, departments, and clock numbers. One table is linked to another database and contains document numbers, titles, revision levels, and effective dates. Another table is used for completion of...
  7. M

    Lookup Field

    I have a lookup field in my form that looks up data from another table. My problem is that when I type in the first few characters of the field it does not go to that record. You can scroll down to the record and select it by clicking your mouse, but I want to type a few characters to find...
  8. M

    Problem with zero in my query

    I have a table with a drop down field in it. The info you select is stored in the field named Clock #. It works fine. When I try to run a query on this table using this field, I can only get it to run if I show all the records. When I specify a particular Clock #, I get nothing. The field...
  9. M

    Recordset is not updateable

    I have a database that is split into front and back ends. I have 35-50 users with read/file scan rights only set by our MIS Network Administrator. My department has read/write rights to the database. I am the only person that uses the database though. My problem is that when certain people...
  10. M

    Upgrading to Access 2002

    We will be upgrading our system to XP by June of this year. I currently have a large Access database created in Access '97. I have been told that there will be "Major" problems with my database. Currently I have about 20 users, but by June, I may have 50 users. Is there anything that can be...
  11. M

    Hyperlink not working

    I have created a database that contains many hyperlinks. After I created the database, I split it into a front and back end. I then made several front ends by copying, pasting and renaming to be used by numerous individuals not needing the same information. My problem is that the initial...
  12. M

    Compact problem

    I have a database with a front and back end. When I compact the database from the front end, I lose the tables with the arrows beside them. I also get an error that the file has been deleted. What's going wrong?
  13. M

    Totals for time fields

    I have a database that has start and end times in it. In order to find the amount of time spend, I created a calculated field in my query. I used the following formula: Format([StartTime]-1 -[EndTime], "Short Time") My query works great, but when I attempt to run my report I get an error...
Back
Top Bottom