Search results

Mail merge field names are the titles above the columns in the excel worksheet that are being merged into the word document. EX: City, State, Zip, etc.

Hi, I'm not sure that I understand your question. The fields that are in my mail merge were created in an excel worksheet. Using the mail merge wizard, I imported that data that I wanted from the excel worksheet. Hope this helps.

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

If the date exceeds 10 days the cell turns red. When the date is met the cell turns green. Otherwise the date is cell is white.

It was done in traditional conditional formatting. We are using the same version of excel.

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?

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

That works on the hyperlinks that I do not have a display text in the field. (maybe 12) It will not work on the other fields. Any other suggestions??

Are you trying to put the formula in the table or in a query?

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

Neil, Thanks for your reply. You are correct in assuming that Data should be Date. (Typo) I tried your suggestion, but it did not produce the records I am looking to receive. When I run the first query (Clock #), I get only employees who have no training records for any document if I place...

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

:) Thanks Aleb. With a few modifications, that worked well. SJ McAbney; I realize that the database is poorly designed, but I am working with a database that was created, managed, and owned by another department in our company. It just happens that the database that I control is linked to...

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

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

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

Thanks, Pat. I think we have the problem resolved.

Then if I understand correctly, the only option I have is to give everyone read/write rights through the intranet, and to set up Access security. Is this correct?

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

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