Replies

Well, I tried the whole system file checker thing. I replaced a number of dlls, some of which apparently are not on my Win98SE cd (gdi32.dll, setupx.dll, kernel32.dll). I’m still getting the Kernel32.dll error (The setup.exe is linked to missing export kernel32.dll). I didn’t know about the registry fix thing but will try later today.

At this point, I’m pulling my hair out and considering just reinstalling the OS. Uggggh.

I thought of that, too, since I can “explore” the cd with the drive. I tried installing two different things: one was the drivers for a cordless mouse, the other was WinFaxPro. Both give similar errors. I can install both on a different pc, which leads me to think that it’s not the disks.

Added information: I also tried uninstalling/removing the drive and reinstalling. According to TEAC (maker of the drive), there are no drivers for this drive at all. I checked driverguide.com and found a single driver that did nothing for this drive.

The only reason I thought it might be a Win98 problem is the Kernel32.dll error that I got. But it doesn’t seem likely because Win98 didn’t have any problems before this drive. But since it’s a driverless drive and I can explore and open files from it, how can it be the drive?

I’m so lost….

I thought of that, too, since I can “explore” the cd with the drive. I tried installing two different things: one was the drivers for a cordless mouse, the other was WinFaxPro. Both give similar errors. I can install both on a different pc, which leads me to think that it’s not the disks.

Added information: I also tried uninstalling/removing the drive and reinstalling. According to TEAC (maker of the drive), there are no drivers for this drive at all. I checked driverguide.com and found a single driver that did nothing for this drive.

The only reason I thought it might be a Win98 problem is the Kernel32.dll error that I got. But it doesn’t seem likely because Win98 didn’t have any problems before this drive. But since it’s a driverless drive and I can explore and open files from it, how can it be the drive?

I’m so lost….

Hi again, Hans,

#1–Thanks for the tips on using help.

#2–I actually remembered at the last minute that I’ve done this before, and once I remembered, it was so simple, I can’t believe I missed it!

Unfortunately, I don’t program *all* the time, and in between I kinda forget stuff. Urrrgh, that gets me all stressed out, when I know there’s a simple solution, but I can’t for the life of me find it.

But all’s (mostly) good with the world now, and definitely many thanks to you!!!

Hi again, Hans,

#1–Thanks for the tips on using help.

#2–I actually remembered at the last minute that I’ve done this before, and once I remembered, it was so simple, I can’t believe I missed it!

Unfortunately, I don’t program *all* the time, and in between I kinda forget stuff. Urrrgh, that gets me all stressed out, when I know there’s a simple solution, but I can’t for the life of me find it.

But all’s (mostly) good with the world now, and definitely many thanks to you!!!

Thanks again, Hans,

I was just hoping that with this version of Access that things would have gotten easier. Just a simple thing like finding a path to save a spreadsheet is such a pain!

Even searching for simple code to open an excel spreadsheet is impossible! I can type in Excel and get only four results, none of which has to do with Excel. Excel Automation results in some vague references to access automation. Shell is useless because the server path is way too convoluted, and I can’t find my old familiar shell help, either. I know it’s in there–How do I unlock this completely useless help system??? Does MS expect me to memorize ALL bits of code???

I wish we could go back to 97….

Okay, sorry for complaining….I’ll be nice now

Thanks again, Hans,

I was just hoping that with this version of Access that things would have gotten easier. Just a simple thing like finding a path to save a spreadsheet is such a pain!

Even searching for simple code to open an excel spreadsheet is impossible! I can type in Excel and get only four results, none of which has to do with Excel. Excel Automation results in some vague references to access automation. Shell is useless because the server path is way too convoluted, and I can’t find my old familiar shell help, either. I know it’s in there–How do I unlock this completely useless help system??? Does MS expect me to memorize ALL bits of code???

I wish we could go back to 97….

Okay, sorry for complaining….I’ll be nice now

Thanks, Hans…

Sometimes I can be so silly.

Interesting thing, though, is that it saves the spreadsheet to the My Documents folder…Which isn’t even my default database location! I kind of expected it to be in the same folder as my database. Kind of makes it difficult to have the file automatically open.

BTW, is it just my imagination, or is Help in XP not nearly as good as it was in 97? I seem to have a much harder time these days looking up things like this.

Thanks again!

Thanks, Hans…

Sometimes I can be so silly.

Interesting thing, though, is that it saves the spreadsheet to the My Documents folder…Which isn’t even my default database location! I kind of expected it to be in the same folder as my database. Kind of makes it difficult to have the file automatically open.

BTW, is it just my imagination, or is Help in XP not nearly as good as it was in 97? I seem to have a much harder time these days looking up things like this.

Thanks again!

Have you tried TransferText? From the Help….

Example
The following example exports the data from the Microsoft Access table External Report to the delimited text file April.doc by using the specification Standard Output:

DoCmd.TransferText acExportDelim, “Standard Output”, _
“External Report”, “C:TxtfilesApril.doc”

Have you tried TransferText? From the Help….

Example
The following example exports the data from the Microsoft Access table External Report to the delimited text file April.doc by using the specification Standard Output:

DoCmd.TransferText acExportDelim, “Standard Output”, _
“External Report”, “C:TxtfilesApril.doc”

What I would do is verify the data as the user enters it (ie. use the BeforeUpdate event). You can verify just about anything that way.

For example,

Sub txtMyTextBox_BeforeUpdate(Cancel As Integer)

If me.txtMyTextBox=”” Then
MsgBox “You can’t leave this field blank!”
me.txtMyTextBox.setfocus

End Sub

What I would do is verify the data as the user enters it (ie. use the BeforeUpdate event). You can verify just about anything that way.

For example,

Sub txtMyTextBox_BeforeUpdate(Cancel As Integer)

If me.txtMyTextBox=”” Then
MsgBox “You can’t leave this field blank!”
me.txtMyTextBox.setfocus

End Sub

Thanks, Hans. It must be something freaky about our Outlook installation, then. Or maybe IE. I’m going to just give up and mark this one “unsolved.”

Thanks again for all your help,

Thanks, Hans. It must be something freaky about our Outlook installation, then. Or maybe IE. I’m going to just give up and mark this one “unsolved.”

Thanks again for all your help,