Replies

Take a look at this document, although it is for Outlook Express, it walks you through the steps to verify your hyperlinks are setup correctly, and that IE is your default browser.

OLEXP: Internet Shortcuts in Outlook Express Do Not Start Web Browser

Martin,
The only time I have seen that get checked, is when a user has checked it; but although I’m not sure how, I would not doubt that something else could have set it, such as a template. (There is an Application.IgnoreRemoteRequests property in VBA that could have done it).

Jols,
Are you using the NZ function in the the query that is the source for the form? My best guess, is you a getting Null values instead of 0 values, if nulls are converted to 0 (with NZ), they should show as $0.00

Even though you have tried the utility, you might want to take a look at OFF2000: Internal Error 2343 During Setup

Specifically, it is unclear if the utility fixes the notes.ini part, so you may want to try that manually. Also, you can walk through the other steps, to see if the utility did them correctly.

In Excel, look at Tools-Options-General, uncheck “Ignore Other Applications”

Use Setwarnings:

DoCmd.SetWarnings False
DoCmd.RunSQL
DoCmd.SetWarnings True

Note: YOU MUST turn the warnings back on, or a lot of problems may result. I strongly recommend turning them off perform the action, then turn them on. Also, I would not group actions in between, perform one action per off / on. ( A bit more overhead, but less chance of missing important errors)

From your description, it sounds like you are getting the values fine from the subform. My concern/observation is your decision to store those values in the tblMaster. By doing that, you run into a situation where problems could arise, if they are ever updated improperly. The rule of thumb with tables is to usually store the raw values for calculations in the tables, but to perform the calculations on the fly, when needed. This ensures that you always have the most current data. It also makes your tables much more portable, and may eliminate headaches down the road. For example, what would happen if you decided to make a quick entry screen, where just the subform showed, so you could update a group of payments quickly. The way you have it set up, the tblMaster would not be updated with the calculations, unless you created something to do it, and the potential for inaccurate data is high.
So, if it was me, I would leave the fields Amount Paid and Balance Due on the main form, but do not have them update the tblMaster (in other words, delete them from tblMaster, and leave the Main Form formulas there, but do not set them to update the table). Then, in any place you need the values calculated, create a formula or query (depending on the scenario).

Let me know if I made this more confusing than it needs to be.

ok, I dated myself a bit

NZ is available in 97 AND 2000, sorry for the confusion.

Jols,
Someone may jump in with a better solution, but I have some ideas for you.

First, an observation. In tblMaster, you have Amount Paid, and Balance Due, this seems confusing, since they appear to be calculated fields based on tblDetails, is that correct? If that is the case, it would seem those fields are better calculated by doing a calculation on tblDetails, and not storing the value in tblMaster, otherwise, it appears you would need to update two fields, whenever a payment is made. For the calculated values on the form you have setup, you can use a dlookup, or the query below, when done.

As for the query issue, I would recommend a subquery be used. It seems the main issue is that the way you have it setup, no records are returned when there is no payment. You need to retrieve those records also. I would do this as follows: (Please let me know if you need more detail)

Create a query, similar to the one you posted, setting the link to retrieve all records from tblMaster, and those that are equal from tblDetails(joined on Docket #). Only add the fields Docket # from tblMaster, and Payment from tblDetails (set total to Sum). This will return all records, including records for which no payment is recorded.

The SQL for the subquery (leaving out extraneous fields, that you may want to add):
Name: qryPayments

SELECT tblMaster.[Docket #], Sum(tblDetails.Payment) AS SumOfPayment
FROM tblMaster LEFT JOIN tblDetails ON tblMaster.[Docket #] = tblDetails.[Docket #]
GROUP BY tblMaster.[Docket #];

The main query (note, if you change the subquery name, change it in here)
Name: qryRestitution

SELECT tblMaster.[Docket #], tblMaster.[Date Due], nz([SumOfPayment],0) AS Payment
FROM tblMaster INNER JOIN qryPayments ON tblMaster.[Docket #] = qryPayments.[Docket #]
WHERE (((tblMaster.[Date Due])<Date()) AND ((nz([SumOfPayment],0))<[Amount Ordered]));

Note: the NZ function is only available in Access 2000, if you are not using 2000, I can send you code to write it.

Let me know if this is too confusing.

kris,
Any chance it is Error 50003 and not 5003, I’ve seen the 50003 before, but not of my resources shows any 5003 with VB. If it is 50003, it is usually related to outdated or incompatible OCX’s or DLL’s. If you have more info about how your app works, we might be able to narrow it down.

This outlines the process pretty well, please ask if you have any questions.
(Note, after you export, move the exported files to the new computer, then follow the import part).

OLEXP: How to Back Up and Recover Outlook Express Data

Got this from a board, some time ago….

=A1-DATE(YEAR(A1),1,0), where A1 = the date you are checking.

I have seen the Standby option disappear before, if that is the case, see the following:

MS KB Q188134

Geoff,
If you open the spelling options page, the Recheck document button should reset it.
If you are looking to add this to your macro, look at the properties
SpellingChecked and ResetIgnoreAll

From Help:
Application.ResetIgnoreAll
ActiveDocument.SpellingChecked = False
ActiveDocument.CheckSpelling

In addition to the previously mentioned XLStart folder, there is also an alternate one that can be set from Tools-Options-General Tab, you might want to check there also.