Replies

In searching for a solution to this problem, I found two ways that resolve it.

(1) There is a program called SuperToast that can be downloaded and installed. It provides the ability to generate a popup whenever an IM is received. Plus, it has a free version that works well. I am using this and am pleased with the way the program works.

(2) Assumed that there must be a way to have a program running in the background that would detect when an IM is received and provide a message. (In theory!) Determined that after installing an AutoHotkey program, it can be programmed to determine when an IM is received and provide the message. This works but is not as clean as the program. Also determined that some Virus software think the AutoHotKey program file is a virus and removes it. (Small issue!)

Either way works, however, it is easier to just install a program that already works.

Thanks Wendell. Getting around a .MDW file is fairly easy as well. Artov10 – post back if neither solution works as there are other ways to obtain or bypass the password. Also, just curious, will a shift bypass work to open the database? (After starting the database, hold down the shift key). If it does work, then you should open in the views of tables, queries, etc. You could also try to copy all objects to a new database as long as there is not a VB password applied. Good Luck.

There are a number of ways to bypass database passwords. I assume that your database has a database level password that requires you to input a password to get the database to open. The following simple utility can be used to retrieve your database level password from an older database. Go to the following link: http://www.nirsoft.net/utils/accesspv.html
At the bottom of the page, click the Download Access Passview Link. Save to a folder, unzip, install, and launch the app. Press the Get Password Button, browse to and then double click on your database and the app will provide you with your password. Post back if this does not work as there are other ways to get the password. ***OF COURSE – COPY YOUR DATABASE FIRST SO IT IS BACKED UP *** Good Luck.

This is as close as I can get with a scatter chart. A line chart (with axes reversed) would be easier! Or even a bar chat with no fill and data labels set to display X.

Rory,
Thanks. The example helped a lot. However, I do have one question.

How did you get the starting date of the X Axis to lock to the date? Whenever I set the min and max values for the X axis the min always resets back to zero and shows on the graph as 1/0/1900. (I do not want it to do this!) Thanks.

I am goign to assume you are using Windows 7. You could highlight the table in Word, Select Copy, then go to Excel, and Select Paste Special, and then either paste it as an Word Document Object or Picture. HTH

Tom,

If I remember correctly, I do not think Windows Version 7 is compatible with the Snapshot Viewer which would cause the error.

You are using Interior.ColorIndex

These Run from 0 to 56 only

If you want to use 255 or vbRed etc, then you need to use Interior.Color

So
Interior.Color=vbRed
Is the same as
Interior.ColorIndex=3

Thanks for the help. Changing to the 56 colors worked. The code was a pain but it is done.

You indicate “by comparing the two tables…”

What field(s) are you comparing to determine if the records in the new data is a new record or modification of an existing record in the existing table?

Are you using the ID setup as an autonumber as the key and then checking to see if that autonumber exists? If you are using the ID as the field driving your information I see where you could have a problem if you attempt to run an append query.

I would do this in a two step process if you are using the ID.

Step 1 – Where the id’s are the same, use an update query to update the fields that are modified.

Step 2 – For all id’s in the new file that are not in the existing file, you will need to run an append query to append the records, however, this is where the issue comes in. The new ID’s will most likely NOT be the same as those loaded as the system will generate them. You may want to use a different field to store the ID so it remains a constant.

Could you please provide some more information on what fields you are comparing in the tables. Thanks.

Try this (or something like it)

Code:

strsql = "INSERT INTO SubProcesses ( [Process Name], [Process Description], [Process BAU or Project?], [Sub-Process Name], [Sub-Process Description]," _
& " [Sub-Process BAU or Project?], [Process % Complete], [Process Actual Start Date], [Process Actual Completion Date]," _
& " [Sub-Process Flowcharts/ Narratives Complete & Attached?], Status, [Sub-Process Baselined Start Date], [Sub-Process Baselined Completion Date]," _
& " [Sub-Process Revised Start Date], [Sub-Process Revised Completion Date] ) "

docmd.runsql strsql

Well, what i have is an unbound Textbox on the report with the control source set to =”Printed on: ” & Now(), which reflect the time the report was opened. what i was looking for is some event called ‘OnPrint’. if it doesn’t exist, fair enough, just will have to advise the time stamp is the time the report is opened, not printed.

Sorry, I needed to read your post closer. You will find the On Print event in the Header portion of the report. (Right Click on Report Header and select Properties) This should get you to where you need to be.

Put this in the on open event of the report. I am going to assume that you added a Label called TextTS to the report (i.e,. put it in the header) that you want to add to the report as the timestamp.

Me.Controls(“TextTS”).Caption = Now()

HTH

Here is an option that may work for you. Go to the record source for the report and add a column for the time stamp so it becomes available as a selection in the report. I.e., add a column called TStamp and set it equal to =Now(). All of the data fields in the report would have the same result so it will not effect any groupings. Then just add it as a data field in the main body or header of the report. This will give you the tstamp when the report was generated which may suffice. HTH

Thank you.

I would also like to wish you and others a very Merry Christmas and Happy New Year.

… I hate snow as well – go figure, as we got 21 inches on Sunday.

However, Hans, the picture is stunning. Very nice.

Adam,

Which version of Yahoo mail are you using. I was not aware that Yahoo automatically saves the email addresses (at least in the older version). I thought you would need to update the contact list to save the contacts.

To delete contacts, open the contact tab, find the contact you want to remove, and then you can delete it.