Recent content by timgill

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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