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 Mike Lewis 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. CathieB

    Compile Error in query expression

    THANK YOU GOLOM. Does the SP3 reset this option?
  2. CathieB

    Compile Error in query expression

    I am programming in Access 2002, Using Windows 2000. I installed the new SP3 to my computer, and now when I try to create a query using the tables in access, it adds all the fields to the query, even if I have only added one. And I am getting compile errors in all my queries.... Does anyone...
  3. CathieB

    Word Merge Print Question

    I am using MSWord XP. I have a word document that has three pages as part of the document. I merge the document and I get three pages for each one of my records, but I only want to print pg 1 for each one of the records in each section. Does anyone know how to do this easily. I have tried...
  4. CathieB

    Protecting folders in Microsoft Word

    You can create a folder and assign Security to the folder, what version of MS are you using, in Version MS XP, you would create the folder, then right click the folder and go to Properties then go to the "Sharing" Tab. You can have it so that no one can go in it but you, or you can...
  5. CathieB

    IS Null or =""

    Thank You both for your help!
  6. CathieB

    IS Null or =""

    I am using Access 2002 sp 2 on a Windows 2000 sp 2 computer. When writing a query or code and a field is text or a string, what is the difference with an if statement when asked as follows, because I get different answers with each statement, and don't understand why. Iif([field]="&quot...
  7. CathieB

    how to make access form

    Create a form that uses the table called members. Then Create an append query that uses the query from the form . Create a button on the form that runs the append query and appends the information into another table which has those fields as text.
  8. CathieB

    Access Reports

    Thank you very much SMedvid. Now I would like to throw a wrench in the question. The Report has Groupings on it. Each grouping could fall on many pages, now the client wants the grouping header with Cont'd if the grouping is continued on to another page. Is that possible? Thank you again
  9. CathieB

    Access Reports

    I have Access 2002 and have a report that has about 100 pages, I would like to put Cont'd in the Page header on all pages except for the first. I would appreciate any help in making this happen. Thank YOU
  10. CathieB

    Need to Create an Array

    I guess what I really need is a recordset. I'm kind of new to VB, but have been working with Access for a very long time. When I asked another Programmer (4d) for help, I was told what I needed was an array. I am using this for a show all form, where the Partners Name is in one field, and all...
  11. CathieB

    Need to Create an Array

    I have an access 2002 database where I have two tables, a Fund table which lists funds and a Partner Fund table which associates many partners to many funds. I need to create an array that lists the partners once in one field and have another field that holds all the funds that they are in...
  12. CathieB

    OPENING MICROSOFT WORD FILE FROM ACCESS

    If you hyperlink the file to a button, or label it will open the file also. In the properties of the button or label, click on format, click on hyperlink address, click the three dots, browse to the file, click okay.
  13. CathieB

    Update Access DB with Word Macro

    I am trying to update an open Access DB with information from a MS Word Macro, the problem is that it will not update the field, and I don't know what is the problem. It runs through the whole macro, and does not give me an error message. The following is my code. Dim DB As database Dim...

Part and Inventory Search

Back
Top