Replies

I often do integrate both excel and word into my work, sending access reports to either, merging docs, etc. I also have Missing:utility, but selecting it and browsing to the location (1033 directory), will fix the “missing” but seems only temporarily, and doesn’t seem to help my reference problem. Why is it being listed as missing when the file is there? Might accessing from different computers cause this? The utility.mda is located on each computer. Does the utility.mda contain the reference I need? is Date() not a VBA function?

Hans. You’re a genius. It works! We’ll dedicate a march to you at the next concert.

With Thanks
Doug

Hans. You’re a genius. It works! We’ll dedicate a march to you at the next concert.

With Thanks
Doug

I want to create a report formated for printing lablels. There would be one label on the report for each student who has sold two boxes of fruit. I would therefore need to have a qery to base the report on that would list every student as many times as the quantitysold/2. A further twist: I just found out the query should exclude the top 5 sellers! Hope this is clearer than the soup I’m about to eat.

I want to create a report formated for printing lablels. There would be one label on the report for each student who has sold two boxes of fruit. I would therefore need to have a qery to base the report on that would list every student as many times as the quantitysold/2. A further twist: I just found out the query should exclude the top 5 sellers! Hope this is clearer than the soup I’m about to eat.

Thanks a million! I did search the archive first. Honest. Guess I need to hone my search skill some. But replacing the mlang.dll file did the trick!

I have had two cd players go on me right near the one year mark. Its not uncommon. They don’t “decay” without use. As with anything mechanical, they wear with use. Dirt, dust, etc. is the biggest contributor to malfunction in a cd player. Does anyone smoke near your computer? Is this a burner or just a player? You say the manufacturer is Creative Labs. What model?

Thank-You. I must have missed that one when I did the google search.

This is very similar to a problem I worked on recently. It is very possible that the FAT was damaged in the shutdown. Did you try booting to a floppy? you may have to check that the bios is set to seek the flppy first. Many schools will disable this to prevent students from rebooting to DOS via a floppy.

First, canned air can be dangerous to the inside of a CD. Use it sparingly, in very short blast(s) if you must use it. Second, the effectiveness of most CD lens cleaners is debateable. Does yours include antistatic brushes? Don’t overlook cleaning your CDs. They are more often the culprits than the CD player. After that, if there is still problems, it is cheaper to replace the drive than try to repair it.

Thanks so much. Excellent useful information. I got my attachment.

Actually I did mention [envelopenumber]. See 23-Feb-02 04:08. Inserting the Nz function into the combo event won’t do anything since that particular field is an “autonumber” field and never null. But it did inspire me to look elsewhere. As it turns out, the problem arises in the query where there is a sort on the [envelopenumber] field and of course it can’t sort a null field. Creating a [EnvelopeNumber] field in the query with the Nz function and sorting on this solved the problem. Thanks. Once again, thanks to all who responded.

new envelope number field: EnvelopeNum: CInt(Nz([EnvelopeNumber]))

Columnwidth is set as yous seay: 0,1. By doesn’t work I mean as in original post: I get the error message “The text you entered isn’t an item in the list”. It does look up the value when using the mouse and clicking an item, but if you type a number and hit enter, you get the error message.

There is now a new twist involving null value. I only get the error message when one or more records contain a null value in the [envelopenumber] field.

I found the same thing when I tried it on a different database, It worked. What was different was that there was one record in this table that contained a null value. Therefore, the problem is now making it work when certain records will contain a null value in the [envelopenumber] field. I suppose one way would be to just have zero inserted in the default field but why will the code not overlook the null field?

I did use the wizard. No filter. Using a query as the row source makes no difference. Following is the query:
SELECT Members.MemberID, Members.Envelope, Members.FirstName, Members.LastName
FROM Members
ORDER BY Members.Envelope;

and the combo box:
Private Sub Combo23_AfterUpdate()
‘ Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst “[MemberID] = ” & str(Me![Combo23])
Me.Bookmark = rs.Bookmark