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

    File Closes itself!!!!

    I have the same problem. I am using Acrobat Pro 7. If I open a file on my desktop or a hyperlink to a pdf file it is ok, but a html hyperlink will just blink the page for a second or five and disappear. I don't have any pop-up blockers and I have tried changing the settings from open pdf in...
  2. officeguru

    Using Excel 2003 to Manipulate Access97 table

    Thanks Andy, I am not replacing existing forms, I have added some functionality to my database, and other users want to be included. They have been filling in a spreadsheet, printing it and routing the print. I want to capture their data from the spreadsheet, save and report from it. The...
  3. officeguru

    Using Excel 2003 to Manipulate Access97 table

    Greetings! I maintain an Access 97 database for a small group of users. When our company upgraded from office97 to office 2003, they didn't get Access 2003, and they removed access97 from most users desktops. Is there a way to use Excel 2003 as a data-entry tool for Access 97? I know I could...
  4. officeguru

    TransferSpreadsheet - Allow user to define range or highlight range

    Bailey, Are they selecting the range just to avoid importing blank rows? If that's the case you can reset the excel's last cell before importing..
  5. officeguru

    Merging a Access Query with a Word Document

    ETID, I think that is exactly what I am looking for, can you please show me how it's done?
  6. officeguru

    Merging a Access Query with a Word Document

    I have a similar question as Scudy. Is there a way to open word mail merge document from an access form and populate the merge fields with data from the form? I am using Access 97 and I don't have a "merge with Word" menu item
  7. officeguru

    Disappearing relationship

    Hello, I am trying to create a report with the report wizard based on two related tables. Access (97) tells me I am trying to include records from two unrelated tables. [COLOR=green] You have chosen fields from these tables: Service Parts, BOM Rejections; one or more of the tables isn't...
  8. officeguru

    Counting parent but not child records in query

    Thanks, I need to play around with these examples, but I think you've got me thinking correctly. This forum is teaching me a lot about Access AND about phrasing my questions. When you look at it every day it's easy to forget that 'passed' doesn't mean passed and 'rejected' doesn't always mean...
  9. officeguru

    Counting parent but not child records in query

    Thanks for your help, but I am still struggling. What I am trying to do is count all completed documents ('Passed') on a pass/fail basis. If there is one or 1000 related records in the rejections table, it is counted as a failure, if there are 0 related records it is a success. Using Quehay's...
  10. officeguru

    Counting parent but not child records in query

    Thanks Jeffrey, I'll try that when I get back in--it does make sense though. Brian
  11. officeguru

    Counting parent but not child records in query

    OK, I created a dummy database to use as an example Table 1 Task ID WriterID Task Description End Date Passed 5 Dick Dick 1 2/25/2004 TRUE 6 Dick Dick 2 3/4/2004 TRUE 7 Harry Harry 1 3/4/2004 TRUE 9 Harry Harry 2 2/28/2004 TRUE 1 Tom Title 1 3/2/2004 TRUE 2 Tom Title 2 2/15/2004 TRUE 3 Tom...
  12. officeguru

    Counting parent but not child records in query

    Greetings, I have two tables that track publications submitted for proofing. Table 1[BOM Review] holds the name of the writer[Leader], the ID of the publication [Pub #], the date it passes review and a checkbox [Status] indicating it has passed. Table 2[Rejections] is related on publication...
  13. officeguru

    Counting and comparing to total in query

    I hope I am not offending your intellect but I can't figure this one out. I am keeping track of writers/publications in Access 97 each publication has a due date, a completed date, an intermediate date and a yes/no variable. I am trying to create a query that will count publications that are...

Part and Inventory Search

Back
Top