Search results

  1. A

    Update the second table with the same item # and description using a query

    Thank you Pat Hartman, I appreciate your note. Could you please let me know where your query is?
  2. A

    Update the second table with the same item # and description using a query

    Both my boss and I appreciate your suggestion MajP to have professionals look at our database problems. We have some problems. When forms # 01, # 02 and number # 03 are opened from the main menu, there is no Menu Bar (File, View) on these forms. But when opened directly the Full Menu Bar is...
  3. A

    Update the second table with the same item # and description using a query

    New Experience. In the past we had been able to solve our MsAccess 2003 problems internally and with the help of the nice people in the forum. This time we were stumped even with the help of the Forum Group. A professor at the local Computer Science College offered our problem of connecting the...
  4. A

    Update the second table with the same item # and description using a query

    Thank you for your suggestions, which I appreciate.
  5. A

    Update the second table with the same item # and description using a query

    Thank you for your suggestion and after creating a new database and its forms, I am having some problems. The Query returns the results I was looking for. I cannot enter any data using the Form or Query. BUT I can edit data in each of the tables in the query separately. Could I please get a...
  6. A

    Update the second table with the same item # and description using a query

    Thank you * * * Majp for your suggestion THAT WORKS and which I * * * appreciate. The main table in our database does have 103 fields, so I thought a new table would be helpful. The data that we use comes from MANY different sources and is manually entered into the database. I am sorry but I do...
  7. A

    Update the second table with the same item # and description using a query

    I do appreciate all of your comments. We are trying to do 4 different comparisons for each of the stock codes at different time elements. Our table”01” currently contains 103 fields, with the Primary Key “Symbol_Stock” I thought that we could create a new table “01K” with the required fields to...
  8. A

    Update the second table with the same item # and description using a query

    Can we please get a suggestion on how to create a query to update the same item from two different tables? The second table has four choices, but has the SAME COMMON NUMBER? We do not want to again enter the same COMMON NUMBER in the second table again. Thank you. Nicole
  9. A

    Preview Report Then Print 4 Copies

    P.E.F.E.C.T., 100% Thank YOU arnelgp
  10. A

    Preview Report Then Print 4 Copies

    Thank you for sending us your database, but we cannot open it because of the "Unrecognized Database Format" message. Could you please send us another database. Thank you very much
  11. A

    Preview Report Then Print 4 Copies

    The BLANK TEMPLATE is used for the user’s research and is then completed MANUALLY. The updated research report data is then entered into the volunteer's database. Once we have help with the code, I will create more templates for our other research projects. We do not want to use a Word...
  12. A

    Preview Report Then Print 4 Copies

    Thank you for your question, mike60smart.
  13. A

    Preview Report Then Print 4 Copies

    Please open the database and use Ctrl + E to open up the report, that we would use or look at the report => Print_4_Pages. The actual detailed report will be used for data entry after printing and we prefer not to use a Wor Please open the database and use Ctrl + E to open up the report, that...
  14. A

    Preview Report Then Print 4 Copies

    Thank you GP George for your question. The currently Macro previews the document and then 2 copies are printed, while we would like the Macro to preview the document and than print 4 copies.. Nicole
  15. A

    Preview Report Then Print 4 Copies

    Could I please get a code suggestion to preview a report and then print 4 copies using the Macro = Control + E. Your suggestions are appreciated. Nicole
  16. A

    Contacts are not being sorted alphabetically.

    jdraw The volunteers had taken the data from a web sheet that we had received and a bad character was picked up. Now we enter the data into notepad and copy the data into the database.
  17. A

    Contacts are not being sorted alphabetically.

    Thank you all for your suggestions. We now enter the names in a text document and then copy it to the database. Thank you Marylyn
  18. A

    Contacts are not being sorted alphabetically.

    Thank you for your suggestions. Would using a filter such as below help to overcome our problem and if yes would the code be placed in the Table's Field or on the Form? Is Null Or Not Like "*[!a-z OR "" ""]*" Thank you Marylyn
  19. A

    Contacts are not being sorted alphabetically.

    Could you please tell me how to correct the sorting in our Access Database of Contacts / Companies? Thank you Marylyn
  20. A

    Syntax Error in changing a field’s contents

    Thank you cheekybuddha for your note, which I appreciate. I was trying to find a solution to the reports the Charity needed completed by Dec 29th. Enjoy the holidays. Marylyn
Back
Top Bottom