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!

Register Log in
  • Congratulations derfloh 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. timgill

    Off Subject - US Pride

    I know this is totally off subject for this forum, but i urge anyone that is a webmaster to consider adding an american flag to your home page. In this time of tragedy, it is the least that we can do to show our support. Our page can be viewed at http://www.amstat.org/index_us.html I apologize...
  2. timgill

    Where do I put this Code?????

    Actually, you WOULD put it in your query. When you have the query open in design mode, change it to "SQL VIEW" and paste the code in. You can then switch back to design mode and it will convert it visually for you. You can switch to "SQL View" by right clicking on the area...
  3. timgill

    Reporting on #'s of Messages read/unread

    I understand how to use Outlook. Perhaps I phrased the question incorrectly. I want to run a report that lists all users and how many messages are in THEIR inboxes and of those, how many are unread. I don't care what they are, just the counts of how many per user. Tim Gill Gill Consulting...
  4. timgill

    Reporting on #'s of Messages read/unread

    Does anyone know of a way to report on the number of messages in a mailbox (or mailboxes) and count how many there are total and of those how many are unread? I can connect to the Exchange server through Access using the Exchange/Outlook connector, but it doesn't show a field for read vs unread...
  5. timgill

    Restore 6.5 Backup to 7.0 Server?

    Can you restore a backup made in SQL 6.5 to a SQL 7.0 server? If so, how can it be done? Tim Gill Gill Consulting http://www.dagills.com
  6. timgill

    "The datahas been chaged" with SQL7 Desktop

    Figured it out myself. I added a timestamp field to each table, and now have no problems. Tim Gill Gill Consulting http://www.dagills.com
  7. timgill

    Can I export an Acces report to a PDF file?

    Unfortunately, yes. It is the only way I have found to pass the name of the pdf file to be created. What I had to do was add a "pause" routine to wait long enough for the pdf writer to load and start processing. Once I got the right amount of paus time figured out, it worked like a...
  8. timgill

    Can I export an Acces report to a PDF file?

    It works just fine. In fact, I now have it so that it will run through the listbox and print out each one individually with no user intervention (other than pressing the "GO" button. The code in the previous post will work to do them one at a time. If you want the new code that runs...
  9. timgill

    Listbox of reports in a form to preview and/or print

    Opps, I made a mistake. You HAVE to have a description for each report, otherwise it will generate an error. I use it like this: me.lstReports.rowsource = reportlist("*") The asterisk tells it to return all reports. You can also pass any string for it to look for. Say you have 5...
  10. timgill

    Listbox of reports in a form to preview and/or print

    Try using this: Public Function ReportsList(strCriteria As String) Dim db As DATABASE Dim docLoop As Document Dim prpLoop As Property Dim strReports As String Set db = CurrentDb strReports = """" With db.Containers!Reports ' Run through...
  11. timgill

    "The Data has changed" error in SQL7 Desktop

    Running SQL7 Desktop on Win98 machine. I have an access application using a SQL7 database. When using a form (any form) to change data in a field, if I edit the record, save it, then try to make another change to that same record, I get the "The data has changed. Another user edited this...
  12. timgill

    "The datahas been chaged" with SQL7 Desktop

    Running SQL7 Desktop on Win98 machine. I have an access application using a SQL7 database. When using a form (any form) to change data in a field, if I edit the record, save it, then try to make another change to that same record, I get the "The data has changed. Another user edited this...
  13. timgill

    Preview same report several times

    Ehat you are trying to do, you can't do directly. You can only have one instance of a specific report open at a time. One way to get around it (not very graceful, I admit) is to create as many copies of the report as you want open, and then open those since you CAN have multiple reports open...
  14. timgill

    Get ID (primary key) immediately on inserting new record.

    The only problem with the previous technique is that if you have many people using the database at the same time, a new record could be slipped in between you adding a record, and running the above code to retrieve the ID. Using CFTransaction to do the insert, and then using select @@identity...
  15. timgill

    How to Check for existence of a field across multiple tables

    Let's say you have a database that has 100 tables in it. I want to be able to search across all tables and return a list of all tables where a specific field exists. Any ideas on a nice, clean way to do this? Tim Gill Gill Consulting http://www.dagills.com
  16. timgill

    Passing Filename to PDF Writer via code

    That did the trick. It actually only needed a 1 sec pause. I guess long enough for the PDFWriter to initialize. Thanks! Tim Gill Gill Consulting http://www.dagills.com
  17. timgill

    How to pass a variable in a text box to a query

    tim@dagills.com should have worked. Try tim@amstat.org, that is my work address. Tim Gill Gill Consulting http://www.dagills.com
  18. timgill

    Can I export an Acces report to a PDF file?

    I am working on this right now. I have a list of source codes, and I want a separate report for each code exported to a PDF. Here's where I am: I have a form with a listbox listing all possible source codes. The listbox has two columns: Code, Description. I have PDF Writer as my default...
  19. timgill

    How to pass a variable in a text box to a query

    Any chance you could send me the database? What you have should work, so I must be missing something. If you send it to me, I'll take a look and try to help. Tim Gill Gill Consulting http://www.dagills.com
  20. timgill

    Calculating a median value

    I have created the following functions to calculate Median, Percentiles and Quartiles (they work properly, I work for the American Statistical Association!). Sorry for the post being so long, but I wanted to be sure you had all you would need. Others might find them useful as well. I use...

Part and Inventory Search

Back
Top